cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matthew Langham" <mlang...@sundn.de>
Subject AW: SQLProcessor MS SQL Server
Date Fri, 12 May 2000 12:32:20 GMT
Christian -

YES! That was it.

Danke und schoenes Wochenende !

Matthew

--
=================================================================
Matthew Langham, S&N AG, Klingenderstrasse 5, D-33100 Paderborn
Tel: +49-5251-1581-30   [mlangham@sundn.de - http://www.sundn.de]
=================================================================

-----Ursprüngliche Nachricht-----
Von: Schmitt, Christian [mailto:Christian.Schmitt@Dresdner-Bank.com]
Gesendet: Freitag, 12. Mai 2000 14:02
An: cocoon-users@xml.apache.org
Betreff: AW: SQLProcessor MS SQL Server


Hi Matthew,
we stumbled across the same using an Informix database.
We patched org.apache.cocoon.processor.sql.SQLProcessor.java.

At line 294 it reads:
st.close(); conn.commit();

We replaced that with:
st.close();
if (!conn.getAutoCommit()) conn.commit();

May be this ought to be incorporated into Cocoon.


Hope this helps,
Christian Schmitt




> -----Ursprüngliche Nachricht-----
> Von: Matthew Langham [mailto:mlangham@sundn.de]
> Gesendet am: Freitag, 12. Mai 2000 13:58
> An: cocoon-users@xml.apache.org
> Betreff: SQLProcessor MS SQL Server
>
> I cant seem to access the apache site - so I cant check the docs and
> archive.
>
> Has anyone got SQLProcessor to work against MS SQL-Server 6.5
> using a JDBC
> driver (not ODBC)? - What are you using? I have got the
> FreeTDS driver and
> keep getting an error on select : "This method should only be
>  used when
> auto commit has
> been disabled."
>
> Apart from that - is it possible to have multiple SQL queries
> in the same
> XML file using the same connection? How do you do that?
>
> Again - sorry - its probably all in the archive...
>
> Matthew
>
> --
> =================================================================
> Matthew Langham, S&N AG, Klingenderstrasse 5, D-33100 Paderborn
> Tel: +49-5251-1581-30   [mlangham@sundn.de - http://www.sundn.de]
> =================================================================
>
> --------------------------------------------------------------
> ----------------------------
> ...this mail was scanned for viruses by mailserver...
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>

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

------------------------------------------------------------------------------------------
...this mail was scanned for viruses by mailserver...

Mime
View raw message