Hi, Do you close your Resultset/PreparedStatement/Connection after you are finished with it??? Burkhard ----- Original Message ----- From: "$BMe5#(B" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 7:40 AM Subject: [JBoss-user] BMP problem
> I create a web application. JSP + EJB BMP. JSP file list all the record in > DataBase by calling the BMP findALL mechod,when submit the input form, > another JSP file insert the record by calling create method. > > The problem is > > The new record was not be seen by SQL PLUS and the application had no > response. > > After the Jboss is stopped, the new record can be seen in the table. > > I use JBoss-2.2.2_Tomcat-3.2.2, Database Oracle 8.15. > > The EJB is BMP with container managed transaztion, all the method in the > EJB is transactin "required", and all the containner commit option is C. > > Please give me some advice. Thank you! > > Server.log > > [Service Control] Started 26 services > [Default] JBoss 2.2.2 Started in 0m:38s > [EmbeddedTomcatSX] before findAll > [OracleDB] Resource > 'org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl@9f854' enlisted for > 'org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@562270'. > [OracleDB] Pool OracleDB [1/1/Unlimited] gave out pooled object: > org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@562270 > [testBean] Dbconnection=java:comp/env/jdbc/AccountDB > [testBean] ejb find All > [testBean] 111 in select ALL > [EmbeddedTomcatSX] after findAll > [testBean] Activated bean testBean with id = 1 > [testBean] ejb Load- id =1 > [testBean] ejb Store > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 1 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 1 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 1 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 1 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 1 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 1 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 1 > [Container factory] Passivated bean testBean with id = 1 > [testBean] Activated bean testBean with id = 2 > [testBean] ejb Load- id =2 > [testBean] ejb Store > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 2 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 2 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 2 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 2 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 2 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 2 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 2 > [OracleDB] org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl created > new Connection (oracle.jdbc.driver.OracleConnection) with XAResource > org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl and XAConnection > org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl. > [OracleDB] Resource > 'org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl@2679a' enlisted for > 'org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5ae160'. > [OracleDB] Pool OracleDB [1/1/Unlimited] gave out new object: > org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@5ae160 > [testBean] Dbconnection=java:comp/env/jdbc/AccountDB > [testBean] Activated bean testBean with id = 3 > [testBean] ejb Load- id =3 > [Container factory] Passivated bean testBean with id = 2 > [testBean] ejb Store > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 3 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 3 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 3 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 3 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 3 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 3 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 3 > [testBean] Activated bean testBean with id = 4 > [testBean] ejb Load- id =4 > [Container factory] Passivated bean testBean with id = 3 > [testBean] ejb Store > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 4 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 4 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 4 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 4 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 4 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 4 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 4 > [testBean] Activated bean testBean with id = 5 > [testBean] ejb Load- id =5 > [Container factory] Passivated bean testBean with id = 4 > [testBean] ejb Store > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 5 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 5 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 5 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 5 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 5 > [testBean] ejb Store > [Container factory] Postponed passivation of bean testBean with id = 5 > [testBean] in storeRow > [testBean] Scheduled passivation of bean testBean with id = 5 > [Container factory] Passivated bean testBean with id = 5 > [testBean] Scheduled passivation of bean testBean with id = 6 > [EmbeddedTomcatSX] -account_insert.jsp first_name=6t > [EmbeddedTomcatSX] account_insert.jsp a=6t > [Container factory] Passivated bean testBean with id = 6 > [EmbeddedTomcatSX] account_insert.jsp b=6t > [EmbeddedTomcatSX] account_insert.jsp c=6t > [EmbeddedTomcatSX] account_insert.jsp d=6t > [EmbeddedTomcatSX] account_insert.jsp es=6t > [EmbeddedTomcatSX] before findAll > [testBean] ejb find All > [testBean] 111 in select ALL > [EmbeddedTomcatSX] after findAll > [testBean] Activated bean testBean with id = 1 > [testBean] ejb Load- id =1 > [testBean] ejb Store > [testBean] Transaction XidImpl [FormatId=257, GlobalId=diy27//23, > BranchQual=] timed out. status=STATUS_ACTIVE > [Bean Cache] Resized cache for bean testBean: old capacity = 1000, new > capacity = 50 > > > ------------------------------------------------- > LUO$B!!(BYI$B!!([EMAIL PROTECTED] > > ------------------------------------------------- > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
