//approach 1:
In weblogic.properties file under weblogic jdbc connection pool management insert the code
as
Weblogic.jdbc.connectionPool.oraclePool=\
url=jdbc:oracle:thin:@wdodev:1521:wdodb,\
driver=oracle.jdbc.driver.OracleDriver,\
initialCapacity=4,\
maxCapacity=10,\
props=user=john; password= secret;
weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.oraclePool=oraclePoo l
weblogic.allow.reserve.weblogic.jdbc.connectionPool.oraclePool=ev eryone and add c:\Oracle\Ora81\jdbc\lib\classes111.zip to weblogic_classpath in startWeblogic.cmd file.
add to set CLASSPATH in startWeblogic.cmd file as c:\Oracle\jdbc\lib\classes111.zip.
this should work out. //approach 2:
hi,
you should add the driver(.zip file ) to the weblogic.classpath in the startWebLogic.cmd(if u are using NT).The zip file can be obtained from the Oracle site. In the weblogic properties file,give the relevant < > details. weblogic.jdbc.connectionPool.<Pool name>=\
url=jdbc:oracle:thin:<machine name>:1521:<database name>,\
driver=oracle.jdbc.driver.OracleDriver,\
loginDelaySecs=0,\
initialCapacity=4,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=<table name>,\
props=user=<username>;password=<secret>; It should work.
In weblogic.properties file under weblogic jdbc connection pool management insert the code
as
Weblogic.jdbc.connectionPool.oraclePool=\
url=jdbc:oracle:thin:@wdodev:1521:wdodb,\
driver=oracle.jdbc.driver.OracleDriver,\
initialCapacity=4,\
maxCapacity=10,\
props=user=john; password= secret;
weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.oraclePool=oraclePoo l
weblogic.allow.reserve.weblogic.jdbc.connectionPool.oraclePool=ev eryone and add c:\Oracle\Ora81\jdbc\lib\classes111.zip to weblogic_classpath in startWeblogic.cmd file.
add to set CLASSPATH in startWeblogic.cmd file as c:\Oracle\jdbc\lib\classes111.zip.
this should work out. //approach 2:
hi,
you should add the driver(.zip file ) to the weblogic.classpath in the startWebLogic.cmd(if u are using NT).The zip file can be obtained from the Oracle site. In the weblogic properties file,give the relevant < > details. weblogic.jdbc.connectionPool.<Pool name>=\
url=jdbc:oracle:thin:<machine name>:1521:<database name>,\
driver=oracle.jdbc.driver.OracleDriver,\
loginDelaySecs=0,\
initialCapacity=4,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=<table name>,\
props=user=<username>;password=<secret>; It should work.
Using jdbc 2.0 provided by oracle8i.
classes12.zip
When you install client8i, select "custom", and select "jdbc2.0".