Re: Tomcat 5.0, JNDI-DataSource and Blobs

2005-06-20 Thread Martin Kalén 

Ribi Roland wrote:

I found a solution:

Installed OJB 1.0.3 instead of 1.0.1


The reason it works with OJB 1.0.2 or later (and didn't in=1.0.1) is that
Tomcat uses DBCP for Connection Pooling and that DBCP wraps the Oracle
Connection object in a DBCP-specific PoolWrapper object.

In older versions of OJB you would get exactly the same problem with
non-DataSource connection pools if you use the OJB DBCP ConnectionFactory
(configurable in OJB.properties).

We have added unwrapping of Connections object for all environments that
we have user reports for (including P6Spy, DBCP, JBoss, WebLogic).

Regards,
 Martin


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

RE: Tomcat 5.0, JNDI-DataSource and Blobs

2005-06-16 Thread Ribi Roland 
I found a solution:

Installed OJB 1.0.3 instead of 1.0.1


 -Original Message-
 From: Ribi Roland [mailto:[EMAIL PROTECTED]
 Sent: Thursday, June 16, 2005 11:11 AM
 To: 'ojb-user@db.apache.org'
 Subject: Tomcat 5.0, JNDI-DataSource and Blobs
 
 
 Hi
 
 Since I moved the config of the connection pool from repository.xml to
 server.xml and get the connection via JNDI-lookup the broker 
 throws the
 following Exception:
 
 ch.braunvieh.dbutils.DirectoryImageUploadVisitor -
 org.apache.ojb.broker.PersistenceBrokerSQLException: SQL failure while
 insert object data for 
 class ch.braunvieh.ojb.argus.TFotoMitOrig, . [Oracle thin 
 driver cannot
 update BLOB values with length2000. (Consider using Oracle9i as OJB
 platform.)]
 
 
 Any hints? I did'nt change the JDBC-Driver classes or any 
 other Property...
 
 The old config in repository.xml was:
 jdbc-connection-descriptor
 jcd-alias=argus
 default-connection=true
 platform=Oracle9i
 jdbc-level=3.0
 driver=oracle.jdbc.driver.OracleDriver
 protocol=jdbc
 subprotocol=oracle
  
 dbalias=thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=T
 CP)(HOST=satur
 n.braunvieh.ch)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=AR01.s
 aturn.braunvie
 h.ch)(SERVER=DEDICATED))) 
 initsql=ALTER SESSION USING SCHEMA GESTHO
 username=x
 password=x
 ignoreAutoCommitExceptions=true
 useAutoCommit=0
   attribute attribute-name=initsql 
 attribute-value=ALTER SESSION
 SET NLS_NUMERIC_CHARACTERS='.,' /
   connection-pool 
   maxActive=50
   maxIdle=20
   maxWait=5000
   whenExhaustedAction=1
   testOnBorrow=true
   testOnReturn=true
   testWhileIdle=false
   timeBetweenEvictionRunsMillis=360
   minEvictableIdleTimeMillis=180
   numTestsPerEvictionRun=20
   validationQuery=SELECT PA_ANI.nGetAniID('US 
 184087.2') FROM DUAL
/
 sequence-manager
 className=org.apache.ojb.broker.util.sequence.SequenceManager
 NextValImpl
 /
   /jdbc-connection-descriptor
 
 And now it is:
 
jdbc-connection-descriptor
 jcd-alias=argus
 jndi-datasource-name=java:/comp/env/jdbc/argus
 default-connection=true
 platform=Oracle9i
 jdbc-level=3.0
 ignoreAutoCommitExceptions=true
 useAutoCommit=0
 driver=oracle.jdbc.driver.OracleDriver
   attribute attribute-name=initsql 
 attribute-value=ALTER SESSION
 SET NLS_NUMERIC_CHARACTERS='.,' /
 sequence-manager
 className=org.apache.ojb.broker.util.sequence.SequenceManager
 NextValImpl
 /
   /jdbc-connection-descriptor
 
 
 
 The Connection-Pool is defined as follows in the server.xml:
 
 
 Resource name=argus auth=Container
 type=javax.sql.DataSource/ 
 
 ResourceParams name=argus
   parameter
 namefactory/name
 valueorg.apache.commons.dbcp.BasicDataSourceFactory/value
   /parameter
   parameter
 namedriverClassName/name
 valueoracle.jdbc.driver.OracleDriver/value
   /parameter
   parameter
 nameurl/name
  
 valuejdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(
 PROTOCOL=TCP)(
 HOST=saturn.braunvieh.ch)(PORT=1521)))(CONNECT_DATA=(SERVICE_N
 AME=AR01.satur
 n.braunvieh.ch)(SERVER=DEDICATED)))/value
   /parameter
   parameter
 nameusername/name
 valuex/value
   /parameter
   parameter
 namepassword/name
 valuex/value
   /parameter
   parameter
 nameinitialSize/name
 value1/value
   /parameter
   parameter
 namemaxActive/name
 value5/value
   /parameter
   parameter
 namemaxIdle/name
 value2/value
   /parameter
   parameter
 nameminIdle/name
 value1/value
   /parameter
   parameter
 namemaxWait/name
 value-1/value
   /parameter
   parameter
 namevalidationQuery/name
 valueSELECT PA_ANI.nGetAniID('US 184087.2') FROM 
 DUAL/value
   /parameter
   parameter
 nametestOnBorrow/name
 valuetrue/value
   /parameter
   parameter
 nametestOnReturn/name
 valuetrue/value
   /parameter
   parameter
 nametestWhileIdle/name
 valuefalse/value
   /parameter
   parameter
 nametimeBetweenEvictionRunsMillis/name
 value360/value
   /parameter
   parameter
 namenumTestsPerEvictionRun/name
 value5/value
   /parameter
   parameter
 nameminEvictableIdleTimeMillis/name
 value180/value
   /parameter
   parameter
 namewhenExhaustedAction/name
 value2/value
   /parameter
 
 /ResourceParams
 
 
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]