Date: 2005-01-18T06:22:52 Editor: OliverBaum Wiki: DB OJB Wiki Page: YourQuestionHere URL: http://wiki.apache.org/db-ojb/YourQuestionHere
no comment Change Log: ------------------------------------------------------------------------------ @@ -594,3 +594,39 @@ Help! Thanks + +------- + [EMAIL PROTECTED] + +We're using OJB with the MSSQL DB. Now we have problems with the reconnect to the DB when the DB was down. Can somebody tell me what we can do? + +Entry in the respository.xml: + +<jdbc-connection-descriptor +jcd-alias="default" +default-connection="true" +platform="MsSQLServer" +jdbc-level="2.0" +driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" +protocol="jdbc" +subprotocol="microsoft:sqlserver" +dbalias="//serv114:1433;SelectMethod=cursor;databasename=sqltest" +username="***" +password="***" +batch-mode="false" +useAutoCommit="2" +ignoreAutoCommitExceptions="false" +> + +<sequence-manager +className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl"> +</sequence-manager> + +<connection-pool +maxActive="10" +validationQuery="select count(*) from OJB_HL_SEQ" +/> + +Thanks +Olly --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
