Oracle-L: RE: BLOB question/JDBC

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Mon, 18 Aug 2003 11:39:28 -0800
Message-ID: <F001.005CB602.20030818113928@fatcity.com>

Thin driver supports LOBs.

-----Original Message-----

From:	Vordos, Suzy [mailto:Suzy.Vordos_at_qwest.com]
Sent:	Mon 8/18/2003 2:19 PM
To:	Multiple recipients of list ORACLE-L
Cc:	
Subject:	RE: BLOB question/JDBC

IIRC, the thin driver doesn't support LOBs

-----Original Message-----
Sent: Friday, August 15, 2003 8:26 AM
To: Multiple recipients of list ORACLE-L

Hi,

I'm fairly new to the area of JDBC and Orcale but I was hoping some of you may be able to help me out with this one. I may have the wrong list as its a Java related question. If so could someone please direct me to the correct list.

I'm trying to write a large file into a BLOB column of an Oracle 9I DB, using a set of classes as follows ..

I'm creating a general java.sql.Connection as follows ...

dbUrl = "jdbc:" + dbProtocol + ":thin:@" + dbHost + ":" +dbPort + ":" + dbName;

Class.forName(oracle.jdbc.driver.OracleDriver);

return DriverManager.getConnection(dbUrl, dbUser, dbPass);

So I'm returning from here with a normal java.sql.Connection.

Then I'm creating a the BLOB as follows ...

oracle.sql.BLOB dataFile = new BLOB((OracleConnection) con, dataAsBytes);

Note here that I am casting the java.sql.Connection to an OracleConnection and passing this as an argument. Why does the connection need to be passed as an argument here ??

I am then using a PreparedStatement to send the BLOB to the DB.

stmt.setBlob(1,dataFile);

stmt.setString(2,time.toString());

stmt.setLong(3,time.getTimeInMillis());

stmt.executeUpdate();

stmt.close();

con.close();

My problem is that I keep getting the following exception ....

java.sql.SQLException: ORA-24813: cannot send or receive an unsupported LOB

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)

at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)

at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)

at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)

at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132 )

at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)

at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java :2877)

at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState ment.java:608)

at
com.changingworlds.nav.updatemanager.database.DatabaseManager.addToHistoryDB
(DatabaseManager.java:138)

I've been looking all over for a solution to this exception and I'm finding that its usually caused when I am using the different versions of oracle on server and client.

I don't understand this because I am using the correct oracle9i drivers.

I hope somebody can help me with this as I'm really stuck.

Yours sincerely,

Robert Foley

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

------_=_NextPart_001_01C365B8.3442F6DC--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: Richard.Ji_at_ztango.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).



application/ms-tnef attachment: winmail.dat

Received on Mon Aug 18 2003 - 14:39:28 CDT