Re: problem with jUDDI on tomcat & oracle

[cp392 <ch...@gmail.com>]

Hey,

 Did you fond any steps for running JUDDI with Oracle?

 I am having issues too.



fayng21 wrote:
> 
> Hi all, I have a few questiones regarding setting jUDDI on tomcat and
> oracle 10g. I get the error message below.  i have downloaded the oracle
> jdbc driver jar files and copied it into juddi/web-inf/lib folder and
> followed the instructions on setting it up.   i put the juddi.properties
> and server.xml below too.  please any suggesstion is appreciated.  Thanks
> in advance.   
> 
> -fay
> 
> p.s. if i can get a installation guide for juddi on oracle would be
> greatly
> 
> -------------result of validation
> page---------------------------------------------------------------
> + Got a JNDI Context!
> + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
> - DB connection was not aquired. (Cannot create JDBC driver of class ''
> for connect URL 'null')
> - SELECT COUNT(*) FROM PUBLISHER failed (null)
> 
> ----------------juddi.properties-------------------------------------------------------------------
> # required JDBC DataSource properties
> juddi.dataSource = java:comp/env/jdbc/juddiDB
> 
> # required JDBC Driver properties
> juddi.useConnectionPool = true
> juddi.jdbcDriver = oracle.jdbc.driver.OracleDriver
> juddi.jdbcURL = jdbc:oracle://localhost/juddi
> juddi.jdbcUser = SYSTEM
> juddi.jdbcPassword = password
> 
> # optional JDBC Driver connection pool properties
> juddi.jdbcMaxActive = 20
> juddi.jdbcMaxIdle = 20 
> juddi.jdbcMaxWaitTime = 15000
> juddi.jdbcRetryInterval = 1000
> 
> ---------------------- server.xml
> --------------------------------------------------------------------
> 
> 	<Context path="/juddi" docBase="juddi" debug="5" reloadable="true"
> crossContext="true">
> 	  <Resource name="jdbc/juddiDB" auth="Container"
> type="javax.sql.DataSource"
> 		    username="SYSTEM" password="password"
> driverClassName="oracle.jdbc.driver.OracleDriver"
> 		    url="jdbc:oracle://localhost:3306/juddi?autoReconnect=true"
> 		    validationQuery="select count(*) from PUBLISHER" />  
> 	</Context>
> 

-- 
View this message in context: http://old.nabble.com/problem-with-jUDDI-on-tomcat---oracle-tp5540373p32359721.html
Sent from the jUDDI - User mailing list archive at Nabble.com.

Re: problem with jUDDI on tomcat & oracle

[Kurt T Stam <ku...@gmail.com>]

yes these are the settings for juddi v2. From what I can see the only 
thing wrong
is the connection url. It needs to be something like

/jdbc/:/oracle/:thin:@//myhost:1521/orcl

Also I would use a user a little less potent then System..

For the thin driver see also: http://www.orafaq.com/wiki/JDBC#Thin_driver

Good luck,

--Kurt

On 8/29/11 4:01 PM, cp392 wrote:
> Hey,
>
>   Did you fond any steps for running JUDDI with Oracle?
>
>   I am having issues too.
>
>
>
> fayng21 wrote:
>> Hi all, I have a few questiones regarding setting jUDDI on tomcat and
>> oracle 10g. I get the error message below.  i have downloaded the oracle
>> jdbc driver jar files and copied it into juddi/web-inf/lib folder and
>> followed the instructions on setting it up.   i put the juddi.properties
>> and server.xml below too.  please any suggesstion is appreciated.  Thanks
>> in advance.
>>
>> -fay
>>
>> p.s. if i can get a installation guide for juddi on oracle would be
>> greatly
>>
>> -------------result of validation
>> page---------------------------------------------------------------
>> + Got a JNDI Context!
>> + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
>> - DB connection was not aquired. (Cannot create JDBC driver of class ''
>> for connect URL 'null')
>> - SELECT COUNT(*) FROM PUBLISHER failed (null)
>>
>> ----------------juddi.properties-------------------------------------------------------------------
>> # required JDBC DataSource properties
>> juddi.dataSource = java:comp/env/jdbc/juddiDB
>>
>> # required JDBC Driver properties
>> juddi.useConnectionPool = true
>> juddi.jdbcDriver = oracle.jdbc.driver.OracleDriver
>> juddi.jdbcURL = jdbc:oracle://localhost/juddi
>> juddi.jdbcUser = SYSTEM
>> juddi.jdbcPassword = password
>>
>> # optional JDBC Driver connection pool properties
>> juddi.jdbcMaxActive = 20
>> juddi.jdbcMaxIdle = 20
>> juddi.jdbcMaxWaitTime = 15000
>> juddi.jdbcRetryInterval = 1000
>>
>> ---------------------- server.xml
>> --------------------------------------------------------------------
>>
>> 	<Context path="/juddi" docBase="juddi" debug="5" reloadable="true"
>> crossContext="true">
>> 	<Resource name="jdbc/juddiDB" auth="Container"
>> type="javax.sql.DataSource"
>> 		    username="SYSTEM" password="password"
>> driverClassName="oracle.jdbc.driver.OracleDriver"
>> 		    url="jdbc:oracle://localhost:3306/juddi?autoReconnect=true"
>> 		    validationQuery="select count(*) from PUBLISHER" />
>> 	</Context>
>>