0

I wrote java class to connect mysql database and insert data to database on my centos installed pc.(this java file called by asterisk program using AGI). but I got below exception at runtime.

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

How could I solve this ?

Bishan
  • 15,211
  • 52
  • 164
  • 258
  • This question/Answer should help you : http://stackoverflow.com/questions/4233049/java-lang-classnotfoundexception-com-mysql-jdbc-driver – Adam Jan 11 '12 at 11:00

2 Answers2

1

Ok. I solved my question. when I run the asterisk program with AGI server, I added mysql connector classpath as below.

java -classpath asterisk-java-0.3.jar:mysql-connector-java-5.1.18-bin.jar:. org.asteriskjava.fastagi.DefaultAgiServer
Bishan
  • 15,211
  • 52
  • 164
  • 258
0

you need this jar file: mysql-connector-java-{version}.jar

e.g. http://findjar.com/jar/mysql/mysql-connector-java/5.1.9/mysql-connector-java-5.1.9.jar.html

tonng
  • 1
  • i have added `mysql-connector-java-5.1.18-bin.jar` and set `class path`. but still having problem. – Bishan Jan 12 '12 at 04:03