Insert Results into MySQL Database (lassNotFoundException (line 5): com.mysql.jdbc.Driver-- Method Invocation Class.forName)
Hi
I am new to Screen Scraper, previously I used VelocityScape on Windows which had data connections built in. My problem is with Inserting data into MySQL from my Scrape.
I followed the tutorial http://community.screen-scraper.com/writing_extracted_data_to_a_database but the result is not as expected; I receive the following error message:
An error occurred while processing the script: Insert Data
The error message was: ClassNotFoundException (line 5): com.mysql.jdbc.Driver-- Method Invocation Class.forName
The error message was: ClassNotFoundException (line 5): com.mysql.jdbc.Driver-- Method Invocation Class.forName
I have tried amending the script to just insert static data and run before the the scrape of the first page, but receive the same error. So I guess it is that script or the connection to the database from Screen Scraper.
Can you assist? I am using OSX Leopard, have a working Apache/MySQL setup already serving websites locally so all is well there.
Many thanks in advance
Stu
Removed and re-installed.
Removed and re-installed. Sorted.
Stu, To start, download the
Stu,
To start, download the appropriate JDBC Driver connector Jar file for your particular database and place it in the lib/ext folder where screen-scraper is installed.
-Scott
OK, So
OK So it looks like I did not install the MYSQL JDBC Driver connector correctly. I followed the instructions placing the .jar file in the Screen Scraper lib folder. I will research further.
A little frustrating the comments from the product author on database connectivity, I think it a fair assumption that you want the data exporting. You would think that this kind of information would be pushed since the goal would be an upgrade from the basic version.
I will post information on what I did IF I manage to get the problem resolved. I notice alot of the forum posts on related subjects cut short without posted resolution... also frustrating.
Stu :-/
Clearly something I am doing is wrong.
I cannot get the connector to work, I had a genius moment and thought I will work around the problem creating a php script to insert into the database from a generated csv... GENIUS, but not really at all since I have to read from the Database to perform the next part of the Scrape! DER, Idiot me, didnt think that one through....
Home > Brands > Products > Product
If someone could provide some direction on getting the MYSQL JDBC Driver connector installed correctly I would really appreciate it (Scraper 5.5, OSX Leopard, MySQL 5.1.58)
Working!
Yeah! I got it to work, but uninstalled and removed the MYSQL JDBC Driver, then put it all back... So I have no explaination for anyone else.
Stu, I wish I had an
Stu,
I wish I had an explanation for why that ended up working. Glad to hear you got it working.
Your comments on unresolved forum postings is noted and I will see what we can do about resolving those that look incomplete.
Thank you for your patience working this through.
-Scott
It's probably because you
It's probably because you need to restart after you install it. I just went through the exact same problem for the second time forgetting that I needed to restart. Figured I'd post this comment for future users.