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
