Tricky Question for Shark 1.1-2, SQL Server and double deployment in Tomcat 6
Gabriel Gruber <[email protected]> Thu, 4 Mar 2010 17:38:03 +0100
| Newsgroups | gmane.comp.java.enhydra.shark |
|---|---|
| Message-ID | <OF747D8D9F.694DB4B6-ONC12576DC.005AC4E5-C12576DC.005B5FCC@workflow.at> |
This is a multi-part message in MIME format...
------------=_1267721669-8018-10397
Content-Type: multipart/alternative; boundary="=_alternative 005B5FC9C12576DC_="
This is a multipart message in MIME format.
--=_alternative 005B5FC9C12576DC_=
Content-Type: text/plain; charset="US-ASCII"
Hello Sasa and comunity!
I am still heavily using shark and we have a tricky problem with a
customer using shark inside our webapplication which is deployed 2 times
within the same tomcat (for different customers).
We have correctly set the shark-engine parameters to be unique for each
instance.
From time to time we get exceptions from DODS from the remote MS SQL
Server saying ... An existing connection was forcibly closed by the remote
host
We are using shark 1.1-2.
Complete Stacktrace:
stacktrace[hide]
java.sql.SQLException:
<SqlQueryExecute><SqlQueryException>(<Replicated>:An existing connection
was forcibly closed by the remote host)
at
com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(QueryBuilder.java:2480)
at
org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.executeQuery(ProcessDefinitionQuery.java:1357)
at
com.lutris.appserver.server.sql.standard.StandardDBQuery.query(StandardDBQuery.java:118)
at
org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.runQuery(ProcessDefinitionQuery.java:771)
at
org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.getDOArray(ProcessDefinitionQuery.java:1170)
at
org.enhydra.shark.instancepersistence.DODSPersistentManager.getAllPersistedProcessMgrs(DODSPersistentManager.java:3038)
at
org.enhydra.shark.instancepersistence.DODSPersistentManager.getProcessMgrsWhere(DODSPersistentManager.java:4248)
at
org.enhydra.shark.WfProcessMgrIteratorWrapper.fillObjectList(WfProcessMgrIteratorWrapper.java:203)
at
org.enhydra.shark.BaseIteratorWrapper.getNextNSequence(BaseIteratorWrapper.java:256)
at
org.enhydra.shark.WfProcessMgrIteratorWrapper._get_next_n_sequence(WfProcessMgrIteratorWrapper.java:148)
at
org.enhydra.shark.WfProcessMgrIteratorWrapper.get_next_n_sequence(WfProcessMgrIteratorWrapper.java:140)
at
org.enhydra.shark.ExecutionAdmin._get_sequence_processmgr(ExecutionAdmin.java:333)
at
org.enhydra.shark.ExecutionAdmin.get_sequence_processmgr(ExecutionAdmin.java:310)
at
at.workflow.webdesk.wf.sharkimpl.helper.WfSharkApi.getAllProcessMgrs(WfSharkApi.java:55)
at
at.workflow.webdesk.wf.sharkimpl.daos.WfProcessDefinitionDAOImpl.getCurrentProcMgrMap(WfProcessDefinitionDAOImpl.java:932)
at
at.workflow.webdesk.wf.sharkimpl.daos.WfProcessDefinitionDAOImpl.loadProcessDefinitions(WfProcessDefinitionDAOImpl.java:902)
at
at.workflow.webdesk.wf.sharkimpl.daos.WfProcessDefinitionDAOImpl.loadAllCurrentProcessDefinitions(WfProcessDefinitionDAOImpl.java:140)
.....
The next request will work again... It seems that after a longer period of
inactivity an existing connection gets dropped by the remote SQL Server
and DODS (Lutris DBConnection) does not notice it....
Would updating to latest DODS version help? Is it compatibly with Shark
1.1.2????
Any ideas, tips etc. greatly appreciated!!!
cheers,
Gabriel
--=_alternative 005B5FC9C12576DC_=
Content-Type: text/html; charset="US-ASCII"
<br><font size=2 face="sans-serif">Hello Sasa and comunity!</font>
<br>
<br><font size=2 face="sans-serif">I am still heavily using shark and we
have a tricky problem with a customer using shark inside our webapplication
which is deployed 2 times within the same tomcat (for different customers).</font>
<br>
<br><font size=2 face="sans-serif">We have correctly set the shark-engine
parameters to be unique for each instance.</font>
<br>
<br><font size=2 face="sans-serif">From time to time we get exceptions
from DODS from the remote MS SQL Server saying ... </font><font size=2 face="Courier New">An
existing connection was forcibly closed by the remote host</font>
<br>
<br><font size=2 face="sans-serif">We are using shark 1.1-2. </font>
<br>
<br><font size=2 face="sans-serif">Complete Stacktrace:</font>
<p><font size=3 face="Times New Roman">stacktrace[hide] </font>
<p><font size=2 face="Courier New">java.sql.SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:An
existing connection was forcibly closed by the remote host)</font>
<br><font size=2 face="Courier New"> at
com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(QueryBuilder.java:2480)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.executeQuery(ProcessDefinitionQuery.java:1357)</font>
<br><font size=2 face="Courier New"> at
com.lutris.appserver.server.sql.standard.StandardDBQuery.query(StandardDBQuery.java:118)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.runQuery(ProcessDefinitionQuery.java:771)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.getDOArray(ProcessDefinitionQuery.java:1170)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.instancepersistence.DODSPersistentManager.getAllPersistedProcessMgrs(DODSPersistentManager.java:3038)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.instancepersistence.DODSPersistentManager.getProcessMgrsWhere(DODSPersistentManager.java:4248)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.WfProcessMgrIteratorWrapper.fillObjectList(WfProcessMgrIteratorWrapper.java:203)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.BaseIteratorWrapper.getNextNSequence(BaseIteratorWrapper.java:256)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.WfProcessMgrIteratorWrapper._get_next_n_sequence(WfProcessMgrIteratorWrapper.java:148)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.WfProcessMgrIteratorWrapper.get_next_n_sequence(WfProcessMgrIteratorWrapper.java:140)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.ExecutionAdmin._get_sequence_processmgr(ExecutionAdmin.java:333)</font>
<br><font size=2 face="Courier New"> at
org.enhydra.shark.ExecutionAdmin.get_sequence_processmgr(ExecutionAdmin.java:310)</font>
<br><font size=2 face="Courier New"> at
at.workflow.webdesk.wf.sharkimpl.helper.WfSharkApi.getAllProcessMgrs(WfSharkApi.java:55)</font>
<br><font size=2 face="Courier New"> at
at.workflow.webdesk.wf.sharkimpl.daos.WfProcessDefinitionDAOImpl.getCurrentProcMgrMap(WfProcessDefinitionDAOImpl.java:932)</font>
<br><font size=2 face="Courier New"> at
at.workflow.webdesk.wf.sharkimpl.daos.WfProcessDefinitionDAOImpl.loadProcessDefinitions(WfProcessDefinitionDAOImpl.java:902)</font>
<br><font size=2 face="Courier New"> at
at.workflow.webdesk.wf.sharkimpl.daos.WfProcessDefinitionDAOImpl.loadAllCurrentProcessDefinitions(WfProcessDefinitionDAOImpl.java:140)</font>
<br><font size=2 face="sans-serif">.....</font>
<br>
<br><font size=2 face="sans-serif">The next request will work again...
It seems that after a longer period of inactivity an existing connection
gets dropped by the remote SQL Server and DODS (Lutris DBConnection) does
not notice it....</font>
<br>
<br><font size=2 face="sans-serif">Would updating to latest DODS version
help? Is it compatibly with Shark 1.1.2????</font>
<br>
<br><font size=2 face="sans-serif">Any ideas, tips etc. greatly appreciated!!!</font>
<br>
<br><font size=2 face="sans-serif">cheers,</font>
<br>
<br><font size=2 face="sans-serif">Gabriel</font>
<br>
<br>
<br>
--=_alternative 005B5FC9C12576DC_=--
------------=_1267721669-8018-10397
Content-Type: text/plain; charset="UTF-8"; name="message-footer.txt"
Content-Disposition: inline; filename="message-footer.txt"
Content-Transfer-Encoding: quoted-printable
--
You receive this message as a subscriber of the [email protected] mailing lis=
t.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=3Dhelp
OW2 mailing lists service home page: http://www.ow2.org/wws
------------=_1267721669-8018-10397--