Hi,

I need instructions on how to connect my trial server to the mysql database.  What should be the string that is supplied to the Driver entry in the db.properties file ?  Should I also add the mysql driver to the /lib/jdbc directory?  I have the mysql-connector-java5.0.5-bin.jar; is there another version required ?

 Thanks much.
 

Here's an example:

kapow.maxconn=15

kapow.user=root

kapow.pooling=true

kapow.password=sddsdf

kapow.url=jdbc\:mysql\://localhost\:3306/kapow

Hi

Yes you should put the JDBC driver in /lib/jdbc, I use mysql-connector-java-5.0.6-bin.jar.

Then start (or restart) RoboSuite Settings and go to the Database Connection tab, hit the + icon, and configure your connection. You must provide a symbolic name for the connection to the database, which is how you refer to it from robots. Also provide database type, connection settings, and Credentials. The setting called Host Database Name is what is also know as the schema.
If you are not running MySql on the default port and/or do not use latin-1 encoding go to the advanced tab and correct the defaults.

The configuration will be save in the db.properties file, but you normally don't modify them directly, as certain chars must be escaped.  It is however common to copy the files when you upgrade you installation.