Author |
Message |
Guest
Offline
|
Posted: Mon Nov 06, 2006 1:27 pm Post subject: twcore and connecting to SQL |
 |
|
|
|
Ok i'm trying to connect to MySQL via locally. But when I run the bots, it gives an error and says "missing driver?". Its MySQL 5 and all the other bots work fine. Any ideas?
thax |
|
Back to top |
|
 |
BDwinsAlt Agurus's Posse

Age:34 Gender: Joined: Jun 16 2003 Posts: 1145 Location: Alabama Offline
|
Posted: Mon Nov 06, 2006 4:47 pm Post subject: |
 |
|
|
|
There is a JDBC driver, (been so long I can't remember) that you have to have. I got the bots to connect to the mysql server but for some reason I couldn't get it to insert data. At that time I didn't understand mysql but I understand it better now. I don't play with TWCore that much anymore.
Helpful links:
Talks about JDBC: http://www.javaworld.com/javaworld/jw-07-2000/jw-0707-jdbc.html
Drivers: http://java.sun.com/products/jdbc/download.html
Good luck.
If you want to be successful you'll need to know a lot about how mysql works and java. |
|
Back to top |
|
 |
D1st0rt Miss Directed Wannabe

Age:37 Gender: Joined: Aug 31 2003 Posts: 2247 Location: Blacksburg, VA Offline
|
Posted: Mon Nov 06, 2006 5:54 pm Post subject: |
 |
|
|
|
In corecfg/sql.cfg make sure any entry that starts with Driver = com.mysql.jdbc.Driver
Also check your runbots script (you can edit it with right click) and make sure that the jar on the classpath is the one in the misc folder.
Downloading a newer jar and updating the classpath in here is probably not a bad idea. _________________
 |
|
Back to top |
|
 |
|