Server Config error

Classic Servoy
1

Hi,

I was trying to connect to MySql database

followign are the details I porvided for Server Congif using Application Preferences:

servername :localhost
username : myusername
password: mypassword
database Server URl : jdbc:mysql://localhost/business_system

business_system is name of my database in MySql.

on click of OK button i got following error:

JDBC Driver ‘org.gjt.mm.mysql.Driver’ not found in classpath or drivers directory : java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver org.gjt.mm.mysql.Driver

Please let me know How do i fix it??

Thanks,
Sejal

2

Sounds like the JDBC driver is not present. Check the drivers directory inside the Servoy directory to see if there is a recent mySql JDBC driver.

3

Hi Patrick,

Thanks for ur help..
I installed latest JDBC: MYSql driver and it worked.

Thanks,
Sejal

4

I have never attempted anything of this sort before (running a DB) but I have been assigned the task of dropkicking MS Access to the curb. And of course implementing a new front end for MS SQL. So as I have attempted to integrate servoy I have run into many learning experiances.

Currently when I attempt to do the “Server Config” I receive the error
“Driver does not recognize the URL”
Which I entered as

jdbc:microsoft:sqlserver://IP… address:1433;DatabaseName=example_data;SelectMethod=cursor

I am using the jtds-1.2 driver.

So in trying to troubleshoot the URL I am wondering how I go about verifying the port number? I used the default without knowing for sure.

Any help would be appreciated.

-Nick-

5

Here’s some instructions:

SETTING UP WITH JTDS Driver:

  1. Make a new connection (Edit → Preferences → DB Servers)

  2. Enter your server name (anything you want); username; password

  3. In the database URL line - use: jdbc:jtds:sqlserver://localhost:1433/

REPLACE “localhost” with the IP address, and replace “” with the name of the database.

  1. Choose net.sourceforge.jtds.jdbc.Driver in the driver section.

SETTING UP WITH MS DRIVER:

  1. Exit Servoy.

  2. Put the drivers into the “drivers” folder

  3. Restart Servoy

  4. Choose “MS SQL” from the “Auto Setup Server” popup at the bottom of the DB Servers Tab

  5. Enter your server name (anything you want); username; password

  6. In the database URL line - use: jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=;SelectMethod=cursor

REPLACE “localhost” with the IP address, and replace “” with the name of the database.