MYSQL Getting General error: table dosn't exist

Classic Servoy
1

I have connected Servoy developer to a mysql server hosted by my internet provider. The connection seems to work. I made a new form selecting the mysql server and a test table of it that contains 30 records. The field names come up correctly and I placed some of them on a form. But when I return to “run mode” I get a "CANNOT SHOW FORM DATA"message with a java.sql.SQLException: General Error: table “databasename:tablename” does not exist (repeated 2 times).

I’m running with a trial licence.

Any suggestion?. thanks a lot in advance.

Enrico Arata

2

I havn’t seen this error before and we do quite some testing on MySQL, also quite a few customers are already using Servoy in production with mysql without experiencing this particular error.

Which version of mysql are you using?

3

Server version: 3.23.49
Protocol version: 10
Connection: www.arata.net via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3306

4

As Jaleman quickly found out the problem with my mysql was that the table name and the fields name contained uppercase characters. Mysql is case sensitive while servoy uses lowercase characters for tables name and fields names. I renamed fields and table to lowercase and all worked with no problem.

Thank you Jaleman

Enrico Arata