Hi, You gave too little code for concrete help to be easy ;) What are the types returned from .getDbCon() and getCon() ? Judging from the rest of your code, you're probably expecting an Oracle-specific type?
In general, try to use the JDBC API as much as possible and vendor-specific extensions as little as possible. Yoav Shapira Millennium Research Informatics >-----Original Message----- >From: Edson Alves Pereira [mailto:[EMAIL PROTECTED] >Sent: Friday, August 27, 2004 1:44 PM >To: Tomcat-User List (E-mail) >Subject: 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 This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
