From: kongsen.tian at tokuii.com (kstian) Date: Wed, 07 Sep 2005 14:56:32 +0800 Subject: [Pljava-dev] pljava test build error In-Reply-To: <431E4222.6000300@tokuii.com> References: <431D5156.90901@tokuii.com> <431D64F9.1080300@mailblocks.com> <431E4222.6000300@tokuii.com> Message-ID: <431E8F20.2000103@tokuii.com> Hi Thomas, I digged into the code the printed out string 'urlString' at org.postgresql.pljava.management.Commands.replaceJar(Commands.java:243) and found that urlString has extremely long text. Since it's too long and I have enlcosed the output in the file urlString.txt. I even tried to declare the the char length with varchar(100000) in Deployer.java and it went out of limit. How does urlString get stored with such a long string? Thanks for help. Regards, Kong kstian wrote: > Hi Thomas, > > Thanks for replaying. I am using PL/Java 1.1.0, PostgreSQL 8.0.3, and > Gentoo Linux system. > > My base Java directory is /opt/blackdown-jdk-1.4.2.02/bin/java. It > looks normal to me. > > Thanks again for your help. > > Regards, > Kong > > Thomas Hallgren wrote: > >> Kong, >> I honestly have no idea why this happens. What is the base directory >> for your Java installation? Is it an extremely long path or perhaps a >> path containing unusual characters (spaces, commas, $, or something)? >> Also, please provide version information on PL/Java, PostgreSQL, and >> Operating System. >> >> Regards, >> Thomas Hallgren >> >> kstian wrote: >> >>> Hi, >>> >>> I was trying to build (ant -f build.xml) pljava test in >>> src/java/test folder and I got the following error in build window: >>> >>> src/java/test/build.xml:17: Unable to do install_jar: ERROR: value >>> too long for type character varying(500) >>> >>> postgresql.log file showed the following error: >>> >>> NOTICE: drop cascades to function javatest.java_gettimestamp() >>> CONTEXT: SQL statement "DROP SCHEMA javatest CASCADE" >>> LOG: Exception >>> LOG: in thread "main" >>> org.postgresql.pljava.internal.ServerException: value too long for >>> type character varying(500) >>> at >>> org.postgresql.pljava.internal.ExecutionPlan._execute(Native Method) >>> at >>> org.postgresql.pljava.internal.ExecutionPlan.execute(ExecutionPlan.java:170) >>> >>> at >>> org.postgresql.pljava.jdbc.SPIStatement.executePlan(SPIStatement.java:119) >>> >>> at >>> org.postgresql.pljava.jdbc.SPIPreparedStatement.execute(SPIPreparedStatement.java:263) >>> >>> at >>> org.postgresql.pljava.jdbc.SPIPreparedStatement.executeUpdate(SPIPreparedStatement.java:79) >>> >>> at >>> org.postgresql.pljava.management.Commands.replaceJar(Commands.java:568) >>> at >>> org.postgresql.pljava.management.Commands.replaceJar(Commands.java:243) >>> ERROR: value too long for type character varying(500) >>> CONTEXT: SQL statement "UPDATE sqlj.jar_repository SET jarOrigin = >>> $1, jarOwner = $2, deploymentDesc = NULL WHERE jarId = $3" >>> =============================================================== >>> >>> I would really appreciate any help you can provide to resolve this >>> problem. >>> >>> Thank you. >>> >>> Regards, >>> Kong >>> _______________________________________________ >>> Pljava-dev mailing list >>> Pljava-dev at gborg.postgresql.org >>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev >> >> >> >> >> >> >> > > -------------- next part -------------- An embedded and charset-unspecified text was scrubbed... Name: urlString.txt URL: