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