On Fri, Sep 02, 2005 at 03:40:23PM +0200, Andreas Busch wrote:
> I have to store posted XML-Documents into a Oracle Database for Archiving,
> but i have no idea how to do this.
> I think SQLTransformer can not handle Blob/Clob as a stream!
> Something like this :
> <xsl:template match="/">
> <sql:execute-query>
> <sql:query>
> insert into incoming(id,docnummer,xmldata)
> values(inc_seq.nextval(),1,xmlelement('<xsl:copy-of select="/"
> />'))
> </sql:query>
> </sql:execute-query>
> </xsl:template>
>
> Can handle up to 4000 bytes only.
>
> After storing I have to process the xml and store it in relational
> tablestruktur so sqlTransformer/XSQL looks good for this job.
> Or must I write a custom Streamgenerator ??
In the Oracle 10g driver (backwards-compatible with 9) there is a
setBigStringTryClob parameter which gets around this limitation. See:
http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/clob10g/handlingclobsinoraclejdbc10g.html
http://confluence.atlassian.com/display/JIRA/Using+Oracle+10g+drivers+to+solve+the+4000+character+limitation
--Jeff
> Thanks a million
>
>
> Andreas Busch
> ILOGICS GmbH â Berduxstr. 22 â D-81245 München
> [EMAIL PROTECTED]
> Tel: +49 89 896667-0
> Fax: +49 89 896667-29
> www.ilogics.de
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
