Oracle, JDBC, LONG datatype problem... Help!

Hi all, I am developping a site with servlets connecting back to an Oracl DB with JDBC. I have two different platform. One is running Oracle 8.0.5 on NT, the other Oracle 8i on HPUX. The databases are the same, one havn't been exported and imported into the other. Everything is working fine on the NT box, but the same servlet code failts on the HPUX machine with 8i when I try to retrieve a Long value. I tried the getString() method, and I tired to read the Stream directly, to no avail. This is what I get:

java.lang.ArrayIndexOutOfBoundsException: 1
at oracle.jdbc.ttc7.NonPlsqlTTCColumn.unmarshal(NonPlsqlTTCColumn.java)
at oracle.jdbc.ttc7.NonPlsqlTTCDataSet.unmarshalRow(NonPlsqlTTCDataSet.java)
at oracle.jdbc.ttc7.TTIrxd.unmarshal(TTIrxd.java)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java)
at oracle.jdbc.driver.OracleStatement.fetchNextColumns(OracleStatement.java)
at oracle.jdbc.driver.OracleInputStream.needBytes(OracleInputStream.java)
at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java)
at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java)
at oracle.jdbc.driver.OracleStatement.getBytesInternal(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java) at ...
my code...

Somebody has an idea? I use Long values because varchar2 are too short for what I need, but varchar2 works fine...

Thanks very much!

JP Moresmau
jeffries_at_indigo.ie Received on Mon Oct 04 1999 - 05:01:32 CDT