Any updates on this?
On Wed, Mar 19, 2014 at 9:58 AM, Kurt Stam <kurt.s...@gmail.com> wrote: > The dialect is set in the persistence.xml. > > On Mar 18, 2014, at 19:22, MIX <zxtl...@gmail.com> wrote: > > Thanks for you reply! > To Alex: > Yes I mean the MySQL database 'juddiv3', and I have tables like > j3_address, j3_address_line,..., created automaticly by juddi. > Here is my 'juddiv3' database in MySQL, and there is lack of > 'j3_pulisher' table in it: > +-------------------------------+ > | Tables_in_juddiv3 | > +-------------------------------+ > | 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_canonicalization_method | > | 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 | > +-------------------------------+ > > > To Kurt: > I followed the user guide and change the dialect for MySQL in > > *context.xml* . > I think I have a successful connection to MySQL. It seems like juddi > didn't build all the tables needed when starting itself. > > > 2014-03-19 9:34 GMT+08:00 Kurt Stam <kurt.s...@gmail.com>: > >> Did you follow the instructions in chapter 4? >> >> >> >> http://juddi.apache.org/docs/3.x/userguide/html/ch04.html#_switch_to_mysql_on_tomcat_using_openjpa >> >> You may have forgotten to change the dialect. >> >> On Mar 18, 2014, at 17:21, "Alex O'Ree" <spyhunte...@gmail.com> wrote: >> >> I'm assuming you meant the 'database' juddiv3. Were the tables created >> automatically through jpa or did you create them yourself? >> >> >> On Tue, Mar 18, 2014 at 11:08 AM, MIX <zxtl...@gmail.com> wrote: >> >>> Hi all, >>> I'm trying to run juddi_v3.2 with openJPA & MySQL, I unziped the >>> juddiv3.war in tomcat's webapps, and configed a datasource in >>> juddiv3/META-INF/context.xml like this: >>> >>> <?xml version="1.0" encoding="UTF-8"?> >>> <Context> >>> <WatchedResource>WEB-INF/web.xml</WatchedResource> >>> <Resource name="jdbc/JuddiDS" auth="Container" >>> type="javax.sql.DataSource" username="juddi" password="juddi" >>> driverClassName="com.mysql.jdbc.Driver" >>> url="jdbc:mysql://localhost:3306/juddiv3" >>> maxActive="8"/> >>> </Context> >>> >>> juddi is granted with full privilige on a empty juddiv3 table in >>> MySQl. I had a MySQL connector added into tomcat lib of course. >>> And when I try to visit localhost:8080/juddiv3 I got this: >>> >>> <openjpa-2.2.1-r422266:1396819 fatal general error> >>> org.apache.openjpa.persistence.PersistenceException: Table >>> 'juddiv3.j3_publisher' doesn't exist {prepstmnt 6413608 SELECT >>> t0.email_address, t0.is_admin, t0.is_enabled, >>> t0.max_bindings_per_service, t0.max_businesses, >>> t0.max_services_per_business, t0.max_tmodels, t0.publisher_name FROM >>> j3_publisher t0 WHERE t0.authorized_name = ?} [code=1146, state=42S02] >>> FailedObject: root [org.apache.openjpa.util.StringId] [java.lang.String] >>> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4958) >>> >>> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4918) >>> >>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136) >>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:86) >>> >>> I check MySQL and there are tables like j3_address, j3_address_line, >>> etc. And juddiv3.j3_publisher table wasn't there. JUDDI seems didn't build >>> all the needed tables when starting. Am I missing something? >>> >>> Thanks. >>> >> >> >
