You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by "Viens, Steve" <St...@FMR.COM> on 2003/05/28 10:31:10 UTC

[juddi-Developers] RE: [juddi-Users] Problem with datastore

Juan, why don't you submit your "happyjuddi.jsp" change to the jUDDI bug
list (under UI). Simply copy-pasting the content of your note below will be
enough of a description.

http://sourceforge.net/tracker/?group_id=42875&atid=434422

Steve

-----Original Message-----
From: Juan Pablo [mailto:jp@mattenet.com] 
Sent: Wednesday, May 28, 2003 11:09 AM
To: jUDDI mailing list
Subject: RE: [juddi-Users] Problem with datastore


Hi,
	Just a small warning... I tried to put the resource as global and
not under
the context (using tomcat4/MySQL), and then I was hitting another
 problem that the driver was not being loaded. The exception is reported on
the Catalina.out file instead of the juddi log file, so it is easy to miss
the problem.

Also the  http://localhost:8080/juddi/happyjuddi.jsp page does not report
these problem (when the connection is null) .

I have done a minor change to the jsp to report that .


    if (ds != null)
    {
      out.println("got a jUDDI DataSource!");
      Connection conn = ds.getConnection();
      if (conn != null)
      {

           out.println("got a jUDDI db Connection!");
           Statement stmt = conn.createStatement();
           ResultSet rs = stmt.executeQuery("SELECT * FROM PUBLISHER");
           out.println("");
           out.println("*** jUDDI Publishers ***");
           while (rs.next())
             out.println(rs.getString("PUBLISHER_NAME"));
           conn.close();
     } else {
	throw new Exception("No Connection");
     }
    }


JP
-----Original Message-----
From: juddi-users-admin@lists.sourceforge.net
[mailto:juddi-users-admin@lists.sourceforge.net]On Behalf Of Viens, Steve
Sent: Wednesday, May 28, 2003 5:04 PM
To: anthony_web@tiscali.fr
Cc: jUDDI mailing list
Subject: RE: [juddi-Users] Problem with datastore

Anthony, have you tried to view the happyjuddi.jsp page?

Try this:

  http://localhost:8080/juddi/happyjuddi.jsp

... This should at least help in the debugging process.

Also, the latest version of Tomcat (ver 4.1.24 I think) comes with a
web-based UI for configuring a datasource - which is what I used - with
MySQL.

Finally, I believe Rupesh recently posted a message to the jUDDI-users list
about his Tomcat/MySQL configuraiton.

http://sourceforge.net/mailarchive/forum.php?thread_id=2429672&forum_id=7138

Steve

-----Original Message-----
From: Andy Cutright [mailto:acutright@borland.com]
Sent: Wednesday, May 28, 2003 10:27 AM
To: anthony_web@tiscali.fr
Cc: jUDDI mailing list
Subject: Re: [juddi-Users] Problem with datastore


hi anthony,

i'm pretty certain there's a few folks using MySQL on the list. i'm not
familiar with that database, or the configuration of JNDI directly with
tomcat.

cheers,
andy

anthony_web@tiscali.fr wrote:

>Thank you for your answer
>As you have said, I have configure JNDI again but I always have the same
problem. I think the connection with DB doesn't work. Maybe I don't make it
well so if you know how to make it that would be good to help me.
>I use MySQL 2 wher I have created a database juddiDB and I use too Apache
Tomcat 4.
>
>Thank you for advance.
>
>




-------------------------------------------------------
This SF.net email is sponsored by: ObjectStore.
If flattening out C++ or Java code to make your application fit in a
relational database is painful, don't do it! Check out ObjectStore.
Now part of Progress Software. http://www.objectstore.net/sourceforge
_______________________________________________
juddi-users mailing list
juddi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-users


-------------------------------------------------------
This SF.net email is sponsored by: ObjectStore.
If flattening out C++ or Java code to make your application fit in a
relational database is painful, don't do it! Check out ObjectStore.
Now part of Progress Software. http://www.objectstore.net/sourceforge
_______________________________________________
juddi-users mailing list
juddi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-users



-------------------------------------------------------
This SF.net email is sponsored by: ObjectStore.
If flattening out C++ or Java code to make your application fit in a
relational database is painful, don't do it! Check out ObjectStore.
Now part of Progress Software. http://www.objectstore.net/sourceforge
_______________________________________________
juddi-users mailing list
juddi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/juddi-users