I need help to tie in MySQL to Tomcat

[SEO practioner]

Hi everybody

Boy are we stuck on that one. We have just completed the development of a new ecommerce secure application, complete with secure transaction and everything.

The problem is, after ''fiddling for a few days'' with the cumbersome connection between Apache and Tomcat (wich we had to scour the web to finally figure out), (Tomcat is our application server), now the database will not connect!

We are using a standard connection string. Here it is:

jdbc:mysql://localhost:3306/[database name]

Did we goof somewhere or am I missing something? That is the only thing between this and deploying our application to our client.

My thanks to anybody that can help us out of this dead-end.

:-) SEO practioner (you can sticky me with the answer (s) if you prefer-

[DaveAtIFG]

Frankly, I know little about MySQL and less about Java and Tomcat. But I found this [developer.java.sun.com] at a Sun's site which may suggest a solution, or at least a direction. Does anyone have any experience in this area? Or suggestions?

[txbakers]

Hi, I had the same problem trying to tie TomCat with IIS. It was a mess and a half.

I finally ditched TomCat altogether and installed JRun from Macromedia. It was once click of the mouse to make IIS compatible with JRUN, and it would probably be just as easy with Apache.

They do offer a free demo.

As for the mySQL problem, try using a JDBC:ODBC bridge and see if that works. Do you have the myODBC component from mySQL?

Let us know how it progresses.