Servoy 8 MySQL Issues

Classic Servoy
1

Hi
I am having problems importing a solution into Servoy 8 server due to persistent errors being reported about MySQL Syntax

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘connection_name = ‘fm’ and tablename = ‘test’ and columnname = ‘created’’ at line 1

I have tried the same solution in Servoy 7 and the errors are not being flagged. Is there a difference between the way Servoy 7 and 8 handle database checks on import ?

Its not practical to change to Postgres and the database in question is super simple, it has one table with a Servoy generated id. The whole structure of the database i.e. table and column were created in Servoy with a servoy sequence

Any ideas would be gratefully received.

Best
Gordon

2

I had the same issue

https://www.servoy.com/forum/viewtopic.php?f=11&t=21137

I spent a lot of hours trying to fix the problem with no success … at last the only solution I found was migrate to Postgres :cry: :cry:

3

Thanks Roberto,

That is terrible news I have a LOT of data on MySQL and for many many reasons I don’t not want to do that migration :cry:

Thanks for the reply - time to reconsider the options once again !!

Cheers
Gordon

4

Hi Gordon,

It looks like it’s a MySQL error and not a Servoy check or something. Do you see in the MySQL log what the full statement is that gave the error?
Also what if you copy the MySQL JDBC driver from Servoy 7 to 8? Perhaps it’s a driver version issue.

5

Hi Robert
Will check both thanks, it will be a real pain to have to get another database server installed and port solutions from one the other.

Cheers
Gordon

6

Hi Robert

I have had a harder look into this and found the following:

  1. The JDBC drivers are matched and current on both 7 and 8
  2. There is nothing unexpected in the MySQL Log
  3. The problem is the importing of the solution and I would therefore suggest with the Servoy checking the import process as nothing is being added to the db
  4. The database being used on both 7 and 8 is matched i.e. its the same database in on the same server with the same login
  5. I have done a single table, single row, sample in a new database again put on the same server and the problem persists i.e. a test solution with this db will work on 7 and not 8

As Roberto suggested I can change the database from MySQL to PostGres and this works fine on both platforms.

I also used MySQL as a repository server and this appears to be working fine, which was obviously set up outside of the Servoy import using upgrade repository from the command line.

The conclusion I would have is at the moment MySQL is not apparently working with Servoy 8. I will find a trusted Servoy Expert to test my set up and see if they can find any other reason this would be breaking. I was however reassured by the fact Roberto had experienced the same issue.

Cheers
Gordon

7

You could file a case if it looks like a bug in 8.
Mention this forum thread in there + give all needed details to reproduce (versions, any small samples that you used).

8

Andrei
I have created a case for this and will send server login details to you by email/pm so you can take a look
Cheers
Gordon

9

It was a bug introduced in 8.0. Fixed (for 8.0.3).
Case number: SVY-9558.