• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

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

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 !!!
 
Ranch Hand
Posts: 2713
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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!!!
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
My cellmate was this tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic