[Pljava-dev] Re: pljava test build error

Ok, I see now what it is that goes wrong. There are two overloaded
replace_jar functions. One that takes an image of a jar (the first
argument is a bytea) and another that takes the URL of a jar. Somehow,
your PostgreSQL JDBC driver gets confused and selects the wrong one.

What is the version of the JDBC driver? This is likely a bug in that driver.

Regards,
Thomas Hallgren

kstian wrote:
> 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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev