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