Ok well I got it sorted after a lot of googling and messing about. This is connecting to a remote Oracle database using a struts-config datasource:
Now the main problem with me was connecting remotley and my Oracle TNS not configured correctly, it is corrupt locally so having real problems with that. The way it was sorted in the end was using a connection string to directly connect to Oracle. This is my struts-config datasource, the URL property is where all the action is: | <data-sources> | <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:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hereGoesTheHostNameOrIPAddressOfHost)(PORT=1521))(CONNECT_DATA=(SID=PROD2)))" /> | <set-property property="username" value="myUser" /> | <set-property property="password" value="myPass" /> | <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> | </data-sources> | Also make sure to have these classes visible to the server; I have mine in the WEB-INF/lib directory: The last 2 are Oracle specific I think. commons-pool-1.3.jar commons-collections-3.2.jar jdbc2_0-stdext.jar classes12.jar View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3952996#3952996 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3952996 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
