Sorry, I don't know Enumeration Entity How to use? Thank you! -----Original Message----- From: Jacques Le Roux [mailto:[email protected]] Sent: 2009年2月11日 17:33 To: [email protected] Subject: Re: Does OFBiz support mysql data type enum?
Are you aware of Enumeration Entity ? Jacques From: "Jack Liu" <[email protected]> > There is no enun in ofbiz, but my database uses it. > > For example there is a field named "test" in the table enum_test and it's > type is enum('one','two','three'). > > In entitymodel.xml > <entity entity-name="EnmuTest" > package-name="com.aicent.ccb" > title="test enum type in mysql"> > <field name="id" type="id" /> > <field name="test" type="enumtest" /> > <prim-key field="id" /> > </entity> > > Field test's type is enumtest. > > In fieldtypemysql.xml > <field-type-def type="enumtest" sql-type="enum('one','two','three')" > java-type="String[]"></field-type-def> > > Then I execute command "ant run-install" in root directory of ofbiz. > It creates table enum_test successfully but when I start ofbiz > There are two errors: > > 2009-02-11 16:38:49,452 (main) [ DatabaseUtil.java:988:INFO ] Getting > Column Info From Database > 2009-02-11 16:38:49,577 (main) [ DatabaseUtil.java:236:ERROR] > ---- runtime exception report > -------------------------------------------------- > Exception: java.lang.NumberFormatException > Message: For input string: "'one'" > ---- stack trace > --------------------------------------------------------------- > java.lang.NumberFormatException: For input string: "'one'" > java.lang.NumberFormatException.forInputString(NumberFormatException.java:48) > java.lang.Integer.parseInt(Integer.java:447) > java.lang.Integer.parseInt(Integer.java:497) > org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:234) > org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:125) > org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java:1099) > org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:198) > org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:185) > org.ofbiz.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:117) > org.ofbiz.catalina.container.CatalinaContainer.init(CatalinaContainer.java:165) > org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:141) > org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:65) > org.ofbiz.base.start.Start.initStartLoaders(Start.java:248) > org.ofbiz.base.start.Start.init(Start.java:87) > org.ofbiz.base.start.Start.main(Start.java:403) > -------------------------------------------------------------------------------- > > 2009-02-11 16:38:49,577 (main) [ DatabaseUtil.java:243:ERROR] > ---- runtime exception report > -------------------------------------------------- > Exception: java.lang.NumberFormatException > Message: For input string: "'two','three'" > ---- stack trace > --------------------------------------------------------------- > java.lang.NumberFormatException: For input string: "'two','three'" > java.lang.NumberFormatException.forInputString(NumberFormatException.java:48) > java.lang.Integer.parseInt(Integer.java:447) > java.lang.Integer.parseInt(Integer.java:497) > org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:241) > org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:125) > org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java:1099) > org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:198) > org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:185) > org.ofbiz.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:117) > org.ofbiz.catalina.container.CatalinaContainer.init(CatalinaContainer.java:165) > org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:141) > org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:65) > org.ofbiz.base.start.Start.initStartLoaders(Start.java:248) > org.ofbiz.base.start.Start.init(Start.java:87) > org.ofbiz.base.start.Start.main(Start.java:403) > --------------------------------------------------------------------------- > > How should I solve this problem? > Thank you all! > > -----Original Message----- > From: BJ Freeman [mailto:[email protected]] > Sent: 2009年2月10日 21:24 > To: [email protected] > Subject: Re: Does OFBiz support mysql data type enum? > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > not sure what you are asking > where did you find enum in the file? > > Jack Liu sent the following on 2/10/2009 5:04 AM: >> I knew that, but did you test it for data type enum in mysql? >> >> -----Original Message----- >> From: BJ Freeman [mailto:[email protected]] >> Sent: 2009年2月10日 19:46 >> To: [email protected] >> Subject: Re: Does OFBiz support mysql data type enum? >> >> type of fields used for a specific DB is found in >> /framework/entity/fieldtypes/ >> >> Jack Liu sent the following on 2/10/2009 12:13 AM: >>> Best Regards, >> >>> Jack Liu >> >> > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.6 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFJkX/xrP3NbaWWqE4RAtHgAJ9sRul4GLQjbiQULbbIoQZZtVH+KACfcZwM > 3qlsZYqXj3Q/CJU/mAj6i1M= > =DKmP > -----END PGP SIGNATURE----- >
