Hi guys,
I was really frustrated with juddi again. I'm using juddi_v3.2 and
following the v3.2 admin & server guide. I think some content in the guide
it is depreciated, but it's ok.
What I changed is really little. Here is all my environments: windows 7
x64, MySQL 5.1.69 for Win64, juddiv3 v3.2, mysql-connector-java-5.1.24,
tomcat-7.0.47.
I unziped juddi-distro-3.2.0/juddiv3.war directly into tomcat's webapp
directory. And changed the datasource config in
webapps/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>
Granted all privilege for user 'juddi' at 'juddiv3' database.
Is that all for juddi to go?
But when I tried to get my happy juddi page, I have these error msg instead:
org.apache.openjpa.lib.jdbc.ReportingSQLException: 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]
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
...........
It was like juddi didn't created all the needed table in 'juddiv3' database.
Then I tried to create these missing tables by myself, there are three of
them: j3_publisher, j3_service_category_bag and j3_tmodel_category_bag.
Several minutes later ..., done, run it again. And error msg:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'RR' at line 1
{prepstmnt 30634077 SELECT SEQUENCE_VALUE FROM OPENJPA_SEQUENCE_TABLE WHERE
ID = ? FOR UPDATE WITH RR} [code=1064, state=42000]
Cann't recognize RR? Ok, found the config file for MySQL: my.ini, added
line below:
transaction_isolatoin=REPEATABLE_READ
Actually this time I was not so optimistic, and so is juddi. Same error msg
as before:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'RR' at line 1
{prepstmnt 30634077 SELECT SEQUENCE_VALUE FROM OPENJPA_SEQUENCE_TABLE WHERE
ID = ? FOR UPDATE WITH RR} [code=1064, state=42000]
I really need some kind of rescue now.
Thanks to all.
