We have a set of applications and , each app connect with 3 different DB, two
DB are shared for all app, and the others are only use for each app
Example
app db
------------------------------------
XXXX att
XXXX
des
-----------------------------------
YYYY att
YYYY
des
-----------------------------------
ZZZZ att
ZZZZ
des
If run only one app, all work nice, but when run many app's the Shared DB
(att,des) work nice, but the others work randomly(some times update the db,
sometimes not, but ever read nicely).
This app's run over JBoss 4.0.2 whit MS SQL server 2000 (Microsoft's Driver).
this is the mssql-ds.xml
.....
<local-tx-datasource>
<jndi-name>des</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://PROGRAMACION\\DESARROLLO:1433;DatabaseName=des</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
XXXX
<prepared-statement-cache-size>50</prepared-statement-cache-size>
<min-pool-size>5</min-pool-size>
<max-pool-size>50</max-pool-size>
<idle-timeout-minutes>15</idle-timeout-minutes>
<track-statements>false</track-statements>
<type-mapping>MS SQLSERVER2000</type-mapping>
.... many other's here
How we can do?
Many thank's for your answers... and sorry for my english, I'm latin
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3888771#3888771
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3888771
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
