aspose file tools*
The moose likes JDBC and the fly likes Connection Pooling problem connect with MYSQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection Pooling problem connect with MYSQL" Watch "Connection Pooling problem connect with MYSQL" New topic
Author

Connection Pooling problem connect with MYSQL

beeez beee
Greenhorn

Joined: Feb 12, 2012
Posts: 1
Hi everyone

i would like to ask few question here,since i try to configure this out for 1 week,i dont find any solution for my problem. T_T
I have develop my java web application in window Environment and now i have buy domain and hosting(linux) where i put my web system there.I deploy the project in WAR file and then i upload to my hosting. The problem come when my system won't be able to connect to database in pooling environment. i try follow some tutorial how to solve it.But thing still remain the same. In my laptop,everything work very well but thing doesnt go well in the real hosting. My humble request if any of you have any idea how to solve it?

here my code for connection:

file name:context.xml



and i have create connection pooling class..here the code

filename: ConnectionPool.java






so what error is occur,i paste it here:

java.lang.NullPointerException
data.ConnectionPool.getConnection(ConnectionPool.java:38)
data.UserDB.checkStoreOfficer(UserDB.java:45)
registration.CheckUser.doPost(CheckUser.java:43)
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)


,for your information,in my hosting..i'm using tomcat version 5.5.x

Thanks for your concern for spend your time at my question here.I really appreciate it.
Ratih Pertiwi
Greenhorn

Joined: Mar 01, 2012
Posts: 2
Hi,
I have almost similar problem with you, I developed my web app in Windows environment and need to deploy it on Linux.
It has been 4 month since your post, have you solved your problem?

If not yet solved, maybe it was so late, I think you need to check your code below in context.xml in line: url="jdbc:mysql://localhost:3306/database_name?autoReconnect=true". Maybe you forgot to change "localhost:3306" with url database where you get the hosting. Make sure the username and password too.


 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection Pooling problem connect with MYSQL