SQL Syntax Error on solution Import

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

SQL Syntax Error on solution Import

Postby rafig » Wed Jul 01, 2015 5:40 pm

I'm having a strange problem when trying to import a solution to a new Servoy server I have set up.
I am using MySQL hosted on my ISP, with the Repository database on one MySQL instance/IP address and the actual Data database on another (never done this before) and the actual Servoy Application Server installed on a headless Ubuntu 14.04.2 LTS DigitalOcean 'droplet' somewhere else (never done this before, but eventually got it set up using SSH from Mac Terminal ;-) )
Both MySQL databases are using InnoDB & utf8_bin.
Servoy details are
Server Information
Servoy version 8.0.0 b2-releaseNumber 3017
Port used by RMI Registry: 1099
Repository version 46
Current time: Wed Jul 01 16:35:25 BST 2015
Uptime: 16 days 2 hours 32 minutes 14 seconds
Server ID: 567041DD-8F35-4430-B582-DB9C9ACC5203

Settings file for this server: /home/rafig/servoy/application_server/servoy.properties

User Information
Logged in as: servoy

JVM Information
java.vm.name=OpenJDK 64-Bit Server VM
java.version=1.7.0_79
java.vm.info=mixed mode
java.vm.vendor=Oracle Corporation

Operating System Information
os.name=Linux
os.version=3.13.0-52-generic
os.arch=amd64

System Information
Code Cache Non-heap memory: allocated=3776K, used=3694K, max=49152K
Perm Gen Non-heap memory: allocated=56320K, used=56140K, max=131072K
Heap memory: allocated=125308K, used=35760K, max=1013632K
Number of Processors: 1

When I try to 'Import Solution' I get this error
SAS_ImportFail_882x208.png
Import Error
SAS_ImportFail_882x208.png (106.33 KiB) Viewed 3359 times

I have NEVER seen this kind of a message before and couldn't really find anything helpful on Forum, hence this post.
I am assuming it is some error related to the Repository as the Data database & tables already exist.
I am happily connected to both Database Servers using Servoy Developer on my local Mac and solution runs fine in Debug Client locally.
I am also attaching Stack Dump from server.
If anyone needs anything to help them solve this, please let me know
Thanks for any help
Rafi
Attachments
SAS_Stack_Dump.txt.zip
Stack Dump
(2.88 KiB) Downloaded 199 times
Servoy Certified Developer
Image
rafig
 
Posts: 704
Joined: Mon Dec 22, 2003 12:58 pm
Location: Watford, UK

Re: SQL Syntax Error on solution Import

Postby ROCLASI » Thu Jul 02, 2015 9:28 am

Hi Rafi,

What MySQL version(s) are you using ? Perhaps you need to update your JDBC driver to match your MySQL version.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: SQL Syntax Error on solution Import

Postby rafig » Thu Jul 02, 2015 10:26 pm

Hi Robert
ROCLASI wrote:What MySQL version(s) are you using ? Perhaps you need to update your JDBC driver to match your MySQL version.

here are server details
Server type: MySQL
Server version: 5.1.73-log - Source distribution
Protocol version: 10

I was using driver
mysql-connector-java-5.1.35-bin

but am just downloading 5.1.36 and will try that tomorrow and let you know.
Thanks for the suggestion (which I hope will work ;-) )
Servoy Certified Developer
Image
rafig
 
Posts: 704
Joined: Mon Dec 22, 2003 12:58 pm
Location: Watford, UK

Re: SQL Syntax Error on solution Import

Postby rafig » Mon Jul 06, 2015 11:03 am

Hi Robert,
I tried with the new driver, but same issue.
Actually, I first had an issue with a timeout to the MySQL db.
I was using 'Connection validation type = Query Validation' & had 'SELECT 1;' as the query.
I then changed this back to 'Exception Validation' but still the same error.
Thanks

Rafi
Servoy Certified Developer
Image
rafig
 
Posts: 704
Joined: Mon Dec 22, 2003 12:58 pm
Location: Watford, UK


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 3 guests