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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3952920#3952920 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3952920 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user