solution import trouble continued

Classic Servoy
1

Hello,

after having this Oracle problem when trying to import a solution I now tried mySQL. Here I am getting this error:

com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Syntax error or access violation message from server: “Incorrect column specifier for column ‘name’”

Strange thing: upon first try, some 30 tables were created. When I try once more I have some 60 tables, next time almost 80, then 82, then 94, 94 again, next time 95, then 97; that’s as far as I get, missing a few tables.

Sorry to be so annoying, but I think this should work.

Thanks
Patrick

2

This seems to me a bug in your database or driver, Servoy will time upon time create and execute the same SQL!

3

It’s a newly downloaded mySQL with latest driver. :?

What I did: download and install mySQL, created a repository and imported a solution that was developed on MS SQL Server. It simply doesn’t work with my solution.

4

I can think of 3 possibilities:
1-bug in database or driver
2-“access violation” database user/pass has not enouf priviliges todo all the actions
3-bug in Servoy (very unlikely in this senario)

To rule out:
3-try importing on sybase for example
2-check priviliges
1-try older stable version of that db

5

can you also see which table it fails exactly?
If you start the developer with -DSTACKTRACE=TRUE then what is the last create table statement that fails?

6

Can you do a quick dump of the table structure of the database? It sounds to me like you’re trying to import a values mismatching what the database is expecting.

For example, trying to import a firstname column into an id column. Id est, the id column is most likely auto_increment, which requires the column to be of type INT. The firstname column would most likely be of type VARCHAR.

Do a structural export and look it over. You may notice something right off the bat. If not, post it in here and we can all look it over. If nothing else it would help rule that out.

7

Haven’t got any answers for Patrick but maybe my problem will assist his trouble-shooting.

Getting same error message “… incorrect column specifier for column tr_id…” when trying to import a solution developed on my laptop onto a Server (as new solution).

The column in question is the PK and Sequence Type had been set to ‘db identity’. Laptop development was using Servoy/Sybase but import was to MySQL on Win 2K Server.

Server ISP suggesting maybe incompatibility between Sybase & MySQL but other guidance/suggestions welcomed.

Thanks

GrahamG

LAPTOP
Servoy Developer
Version R2 2.1.2-build 315
Java version 1.5.0-b64 (Windows XP)

SERVER
Servoy Developer
MySQL 4.0.16
Version R2 2.1.2-build 315
Java version 1.4.2_05-B04 (Windows 2000)
Apache Tomcat/4.0.1

8

Hi Graham,

Wondered why you had not called today !!

I have a MySQL 4.x setup in the office running on OS X

If you would like me to try a test import here then feel free to call and we can talk it through.

Must speak tyomorrow anyway !

Cheers
Harry