Hi All!
I would like to know if there is a way to share the same MySQL connection of 2 different java Appl that are running at the same time. The mySQl connector i use is mysql-connector-java-3.1.11-bin.jar . The platforms that i use is linux and Windows. The relationship between the two appl is that the first one launches a script that executes the second one. But the problem i am facing currently is that when it launches the second one, it has to open another connection to the mysql database which sometimes take too much time. So if there is a way to tell the second application to use the first apllication's connection then the problem would be resolved!

HI -

If these were servlets in a web application (instead of two standalone applications, which is what your description sounds like), the ideal solution would be to use a connection pool. For example:

http://dev.mysql.com/tech-resources/...onnectorj.html

... or ...

http://forum.java.sun.com/thread.jsp...sageID=3421546

Both of these links use Tomcat (i.e. use servlets), so I'm not sure to what extent that would help you.

'Hope that helps .. PSM

Thanks, I'll check the links but as you already figured out, these are 2 standalone applications.

Hi, I looked at the Examples given on those links but it won't help me right now as my applications are actually 2 completely different ones. Can we actually do what i am asking? I can't find any reference to this anywhere!

I dont know if persistant connection will work.
If it does then its a simple matter of sending the connection ID to the second application