-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Brian,

(Marking off-topic as this is a JDBC thang, not a Tomcat one).

Brian Munroe wrote:
| 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?

It shouldn't.

| // This is where things fall apart (setStringForClob
| // is a Oracle PreparedStatement method) - which
| // is wrong, but still
|
| insertMsgBodyRecord.setStringForClob(2,message.toXML());

What's wrong with

insertMsgBodyRecord.setString(2, message.toXML());

??

If your "message" is too long to fit into a String object, how about:

insertMsgBodyRecord.setCharacterStream(2, reader, length);

??

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkgHuQYACgkQ9CaO5/Lv0PBWkwCgmi0PjBhML2qVCIDl6hedjO99
ChEAnirZOMIVXoJ3RJ148NCFWxoEQdqQ
=Aags
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to