Re: MySQL Syntax Error
Re: MySQL Syntax Error
- Subject: Re: MySQL Syntax Error
- From: Pascal Robert <email@hidden>
- Date: Mon, 25 Feb 2013 08:03:12 -0500
That's a bug in the MySQL bundled with WO, you have to use the one from Wonder. So either you have to add the MySQLPlugin framework from Wonder in your app or you have to make sure it is loaded after the core WO frameworks.
> Hi,
>
> i use MySQL 5.1 with MySQL Adaptor (Wonder 5.7.1) and mysql-connector 5.1.22
>
> and during the migration i have an error:
>
> 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 'null billingDescriptor VARCHAR(255) NOT NULL' at line 1
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ...
>
> Caused by: java.lang.RuntimeException: Failed to execute 'alter table LoggedAction null billingDescriptor VARCHAR(255) NOT NULL'.
>
> Caused by: 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 'null billingDescriptor VARCHAR(255) NOT NULL' at line 1
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>
>
> my code is:
>
> loggedActionTable = database.existingTableNamed(LoggedAction.ENTITY_NAME);
> loggedActionTable.newStringColumn("billingDescriptor", 255, false);
>
> why this 'null' appears?
>
> any ideas?
>
> Thanx.
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden