0 Replies Latest reply on Apr 1, 2002 2:49 PM by Alexander Petty

    JBoss 244 Pool for Oracle 81701 on NT

    Alexander Petty Newbie

      I am having problems getting data to insert into the db via the connection pool untill after I shutdown Jboss.

      In other words, I might submit a form 20 times, check the DB for data... nothing.

      Then I shut down Jboss and voila! its all there!!!

      What could go be going on to cause this? How can I prevent it?

      *******
      Form:
      *******
      <%@ taglib uri="http://jakarta.apache.org/taglibs/dbtags" prefix="sql" %>

      <sql:connection id="conn1" jndiName="java:/db00Pool"/>
      <sql:statement id="stmt1" conn="conn1">
      <sql:query>
      insert into userinfo (userid, lname, fname, username, userpass, useremail, userlevel)
      values ( seq_userinfo.nextval,
      '<sql:escapeSql><%=request.getParameter("lname")%></sql:escapeSql>',
      '<sql:escapeSql><%=request.getParameter("fname")%></sql:escapeSql>',
      '<sql:escapeSql><%=request.getParameter("username")%></sql:escapeSql>',
      '<sql:escapeSql><%=request.getParameter("userpass")%></sql:escapeSql>',
      '<sql:escapeSql><%=request.getParameter("useremail")%></sql:escapeSql>',
      '<sql:escapeSql><%=request.getParameter("userlevel")%></sql:escapeSql>'
      )
      </sql:query>
      </sql:statement>

      ******
      jboss.jcml
      ******


      oracle.jdbc.driver.OracleDriver



      db00Pool
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:oracle:thin:@12.109.142.35:1521:db00
      xxxx
      xxxx
      1.0
      true
      1000
      60000
      60000
      true
      false
      true
      true
      true
      1
      2