Problemas para gererar modelos en java
Publicado por Mauricio (14 intervenciones) el 10/03/2011 15:23:57
Hola quisiera que me ayudaran con este problema que tengo para generar con java es la primera vez que trabajo con java desde genexus y estoy tratando de configurar el modelo para web pero cuando esta creando las tablas de la base de datos me da el siguiente error:
ExecuteDirectSQL/ CREATE TABLE `TRN01` (`id` smallint NOT null , `nombre` smallint NOT null , PRIMARY KEY(`id`)) TYPE=InnoDB
Text : 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 'TYPE=InnoDB' at line 1
Error Code : 1064 SQLState : 42000
com.mysql.jdbc.exceptions.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 'TYPE=InnoDB' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1316)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235)
at com.genexus.db.driver.GXStatement.executeUpdate(Unknown Source)
at com.genexus.db.DBConnectionManager.executeStatement(Unknown Source)
at com.genexus.ExecuteDirectSQL.execute(Unknown Source)
at gxrgza.execute_int(gxrgza.java:49)
at gxrgza.execute(gxrgza.java:21)
at Reorganization.execute(Reorganization.java:35)
at com.genexus.GXReorganization.executeReorg(Unknown Source)
at com.genexus.GXReorganization.executeReorg(Unknown Source)
at Reorganization.main(Reorganization.java:13)
es solo una transacción de prueba la que tengo ya que solo quiero hacer la configuración para iniciar mi proyecto.
ExecuteDirectSQL/ CREATE TABLE `TRN01` (`id` smallint NOT null , `nombre` smallint NOT null , PRIMARY KEY(`id`)) TYPE=InnoDB
Text : 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 'TYPE=InnoDB' at line 1
Error Code : 1064 SQLState : 42000
com.mysql.jdbc.exceptions.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 'TYPE=InnoDB' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1316)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235)
at com.genexus.db.driver.GXStatement.executeUpdate(Unknown Source)
at com.genexus.db.DBConnectionManager.executeStatement(Unknown Source)
at com.genexus.ExecuteDirectSQL.execute(Unknown Source)
at gxrgza.execute_int(gxrgza.java:49)
at gxrgza.execute(gxrgza.java:21)
at Reorganization.execute(Reorganization.java:35)
at com.genexus.GXReorganization.executeReorg(Unknown Source)
at com.genexus.GXReorganization.executeReorg(Unknown Source)
at Reorganization.main(Reorganization.java:13)
es solo una transacción de prueba la que tengo ya que solo quiero hacer la configuración para iniciar mi proyecto.
Valora esta pregunta


0