Return-Path: 
 <ojb-user-return-20861-apmail-db-ojb-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ojb-user-archive@www.apache.org
Received: (qmail 6907 invoked from network); 16 Jun 2005 13:22:41 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 16 Jun 2005 13:22:41 -0000
Received: (qmail 1065 invoked by uid 500); 16 Jun 2005 13:22:39 -0000
Delivered-To: apmail-db-ojb-user-archive@db.apache.org
Received: (qmail 1032 invoked by uid 500); 16 Jun 2005 13:22:38 -0000
Mailing-List: contact ojb-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:ojb-user-unsubscribe@db.apache.org>
List-Help: <mailto:ojb-user-help@db.apache.org>
List-Post: <mailto:ojb-user@db.apache.org>
List-Id: "OJB Users List" <ojb-user.db.apache.org>
Reply-To: "OJB Users List" <ojb-user@db.apache.org>
Delivered-To: mailing list ojb-user@db.apache.org
Received: (qmail 999 invoked by uid 99); 16 Jun 2005 13:22:38 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of Roland.Ribi@braunvieh.ch
 designates 212.80.100.68 as permitted sender)
Received: from mail.braunvieh.ch (HELO mail.braunvieh.ch) (212.80.100.68)
  by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 16 Jun 2005 06:22:37 -0700
Received: from 192.168.168.22 [192.168.168.22]
	by mail.braunvieh.ch
	with XWall v3.33d ;
	Thu, 16 Jun 2005 15:18:03 +0200
Received: by sbzvzgsrv1.braunvieh.ch with Internet Mail Service (5.5.2650.21)
	id <NAXYM0D9>; Thu, 16 Jun 2005 15:18:58 +0200
Message-ID: <6FC2B4C5FA24D4118DAD00508BC74A5DDB16CD@sbzvzgsrv1.braunvieh.ch>
From: Ribi Roland <Roland.Ribi@braunvieh.ch>
To: 'OJB Users List' <ojb-user@db.apache.org>
Subject: RE: Tomcat 5.0, JNDI-DataSource and Blobs
Date: Thu, 16 Jun 2005 15:18:57 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2650.21)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

I found a solution:

Installed OJB 1.0.3 instead of 1.0.1


> -----Original Message-----
> From: Ribi Roland [mailto:Roland.Ribi@braunvieh.ch]
> 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 length>2000. (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="xxxxx"
>     password="xxxxx"
>     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="3600000"
>           minEvictableIdleTimeMillis="1800000"
>           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>
>         <name>factory</name>
>         <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
>       </parameter>
>       <parameter>
>         <name>driverClassName</name>
>         <value>oracle.jdbc.driver.OracleDriver</value>
>       </parameter>
>       <parameter>
>         <name>url</name>
>  
> <value>jdbc: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>
>         <name>username</name>
>         <value>xxxxx</value>
>       </parameter>
>       <parameter>
>         <name>password</name>
>         <value>xxxxx</value>
>       </parameter>
>       <parameter>
>         <name>initialSize</name>
>         <value>1</value>
>       </parameter>
>       <parameter>
>         <name>maxActive</name>
>         <value>5</value>
>       </parameter>
>       <parameter>
>         <name>maxIdle</name>
>         <value>2</value>
>       </parameter>
>       <parameter>
>         <name>minIdle</name>
>         <value>1</value>
>       </parameter>
>       <parameter>
>         <name>maxWait</name>
>         <value>-1</value>
>       </parameter>
>       <parameter>
>         <name>validationQuery</name>
>         <value>SELECT PA_ANI.nGetAniID('US 184087.2') FROM 
> DUAL</value>
>       </parameter>
>       <parameter>
>         <name>testOnBorrow</name>
>         <value>true</value>
>       </parameter>
>       <parameter>
>         <name>testOnReturn</name>
>         <value>true</value>
>       </parameter>
>       <parameter>
>         <name>testWhileIdle</name>
>         <value>false</value>
>       </parameter>
>       <parameter>
>         <name>timeBetweenEvictionRunsMillis</name>
>         <value>3600000</value>
>       </parameter>
>       <parameter>
>         <name>numTestsPerEvictionRun</name>
>         <value>5</value>
>       </parameter>
>       <parameter>
>         <name>minEvictableIdleTimeMillis</name>
>         <value>1800000</value>
>       </parameter>
>       <parameter>
>         <name>whenExhaustedAction</name>
>         <value>2</value>
>       </parameter>
> 
>     </ResourceParams>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org