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
2011/4/5 Kurt T Stam <[email protected]>
> Hi Martin,
> Martin, I have no clue. Lots of our users are on windows.
>
> The SQL in your log file that errors is perfectly good for MySQL, which
> makes me think you are still connecting to Derby.
> Please check your
>
> conf/Catalina/localhost/juddiv3.xml
> On startup tomcat creates a copy of the juddiv3/META-INF/context.xml there,
> and that copy may still be pointing to Derby. If
> you delete this file it creates a fresh copy.
>
> Good luck,
>
> --Kurt
>
>
>
> On 4/5/11 1:00 PM, Martynas A. (chainer) wrote:
>
> Hi Kurt,
>
> Thank you for your time taking everything step by step. Well.. I just
> checked on a colleagues pc (Ubuntu natty (development branch) Linux
> 2.6.38-7-generic #39-Ubuntu SMP Fri Mar 25 21:24:57 UTC 2011 x86_64 x86_64
> x86_64 GNU/Linux), works here, but not on my Winblows Vista 32x SP3. Too bad
> I'm forced to work on it atm. But still that points to a leaks in database
> initialization. What could be the problem? I'm gonna test it later on Win7
> SP1 64x, will report in few hours.
>
> --Martin
>
> 2011/4/5 Kurt T Stam <[email protected]>
>
> Hi Martin,
>
> I just downloaded
> http://apache.ziply.com//juddi/3_0_4/juddi-portal-bundle-3.0.4.zip
>
> 0. I created a juddiv4 database (not v3 to avoid confusion)
>
> 1. I unzipped
>
> 2. I changed the juddiv3/WEB-INF/classes/META-INF/persistence.xml from
> derby dialect to mysql dialect.
> <property name="openjpa.jdbc.DBDictionary" value="mysql"/>
>
>
> 3. I changed the juddiv3/META-INF/context.xml, and commented out derby and
> uncommented mysql,
> and pointed it to the juddiv4 mysql database.
>
> <!-- mysql -->
> <Resource name="jdbc/JuddiDS" auth="Container"
> type="javax.sql.DataSource" username="root" password=""
>
> driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost:3306/juddiv4"
> maxActive="8"
> />
>
>
> 4. I fired up juddi with the start.sh
>
> Then I checked the database, and it created all the tables:
>
> Database changed
> mysql> show tables;
> +-------------------------------+
> | Tables_in_juddiv4 |
> +-------------------------------+
> | OPENJPA_SEQUENCE_TABLE |
>
> | j3_address |
> | j3_address_line |
> | j3_auth_token |
> | j3_binding_category_bag |
> | j3_binding_descr |
> | j3_binding_template |
> | j3_business_category_bag |
> | j3_business_descr |
> | j3_business_entity |
> | j3_business_identifier |
> | j3_business_name |
> | j3_business_service |
> | j3_category_bag |
> | j3_clerk |
> | j3_client_subscriptioninfo |
> | j3_contact |
> | j3_contact_descr |
> | j3_discovery_url |
> | j3_email |
> | j3_instance_details_descr |
> | j3_instance_details_doc_descr |
> | j3_keyed_reference |
> | j3_keyed_reference_group |
> | j3_node |
> | j3_overview_doc |
> | j3_overview_doc_descr |
> | j3_person_name |
> | j3_phone |
> | j3_publisher |
> | j3_publisher_assertion |
> | j3_service_category_bag |
> | j3_service_descr |
> | j3_service_name |
> | j3_service_projection |
> | j3_subscription |
> | j3_subscription_chunk_token |
> | j3_subscription_match |
> | j3_tmodel |
> | j3_tmodel_category_bag |
> | j3_tmodel_descr |
> | j3_tmodel_identifier |
> | j3_tmodel_instance_info |
> | j3_tmodel_instance_info_descr |
> | j3_transfer_token |
> | j3_transfer_token_keys |
> | j3_uddi_entity |
> +-------------------------------+
> 47 rows in set (0.00 sec)
>
> I hope this helps..
>
> --Kurt
>
>
>
>
>
> On 4/5/11 11:04 AM, Martynas A. (chainer) wrote:
>
> okay, my persistence.xml looks:
>
> <properties>
> <property name="openjpa.jdbc.SynchronizeMappings"
> value="buildSchema(SchemaAction='add')"/>
> <property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
> <property name="openjpa.jdbc.UpdateManager" value="operation-order"/>
> <property name="openjpa.jdbc.DBDictionary"
> value="org.apache.openjpa.jdbc.sql.MySQLDictionary"/>
> <property name="openjpa.RuntimeUnenhancedClasses" value="warn"/>
>
> </properties>
>
> (<property name="openjpa.ConnectionDriverName"
> value="com.mysql.jdbc.Driver"/> - makes no diff, I guess it takes
> ConnectionDriverName from context.xml)
>
> context.xml:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <Context>
> <WatchedResource>WEB-INF/web.xml</WatchedResource>
> <!-- mysql -->
> <Resource name="jdbc/JuddiDS" auth="Container"
> type="javax.sql.DataSource" username="juddi" password="juddipw"
> driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost:3306/juddiv3"
> maxActive="8"
> />
> </Context>
>
>
> I even found you have similar problems some time ago (
> http://openjpa.208410.n2.nabble.com/Openjpa-MySQL-Tomcat-datasource-issue-td3680422.html).
> However I still cannot manage how to force it to build tables. Now it
> even does nothing.
>
> localhost***.log tells:
>
> Apr 5, 2011 5:58:03 PM org.apache.catalina.core.ApplicationContext log
> INFO: Initializing Spring root WebApplicationContext
> Apr 5, 2011 5:58:09 PM org.apache.catalina.core.ApplicationContext log
> 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
> 15097546 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)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159)
> ...
>
>
> Seems like a very similar exception to yours, but this time it's not
> juddiv3.xml and context.xml conflict, since they are both the same and
> nomater if I delete juddiv3.xml that makes no difference.
>
> --Martin
>
>
>
> 2011/4/5 Kurt T Stam <[email protected]>
>
> Martin,
>
> jUDDI uses JPA for persistence, and we support 2 implementations: OpenJPA
> and Hibernate. It looks like you are using OpenJPA, but with a
> persistence.xml which tries to use Hibernate.
>
> You should be using the OpenJPA persistence.xml. Can you try that?
>
> Thx,
>
> --Kurt
>
>
>
>
> On 4/5/11 10:01 AM, Martynas A. (chainer) wrote:
>
> Okay, I turned some debug options in log4j.properties:
>
> log4j.category.org.springframework.beans.property
> editors.CustomDateEditor=DEBUG
>
> log4j.debug=true
>
> # showing sql
> log4j.category.org.hibernate.hql.ast.QueryTranslatorImpl=DEBUG
> log4j.category.org.hibernate.SQL=DEBUG
> log4j.category.org.hibernate.loader.hql.QueryLoad er=DEBUG
>
>
> Launched on fresh juddi bundle deployment and juddiv3 database.This
> probably might be interesting:* localhost.2011-04-05.log (
> http://codepaste.net/yuq5jq )** *others should be pretty much the same (
> catalina.2011-04-05.log http://codepaste.net/o99gk3 ) and ( juddi.log
> http://codepaste.net/56hiet ).
>
> Tom Cunningham <[email protected]>
>
> instead. I have MySQL 5 installed locally, so if you're still having
> problems after that, I'll run through the instructions on my box with the
> juddi-portal-bundle and double check them for you.
>
>
> Maybe u have checked that?
>
> --Martin
>
> 2011/4/5 Kurt T Stam <[email protected]>
>
> Hi Martin,
>
> The logs you referenced do not show any logging of it creating tables.
>
> --K
>
>
> On 4/5/11 6:09 AM, Martynas A. (chainer) wrote:
>
> Morning,
>
> on fresh clean juddiv3 database, with mentioned presistence.xml (
> http://codepaste.net/donutg ) and context.xml (
> http://codepaste.net/hckpnf )
>
> juddi.log: ( http://codepaste.net/b317wh )
> cmd.exe: ( http://codepaste.net/xv6zmi )
>
> --Martin
>
> 2011/4/5 Kurt T Stam <[email protected]>
>
> Can you check the juddi.log for errors? If it doesn't create all the
> tables, there must be some error that may give you a clue as to what's going
> on. --K
>
>
> On 4/4/11 12:43 PM, Martynas A. (chainer) wrote:
>
> okay I did it from the start with using MySQL5Dialect. Deleted juddiv3.xml,
> edited persistence.xml looks now ( http://codepaste.net/donutg ), and
> context.xml looks now ( http://codepaste.net/hckpnf ). Still creates only
> 34 tables.
>
> --Martin
>
> 2011/4/4 Tom Cunningham <[email protected]>
>
>
>
>
>
> On 04/04/2011 12:12 PM, Martynas A. (chainer) wrote:
>
> I'm using portable 'juddi-portal-bundle-3.0.4', MySQL5.5 [mysql Ver 14.14
> Distrib 5.5.9, for Win32 (x86)], and now tried with PostgreSQL (postgres
> (PostgreSQL) 9.0.3).
>
>
> okay I feel a bit green now, how to use MySQL5Dialect then? If it's about
> of downloading 'hibernate-core-3.3.2.GA.jar' and adding it to '~\lib', I did
> it but nothing changes. I don't know how exactly this object-relational
> mapping works.
>
>
>
> The first instruction in the User Guide on how to switch to MySQL talks
> about editing the persistence.xml file and adding :
>
>
> <property name="hibernate.dialect"
> value="org.hibernate.dialect.MySQLDialect"/>
>
>
> What Kurt is suggesting is adding :
>
> <property name="hibernate.dialect"
> value="org.hibernate.dialect.MySQL5Dialect"/>
>
>
> instead. I have MySQL 5 installed locally, so if you're still having
> problems after that, I'll run through the instructions on my box with the
> juddi-portal-bundle and double check them for you.
>
>
>
>
>
>
>
>
>
>
>
>
