[PATCHES] Bad Short Default v530 (Fix getXXX methods when used with CHAR columns or columns withdecimals)

[Addison, Darrick]

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