[JIRA] Commented: (OFBIZ-359) Incompatible "create table" syntax, if using "table types"

     [ http://jira.undersunconsulting.com/browse/OFBIZ-359?page=comments#action_13945 ]
     
Marco Risaliti commented on OFBIZ-359:
--------------------------------------

can this issue be closed ?

Thanks
Marco

> Incompatible "create table" syntax, if using "table types"
> ----------------------------------------------------------
>
>          Key: OFBIZ-359
>          URL: http://jira.undersunconsulting.com/browse/OFBIZ-359
>      Project: [OFBiz] Open For Business
>         Type: Bug
>   Components: entity
>     Versions: SVN
>  Environment: Linux 2.6.11
> JDK 1.4.2.08
> i386, AMD AlthonXP 1800
>     Reporter: Zarick
>     Assignee: Jira Administrator

>
>
> When using MySQL as the datasource, if you run 'ant run-install', it can't create tables, and I will put the relevant log excerpt at the end of this report!
> I've track the source, and I think, the problem is caused by
> org.ofbiz.entity.jdbc.DatabaseUtil:createTable()
> It will append " TYPE " + this.dataSourceInfo.tableType
> In the entity engine config 'entityengine.xml', datasource 'localmysql' as the attribute 'table-type="InnoDB"'
> The final SQL statement is end with 'type InnoDB'
> But, according to MySQL manual, the correct syntax should be type=InnoDB.
> Is it a MySQL problem, or OFBiz problem?
> As I don't see other datasource definition using that attribute.. I am not really sure.
> The following is the relevant log excerpt:
>      [java] 75641[       DatabaseUtil.java:1362:org.ofbiz.entity.jdbc.DatabaseUtil:DEBUG] [createTable] sql=CREATE TABLE ACCTG_TRANS (ACCTG_TRANS_ID VARCHAR(20) NOT NULL, ACCTG_TRANS_TYPE_ID VARCHAR(20), DESCRIPTION VARCHAR(255), TRANSACTION_DATE DATETIME, IS_POSTED CHAR(1), POSTED_DATE DATETIME, GL_JOURNAL_ID VARCHAR(20), GL_FISCAL_TYPE_ID VARCHAR(20), VOUCHER_REF VARCHAR(60), VOUCHER_DATE DATETIME, GROUP_STATUS_ID VARCHAR(20), FIXED_ASSET_ID VARCHAR(20), INVENTORY_ITEM_ID VARCHAR(20), PHYSICAL_INVENTORY_ID VARCHAR(20), PARTY_ID VARCHAR(20), ROLE_TYPE_ID VARCHAR(20), INVOICE_ID VARCHAR(20), PAYMENT_ID VARCHAR(20), THEIR_ACCTG_TRANS_ID VARCHAR(60), CREATED_BY_USER_LOGIN VARCHAR(250), LAST_MODIFIED_BY_USER_LOGIN VARCHAR(250), LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_ACCTG_TRANS PRIMARY KEY (ACCTG_TRANS_ID)) TYPE InnoDB
>      [java] 75851[       DatabaseUtil.java:318:org.ofbiz.entity.jdbc.DatabaseUtil:ERROR] Could not create table "ACCTG_TRANS": SQL Exception while executing the following:
>      [java] CREATE TABLE ACCTG_TRANS (ACCTG_TRANS_ID VARCHAR(20) NOT NULL, ACCTG_TRANS_TYPE_ID VARCHAR(20), DESCRIPTION VARCHAR(255), TRANSACTION_DATE DATETIME, IS_POSTED CHAR(1), POSTED_DATE DATETIME, GL_JOURNAL_ID VARCHAR(20), GL_FISCAL_TYPE_ID VARCHAR(20), VOUCHER_REF VARCHAR(60), VOUCHER_DATE DATETIME, GROUP_STATUS_ID VARCHAR(20), FIXED_ASSET_ID VARCHAR(20), INVENTORY_ITEM_ID VARCHAR(20), PHYSICAL_INVENTORY_ID VARCHAR(20), PARTY_ID VARCHAR(20), ROLE_TYPE_ID VARCHAR(20), INVOICE_ID VARCHAR(20), PAYMENT_ID VARCHAR(20), THEIR_ACCTG_TRANS_ID
> VARCHAR(60), CREATED_BY_USER_LOGIN VARCHAR(250), LAST_MODIFIED_BY_USER_LOGIN VARCHAR(250), LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_ACCTG_TRANS PRIMARY KEY (ACCTG_TRANS_ID)) TYPE InnoDB
>      [java] Error was: java.sql.SQLException: 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 'InnoDB' at line 1

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.undersunconsulting.com/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira