SQL exception when importing third party jar files
The import of third party jar files fails with a SQL exception.
Failed to insert class 'jar:file:/your_installation_path/prpc_j2ee14_ws/your_jar_path/your_jar_file.jar': VALUE <Lob-Value> IS TOO LONG. SQLCODE=-433, SQLSTATE=22001, DRIVER=3.62.57
Steps to Reproduce
- Go to Designer Studio > Application > Distribution > Import.
- Import jar file.
- Attempt to reference the imported Java classes. The error may not be shown on the screen and is only found after log file inspection.
Root CauseThe column pr_engineclasses.pzBinaryContent is not large enough to store the java class.
ResolutionIncrease the size of pzBinaryContent to accomodate the content of the jar file based on the size of the jar file.
Published August 27, 2016 - Updated September 7, 2016