oracle thin jdbc driver

[Jeremy Bencken]

I'm using the Oracle thin JDBC driver to connect to Oracle 8.0.5 on my
Linux box and having a strange problem. When I execute a select
statement on any single column, everything works great. When I attempt
to select multiple columns, I get the following SQLException. I can
select either name OR address1 individually without problems, but when I
attempt to select both (or any other combination), I get this exception:

<<unnecessary output truncated>>

getConnection returning
driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@6cd7d5]

Connection.prepareStatement
Statement.clearWarnings
PreparedStatement.executeQuery
PreparedStatement.executeUpdate
Statement.clearWarnings
Connection.nativeSQL
SELECT name, address1 from volunteers
SELECT name, address1 from volunteers
SQLException: SQLState(63000) vendor code(3115)
java.sql.SQLException: ORA-03115: unsupported network datatype or
representation

at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:207)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:540)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1286)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:784)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1177)

at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1321)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1358)

at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:263)

at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:150)

at review.service(review.java:102)

Has anybody else seen this error? This seems like it must be a common
problem, but I cannot find ANY mention of this on the Oracle website
(good luck trying to send an email to Support). There were some
postings in this newsgroup over the past year, but none of them appear
to have been resolved. I'm stumped.

I'm using JDK 118 + classes111b.zip (Oracle driver).

Help appreciated.

- Jeremy

[Tonetheman]

This sounds kind of cheesy but we had the same error message when
pulling a BLOB across the network with the thin driver.

And sadly enough we just bumped up the version of the JDBC driver and
everything is fine now.

I would like to here something from Oracle on this but I could not find
anything on their site either.

Oh well.

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

[Tim Romano]

When working with Oracle's ODBC drivers and Visual Basic, over a period of
three years, we encountered a never-ending parade of errors. One update
would fix a problem and introduce another. The following update would
re-introduce an error from two versions back. It was a nightmare. We
switched to Oracle's Objects for OLE and things got much more stable. And
Intersolv's ODBC drivers for use with report-writing software that required
an ODBC datasource. My fear (as we begin to convert our apps to Java) is
that we'll encounter the same kinds of problems with JDBC.

Which leads me to a question: are there any "thin" third party JDBC drivers
for Oracle that are rock-solid?
Tim Romano

Jeremy Bencken <jer...@REMOVETHISwebsimple.com> wrote in message
news:38439931...@REMOVETHISwebsimple.com...

[Bubba]

oracle jdbc drivers version 8.0.x or lower are based on v7 architecture
so no oracle 8 datatypes are supported in them -- hence the 3115 erro
rmessage.

move to the 8i (8.1.5) client for jdbc oci drivers and use the 8.1.6sdk
jdbc thin driver for "thin" drivers.

8.1.6 is due out shortly so more fixes will be availablwe in that
release.

i hope this helps ...