Hi Frank,
To get a connection object from pool,
Properties p=new Properties();
p.put("weblogic.t3.connectionPoolID",poolName);
Where poolName = oraclePool // in your case
Connection con = DriverManager.getConnection(poolURL,p);
Where poolURL = "jdbc:oracle:thin:username/password@hostname:port:database
instance "; //if you are using oracle thin driver.
Hope this helps
Roopa
-----Original Message-----
From: A mailing list for Enterprise JavaBeans development
[mailto:[EMAIL PROTECTED]]On Behalf Of Frank Gao
Sent: Monday, January 22, 2001 9:04 AM
To: [EMAIL PROTECTED]
Subject: Re: The Connection Pool in Weblogic Server.
Hi, when you start weblogic server, you should be able to see some error
message in your server screen. Could be driver is not in your weblogic class
path.
Frank
-----Original Message-----
From: EJB Vikas [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 20, 2001 6:39 PM
To: [EMAIL PROTECTED]
Subject: The Connection Pool in Weblogic Server.
Hi Everbody,
I am using Weblogic with Oracle8i on WindowsNT4.0
I am connecting to Weblogic via Connection Pooling.
In my weblogic.properties file I have the following code:
weblogic.jdbc.connectionPool.oraclePool=\
url=jdbc:weblogic:oracle,\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=1,\
initialCapacity=4,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=SCOTT;password=tiger;server=Oracle8
[I am able to connect to DB by SQL P! lus with given parameters]
But when I write it in My Servlet:
Class.forName("weblogic.jdbc.pool.Driver");
conn = DriverManager.getConnection"jdbc:weblogic:pool:oraclePool");
I am getting the Error and not able to connect to the DB.The error raised
is:
java.SQL.Exception: Poolconnect failed: Connection Pool oraclePool does not
exist.
Can anybodyof you tell me that what might be the problem??? How I can
rectify
it????
TIA.
_____
Get your FREE download of MSN Explorer at http://explorer.msn.com
<http://explorer.msn.com>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
