File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes BEA/Weblogic and the fly likes Trying to make a connection pool with WebLogic 6.1 and SQL Server 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Trying to make a connection pool with WebLogic 6.1 and SQL Server 2000" Watch "Trying to make a connection pool with WebLogic 6.1 and SQL Server 2000" New topic
Author

Trying to make a connection pool with WebLogic 6.1 and SQL Server 2000

Maria Roman
Greenhorn

Joined: Jan 27, 2003
Posts: 3
Hi all!!!
Please, it�s dry me crasy!!!
I�m try to make a connection pool with WebLogic 6.1 and SQL Server 2000.
I�m download a driver for SQL Server 2000 (com.microsoft.jdbc.sqlserver.SQLServerDriver).
Don�t run.
Please, if someone has made this pool, write me!!!
Thank you !!!
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
I recommend using the SQL Server 2000 Driver that comes packaged with WebLogic, it is called the JDriver. I have ran into some issues using the Microsoft supplied SQL Server Driver. Then the WebLogic Driver has its own issues...
Here is a link to the JDriver documentation for SQL Server 2000: Installing and Using WebLogic jDriver for Microsoft SQL Server.
Write back if you have other questions.
Maria Roman
Greenhorn

Joined: Jan 27, 2003
Posts: 3
Thank you very much, but I read this page before. I follow the instructions but the pool don�t run.
The SQL Server 2000 is a server where there are severals data base and I try to connect by other pc.
I try all the option and don�t run. Sometimes WebLogic tell me that cannot load the driver.
I�m lost.
I use this sentences:
URL : jdbc:microsoft:sqlserver://IPDIR ORT
Driver : com.microsoft.jdbc.sqlserver.SQLServer
If you have an idea, please tell me!!!
Thank you!!!
phamti
Greenhorn

Joined: Aug 14, 2002
Posts: 2
Have you figured out the connection pooling yet?
My co-worker got it working with WebSphere 4.0 and MS SQL Server 2000's latest JDBC driver.
For the connection pooling part he programmed it himself as from what I understand, MS' JDBC driver supports connection pooling, but doesn't implement it. It's up to you to program it.
If you haven't figured this out yet and going the route of the MS JDBC driver I will try and find out more info for you.
Regards,
Tin
sony c joy
Greenhorn

Joined: Jul 03, 2002
Posts: 3
For making any connectionpool,first make sure that the Driverclass is in the classpath of the weblogic server.For that we have to add the jar file in the startweblogic.cmd file in case of Win 2kx.After setting this start the weblogic and make the connection pool.Use the proper driver class name and the corresponding URL .
So if all the above mentioned things are correct ,the pool will be created without any problem
thanking u
sony.c.joy
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Trying to make a connection pool with WebLogic 6.1 and SQL Server 2000