Bad Short Default v530 (Fix getXXX methods when used with CHAR co lumns or columns withdecimals) - Mailing list pgsql-jdbc

From Addison, Darrick
Subject Bad Short Default v530 (Fix getXXX methods when used with CHAR co lumns or columns withdecimals)
Date
Msg-id 547FB5C65F37D6119C150003471B5507012DA8C8@shemp.ds.cubic.com
Whole thread Raw
Responses Re: [PATCHES] Bad Short Default v530 (Fix getXXX methods when used
List pgsql-jdbc

Hi,

Just wanted to know if anyone can help with the following PostgresSQL 7.x error that

occurs after running a program that uses the pg73jdbc2.jar:

 

Note: The following URL provided some clues but I'm unsure how to incorporate the fix

http://archives.postgresql.org/pgsql-jdbc/2003-06/msg00062.php

 

 

Proc: {call getExProfiles(-999)}

Bad Short Default v530                                                   

            at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getShort(AbstractJdbc1ResultSet.java:136)

            at Int2SqlField.loadFromDb(Int2SqlField.java:34)

            at DbProc.doExecute(DbProc.java:213)

            at ProfOffsets.refreshScenarioProfiles(ProfOffsets.java:104)

            at PeScenario.JdbcLoadScenarios(PeScenario.java:382)

            at PeScenario.PublishAndSubscribe(PeScenario.java:277)

            at FedAmb.svcInit(FedAmb.java:372)

            at Pehla.Init(Pehla.java:1231)

            at Pehla.DoHla(Pehla.java:912)

            at Pehla$ServiceHla.run(Pehla.java:166)

            at java.lang.Thread.run(Unknown Source)

The column index is out of range.

            at org.postgresql.jdbc1.AbstractJdbc1ResultSet.checkResultSet(AbstractJdbc1ResultSet.java:675)

            at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1ResultSet.java:91)

            at StringSqlField.loadFromDb(StringSqlField.java:40)

            at DbProc.doExecute(DbProc.java:213)

            at ProfOffsets.refreshScenarioProfiles(ProfOffsets.java:104)

            at PeScenario.JdbcLoadScenarios(PeScenario.java:382)

            at PeScenario.PublishAndSubscribe(PeScenario.java:277)

            at FedAmb.svcInit(FedAmb.java:372)

            at Pehla.Init(Pehla.java:1231)

            at Pehla.DoHla(Pehla.java:912)

            at Pehla$ServiceHla.run(Pehla.java:166)

            at java.lang.Thread.run(Unknown Source)

Bad Short Default v530                                                   

            at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getShort(AbstractJdbc1ResultSet.java:136)

            at Int2SqlField.loadFromDb(Int2SqlField.java:34)

            at DbProc.doExecute(DbProc.java:213)

            at ProfOffsets.refreshScenarioProfiles(ProfOffsets.java:104)

            at PeScenario.JdbcLoadScenarios(PeScenario.java:382)

            at PeScenario.PublishAndSubscribe(PeScenario.java:277)

            at FedAmb.svcInit(FedAmb.java:372)

            at Pehla.Init(Pehla.java:1231)

            at Pehla.DoHla(Pehla.java:912)

            at Pehla$ServiceHla.run(Pehla.java:166)

            at java.lang.Thread.run(Unknown Source)

The column index is out of range.

            at org.postgresql.jdbc1.AbstractJdbc1ResultSet.checkResultSet(AbstractJdbc1ResultSet.java:675)

            at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1ResultSet.java:91)

            at StringSqlField.loadFromDb(StringSqlField.java:40)

            at DbProc.doExecute(DbProc.java:213)

            at ProfOffsets.refreshScenarioProfiles(ProfOffsets.java:104)

            at PeScenario.JdbcLoadScenarios(PeScenario.java:382)

            at PeScenario.PublishAndSubscribe(PeScenario.java:277)

            at FedAmb.svcInit(FedAmb.java:372)

            at Pehla.Init(Pehla.java:1231)

            at Pehla.DoHla(Pehla.java:912)

            at Pehla$ServiceHla.run(Pehla.java:166)

            at java.lang.Thread.run(Unknown Source)

 

Kind Regards,

Darrick

pgsql-jdbc by date:

Previous
From: "Addison, Darrick"
Date:
Subject: Bad Short Default v530 (Fix getXXX methods when used with CHAR co lumns or columns withdecimals)
Next
From: Toby
Date:
Subject: Help - lo_close: invalid large obj descriptor