Return-Path: 
 <users-return-5020-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org
Received: (qmail 74075 invoked from network); 21 Sep 2007 13:32:43 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 21 Sep 2007 13:32:43 -0000
Received: (qmail 94674 invoked by uid 500); 21 Sep 2007 13:32:33 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 94657 invoked by uid 500); 21 Sep 2007 13:32:33 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 94648 invoked by uid 99); 21 Sep 2007 13:32:33 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Sep 2007 06:32:33 -0700
X-ASF-Spam-Status: No, hits=1.2 required=10.0
	tests=SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [81.88.238.142] (HELO mail2.aemcom.net) (81.88.238.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Sep 2007 13:32:30 +0000
Received: from [127.0.0.1] (unknown [81.88.231.73])
	by mx5.aemcom.net (Postfix) with ESMTP id 5ED3D6644F1
	for <users@jackrabbit.apache.org>; Fri, 21 Sep 2007 15:32:00 +0200 (CEST)
Message-ID: <46F3C884.1060807@abfidee.it>
Date: Fri, 21 Sep 2007 15:35:00 +0200
From: Adamo Bozzetti <adamo.bozzetti@abfidee.it>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
To: users@jackrabbit.apache.org
Subject: Problem with jboss datasource
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
X-Antivirus: avast! (VPS 000775-4, 20/09/2007), Outbound message
X-Antivirus-Status: Clean
X-Virus-Checked: Checked by ClamAV on apache.org

Hi all,
I'm using jackrabbit deployed on jboss 4.0.3 sp1 in a model 2 
configuration and i use Oracle 10g as db persistence layer. I'm using 
jackrabbit 1.2.3 and jdbc driver ojdbc14.jar.
When i configure the persistence manager accessing directly the db with 
a configuration like this:
 <PersistenceManager 
class="org.apache.jackrabbit.core.state.db.OraclePersistenceManager">
          <param name="driver" value="oracle.jdbc.OracleDriver"/>
          <param name="url" 
value="jdbc:oracle:thin:@192.168.1.3:1521:abftest"/>
          <param name="user" value="jackrabbit"/>
          <param name="password" value="password"/>
          <param name="schema" value="oracle"/>
          <param name="schemaObjectPrefix" value="dmarea_"/>
          <param name="externalBLOBs" value="true"/>
  </PersistenceManager>
there are no proglems in normal use, but when the db is stopped for the 
back up operation and then restarted, i noticed that the connection are 
non refreshed correctly, so i prefer to use the data source managed 
directly by the application server. But if i use a data source of jboss 
in a configuration like this:
     <PersistenceManager 
class="org.apache.jackrabbit.core.state.db.JNDIDatabasePersistenceManager">
          <param name="dataSourceLocation" value="java:/JackRabbitDS"/>
          <param name="schema" value="oracle"/>
          <param name="schemaObjectPrefix" value="dmarea_"/>
          <param name="externalBLOBs" value="true"/>
        </PersistenceManager>
I have problem writing node state because the dimension of the blob 
excedes the mazimum length, the stacktrace is below:
2007-09-21 14:33:36,687 ERROR 
[org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager] 
failed to write node state: 7b5eaf19-85eb-4392-8d4e-0d8b183b8138
java.sql.SQLException: La dimensione dei dati � superiore alla 
dimensione massima per questo tipo: 1024 (The dimension of data is above 
the maximun length for this type)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:95)
        at 
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2445)
        at 
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1170)
        at 
oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedStatement.java:2212)
        at 
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3006)
        at 
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3221)
        at 
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setObject(WrappedPreparedStatement.java:432)
        at 
org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.executeStmt(DatabasePersistenceManager.java:831)
        at 
org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:427)
        at 
org.apache.jackrabbit.core.persistence.AbstractPersistenceManager.store(AbstractPersistenceManager.java:82)
        at 
org.apache.jackrabbit.core.persistence.db.DatabasePersistenceManager.store(DatabasePersistenceManager.java:274)
        at 
org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedItemStateManager.java:675)
        at 
org.apache.jackrabbit.core.state.XAItemStateManager.commit(XAItemStateManager.java:162)
        at 
org.apache.jackrabbit.core.TransactionContext.commit(TransactionContext.java:172)
        at 
org.apache.jackrabbit.core.XASessionImpl.commit(XASessionImpl.java:315)
        at 
org.apache.jackrabbit.jca.TransactionBoundXAResource.commit(TransactionBoundXAResource.java:39)
        at 
org.jboss.tm.TransactionImpl$Resource.commit(TransactionImpl.java:2233)
        at 
org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1764)
        at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:340)
        at 
org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:486)
        at 
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:346)
        at 
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
        at 
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)
        at 
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
        at 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
        at 
org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
        at org.jboss.ejb.Container.invoke(Container.java:873)

I have already seen this problem using jboss datasource managing blob 
data, but it can be solved using the underlying connection instead of 
the wrapped connection of jboss.
I search in the list but i don't find anything for this.
Can anyone help me?
Thank you in advance.

-- 
Adamo Bozzetti
ABF Ideee snc
Corso Matteotti, 10
26100 CREMONA
tel. 0372/800746
fax  0372/800746
e-mail: adamo.bozzetti@abfidee.it
url: www.abfidee.it

Le informazioni contenute nella presente e-mail e nei documenti eventualmente allegati sono confidenziali e sono comunque  riservate al destinatario delle stesse.
La loro diffusione, distribuzione e/o copia da parte di terzi � proibita e pu� costituire violazione della normativa che tutela il diritto alla privacy.
Se avete ricevuto questa comunicazione per errore, Vi preghiamo di informare immediatamente il mittente del messaggio e di distruggere questa e-mail.
________________________________________________________________________________________
This e-mail is confidential and it is legally privileged.
If you have received it in error, please notify us immediately by reply e-mail and then delete this message from your system.
Please do not copy it or use it for any purposes, or disclose its contents to any other person.
Mind that to do so could be a breach of Italian privacy Law.
Thank you for your co-operation.