• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Weblogic 8.1 driver connection pool ?

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Is the jdriver for ms sql server deprecated ?
should we use BEA WebLogic Type 4 JDBC Driver for Microsoft SQL Servers
if so any idea what to include in classpath for this driver ?

Should we use connection pool or data source on top of it

Please do suggest if any idea about this
 
Ranch Hand
Posts: 2713
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The WebLogic Type 4 SQL Server Driver is certainly not deprecated. The MS Driver is widely considered to be of inferior quality (I have personally run into a number of issues with) and I would therefore recommend that you use the WebLogic Driver. See this: WebLogic Type 4 JDBC Drivers: SQL Server Driver.

As far as how to use it... you should create a Datasource backed by a Connection Pool and the client should access the Datasource via JNDI.
 
Ranch Hand
Posts: 1209
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Shail Malpani:
if so any idea what to include in classpath for this driver ?



wlsqlserver.jar under the server/lib folder is available in classpath automatically and hence can be loaded. So you dont need to specify anything explicitly in classpath.
 
shail m
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks a lot for replying,
i had further query if you can help

I read a note in weblogic jdbc related documentation

"The BEA WebLogic Type 4 JDBC MS SQL Server driver replaces the WebLogic jDriver for Microsoft SQL Server, which is deprecated. The new driver offers JDBC 3.0 compliance, support for some JDBC 2.0 extensions, and better performance. BEA recommends that you use the new BEA WebLogic Type 4 JDBC MS SQL Server driver in place of the WebLogic jDriver for Microsoft SQL Server."
i wanted to know as to which jar to use for
"BEA WebLogic Type 4 JDBC MS SQL Server"

Should it be the jar karthik referred to ?

DO we need to install any patch for it ?

Thanks again
 
Karthik Guru
Ranch Hand
Posts: 1209
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yeah now that you say , I notice

mssqlserver4v65.jar in server/lib folder.

Not sure if this is the latest though. If it is the one bea is recommending, then it needs to be put in the classpath explicitly. But I do have this feeling that it might be the one.

wlsqlserver.jar does'nt need to be in the classpath though.
 
shail m
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Karthik
i just went back and saw
infact i do have mssqlserver4v65.jar but that seems to be related with
the jdriver
weblogic.jdbc.mssqlserver4.Driver

and not the new one. "BEA WebLogic Type 4 JDBC MS SQL Server"
however i do not have wlsqlserver.jar do u think i would get that
if i install sp2 ?

Shail
[ June 30, 2004: Message edited by: shail m ]
 
shail m
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Karthik,

I found the following jars are there for the BEA driver.
wlsqlserver.jar
wlutil.jar
wlbase.jar
however i am not sure as to whether they are available in sp1 or not
i installed sp2 and found them,
do you have sp1 or sp2 ?

Thanks
Shail
reply
    Bookmark Topic Watch Topic
  • New Topic