Re: HappyJuddi.jsp errors -- using Juddi deployed on Jboss 4.0.2 and PostGreSQL

[Steve Viens]

Latha, it looks like you've got your datasource set up correctly but is your PostgreSQL db setup and the jUDDI db schema created?  You'll also need at least one entry in the PUBLISHER table with an PUBLISHER_ID that corresponsds to the ID you'll use to acquire a authToken.

 

Steve

 

On 8/23/05, Srinivasan, Latha <[EMAIL PROTECTED]> wrote:

Hi,

In trying to check if my Juddi deployment on JBoss 4.0.2 is correct, I encounter the following error in happyjuddi.jsp:

 

--snip--

 

jUDDI DataSource Validation

+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:/PostgresDS)
+ Got a JDBC Connection!
- SELECT COUNT(*) FROM PUBLISHER failed (ERROR: relation "publisher" does not exist)

--snip--
I've created datasource descriptions for PostgresDS and created appropriate definitions in juddi-ds.xml 
in $JBOSS_HOME/server/all/deploy/.
 
The jar file for the PostGresql driver has also been installed in the server/all/deploy directory. What should I do to get this working?

 
Thanks
Latha