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" <[email protected]> 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 <[email protected]> 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. >
