Welcome to the MacNN Forums.

insha · Mar 23, 2004, 09:05 AM

Can anyone please help me setup JSP/MySQL to work properly in DWMX?

I have DW MX and I have Tomcat 5.0.19 installed (I'm running Panther). When I open DW I create a new Site, using the JSP testing server. No when I try to create a connection for the MySQL I keep getting the unknown error message, when I clicked the "test" button.

My Settings:

I have the mysql J Connector (latest from MySQL site) in my java "extensions" folder and in the <webapp>/projects/jsp_test/WEB-INF/lib/ folder.

I'm using
JDBC Driver: "org.gjt.mm.mysql.Driver"
Connection : "jdbc:mysql://localhost/jsp_sample"
User : "root"
Password : "unknown"

I tried both radio buttons that are at the bottom of the MySQL connection window; but niether of them can connect to the MySQL server.

Tomcat/MySQL servers are both running on the same machine and I can connect to the MySQL both manually throught the terminal and using a sample Java code.

What am I doing worng? Why is it so hard to do this in DW?

Thanks in advance.