Hola,
Just to clarify, is it true that you can store a CLOB if the
java.sql.Connection is
obtained directly from Oracle's DriverManager?
But when you use a java.sql.Connection from DBCP, everything else being
the same,
you can not store a CLOB?
If that's the situation, then there has to be some difference between
the Connections.
I'm not familiar with Tomcat's DBCP, we use JBoss, so I don't know what
goes into
configuring TC's DBCP. Is should be possible to configure DBCP to user the
DriverManager in Oracle's ojdbc14.jar.
/Robert
Edson Alves Pereira wrote:
Hello again, servlet_.getDbCon( ).getCon( ) returns just a
java.sql.Connection, with every DBCP i setup properly cause the connection
works fine and CLOB is a oracle.sql.CLOB from oracle´s ojdbc14.jar. I tried
once to store CLOBs in Oracle with jdbc standard and it didn´t workout, i
just followed the Oracle´s recomendations, again this error only happens
with DBCP.
-Mensagem original-
De: Edson Alves Pereira
Enviada em: sexta-feira, 27 de agosto de 2004 14:44
Para: Tomcat-User List (E-mail)
Assunto: another DBCP problem with tomcat 4.1.30, tomcat-5.0.27 and
OracleApplicationServer-9.0.4
Hello dudes, i´m trying to store a value to a CLOB in my databse,
everything is fine with a simple Connection created with DriverManager,
but when i use DBCP from one of these servlet-engines i got the same
error:
ava.sql.SQLException: invalid arguments in call
04/08/27 11:56:44 at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
04/08/27 11:56:44 at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:231)
04/08/27 11:56:44
atoracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:294)
04/08/27 11:56:44 at oracle.sql.CLOB.createTemporary(CLOB.java:527)
04/08/27 11:56:44 at appi.util.JUtils.getClob(JUtils.java:166)
Here´s my code:
//create a new temporary CLOB
tempClob = CLOB.createTemporary(
servlet_.getDbCon( ).getCon( ),
true,
CLOB.DURATION_SESSION );
How can i fix it?
Regards,
Edson