[Pljava-dev] pljava test build error

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: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050907/f8c56a80/attachment.txt>