Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cocoon.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Message-Id: <432598B20200003500008861@sinclair.provo.novell.com>
Date: Mon, 12 Sep 2005 08:03:14 -0600
From: "Willy Reinhardt" <wreinhardt@novell.com>
To: <users@cocoon.apache.org>,<Andreas.Busch@ilogics.de>
Subject: =?ISO-8859-1?Q?R=C3=A9p.=20:=20CLOB=20Insert=20into=20Oracle=20f?=
 =?ISO-8859-1?Q?rom=20post?=
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

We had the same problem using Tiny JDBC driver version 9.2.0.5.0 with
Oracle 9.2. 
The problem with CLOB or BLOB is you need a native OracleConnection
instead of Connection after looking for solution I found following
possibillities:

- Use OCI driver -> you need to install the oracle client... 
- Use an alternative JDBC driver provide by a compagny like datadirect
which work fine according JBoss forums;
- Get the native OracleConnection from the datasource provide by the
Application server this solution couldn't be very safe because if the
connection is closed the Application Server will failed and you should
use specific API's from the provider of AS. To workaround we create
interface and factory to manage Oracle CLOB and BLOB according the
application server used.  

Then we wrote some Cocoon action's to manage XML request with Oracle.


Hope this help

Regards

Willy Reinhardt


>>> Andreas.Busch@ilogics.de 12/09/05 14:44 >>>
Hi again,
 
almost searching for any hints to insert a XML-Doc coming in via POST
into a
CLOB - Col in Oracle and process it in the pipeline futher on,
SQLTransformer can not insert values larger then (32000) (Oracle
Stringsize)
The parameter (setBigStringTryClob ) for the JDBC-Driver can not be set
in
cocoon.xconf  (Datasource don't have this parameter)
 
Thanks a Million for any idea
 
Andreas Busch
 

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org