agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] pljava test build error
5+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] pljava test build error
@ 2005-09-06 08:20
2005-09-06 09:44 ` [Pljava-dev] pljava test build error
2005-09-07 01:28 ` [Pljava-dev] pljava test build error
0 siblings, 2 replies; 5+ messages in thread
From: @ 2005-09-06 08:20 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] pljava test build error
2005-09-06 08:20 [Pljava-dev] pljava test build error
@ 2005-09-06 09:44 `
1 sibling, 0 replies; 5+ messages in thread
From: @ 2005-09-06 09:44 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] pljava test build error
2005-09-06 08:20 [Pljava-dev] pljava test build error
@ 2005-09-07 01:28 `
2005-09-07 06:56 ` [Pljava-dev] pljava test build error
1 sibling, 1 reply; 5+ messages in thread
From: @ 2005-09-07 01:28 UTC (permalink / raw)
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
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] pljava test build error
2005-09-06 08:20 [Pljava-dev] pljava test build error
2005-09-07 01:28 ` [Pljava-dev] pljava test build error
@ 2005-09-07 06:56 `
2005-09-07 07:26 ` [Pljava-dev] Re: pljava test build error
0 siblings, 1 reply; 5+ messages in thread
From: @ 2005-09-07 06:56 UTC (permalink / raw)
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;
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] Re: pljava test build error
2005-09-06 08:20 [Pljava-dev] pljava test build error
2005-09-07 01:28 ` [Pljava-dev] pljava test build error
2005-09-07 06:56 ` [Pljava-dev] pljava test build error
@ 2005-09-07 07:26 `
0 siblings, 0 replies; 5+ messages in thread
From: @ 2005-09-07 07:26 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-09-07 07:26 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-06 08:20 [Pljava-dev] pljava test build error
2005-09-06 09:44 `
2005-09-07 01:28 `
2005-09-07 06:56 `
2005-09-07 07:26 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox