Servoy 8 MySQL Issues

Questions and answers regarding general SQL and backend databases

Servoy 8 MySQL Issues

Postby Gordon McLean » Tue Mar 08, 2016 7:20 pm

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
Gordon McLean
Clickdigital.com
Gordon McLean
 
Posts: 205
Joined: Wed Aug 03, 2005 12:24 pm
Location: UK

Re: Servoy 8 MySQL Issues

Postby Roberto Blasco » Tue Mar 08, 2016 7:36 pm

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:
Un saludo. Roberto.

Madrid - Spain
Tfno: (+34) 625653066
E-mail: [email protected]
User avatar
Roberto Blasco
007
 
Posts: 341
Joined: Tue Apr 08, 2008 7:18 pm
Location: Madrid / Spain

Re: Servoy 8 MySQL Issues

Postby Gordon McLean » Tue Mar 08, 2016 7:50 pm

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
Gordon McLean
Clickdigital.com
Gordon McLean
 
Posts: 205
Joined: Wed Aug 03, 2005 12:24 pm
Location: UK

Re: Servoy 8 MySQL Issues

Postby ROCLASI » Tue Mar 08, 2016 9:52 pm

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.
Robert Ivens
ROCLASI Software Solutions / JBS Group, Partner
SAN Developer / Servoy Valued Professional / Servoy Certified Developer
Twitter: @roclasi / @servoyforge
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5230
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Servoy 8 MySQL Issues

Postby Gordon McLean » Tue Mar 08, 2016 11:24 pm

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
Gordon McLean
Clickdigital.com
Gordon McLean
 
Posts: 205
Joined: Wed Aug 03, 2005 12:24 pm
Location: UK

Re: Servoy 8 MySQL Issues

Postby Gordon McLean » Wed Mar 09, 2016 9:49 am

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
Gordon McLean
Clickdigital.com
Gordon McLean
 
Posts: 205
Joined: Wed Aug 03, 2005 12:24 pm
Location: UK

Re: Servoy 8 MySQL Issues

Postby Andrei Costescu » Wed Mar 09, 2016 9:58 am

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).
Andrei Costescu
Servoy
Andrei Costescu
 
Posts: 925
Joined: Tue Jun 26, 2007 3:14 pm

Re: Servoy 8 MySQL Issues

Postby Gordon McLean » Wed Mar 09, 2016 10:23 am

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
Gordon McLean
Clickdigital.com
Gordon McLean
 
Posts: 205
Joined: Wed Aug 03, 2005 12:24 pm
Location: UK

Re: Servoy 8 MySQL Issues

Postby Andrei Costescu » Thu Mar 10, 2016 3:18 pm

It was a bug introduced in 8.0. Fixed (for 8.0.3).
Case number: SVY-9558.
Andrei Costescu
Servoy
Andrei Costescu
 
Posts: 925
Joined: Tue Jun 26, 2007 3:14 pm


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 3 guests

cron