You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by Leszek Gawron <ou...@wlkp.org> on 2003/08/09 09:21:19 UTC
cocoon + MS SQL Server problem
I am successfully using cocoon as a middle tier to Microsoft SQL Server engine
via Microsoft JDBC driver (SP1). I do not really know if this is a cocoon or a
JDBC driver issue but I'm unable to determine it without your help.
The goal of the project is to provide the end user with alternate client to
various accounting systems. The client application resides on Pocket PC based
devices (C++) and communicates with middle tier via HTTP (sending and receiving
xml instructions and data).
Now the problem:
One of our customers reported that after some days of my cocoon based middie
tier running that his accounting system starts working veeery slow. The only
connection point between my system and the accounting system is the database
as the original accounting clients connect directly to SQL Server database.
-----------------------------------------------------------------------------
|The fix he found: restart Tomcat on which cocoon resides. The effect is |
|immediate and everything goes back to normal (for 2-3 days). |
| |
|The version installed at custmers site is cocoon-2.1 (cvs version about a |
|month old). For my database communication I use __ESQL only__. |
-----------------------------------------------------------------------------
Best regards
Leszek Gawron
Re: cocoon + MS SQL Server problem
Posted by Frank Taffelt <fr...@interface-business.de>.
> Has anybody asked them for releasing a new version?
Peter Royal did this 2 weeks ago, but i believe there was no action
triggered.
Frank
Re: cocoon + MS SQL Server problem
Posted by Joerg Heinicke <jo...@gmx.de>.
Has anybody asked them for releasing a new version?
Joerg
Frank Taffelt wrote:
> Hi,
>
> i had the same problems with jtds jdbc driver and ms sql server (and it was
> driving me crazy).
>
> The problem described shortly: The sql server closes connections and the
> jdbc driver throws an exception. This exception is not recognized by the
> jdbc pooling component. The connection gets lost, but the jdbc pool doesn't
> know it. This occurs till your max connection number is exceed and then your
> application hangs when requesting a datasource from the pool.
>
> A solution is to upgrade your excalibure datasource to a recent version.
> Look under
> http://cvs.apache.org/viewcvs.cgi/avalon-excalibur/datasource/src/java/org/a
> pache/avalon/excalibur/datasource/AbstractJdbcConnection.java
>
> revision 1.30 fixes this bug.
>
> hth,
> Frank
Re: cocoon + MS SQL Server problem
Posted by Frank Taffelt <fr...@interface-business.de>.
Hi,
i had the same problems with jtds jdbc driver and ms sql server (and it was
driving me crazy).
The problem described shortly: The sql server closes connections and the
jdbc driver throws an exception. This exception is not recognized by the
jdbc pooling component. The connection gets lost, but the jdbc pool doesn't
know it. This occurs till your max connection number is exceed and then your
application hangs when requesting a datasource from the pool.
A solution is to upgrade your excalibure datasource to a recent version.
Look under
http://cvs.apache.org/viewcvs.cgi/avalon-excalibur/datasource/src/java/org/a
pache/avalon/excalibur/datasource/AbstractJdbcConnection.java
revision 1.30 fixes this bug.
hth,
Frank
Re: cocoon + MS SQL Server problem
Posted by Bruno Dumon <br...@outerthought.org>.
Maybe this is caused by the following recently-fixed bug?
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=22050
On Sat, 2003-08-09 at 09:21, Leszek Gawron wrote:
> I am successfully using cocoon as a middle tier to Microsoft SQL Server engine
> via Microsoft JDBC driver (SP1). I do not really know if this is a cocoon or a
> JDBC driver issue but I'm unable to determine it without your help.
>
> The goal of the project is to provide the end user with alternate client to
> various accounting systems. The client application resides on Pocket PC based
> devices (C++) and communicates with middle tier via HTTP (sending and receiving
> xml instructions and data).
>
> Now the problem:
> One of our customers reported that after some days of my cocoon based middie
> tier running that his accounting system starts working veeery slow. The only
> connection point between my system and the accounting system is the database
> as the original accounting clients connect directly to SQL Server database.
>
> -----------------------------------------------------------------------------
> |The fix he found: restart Tomcat on which cocoon resides. The effect is |
> |immediate and everything goes back to normal (for 2-3 days). |
> | |
> |The version installed at custmers site is cocoon-2.1 (cvs version about a |
> |month old). For my database communication I use __ESQL only__. |
> -----------------------------------------------------------------------------
>
> Best regards
> Leszek Gawron
--
Bruno Dumon http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno@outerthought.org bruno@apache.org
Re: cocoon + MS SQL Server problem
Posted by Mark Leicester <ma...@energyintellect.com>.
On 9/08/2003 8:21, "Leszek Gawron" <ou...@wlkp.org> wrote:
Hi,
Our company used cocoon with MSSQL and we had similar sounding issues with
any driver based on the FreeTDS code. I think that the Microsoft driver is
in that category. It seemed to be related to using these drivers with the
connection pooling. Locks were not being released eventually causing *major*
degradation in performance. We also used ESQL. In our case, like yours,
restarting Tomcat fixed it. We found that the Sprinta driver works well and
so we use that instead.
Hope this helps!
Mark
> I am successfully using cocoon as a middle tier to Microsoft SQL Server engine
> via Microsoft JDBC driver (SP1). I do not really know if this is a cocoon or a
> JDBC driver issue but I'm unable to determine it without your help.
>
> The goal of the project is to provide the end user with alternate client to
> various accounting systems. The client application resides on Pocket PC based
> devices (C++) and communicates with middle tier via HTTP (sending and
> receiving
> xml instructions and data).
>
> Now the problem:
> One of our customers reported that after some days of my cocoon based middie
> tier running that his accounting system starts working veeery slow. The only
> connection point between my system and the accounting system is the database
> as the original accounting clients connect directly to SQL Server database.
>
> -----------------------------------------------------------------------------
> |The fix he found: restart Tomcat on which cocoon resides. The effect is |
> |immediate and everything goes back to normal (for 2-3 days). |
> | |
> |The version installed at custmers site is cocoon-2.1 (cvs version about a |
> |month old). For my database communication I use __ESQL only__. |
> -----------------------------------------------------------------------------
>
> Best regards
> Leszek Gawron