This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

creating JDBC Connection Pool in weblogic6.1

 
vasu devan
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I am trying to create JDBC connection pool in weblogic6.1 console, but I am not in position to get connected with the Oracle database.
I have used the following setting in the console.
NAME:My connection Pool
URL :jdbc:weblogic racle
DriverClassName:weblogic.jdbc.oci.Driver
Properties:user=scott server=<database server IP>
Is it correct? Do suggest me the right configuration.
Thanks in Advance
Vasu
[ May 01, 2002: Message edited by: champ ]
 
Pradeep bhatt
Ranch Hand
Posts: 8927
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I hope u have set the password...U can do that by passing password property along with user property..BTW , have u targeted the pool to the server with u r connecting...Use the targets tab in the console to map the pool to the server..It would be better if u post the error message..
Originally posted by champ:
Hi All,
I am trying to create JDBC connection pool in weblogic6.1 console, but I am not in position to get connected with the Oracle database.
I have used the following setting in the console.
NAME:My connection Pool
URL :jdbc:weblogic racle
DriverClassName:weblogic.jdbc.oci.Driver
Properties:user=scott server=<database server IP>
Is it correct? Do suggest me the right configuration.
Thanks in Advance
Vasu
[ May 01, 2002: Message edited by: champ ]

 
Rajeev Bakhru
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Check whether u selected the connection pool in the services tab- JDBC in the console for the server.
Rajeev
 
vasu devan
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi pradeep bhat,
Thanks for the reply
I have set the password also. In the targets tab I have set the server name also.
I am just pasting my code below for you to check and suggest whether the approach is correct.

Class.forName("weblogic.jdbc.oci.Driver");
Connection con = DriverManager.getConnection("jdbc:weblogic racle","username","password");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("sql");

The problem is I could not connect to the database. Do suggest me what is the problem.
Thanks
Vasu
 
Roshan Lal
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by champ:
Hi All,
I am trying to create JDBC connection pool in weblogic6.1 console, but I am not in position to get connected with the Oracle database.
I have used the following setting in the console.
NAME:My connection Pool
URL :jdbc:weblogic racle
DriverClassName:weblogic.jdbc.oci.Driver
Properties:user=scott server=<database server IP>
Is it correct? Do suggest me the right configuration.
Thanks in Advance
Vasu
[ May 01, 2002: Message edited by: champ ]

I use something like:
Properties:--->
user=Test
password=Test
dll=ocijdbc8
protocol=thin
URL:---> (I am using oracle thin driver)
dbc racle:thin:@machine:1521 racleSID
Driver:--->
oracle.jdbc.driver.OracleDriver
Hope that helps!
 
arun sahni
Ranch Hand
Posts: 91
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I too have similar problem with Bea6.1 connecting to Oracle 9. Is this dll=ocijdbc8 work for oracle9 also?
 
Pradeep bhatt
Ranch Hand
Posts: 8927
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Driver myDriver = (Driver)
Class.forName("weblogic.jdbc.pool.Driver").newInstance();
Properties props = new Properties();
props.put("connectionPoolID", "myConnectionPool");
Connection conn =
myDriver.connect("jdbc:weblogic ool", props);
Has the connection pool created properly ? U can observe this from admin console. If the pool is not created plz read the JDBC doc on oracle db.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic