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.