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

[Srinivasan, Latha]

Thanks, Steve. I followed the steps for the datasource setup and juddi users creation. Is there any documentation on the db setup and the juddi schema creation?

 

Appreciate any info you can provide,

Latha

 

 

 

---

From: Steve Viens [mailto:[EMAIL PROTECTED]
Sent: Monday, August 29, 2005 3:39 PM
To: juddi-user@ws.apache.org
Subject: Re: HappyJuddi.jsp errors -- using Juddi deployed on Jboss 4.0.2 and PostGreSQL

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