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
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
