Ok, I've searched and searched, but I cannot figure out the answer. I
am using Tomcat container provided connection pooling; connecting to
an Oracle XE server and I need to insert a CLOB. It would appear that
doing this task is dependent upon which RDBMS vendor you're working
with?
Can anyone help me understand what I need to do? I've gotten this far:
import javax.naming.*;
import java.sql.*;
import javax.sql.*;
import oracle.jdbc.*;
// try/catch stuff omitted for example.
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/env/");
DataSource ds = (DataSource) envContext.lookup("jdbc/isms_messaging");
Connection conn = ds.getConnection();
sqlString = "insert into message_body (message_id,message_body) values (?,?)";
PreparedStatement insertMsgBodyRecord = conn.prepareStatement(sqlString);
insertMsgBodyRecord.setString(1,message.getMessageId());
// This is where things fall apart (setStringForClob
// is a Oracle PreparedStatement method) - which
// is wrong, but still
insertMsgBodyRecord.setStringForClob(2,message.toXML());
insertMsgBodyRecord.executeUpdate();
insertMsgBodyRecord.close();
conn.close();
thanks
-- brian
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
