• 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

Connection Pooling Error

 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
While creating connection with database I am getting error as

'pingConnectionPool' failed in 'resources' Config Mbean
Class name is wrong or classpath is not set for : com.microsoft.jdbcx.sqlserver.SQLServerDataSource

I am using Sun Microsystems Application Server PE 8 and Microsoft SQL Server 2000 as database

Please Help
 
Ranch Hand
Posts: 153
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Hitesh,

Did you add the sqlserver jdbc driver to the application server classpath? The easiest way to get it to work is to dump the sqlserver jdbc jar file in lib folder of you application server.
 
Hitesh Ankolekar
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can you Please explain the steps as I have no idea about it
thank you
 
Shailesh Kini
Ranch Hand
Posts: 153
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hitesh,

I do not have the exact steps for you. There should be a "lib" folder under your application server install folder (App server home folder). This folder usually contains the jar file used by your app server. You should copy the sqlserver jdbc jar file to this folder and restart your server.

Your server logs should tell you which jar files are visible to the server i.e . have been added to the server classpath.
The log files should also be somewhere in the app server home folder which you will have to find yourself. Just search for a file with extension "log".
 
Hitesh Ankolekar
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can you please tell me in which folder I'll get sqljdbc jar file
and in which folder exactly I need to dump the file .In lib folder of "domain" folder or lib folder under AppServer folder.
Actually I searched for sqljdbc jar file but unable to get it.I am using MICROSOFT SQLSERVER 2000 ENTERPRISE EDITION

thank you
 
Shailesh Kini
Ranch Hand
Posts: 153
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Hitesh,

You should be able to get the JDBC driver jar file for SQL Server from Microsoft site. Search for the text "jdbc driver" on Microsoft site. I am not sure it is called sqljdbc.jar. You should download the jdbc driver for SQL Server 2000. If you do not find the driver for SQL Server 2000 you can download the driver file for the latest version of SQL Server. The latest version of the jdbc driver should work with SQL Server 2000. If you do not like microsoft you could use an alternate driver from jTDS. It is an open-source driver and supports the latest version of SQLServer.

You could put the file in the lib folder under the AppServer folder unless you are planning to use 2 different version of the microsoft jdbc jar files.
 
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Hitesh Ankolekar


Did you get the jdbc driver or not ?

If no please reply the mail id kkitcha1@yahoo.com , I will forward to you.
 
Hitesh Ankolekar
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have pasted the sqljdbc jar file in lib directory of AppServer
but still I'm getting the same error of Classpath not found
So please Tell me what should I do to solve this error.

Also what is RESOURCE TYPE (Admin Console)which we mention while Connection pooling??

I have downloaded jar file for SQLServer 2005 and I'm working with SqlServer2000
 
Shailesh Kini
Ranch Hand
Posts: 153
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Hitesh,

When you create a connection pool through your admin console you should use use com.microsoft.sqlserver.jdbc.SQLServerDataSource instead of com.microsoft.jdbcx.sqlserver.SQLServerDataSource.
 
Hitesh Ankolekar
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Shailesh.
The previous problem is solved .But now I'm getting new problem as

Operation 'pingConnectionPool' failed in 'resources' Config Mbean. Target exception message: Connection could not be allocated because: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: no further information

please reply what should I do further???
 
Shailesh Kini
Ranch Hand
Posts: 153
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Hitesh,

Were you able to find a resolution for your problem? If not, let me know.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Shailesh Kini wrote:Hi Hitesh,

Were you able to find a resolution for your problem? If not, let me know.



May you please send me the solution of this problem.

Operation 'pingConnectionPool' failed in 'resources' Config Mbean. Target exception message: Connection could not be allocated because: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: no further information

I am using following soft.

J2EE server 1.4 , SQL server 2000, Window Vista / XP /2003 (All).

Kindly help me!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic