[JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem
by niuxuetao_fiserv
Hi Mircea,
Thanks for the hints, I looked at the debug log, the sql statement being logged right before the exception is not a "INSERT INTO, but a select":
|
| DEBUG JDBCCacheLoader - executing sql: select fqn from Cached_Events where parent=? (/)
|
|
I tries to execute the statement: select fqn from Cached_Events where parent='/', it finds something in the table.
The 1st insert into statement is logged far after the exception is logged. This is the log msg for it, and it is surprisingly involving the automatically created table 'cached_events_d':
| DEBUG JDBCCacheLoader - executing sql: INSERT INTO Cached_Events (fqn, node, parent) SELECT ?, ?, ? FROM Cached_Events_D WHERE NOT EXISTS (SELECT fqn FROM Cached_Events WHERE fqn = ?) (/RTDE/time-distance-analysis-gps/0)
|
I don't know how to execute this in the console (Oracle SQL Developer)
Any idea?
Xuetao
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4241194#4241194
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4241194
16 years, 9 months
[JBoss jBPM] - Re: running jBMP on Weblogic Server 10.x
by smart_umesh_123
Hi,
Thanks for the valuable suggestions given by all of you till now.
I have one more query to ask you. At present application is using TeamWorks BPM tool. Due to some business reason they want to change to other BPM tool. so we are evaluating jBPM and Intalio BPM.
I am posting one example of TeamWorks BPD. I want your input about how easily we can develop such type of BPD using jBPM.
Process Definition: Meeting Reconciliation
There will be two swimlanes namely Meeting Organizer and System(TeamWorks Process)
1) After meeting has successfully taken place/occurred, control comes to Meeting Reconciliation
2) System sends reminder mails stating meeting is pending for re-conciliation. (in this case TeamWorks has email address stored in it's DB)
3) Meeting Requestor will check his mail and complete his re-conciliation task. If Requestor ignore the email then after 15/30 days process # 2 will be executed again.
4) even if Requestor has not completed re-conciliation within 35 days, System will close the meeting.
I am sorry for not pasting Process Diagram because i couldn't able to insert image.
One more point to add here is, actual application have business process which calls other process and web service.
Let me know if you need more information.
Thanks
Chintan
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4241193#4241193
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4241193
16 years, 9 months