Skip to Content
0
Former Member
Feb 16, 2007 at 01:18 AM

new to xMII - xMII cannot connect to mysql database

228 Views

Hi,

I am new to xMII (about 1 week). I need to have xMII talk to MySQl database on another server. Does anyone know how can I connect it to MySQL? I tried from the xMII main menu, Data services -->Data Servers. Then I tried to search for a suitable server types. But there is none for MySQL type. I then used the "Default IDBC server". ( I am not even sure whether I chose the right server type or not. ) I specified the server URL to jdbc:mysql://xxxx/database_name. Then check "enabled". However, the Status windows shows no connection for the data server I've just created. The Log shows

Fatal error while filling connection pool for jdbc:mysql://xxxx/database_name java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection

If I need to change the driver class to the com.mysql.jdbc.Driver. I have to change the class path for the server engine. Where can I change the class path for xMII?

Does anyone have ideas about what's wrong with my settings?

Thanks a lot for your help!