GeeCON Prague 2014*
The moose likes EJB and other Java EE Technologies and the fly likes Connection Pooling Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Connection Pooling Error" Watch "Connection Pooling Error" New topic
Author

Connection Pooling Error

Hitesh Ankolekar
Greenhorn

Joined: Aug 22, 2007
Posts: 7
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
Shailesh Kini
Ranch Hand

Joined: Oct 17, 2001
Posts: 153
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.


Shailesh Kini.
Hitesh Ankolekar
Greenhorn

Joined: Aug 22, 2007
Posts: 7
Can you Please explain the steps as I have no idea about it
thank you
Shailesh Kini
Ranch Hand

Joined: Oct 17, 2001
Posts: 153
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

Joined: Aug 22, 2007
Posts: 7
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

Joined: Oct 17, 2001
Posts: 153
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.
krishnamoorthy kitcha
Ranch Hand

Joined: Feb 04, 2006
Posts: 96
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

Joined: Aug 22, 2007
Posts: 7
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

Joined: Oct 17, 2001
Posts: 153
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

Joined: Aug 22, 2007
Posts: 7
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

Joined: Oct 17, 2001
Posts: 153
Hi Hitesh,

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

Joined: Mar 01, 2010
Posts: 2
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!
 
GeeCON Prague 2014
 
subject: Connection Pooling Error