RE: Probelms while installing on tomcat

["Viens, Stephen" <St...@LibertyMutual.com>]

Ben,

It looks as if Tomcat cannot locate the MySQL JDBC Driver 
(org.gjt.mm.mysql.Driver) which is specified in the resource-ref
element.  Make sure you've added it to the TOMCAT-DIR\common\lib
directory.

Also the SAXParser message is not an error message. The jUDDI happyness
page is 
simply telling you that it found the class it was looking for
(SAXParserFactory) 
but couldn't report on the exact location in which it found it. 

Steve 

PS: I'm travelling again this week and will have only occasional email
access. 

-----Original Message-----
From: bEn Fries [mailto:Develin@gmx.de] 
Sent: Tuesday, November 30, 2004 4:29 AM
To: juddi-user@ws.apache.org
Subject: Probelms while installing on tomcat


Hi!

I tried to install jUDDI on my Tomcat some weird error appeared as the 
jUDDY Happyness page showed:

+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
- DB connection was not aquired. (Cannot load JDBC driver class
'org.gjt.mm.mysql.Driver')
- SELECT COUNT(*) FROM PUBLISHER failed (null)

As this is the first time I work with tomcat I really don't know how to
solve this issue so I'd be really happy if one of you could  help.

Another "problem" is that there is an entry in the happyness page:

*Looking for*: javax.xml.parsers.SAXParserFactory
+Found in an unknown location

Is this an issue or can I live with this?


Thanx in advance!!!!


ben



My server XML looks as follows (it's entirely taken from the jUDDI
deployment manual).



<Context path="/juddi" docBase="juddi" debug="5" reloadable="true" 
crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger" 
prefix="localhost_juddiDB_log" suffix=".txt" timestamp="true"/>
<Resource name="jdbc/juddiDB" auth="Container"
type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/juddiDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>

<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>

<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
-
    <parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>

<parameter>
<name>username</name>
<value>juddi</value>
</parameter>

<parameter>
<name>password</name>
<value>123456</value>
</parameter>

<parameter>
<name>driverClassName</name> <value>org.gjt.mm.mysql.Driver</value>
</parameter>


<parameter>
<name>url</name>
<value>
jdbc:mysql://localhost:3306/jUDDI?autoReconnect=true
</value>
</parameter>

<parameter>
<name>validationQuery</name>
<value>select count(*) from PUBLISHER</value>
</parameter>
</ResourceParams>
</Context>

Problem with Servererror when connecting to jUDDI

[bEn Fries <De...@gmx.de>]

Hi,

I installed jUDDI - seems to be working as it's happyness page is .. 
well... happy.
So I tried to run an example from UDDI4J. Now this example throws an 
exeption and reports an:

(500) Internal Server Error

I thought this might be a user/passwort issue but the passwords seem to 
be OK:

In UDDI4J I used

userid = sviens
password = password

(as this is the "included" user of jUDDI)
 
and in juddi-user.xml I have a user as follows:
<user userid="sviens" password="password" />

and there is a publisher in the juddi/publisher database
with ID "sviens"

So I'm pretty sure this should be OK - is there sth else that might 
cause this error?

Any idea where I might start debugging?

Thanx in Advance

Ben

Re: Probelms while installing on tomcat

[bEn Fries <De...@gmx.de>]

Hi!

Thanx for your answer! Yeah that was exactly my problem - after I added 
the MySQLConnector driver the happyness page was happy again.

Maybe you can answer me another question. When I want to connect to the 
jUDDI with UDDI4J the server returns an 500 Error and the connection is 
refused. Do you have any idea was this can be or where I can look for 
this problem?

Thank you very much!

Ben



Viens, Stephen schrieb:

>Ben,
>
>It looks as if Tomcat cannot locate the MySQL JDBC Driver 
>(org.gjt.mm.mysql.Driver) which is specified in the resource-ref
>element.  Make sure you've added it to the TOMCAT-DIR\common\lib
>directory.
>
>Also the SAXParser message is not an error message. The jUDDI happyness
>page is 
>simply telling you that it found the class it was looking for
>(SAXParserFactory) 
>but couldn't report on the exact location in which it found it. 
>
>Steve 
>
>PS: I'm travelling again this week and will have only occasional email
>access. 
>