Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Problem In java

 
Manikandan Rajmohan
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am working in Travel Portal site using java technology. In my production server is linux.

I am having some problem in connection establishing

Error Message:
============
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)

Please help me
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Manikandan, welcome to Java Ranch!

This sounds to me like a Tomcat data source configuration issue - moving.

By the way, you might want to also post the configuration you did for the data source, and the code you are using to access the data source.
 
Tim Holloway
Saloon Keeper
Pie
Posts: 18152
52
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That usually means that the URL for database access is incorrect or that there's a firewall blocking access from Tomcat to the database.
 
bala funnyguy
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can anybody send me the exact java coding for connecting with ms access..?please...........
 
Tim Holloway
Saloon Keeper
Pie
Posts: 18152
52
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
bala funnyguy wrote:can anybody send me the exact java coding for connecting with ms access..?please...........


You're not as funny as you think. We don't have many rules here at the JavaRanch, but we do insist that you use your Real Name and not some sort of "handle" or obvious alias. If you're not sure about this, see http://www.javaranch.com/name.jsp .

As for connecting Tomcat to MS-Access, don't even think about it. Tomcat is a multi-threaded program. Access isn't a multi-user database. You can corrupt an Access database very rapidly that way. Same goes for FoxPro.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic