[jboss-user] [jBPM Users] - Re: Hibernate, Sessions, and Sync - Oh my!

2009-09-29 Thread michaelholtzman
I think this may help us out a lot! You've got the right idea - a custom node sends off an async request to our central application and waits. Some time later, our jBPM app receives the results of that request, then creates a new jbpmContext, loads the token, signals it, and closes the

[jboss-user] [jBPM Users] - Hibernate, Sessions, and Sync - Oh my!

2009-09-25 Thread michaelholtzman
Greetings - We are plagued with StaleObjectStateExceptions that I have been unable to resolve. We are running jBPM (derived from version 3.1.2) in an application which launches and manages our workflows and also executes commands targetting specific workflow instances (for example, a signal

[jboss-user] [jBPM Users] - Re: Fork branch runs through Join node

2009-09-17 Thread michaelholtzman
OK, I searched through JIRA. I found two fixes that seem related to other problems we are having, but nothing that directly addresses this problem with the join node. In 3.2/3.3 a token entering a join locks its parent node. There's a lot of discussion about this and it seems relevant, but in

[jboss-user] [jBPM Users] - Fork branch runs through Join node

2009-09-15 Thread michaelholtzman
Greetings. We are trying to diagnose an intermittent problem: while one branch of a Fork is in a wait state, the other branch's child token continues through the join and continues executing subsequent process steps. | Fork | / \ | TaskProcess Step |

[jboss-user] [JBoss jBPM] - Re: Maintenance and Repair Tools

2009-08-18 Thread michaelholtzman
anonymous wrote : Are 1,2 and 3 valid for all DBMS you use? Would be great if you could confirm that. Definitely Oracle and Sybase, don't have much experience with MSSql yet. anonymous wrote : And maybe also what the default locking mechanisms are on specific database. Defaults: Oracle -

[jboss-user] [JBoss jBPM] - Re: Maintenance and Repair Tools

2009-08-17 Thread michaelholtzman
bestage: anonymous wrote : How do you re-use the jBPM component in multiple applications? Are you distributing a jar and use a central jbpm db for the tables? This is what I am planning to do in one of my projects. But I was also thinking about the possible deadlock issues. Yes, this is the

[jboss-user] [JBoss jBPM] - Re: Maintenance and Repair Tools

2009-08-17 Thread michaelholtzman
kukeltje: anonymous wrote : - Would be great if you could elaborate a little on the way creating the indexes impacted performance more than just the delete (thankfully it was not the coroner you had to call ;-)) (1) When we start up the jBPM java app, we load information about all the

[jboss-user] [JBoss jBPM] - Maintenance and Repair Tools

2009-08-14 Thread michaelholtzman
Greetings. Is anyone aware of any tools for analyzing, repairing, etc. the jBPM database? For example, - performing regular maintenance tasks like purging the database of process instances that ended over 1 year ago. - identifying and fixing a data integrity constraint error. Thanx. View

[jboss-user] [JBoss jBPM] - Re: Maintenance and Repair Tools

2009-08-14 Thread michaelholtzman
Yes, I have already written a number of these one-trick ponies to solve specific problems. We're more interested in diagnosing database issues. We are pushing jBPM very hard, running multiple processing threads within a java app as well as multiple distributed java apps. (We have a client that

[jboss-user] [JBoss jBPM] - Re: Maintenance and Repair Tools

2009-08-14 Thread michaelholtzman
Well, to make things even more fun we support three db platforms: Sybase, Oracle, and SqlServer. First off, almost all of the deadlock problems were cured after indexing the JBPM tables on all the foreign key columns. (We almost had to call the paramedics for the DBA when we told him we were

[jboss-user] [JBoss jBPM] - Performance slowdown with large JBPM_LOG table

2009-02-26 Thread michaelholtzman
Greetings. We are seeing a huge slowdown in jBPM throughput when the JBPM_LOG file gets very large. For example, during our benchmark testing we start with a virgin database. After three weeks of testing, we see a ~40% increase in workflow execution time. At this point, the JBPM_LOG table has

[jboss-user] [JBoss jBPM] - Re: Problems with GraphSession.deleteProcessInstance()

2008-11-25 Thread michaelholtzman
An HQL delete query will not resolve Foreign Key dependencies (according to Hibernate docs). Since JBPM_LOG has FK's to itself for parent logs, I don't think that an HQL query will work. :( Please tell me I'm wrong :) View the original post :

[jboss-user] [JBoss jBPM] - Problems with GraphSession.deleteProcessInstance()

2008-11-24 Thread michaelholtzman
Greetings: We need to periodically purge process instances that have ended before a certain data. There may be hundreds or thousands of instances that need to be cleaned up. The performance is very poor ... about 8 - 10 seconds PER INSTANCE. Looking at the code (jBPM 3.1.2) I notice two

[jboss-user] [JBoss jBPM] - Re: Sybase row limit

2007-06-22 Thread michaelholtzman
The source of the cannot deserialize errors has been found (not related to this issue). However, I suspect we are seeing performance issues related to the row limit being exceeded. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4057009#4057009 Reply to the

[jboss-user] [JBoss jBPM] - Enable / Disable specific log entry types ?

2007-03-22 Thread michaelholtzman
Greetings. Is it possible to control which log types are actually written to the log table? For example, can I turn off variable update log entries and keep all the other log entry types ?? Thanx. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4030818#4030818

[jboss-user] [JBoss jBPM] - Sybase row limit

2007-03-19 Thread michaelholtzman
Greetings. The default installation of Sybase 12.x has a row size limit of roughly 1700 bytes ... which is exceded by a number of JBPM tables. Has anyone developed a workaround for this problem? I am getting some random cannot deserialize ... errors, which I think are related to the row size

[jboss-user] [JBoss jBPM] - Re: Hibernate problem after upgrading to version 3.1.3

2007-02-07 Thread michaelholtzman
Same problem is ocurring in 3.1.4 This was mentioned in the release notes, but I am still seeing this problem. Here is the stack trace: | 07 Feb 2007 13:44:56:TPM Engine(ProcessCommand):(404832/T5_2_Credit Checks) Signal failed: Unknown entity: java.lang.St | ring | 07 Feb 2007

[jboss-user] [JBoss jBPM] - Recommended version of Hibernate for 3.1.4 ??

2007-01-30 Thread michaelholtzman
Hello, all. The 3.1.4 starters kit ships with hibernate 3.1 Do you recommend upgrading to hibernate 3.2 (the current verison, I believe, is 3.2.2) ? Thanx. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4008321#4008321 Reply to the post :

[jboss-user] [JBoss jBPM] - Re: Different jtds version for MSSQL and Sybase ?

2007-01-30 Thread michaelholtzman
Yes, for most databases the jdbc driver is included in the xxx/lib directory, where xxx is the database name, e.g. sybase. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4008322#4008322 Reply to the post :

[jboss-user] [JBoss jBPM] - Different jtds version for MSSQL and Sybase ?

2007-01-30 Thread michaelholtzman
Greetings. In the version 3.1.3 starters kit, MSSQL uses the jtds 1.2 jar file, and Sybase uses the jdts 1.1 jar file. Is there some problem with Sybase and the newer driver, or is this an oversight? Thanx. View the original post :

[jboss-user] [JBoss jBPM] - Re: Different jtds version for MSSQL and Sybase ?

2007-01-30 Thread michaelholtzman
Glad I could help :) I am testing Sybase with the new (V 1.2) jtds driver, and so far no problems. If anyone has experience with this, please chime in. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4008388#4008388 Reply to the post :

[jboss-user] [JBoss jBPM] - Hibernate problem after upgrading to version 3.1.3

2006-12-12 Thread michaelholtzman
Greetings. After upgrading from v3.1.2 to v3.1.3, I started getting hibernate errors in code that has worked for months. The exact exception thrown varies slightlly, but they all have this in common: First, there is Unknown entity: java.lang.String, and then shortly after error in persistence

[jboss-user] [JBoss jBPM] - Re: Problems with conditions in transactions

2006-10-11 Thread michaelholtzman
The conditional expression must be written in the jBPM Expression Language, not as a BeanShell (java) snippet as you are doing. See the documentation on decision nodes. There have been a number of examples posted in this forum. View the original post :

[jboss-user] [JBoss jBPM] - Re: how to know the state running of the process?

2006-10-06 Thread michaelholtzman
Off the top of my head | public Vector processState(ProcessInstance pin) { |Vector v = new Vector(); |Token root = pin.getRootToken(); |v.add(root.getNode().getName(); |childStates(root, v); |return v; | } | | public void childStates(Token token,

[jboss-user] [JBoss jBPM] - Re: Specifying jbpm config xml file

2006-10-03 Thread michaelholtzman
Done: http://jira.jboss.com/jira/browse/JBPM-761 View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3975719#3975719 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3975719 ___ jboss-user

[jboss-user] [JBoss jBPM] - Specifying jbpm config xml file

2006-09-29 Thread michaelholtzman
Greetings. In order to run multiple instances of our application on the same box, we typically qualify configuration files with the database and server that we are connecting to. I would like to start jBPM with database.server.jbpm.cfg.xml as the configuration file. In my main program, which

[jboss-user] [JBoss jBPM] - Running multiple JBPM engines

2006-09-05 Thread michaelholtzman
Greetings. We are running JBPM as a stand-alone Java application to handle the workflow requirements of our system. We would like to run multiple instances of the JBPM engine, and assign each process definition to run on a specific JBPM engine. We assume there will be no Hibernate caching

[jboss-user] [JBoss jBPM] - Re: Running multiple JBPM engines

2006-09-05 Thread michaelholtzman
Our bigger clients will easily exceed that 100,000 transactions per day benchmark, so we are looking at ways to increase capacity. One strategy is to partition the process definitions across multiple BPM engines. View the original post :

[jboss-user] [JBoss jBPM] - Re: Wonky IDs being generated - Any explanation?

2006-08-22 Thread michaelholtzman
The database is Sybase 12.5 The sequence numbers continue from 500x, incrementing by 1 for each new object. I did not do any special configuration for hibernate, other than the commands generated by the jbpm-db scripts. BTW, what happens when the id numbers roll over? Thx. View

[jboss-user] [JBoss jBPM] - Use Privs for Oracle

2006-08-08 Thread michaelholtzman
Greetings. For security reasons, our DBA will not allow the JBPM JDBC connection with dba privileges. From the JbpmOnOracle document, it says | drop user jbpm cascade ; | | create user jbpm identified by jbpm ; | | grant connect, resource, dba to jbpm ; | and indeed, it does

[jboss-user] [JBoss jBPM] - Re: Use Privs for Oracle

2006-08-08 Thread michaelholtzman
My thoughts exactly, except that without the dba role I get this error when launching a process instance: | 14:31:22,644 ERROR JDBCExceptionReporter : ORA-00942: table or view does not exist | | 14:31:22,659 ERROR ProcessCommand : WORKFLOW_JBPM_LAUNCH_PROCESS couldn't assign id to

[jboss-user] [JBoss jBPM] - Re: Task priority problem

2006-08-07 Thread michaelholtzman
Yes, setting it at run time does work. I am working around the problem by setting the priority that I need in the task assignment handler. However, having the priority correctly assigned when the task instance is created would be nicer. View the original post :

[jboss-user] [JBoss jBPM] - Re: Task priority problem

2006-08-01 Thread michaelholtzman
The JIRA issue for this is marked as closed, but it is STILL a problem. (http://jira.jboss.com/jira/browse/JBPM-325) The priority assigned to the task in the process definition is not propagated to the task instance. If we look at the hibernate cfg for task ... | ?xml version=1.0? | |

[jboss-user] [JBoss jBPM] - Re: Task priority problem

2006-08-01 Thread michaelholtzman
Currently using 3.1, but I hope to migrate to 3.1.2 in the next few weeks. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3962303#3962303 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3962303

[jboss-user] [JBoss jBPM] - Hibernate query to get all active instances

2006-07-21 Thread michaelholtzman
Greetings. As part of our application, I need to display all running process instances. I originally wrote some code to get all definitions (GraphSession.findAllProcessDefinitions()) and then, for each definition get the process instances (GraphSession.findProcessInstances(defnId)). It does

[jboss-user] [JBoss jBPM] - Re: Hibernate query to get all active instances

2006-07-21 Thread michaelholtzman
Thanks, that did it. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3960007#3960007 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3960007 ___ jboss-user mailing list