From: thhal at mailblocks.com (Thomas Hallgren)
Date: Tue, 06 Sep 2005 11:44:25 +0200
Subject: [Pljava-dev] pljava test build error
In-Reply-To: <431D5156.90901@tokuii.com>
References: <431D5156.90901@tokuii.com> <431D64F9.1080300@mailblocks.com>
	<thhal-0ff34A1+w8LQkK0grxuCnMzLkwgoVeJ@mailblocks.com>
Message-ID: <thhal-0f/34A2Ow8LQyGSplJzttY2bK0t/4ub@mailblocks.com>

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