geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vasco...@aol.com
Subject Re: Problems configuring DB pool 1.0
Date Wed, 01 Mar 2006 21:53:31 GMT
 
In a message dated 3/1/2006 9:03:04 PM Eastern Standard Time,  
momanning@yahoo.com 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_ 
(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

Mime
View raw message