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: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]