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