Thread: Bad Short Default v530 (Fix getXXX methods when used with CHAR co lumns or columns withdecimals)

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