Morning, Yes that was it, it worked with mysql Ver 14.14 Distrib 5.1.56. So I guess this is a version leak which should be fixed in the future.
--Martin 2011/4/5 Martynas A. (chainer) <[email protected]> > Hi again, > > Well I looked deeper in SQL error and I remembered that TYPE=innodb is > incorrect and mysql only 'eats' ENGINE=innodb. I'm totally unexperienced in > mysql, but I manually tried to give this to mysql: > > CREATE TABLE j3_address (id BIGINT NOT NULL, sort_code VARCHAR(10), >> tmodel_key VARCHAR(255), use_type VARCHAR(255), address_id BIGINT NOT NULL, >> PRIMARY KEY (id)) ENGINE = innodb >> > > And mysql 'ate' it. > > mysql> show tables; >> +-------------------+ >> | Tables_in_juddiv4 | >> +-------------------+ >> | j3_address | >> +-------------------+ >> 1 row in set (0.00 sec) >> >> mysql> >> > > I guess TYPE is off since 5.1? I'm using 5.5. Could that be a problem? > > --Martin > > > > > 2011/4/5 Martynas A. (chainer) <[email protected]> > > Kurt, >> >> I know about copying juddiv3/META-INF/context.xml to >> conf/Catalina/localhost/juddiv3.xml, so I always delete juddiv3.xml. Just >> tried on win7 64x. Fresh mysql5.5 install, fresh database, fresh unzip, only >> persistence.xml and context.xml changes, and it goes same like on my >> winVista32x. Creates 0 tables. Same exception: >> >> SEVERE: StandardWrapper.Throwable >>> <openjpa-1.2.2-r422266:898935 nonfatal general error> >>> org.apache.openjpa.persistence.PersistenceException: 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 {stmnt >>> 726045964 CREATE TABLE j3_address (id BIGINT NOT NULL, sort_code >>> VARCHAR(10), tmodel_key VARCHAR(255), use_type VARCHAR(255), address_id >>> BIGINT NOT NULL, PRIMARY KEY (id)) TYPE = innodb} [code=1064, state=42000] >>> >>> at >>> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553) >>> at >>> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453) >>> ... >>> >> >> This makes me crazy since I just did it on linux few hours ago. I will >> create a prefab.zip with these changes where you can only unzip it and hit >> startup. >> Here it is (under mysql juddiv4 database, with login 'root' and no >> password): >> http://rapidshare.com/files/456047193/juddi-portal-bundle-3.0.4_mysql.localhost.3306.juddiv4__root_____.zip >> Already tested with it on third pc (win7 32x). Still creates 0 tables. >> Looking for anything... :-| >> >> >> --Martin >> >> >>
