mysql j connector and 4.0.1a
I updated to 4.0.1a and now screen-scraper cant seem to find the driver..
The error message was: The application script threw an exception: java.sql.SQLException: No suitable driver found for jdbc:mysql://xxxxx/scraping?user=xxxxx&password=xxxxx BSF info: null at line: 0 column: columnNo
any ideas?
mysql j connector and 4.0.1a
To fix this you need to put this statement somewhere before the database connection line:
Class.forName ("com.mysql.jdbc.Driver");This statement is needed to be able to use the jdbc driver. So if you run your code without that statement you get the error you mentioned. (No suitable driver found).
This only needs to be run once every time screen-scraper is launched for screen-scraper to be able to use the JDBC driver.
Also, this is assuming that the jdbc .jar file is in the lib/ext folder already.