Re: [PATCHES] Bad Short Default v530 (Fix getXXX methods when used

Darrick,

Can you send a simple test program to the list that reproduces the error
you are seeing?

thanks,
--Barry

Addison, Darrick wrote:
> 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
> <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(AbstractJdbc1Resu
> ltSet.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(AbstractJdbc1Resu
> ltSet.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
>