another DBCP problem with tomcat 4.1.30, tomcat-5.0.27 and Oracle ApplicationServer-9.0.4

2004-08-27 Thread Edson Alves Pereira
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


Re: another DBCP problem with tomcat 4.1.30, tomcat-5.0.27 and Oracle ApplicationServer-9.0.4

2004-08-27 Thread Robert F. Hall
Howdy,
Apparently, the Connections returned from the DriverManager and the DBCP
are not equivalent ;-).   How is the DBCP getting Connections to Oracle?
/Robert
Edson Alves Pereira wrote:
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
 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]