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>
