Server Help :: View topic - twcore and connecting to SQL

Server Help

Bot Questions - twcore and connecting to SQL

Anonymous - 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

BDwinsAlt - 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.

D1st0rt - 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.