Are there any examples on setting up a WebLogic 5.x with MSSQL 7.0?
Created May 4, 2012
Luigi Viggiano It can be done in two steps:
- Include the WebLogic jDriver for Microsoft SQL Server classes in the WebLogic classpath used to start WebLogic Server (specified with the weblogic.class.path property on the command line).
- create a connection pool in weblogic.properties:
weblogic.jdbc.connectionPool.SQLPool=
url=jdbc:weblogic:mssqlserver4:myServer:myPort,
driver=weblogic.jdbc.mssqlserver4.Driver,
loginDelaySecs=1,
initialCapacity=4,
maxCapacity=10,
capacityIncrement=2,
allowShrinking=true,
shrinkPeriodMins=15,
refreshTestMinutes=10,
testTable=dual,
props=user=myUserName;password=secret;server=myServer;
You can find everything you need here: