0 Replies Latest reply on Feb 3, 2008 10:22 AM by Piotr Salski

    Jboss delete oracle triggers

    Piotr Salski Newbie

      I'm new in Jboss, oracle and everything else.
      I have very simple oracle-ds.xml to use oracle database

      <?xml version="1.0" encoding="UTF-8"?>


      <local-tx-datasource>
      <jndi-name>OracleDS</jndi-name>
      <connection-url>jdbc:oracle:thin:@szefo:1521:orcl</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>salski</user-name>
      admin
      </local-tx-datasource>



      When I will create trigger in oracle 10g or 11g database using for example TOAD, it is working fine and stays in database even after computer restart, so I believe everytnig is OK, but when I will just start jboss 4.2.1 GA (clean install with only jdbc driver for oracle and oracle-ds.xml from above ) all trigers that I created will be deleted.
      HOW IT IS POSSIBLE since I dont run any written code.