agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Re: pljava test build error
Date: Wed, 07 Sep 2005 09:26:06 +0200
Message-ID: <dfm4me$roh$1@sea.gmane.org> (raw)
In-Reply-To: <431E8F20.2000103@tokuii.com>
References: <431D5156.90901@tokuii.com>
<431D64F9.1080300@mailblocks.com>
<thhal-0ff34A1+w8LQkK0grxuCnMzLkwgoVeJ@mailblocks.com>
<431E4222.6000300@tokuii.com>
<431E8F20.2000103@tokuii.com>
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
view thread (5+ messages)
Message-ID: <dfm4me$roh$1@sea.gmane.org>
Permalink: ../dfm4me$roh$1@sea.gmane.org/
Also on: postgresql.org/message-id/dfm4me$roh$1@sea.gmane.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Re: pljava test build error
In-Reply-To: <dfm4me$roh$1@sea.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox