Web Application on AWS and Oracle DB on premise
We are deploying an apache-tomcat WebApplication in an Amazon Web Service instance (AWS-EC2, xlarge. ).
The web application needs to access our local Oracle server through a public IP address:port1521.
The webapp was developed in Java and uses ojdbc7.jar, with these properties
<bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" name="DS">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="username" value="***"/>
<property name="password" value="***"/>
<property name="url" value="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:dbname"/>
<property name="maxIdle" value="1"/>
<property name="maxActive" value="10"/>
</bean>
The application works fine for "non-data intensive" queries. We are working on genomics research, and