Datasource error
gurnard Jun 23, 2006 4:45 AM
I have this datasource set up in my struts config, running JBoss 4.0.4, and on starting the server I am getting the below error.
From what I can see from the error I might have the details of the datasource incorrect, so can someone tell me what is supposed to go where? I am on Oracle 9i.
This property should it be host:port:database?
<set-property property="url" value="jdbc:oracle:thin:@localhost:1521:PROD2" />
This property would be my service name in Oracle
<set-property property="username" value="BIZZ_COOP" />
<data-source key="bizzCoop" type="org.apache.commons.dbcp.BasicDataSource"> <set-property property="driverClassName" value="oracle.jdbc.driver.OracleDriver" /> <set-property property="url" value="jdbc:oracle:thin:@localhost:1521:PROD2" /> <set-property property="username" value="BIZZ_COOP" /> <set-property property="password" value="coop" /> <set-property property="maxActive" value="10" /> <set-property property="maxWait" value="5000" /> <set-property property="defaultAutoCommit" value="false" /> <set-property property="defaultReadOnly" value="false" /> <set-property property="validationQuery" value="SELECT SYSDATE FROM DUAL" /> </data-source>
----start of error Caused by: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=( TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:361) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja va:442) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv erConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable ConnectionFactory.java:290) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas icDataSource.java:877) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou rce.java:851) ... 141 more ----
Thanks for reading
cheers
Martin