I am trying to use JDBCStore with SQL Server2000. I use the slide 2rc1, and follow the SQLServerSchema(in db_schema folder) to create the tables. I download the JDBC driver from Microsoft website. the Domain.xml file is written as following. When I setup the slide, it appears org.apache.slide.store.impl.rdbms.JDBCStore couldnot create connection, because "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset".
do anyone know the reason, and help would be very appreciated.
Domain.xml configuration:
<store name="MsSqlStore">
<nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter name="adapter">org.apache.slide.store.impl.rdbms.SQLServerRDBMSAdapter</parameter>
<parameter name="driver">com.microsoft.jdbc.sqlserver.SQLServerDriver</parameter>
<parameter name="url">jdbc:microsoft:sqlserver://taojr:1433;DataBaseName=Slide</parameter>
<parameter name="user">administrator</parameter>
<parameter name="password">123</parameter>
<parameter name="dbcpPooling">true</parameter>
<parameter name="maxPooledConnections">10</parameter>
<parameter name="isolation">SERIALIZABLE</parameter>
<parameter name="compress">false</parameter>
</nodestore>
----------------------------------
errors:
17:49:05,106 INFO [STDOUT] 08 May 2004 17:49:05 - org.apache.slide.store.impl.rdbms.JDBCStore - EMERGENCY - Could not create connection. Reason: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
17:49:05,216 INFO [STDOUT] 08 May 2004 17:49:05 - org.apache.slide.common.Namespace - INFO - Loading namespace slide base data
17:49:05,256 INFO [STDOUT] 08 May 2004 17:49:05 - org.apache.slide.store.impl.rdbms.JDBCStore - EMERGENCY - Could not create connection. Reason: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
17:49:05,276 INFO [STDOUT] 08 May 2004 17:49:05 - org.apache.slide.transaction.SlideTransaction - WARNING - Enlist failure: Resource manager [EMAIL PROTECTED] Error code XAER_RMFAIL in Transaction 1 xid main-1084009745236-1- in thread main
17:49:05,496 INFO [STDOUT] 08 May 2004 17:49:05 - org.apache.slide.store.impl.rdbms.JDBCStore - EMERGENCY - Could not create connection. Reason:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
17:49:05,516 INFO [STDOUT] 08 May 2004 17:49:05 - org.apache.slide.transaction.SlideTransaction - WARNING - Enlist failure: Resource manager [EMAIL PROTECTED] Error code XAER_RMFAIL in Transaction 1 xid main-1084009745236-1- in thread main
.............................. ..............................
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
