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 > > >
