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

    JBoss 244 Pool for Oracle 81701

    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!!!

      The Pool seems to initialize ok, should I use the OracleDataSource driver rather than the XADataSourceImpl?

      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


      ****
      Server Log
      ****
      [14:43:39,744,JdbcProvider] Starting
      [14:43:39,754,JdbcProvider] Started
      [14:43:39,774,db00Pool] Starting
      [14:43:41,957,db00Pool] org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl created new Connection (oracle.jdbc.driver.OracleConnection) with XAResource org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl.
      [14:43:41,997,db00Pool] XA Connection pool db00Pool bound to java:/db00Pool
      [14:43:42,007,db00Pool] No transaction right now.
      [14:43:42,328,db00Pool] Started



      Thanks for your help!

      Alexander Petty