Обсуждение: Bad Short Default v530 (Fix getXXX methods when used with CHAR co lumns or columns withdecimals)

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
>