SQL Syntax Error on solution Import

[rafig]

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

Import Error

SAS_ImportFail_882x208.png (106.33 KiB) Viewed 3701 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

[ROCLASI]

Hi Rafi,

What MySQL version(s) are you using ? Perhaps you need to update your JDBC driver to match your MySQL version.

[rafig]

Hi Robert

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 )

[rafig]

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