Home » Forums » screen-scraper » screen-scraper support for licensed users

ClassNotFoundException when using MYSQL

I copied the JDBC driver into the lib/ext folder in my screen-scraper installation but I still get a ClassNotFoundException when I call the script. My script is:

import java.sql.*;

Class.forName("com.mysql.jdbc.Driver").newInstance();

and that is where it calls the error

‹ has anybody got SOAP interface to work Strange connection error ›
christianrile on 09/12/2012 at 7:02 pm

I restarted Screen Scraper

I restarted Screen Scraper and the computer and it still throws the same error.

 christianrile on 09/17/2012 at 7:10 pm

Then I need to know exactly

Then I need to know exactly which driver you used, and a sample of your script so I can see if I can identify the issue.

 jason on 09/18/2012 at 9:43 am

I have the

I have the mysql-connector-java-5.1.21 in the lib/ext folder and my script is:

import java.sql.*;

Class.forName("com.mysql.jdbc.Driver").newInstance();

and after that line it calls the error

 christianrile on 09/18/2012 at 5:12 pm

Hi Christian, Your code looks

Hi Christian,

Your code looks okay to me. Could you confirm that you have the actual jar file in screen-scraper's lib/ext folder? That is, if you view the contents of the lib/ext folder where screen-scraper's installed you should see:

mysql-connector-java-5.1.21-bin.jar

Todd

 todd on 09/24/2012 at 9:16 am

Did you restart

Did you restart screen-scraper after putting the jar in lib/ext? If not, you need to do so.

 jason on 09/13/2012 at 9:36 am