2 Replies Latest reply on Jan 14, 2005 10:22 AM by lfhc

    servlet with oracle

    lfhc

      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