Skip to Content
0
Former Member
Aug 02, 2012 at 05:17 PM

mySQL connection error

35 Views

Hi,

I am trying to connect mySQL database at receiver end and getting mysql syntax error exception..

JDBC Driver : com.mysql.jdbc.Driver

Connection: jdbc:mysql://<hostname>:3306/test

and deployed following jar file - mysql-connector-java-5.1.21-bin.jar (this is the latest jar is availble in mysql.com / our mysql version is 5.1.57)

added following parameters in provider.xml file -

<jar-name>lib/mysql-connector-java-5.1.21-bin.jar</jar-name>

receiver jdbc comm channel error is - mysql syntax error exception.

please see the attached screen shot error for more details error.

I checked host and port connection are working file both the end.

My concern is jar filename whatever I added in provider.xml file is it correct. because that is the jar file I download and deployed and same .jar file got added in provider.xml file.

Please help.

Attachments

mysqlerror.GIF (23.5 kB)