Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problems with JDBC drivers

Problems with JDBC drivers

From: <chandelr_at_delhi.tcs.co.in>
Date: Tue, 01 Dec 1998 14:25:43 GMT
Message-ID: <740u8l$ee0$1@nnrp1.dejanews.com>


We are using jdbc odbc bridge prvoded by Sun jdk1.1.5 for windows NT. When we try to insert or update multiple records (More than 10 -15, but not any fixed number), we get oracle error trying to insert value too large. But we are sure that there is nothing in the record which is more than the size of the column in the database. If we perform the sme operation one by one then it works fine. Now we replaced this drive with JDBC native driver which comes with Oracle 8 and the above mentioned is solved. But we started facing a different problem. During the query excecution the JVM of application crashes with GPF. This GPF is random in behaviour. We have several other problems like inserting a SQL Date data type in Oracle date with Jdbc Odbc bridge add 01:01:01 in time field. But Jdbc Oracle native driver inserts as date:00:00:00 in time field. Comarision of Double with Double in where clause does not give the appropriate result in JDBC ODBC driver. etc... We ported our application server to SUN Solaris and evrything works fine. Strange....Is'nt it? Any solution or suggestion?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 01 1998 - 08:25:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US