Re: Problems configuring DB pool 1.0

[VascoAce]

In a message dated 3/1/2006 9:03:04 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Were you able to get a db pool created in Geronimo for Sql Server?  I have not been able to get a connection yet.  Thanks for any information Maurice Maurice,   I was able to create a db pool for Sql Server 2005 using JTDS 1.2.   The following is assuming the jtds jar is already in the <geronimo_home>\repository\jtds\jars folder:   Put this inside a .bat file: java -jar C:\geronimo-1.0\bin\deployer.jar distribute C:\geronimo-1.0\repository\jtds\jars\sqlserver2005_geronimo_plan.xml C:\geronimo-1.0\repository\tranql\rars\tranql-connector-1.1.rar   This .bat file will deploy the the db pool in Geronimo.      This is the sqlserver2005_geronimo_plan.xml  deployment descriptor:   <?xml version="1.0"?>   <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector"             configId="darsDS"            parentId="geronimo/j2ee-server/1.0/car"> <dependency>   <uri>jtds/jtds/1.2</uri> </dependency> <resourceadapter>   <outbound-resourceadapter>     <connection-definition>       <connectionfactory-interface>         javax.sql.DataSource       </connectionfactory-interface>       <connectiondefinition-instance>         <name>darsDS</name>         <config-property-setting name="UserName">            userName         </config-property-setting>         <config-property-setting name="Password">            password         </config-property-setting>         <config-property-setting name="Driver">           net.sourceforge.jtds.jdbc.Driver         </config-property-setting>         <config-property-setting name="ConnectionURL">         jdbc:jtds:sqlserver://yourserverName:1433/databaseName         </config-property-setting>         <config-property-setting name="CommitBeforeAutocommit">            false         </config-property-setting>         <config-property-setting name="ExceptionSorterClass">            org.tranql.connector.NoExceptionsAreFatalSorter         </config-property-setting>           <connectionmanager>           <local-transaction/>           <single-pool>              <max-size>10</max-size>              <min-size>0</min-size>              <blocking-timeout-milliseconds>                 5000               </blocking-timeout-milliseconds>               <idle-timeout-minutes>                 30               </idle-timeout-minutes>               <match-one/>           </single-pool>         </connectionmanager>       </connectiondefinition-instance>     </connection-definition>   </outbound-resourceadapter> </resourceadapter> </connector>       Alberto