[jBPM] - Drools - unable to commit after fireRules with retract
by Carlo Carrara
Carlo Carrara [https://community.jboss.org/people/carlo.carrara] created the discussion
"Drools - unable to commit after fireRules with retract"
To view the discussion, visit: https://community.jboss.org/message/736997#736997
--------------------------------------------------------------
I’m using drools 5.4.0.Final & JPA on JBossAS 7.1.1 and MySQL 5 with attached rules file.
All things go fine if I add facts in entry points "startVM" or "destroyVM" (related rules has “retract” instruction commented), but things go wrong when I add facts in entry points "createVM" or "stopVM" (related rules has “retract” instruction active).
The events sequence is this:
1. Startup application with clean db
2. Execute fireRules
3. Add some facts in entry points "startVM" or "destroyVM" (related rules has “retract” instruction commented)
4. Execute fireRules
5. Stop application
6. Restart application, reloading some facts from db
7. Add a fact in entry point "createVM" or "stopVM" (related rules has “retract” instruction active)
8. Execute fireRules
9. Stop application
10. Restart application, reloading some facts from db
11. Execute fireRules: error thrown!
I can do anything before step 7 in any combination, and everything goes fine. The problem is created by step 7.
Here the exception thrown:
Every “add a fact” step and “execute fireRules” step is under transaction.
2012-05-21 19:46:06.441 | fireRules1 | | | | ERROR | com.abc.eventprocessor.rule.drools.DroolsRuleEngine | fireRules | error firing rules
javax.transaction.RollbackException: ARJUNA016053: Could not commit transaction.
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1177) ~[na:na]
at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:117) ~[na:na]
at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75) ~[na:na]
at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:167) ~[na:na]
at com.abc.eventprocessor.rule.drools.DroolsRuleEngine.fireRules(DroolsRuleEngine.java:169) ~[classes:1.0.0-SNAPSHOT]
at com.abc.eventprocessor.scheduler.FireRulesJobDetail.executeInternal(FireRulesJobDetail.java:35) [classes:1.0.0-SNAPSHOT]
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113) [spring-context-support-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at com.abc.commons.quartz.ClusterizableJobMap.executeInternal(ClusterizableJobMap.java:28) [commons-1.0.3-SNAPSHOT.jar:1.0.3-SNAPSHOT]
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113) [spring-context-support-3.1.1.RELEASE.jar:3.1.1.RELEASE]
at org.quartz.core.JobRunShell.run(JobRunShell.java:216) [quartz-1.8.4.jar:na]
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549) [quartz-1.8.4.jar:na]
Caused by: javax.persistence.PersistenceException: error during managed flush
at org.hibernate.ejb.AbstractEntityManagerImpl$CallbackExceptionMapperImpl.mapManagedFlushFailure(AbstractEntityManagerImpl.java:1486) ~[hibernate-entitymanager-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorImpl.beforeCompletion(SynchronizationCallbackCoordinatorImpl.java:109) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.engine.transaction.synchronization.internal.RegisteredSynchronization.beforeCompletion(RegisteredSynchronization.java:53) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76) ~[na:na]
at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:273) ~[na:na]
at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:93) ~[na:na]
at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:164) ~[na:na]
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1165) ~[na:na]
... 10 common frames omitted
Caused by: java.lang.NullPointerException: null
at org.drools.reteoo.ObjectTypeNode$ExpireJobContextTimerOutputMarshaller.serialize(ObjectTypeNode.java:668) ~[drools-core-5.4.0.Final.jar:5.4.0.Final]
at org.drools.marshalling.impl.ProtobufOutputMarshaller.writeTimers(ProtobufOutputMarshaller.java:691) ~[drools-core-5.4.0.Final.jar:5.4.0.Final]
at org.drools.marshalling.impl.ProtobufOutputMarshaller.serializeSession(ProtobufOutputMarshaller.java:176) ~[drools-core-5.4.0.Final.jar:5.4.0.Final]
at org.drools.marshalling.impl.ProtobufOutputMarshaller.writeSession(ProtobufOutputMarshaller.java:100) ~[drools-core-5.4.0.Final.jar:5.4.0.Final]
at org.drools.marshalling.impl.ProtobufMarshaller.marshall(ProtobufMarshaller.java:169) ~[drools-core-5.4.0.Final.jar:5.4.0.Final]
at org.drools.marshalling.impl.ProtobufMarshaller.marshall(ProtobufMarshaller.java:151) ~[drools-core-5.4.0.Final.jar:5.4.0.Final]
at org.drools.persistence.SessionMarshallingHelper.getSnapshot(SessionMarshallingHelper.java:72) ~[drools-persistence-jpa-5.4.0.Final.jar:5.4.0.Final]
at org.drools.persistence.info.SessionInfo.update(SessionInfo.java:85) ~[drools-persistence-jpa-5.4.0.Final.jar:5.4.0.Final]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0]
at org.hibernate.ejb.event.BeanCallback.invoke(BeanCallback.java:39) ~[hibernate-entitymanager-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.ejb.event.EntityCallbackHandler.callback(EntityCallbackHandler.java:110) ~[hibernate-entitymanager-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.ejb.event.EntityCallbackHandler.preUpdate(EntityCallbackHandler.java:95) ~[hibernate-entitymanager-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.ejb.event.EJB3FlushEntityEventListener.invokeInterceptor(EJB3FlushEntityEventListener.java:65) ~[hibernate-entitymanager-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.event.internal.DefaultFlushEntityEventListener.handleInterception(DefaultFlushEntityEventListener.java:315) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.event.internal.DefaultFlushEntityEventListener.scheduleUpdate(DefaultFlushEntityEventListener.java:266) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:149) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:225) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:99) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1081) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:315) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
at org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorImpl.beforeCompletion(SynchronizationCallbackCoordinatorImpl.java:104) ~[hibernate-core-4.0.1.Final.jar!/:4.0.1.Final]
... 16 common frames omitted
After this error I need to clean the db and loose session data.
How can I get out of this problem?
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/736997#736997]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 7 months
[jBPM] - Problem Running Task Service in MySQL
by TC ONG
TC ONG [https://community.jboss.org/people/devilkazuya99] created the discussion
"Problem Running Task Service in MySQL"
To view the discussion, visit: https://community.jboss.org/message/735302#735302
--------------------------------------------------------------
In DemoTaskService.java
EntityManagerFactory emf = Persistence.createEntityManagerFactory("org.jbpm.task");
TaskService taskService = new TaskService(emf, SystemEventListenerFactory.getSystemEventListener());
TaskServiceSession taskSession = taskService.createSession();
...
MinaTaskServer server = new MinaTaskServer(taskService);
Thread thread = new Thread(server);
thread.start();
...
I changed the persistence.xml from using H2 to MySQL like
... <properties>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
<property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
<property name="hibernate.connection.url" value="jdbc:mysql://localhost/mina_task_server_db" />
<property name="hibernate.connection.username" value="root"/>
<property name="hibernate.connection.password" value=""/>
<property name="hibernate.connection.autocommit" value="true" />
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.hbm2ddl.auto" value="none" />
<property name="hibernate.show_sql" value="false" />
</properties> ...
And I always get this error:
Cannot add or update a child row: a foreign key constraint fails (`mina_task_server_db`.`task`, CONSTRAINT `FK27A9A59E619A0` FOREIGN KEY (`createdBy_id`) REFERENCES `OrganizationalEntity` (`id`))
Somehow it's the schema constraint issue. And way, I am also interesting to find out about this:
When I run the service in H2, everything is fine. Then I look at the mydb.trace.db file generated by H2.
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "ATTACHMENT" not found; SQL statement:
alter table Attachment drop constraint FK1C935438EF5F064 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "ATTACHMENT" not found; SQL statement:
alter table Attachment drop constraint FK1C93543F21826D9 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "BOOLEANEXPRESSION" not found; SQL statement:
alter table BooleanExpression drop constraint FKE3D208C0AFB75F7D [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "DEADLINE" not found; SQL statement:
alter table Deadline drop constraint FK21DF3E78684BACA3 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "DEADLINE" not found; SQL statement:
alter table Deadline drop constraint FK21DF3E7827ABEB8A [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "DELEGATION_DELEGATES" not found; SQL statement:
alter table Delegation_delegates drop constraint FK47485D572C122ED2 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "DELEGATION_DELEGATES" not found; SQL statement:
alter table Delegation_delegates drop constraint FK47485D5736B2F154 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "ESCALATION" not found; SQL statement:
alter table Escalation drop constraint FK67B2C6B5C7A04C70 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "I18NTEXT" not found; SQL statement:
alter table I18NText drop constraint FK2349686B2162DFB4 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "I18NTEXT" not found; SQL statement:
alter table I18NText drop constraint FK2349686BD488CEEB [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "I18NTEXT" not found; SQL statement:
alter table I18NText drop constraint FK2349686B5EEBB6D9 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "I18NTEXT" not found; SQL statement:
alter table I18NText drop constraint FK2349686B3330F6D9 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "I18NTEXT" not found; SQL statement:
alter table I18NText drop constraint FK2349686B8046A239 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "I18NTEXT" not found; SQL statement:
alter table I18NText drop constraint FK2349686B69B21EE8 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "I18NTEXT" not found; SQL statement:
alter table I18NText drop constraint FK2349686BB2FA6B18 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "I18NTEXT" not found; SQL statement:
alter table I18NText drop constraint FK2349686B98B62B [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "I18NTEXT" not found; SQL statement:
alter table I18NText drop constraint FK2349686BF952CEE4 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "NOTIFICATION" not found; SQL statement:
alter table Notification drop constraint FK2D45DD0B3E0890B [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "NOTIFICATION_BAS" not found; SQL statement:
alter table Notification_BAs drop constraint FK2DD68EE02C122ED2 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "NOTIFICATION_BAS" not found; SQL statement:
alter table Notification_BAs drop constraint FK2DD68EE09C76EABA [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "NOTIFICATION_RECIPIENTS" not found; SQL statement:
alter table Notification_Recipients drop constraint FK98FD214E2C122ED2 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "NOTIFICATION_RECIPIENTS" not found; SQL statement:
alter table Notification_Recipients drop constraint FK98FD214E9C76EABA [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "NOTIFICATION_EMAIL_HEADER" not found; SQL statement:
alter table Notification_email_header drop constraint FKF30FE3441F7B912A [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "NOTIFICATION_EMAIL_HEADER" not found; SQL statement:
alter table Notification_email_header drop constraint FKF30FE34430BE501C [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "PEOPLEASSIGNMENTS_BAS" not found; SQL statement:
alter table PeopleAssignments_BAs drop constraint FK9D8CF4EC2C122ED2 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "PEOPLEASSIGNMENTS_BAS" not found; SQL statement:
alter table PeopleAssignments_BAs drop constraint FK9D8CF4EC36B2F154 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "PEOPLEASSIGNMENTS_EXCLOWNERS" not found; SQL statement:
alter table PeopleAssignments_ExclOwners drop constraint FKC77B97E42C122ED2 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "PEOPLEASSIGNMENTS_EXCLOWNERS" not found; SQL statement:
alter table PeopleAssignments_ExclOwners drop constraint FKC77B97E436B2F154 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "PEOPLEASSIGNMENTS_POTOWNERS" not found; SQL statement:
alter table PeopleAssignments_PotOwners drop constraint FK1EE418D2C122ED2 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "PEOPLEASSIGNMENTS_POTOWNERS" not found; SQL statement:
alter table PeopleAssignments_PotOwners drop constraint FK1EE418D36B2F154 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "PEOPLEASSIGNMENTS_RECIPIENTS" not found; SQL statement:
alter table PeopleAssignments_Recipients drop constraint FKC6F615C22C122ED2 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "PEOPLEASSIGNMENTS_RECIPIENTS" not found; SQL statement:
alter table PeopleAssignments_Recipients drop constraint FKC6F615C236B2F154 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "PEOPLEASSIGNMENTS_STAKEHOLDERS" not found; SQL statement:
alter table PeopleAssignments_Stakeholders drop constraint FK482F79D52C122ED2 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "PEOPLEASSIGNMENTS_STAKEHOLDERS" not found; SQL statement:
alter table PeopleAssignments_Stakeholders drop constraint FK482F79D536B2F154 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "REASSIGNMENT" not found; SQL statement:
alter table Reassignment drop constraint FK724D0560A5C17EE0 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "REASSIGNMENT_POTENTIALOWNERS" not found; SQL statement:
alter table Reassignment_potentialOwners drop constraint FK90B59CFF2C122ED2 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "REASSIGNMENT_POTENTIALOWNERS" not found; SQL statement:
alter table Reassignment_potentialOwners drop constraint FK90B59CFFE17E130F [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "SUBTASKSSTRATEGY" not found; SQL statement:
alter table SubTasksStrategy drop constraint FKDE5DF2E136B2F154 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "TASK" not found; SQL statement:
alter table Task drop constraint FK27A9A59E619A0 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "TASK" not found; SQL statement:
alter table Task drop constraint FK27A9A56CE1EF3A [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "TASK" not found; SQL statement:
alter table Task drop constraint FK27A9A5F213F8B5 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "TASK_COMMENT" not found; SQL statement:
alter table task_comment drop constraint FK61F475A5B35E68F5 [42102-124]
04-12 14:03:34 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table "TASK_COMMENT" not found; SQL statement:
alter table task_comment drop constraint FK61F475A52FF04688 [42102-124]
So, wehn running in H2, all constraint was dropped. When running in MySQL, the constraint is still there. I tried manually removed the constraints in MySQL and it works, but that is strange for me. Can someone explain what is going on, why H2 drop the constraint and MySQL don't, and is it any thing that I did wrong?
Thank you.
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/735302#735302]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 7 months
[Performance Tuning] - SQL stmts Commit or Rollback confirmation
by Sharad Jhingran
Sharad Jhingran [https://community.jboss.org/people/xhings] created the discussion
"SQL stmts Commit or Rollback confirmation"
To view the discussion, visit: https://community.jboss.org/message/736880#736880
--------------------------------------------------------------
Hello All,
Is there a way to understand if the sql statements have committed or rolled back in the server log file? I could trace the statements as follows:
2012-05-21 05:58:44,769 -0700 level=DEBUG class=org.springframework.jdbc.core.JdbcTemplate [Thread: WorkerThread#13[10.137.67.151:47672]] org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:569) Executing prepared SQL statement [
SELECT ACCOUNTNUMBER FROM MERCHANTACCOUNT_VW WHERE EID = ?
]
2012-05-21 05:58:44,769 -0700 level=DEBUG class=org.springframework.jdbc.datasource.DataSourceUtils [Thread: WorkerThread#13[10.137.67.151:47672]] org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110) Fetching JDBC Connection from DataSource
2012-05-21 05:58:44,776 -0700 level=DEBUG class=org.springframework.jdbc.core.StatementCreatorUtils [Thread: WorkerThread#13[10.137.67.151:47672]] org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:206) Setting SQL statement parameter value: column index 1, parameter value [3439957], value class [java.lang.Long], SQL type unknown
2012-05-21 05:58:44,781 -0700 level=DEBUG class=org.springframework.jdbc.datasource.DataSourceUtils [Thread: WorkerThread#13[10.137.67.151:47672]] org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:332) Returning JDBC Connection to DataSource
2012-05-21 05:58:44,781 -0700 level=DEBUG class=org.springframework.jdbc.core.JdbcTemplate [Thread: WorkerThread#13[10.137.67.151:47672]] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:434) Executing SQL query [
SELECT MEMOID_SEQ.NEXTVAL AS VALUE FROM DUAL
]
I want to find where the statements get committed or rolled back during the load test?
Thanks for noticing!!
Regards,
Xhings
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/736880#736880]
Start a new discussion in Performance Tuning at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 7 months
[JBoss Web Services] - problems in WebServiceContext using @Resource in web application
by Deepak jangid
Deepak jangid [https://community.jboss.org/people/jangiddddd] created the discussion
"problems in WebServiceContext using @Resource in web application"
To view the discussion, visit: https://community.jboss.org/message/736944#736944
--------------------------------------------------------------
Hi
I have some problem in web service context in web application .
Enviroument :
Jdk1.6 , Jboss5.1.0.GA ,jbossws 3.4.0
when i declare
@Resource
private WebServiceContext wsContext;
MessageContext messageContext = wsContext.getMessageContext();
logger.info("--------------message context-------------"+messageContext.toString());
SOAPMessageContext soapMessageContext = (SOAPMessageContext) wsContext.getMessageContext();
SOAPMessageImpl message = (SOAPMessageImpl) soapMessageContext.getMessage();
Than this is give error after calling this endpoint
2012-05-22 10:54:57,718 ERROR org.jboss.wsf.common.invocation.InvocationHandlerJAXWS - Method invocation failed with exception: Cannot create endpoint instance:
java.lang.IllegalStateException: Cannot create endpoint instance:
at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.getTargetBean(AbstractInvocationHandlerJSE.java:85)
at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:119)
at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:241)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:527)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:316)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:222)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:147)
at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(AbstractEndpointServlet.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.jboss.wsf.common.injection.InjectionException: Cannot inject field annotated with @Resource annotation: private javax.xml.ws.WebServiceContext bancmate.mbanc.action.AccountServExposeService.wsContext
at org.jboss.wsf.common.injection.InjectionException.rethrow(InjectionException.java:106)
at org.jboss.wsf.common.injection.InjectionHelper.injectResourceAnnotatedAccessibleObjects(InjectionHelper.java:296)
at org.jboss.wsf.common.injection.InjectionHelper.injectResources(InjectionHelper.java:110)
at org.jboss.wsf.common.invocation.InvocationHandlerJAXWS.onEndpointInstantiated(InvocationHandlerJAXWS.java:75)
at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.getTargetBean(AbstractInvocationHandlerJSE.java:81)
... 28 more
Caused by: org.jboss.wsf.common.injection.InjectionException: Resource 'wsContext' not found
at org.jboss.wsf.common.injection.InjectionException.rethrow(InjectionException.java:106)
at org.jboss.wsf.common.injection.InjectionHelper.lookup(InjectionHelper.java:412)
at org.jboss.wsf.common.injection.InjectionHelper.inject(InjectionHelper.java:389)
at org.jboss.wsf.common.injection.InjectionHelper.injectResourceAnnotatedAccessibleObjects(InjectionHelper.java:291)
... 31 more
Caused by: javax.naming.NameNotFoundException: wsContext not bound
at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)
at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)
at org.jnp.server.NamingServer.getObject(NamingServer.java:785)
at org.jnp.server.NamingServer.lookup(NamingServer.java:443)
at org.jnp.server.NamingServer.lookup(NamingServer.java:399)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:726)
at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:686)
at org.jboss.wsf.common.injection.InjectionHelper.lookup(InjectionHelper.java:407)
... 33 more
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/736944#736944]
Start a new discussion in JBoss Web Services at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 7 months