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?
*******
JSP 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:@::
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