SQL Power Business Intelligence Productivity Tools

SQL Power Software Forum
SQL Power Software Forum
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
copy data from SQLServer to MySQL statement error  XML
Forum Index » SQL Power Architect Bugs
Author Message
[Post New]2014-07-03 04:52:59
    Subject: copy data from SQLServer to MySQL statement error
[Up]
duchang110


Joined: 2014-07-03 04:31:20
Messages: 1
Offline

in create table statement there is "identity(10)" and all columns become primary key.

java.lang.RuntimeException: DDL statement failed:
CREATE TABLE customerSQLServer (
customer_id int identity(10) AUTO_INCREMENT NOT NULL,
province varchar(40) NOT NULL,
lastname varchar(40) NOT NULL,
city varchar(40) NOT NULL,
countrycode varchar(2) NOT NULL,
postcode varchar(10) NOT NULL,
PRIMARY KEY (customer_id, province, lastname, city, countrycode, postcode)

at ca.sqlpower.architect.swingui.DataMoverPanel.moveSingleTable(DataMoverPanel.java:393)
at ca.sqlpower.architect.swingui.DataMoverPanel.doDataMove(DataMoverPanel.java:263)
at ca.sqlpower.architect.swingui.DataMoverPanel$3.actionPerformed(DataMoverPanel.java:226)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
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 'identity(10) AUTO_INCREMENT NOT NULL,
province varchar(40) NOT ' at line 2
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2690)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:164
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1567)
at ca.sqlpower.sql.jdbcwrapper.StatementDecorator.executeUpdate(StatementDecorator.java:133)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:22
at ca.sqlpower.architect.swingui.DataMoverPanel.moveSingleTable(DataMoverPanel.java:390)
... 38 more
[Post New]2016-04-14 18:53:51
    Subject: Re:copy data from SQLServer to MySQL statement error
[Up]
wwillis


Joined: 2016-04-14 17:48:40
Messages: 1
Offline
the syntax of MySQL 5.6 to change ... power architect not support for mysql 5.6 syntax.
[Post New]2016-04-25 12:01:49
    Subject: Re:copy data from SQLServer to MySQL statement error
[Up]
Kirti M


Joined: 2015-02-12 16:21:34
Messages: 71
Offline
Thank you for reporting the issue. I have reported this in our bug database as Bug id#3183.

-Kirti

This message was edited 1 time. Last update was at 2016-04-25 12:32:38
 
Forum Index » SQL Power Architect Bugs
Go to:   
Powered by JForum 2.1.8 © JForum Team