Are there any examples on setting up a WebLogic 5.x with MSSQL 7.0?

Luigi Viggiano

It can be done in two steps:

  1. 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).
  2. 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:

0 Comments  (click to add your comment)
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

About | Sitemap | Contact