Support Article

SQL exception when importing third party jar files

SA-27312

Summary



The import of third party jar files fails with a SQL exception. 
 

Error Messages



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

  1. Go to Designer Studio > Application  > Distribution  > Import.
  2. Import jar file.
  3. 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 Cause



The column pr_engineclasses.pzBinaryContent is not large enough to store the java class.

Resolution



Increase 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

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.