Hi,
I need to access data in Oracle Database Tables.
I've set the jboss configuration in "oracle-ds.xml".
Something like :
<no-tx-datasource>
<jndi-name>a/b/OrDataSource</jndi-name>
<connection-url>jdbc:oracle:thin:@1.2.3.4:1521:V6</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>user</user-name>
pass
<min-pool-size>5</min-pool-size>
<max-pool-size>50</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</no-tx-datasource>
Now I need to develop a servlet to use this to get to the Oracle Info.
Can anyone please give me a few pointers and examples please? Is it regular jdbc programming or are there a few diferences considering I'm using JBoss and not just simply Tomcat for example.
Thank you