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
