Return-Path: 
 <ojb-user-return-20860-apmail-db-ojb-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ojb-user-archive@www.apache.org
Received: (qmail 88505 invoked from network); 16 Jun 2005 09:30:15 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 16 Jun 2005 09:30:15 -0000
Received: (qmail 51953 invoked by uid 500); 16 Jun 2005 09:30:11 -0000
Delivered-To: apmail-db-ojb-user-archive@db.apache.org
Received: (qmail 51928 invoked by uid 500); 16 Jun 2005 09:30:11 -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 51913 invoked by uid 99); 16 Jun 2005 09:30:11 -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 02:30:06 -0700
Received: from 192.168.168.22 [192.168.168.22]
	by mail.braunvieh.ch
	with XWall v3.33d ;
	Thu, 16 Jun 2005 11:10:18 +0200
Received: by sbzvzgsrv1.braunvieh.ch with Internet Mail Service (5.5.2650.21)
	id <NAXYM0B4>; Thu, 16 Jun 2005 11:11:11 +0200
Message-ID: <6FC2B4C5FA24D4118DAD00508BC74A5DDB16CA@sbzvzgsrv1.braunvieh.ch>
From: Ribi Roland <Roland.Ribi@braunvieh.ch>
To: "'ojb-user@db.apache.org'" <ojb-user@db.apache.org>
Subject: Tomcat 5.0, JNDI-DataSource and Blobs
Date: Thu, 16 Jun 2005 11:11:10 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2650.21)
Content-Type: text/plain
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

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=TCP)(HOST=satur
n.braunvieh.ch)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=AR01.saturn.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.SequenceManagerNextValImpl"
/>
  </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.SequenceManagerNextValImpl"
/>
  </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_NAME=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