Re: [SCXML] Inject external event with XML payload () into SCXML engine

2007-07-09 Thread Ingmar Kliche
(Move this thread to the user list) Rahul, you wrote: You can define expression language functions to do more specialized things. That sounds interesting. Do you have an advice where to find examples on how to define EL functions and how to use them in an SCXML document? Thanks, Ingmar. 2

Re: [SCXML] Inject external event with XML payload () into SCXML engine

2007-07-09 Thread Rahul Akolkar
On 7/9/07, Ingmar Kliche <[EMAIL PROTECTED]> wrote: (Move this thread to the user list) Thanks! Rahul, you wrote: > You can define expression language functions to do more specialized things. That sounds interesting. Do you have an advice where to find examples on how to define EL funct

[jelly] How to make a large Jelly-SQL script more memory efficient?

2007-07-09 Thread Karr, David
I have a large Jelly-SQL script (about 3.8 mb) that just does SQL calls to insert rows into a database. Each row it inserts is pretty small, but it inserts a lot of rows (relatively). It currently inserts about 18000 rows. What I'm finding is that the script won't even run on Windows (2 gig proc

Re: [jelly] How to make a large Jelly-SQL script more memory efficient?

2007-07-09 Thread Paul Libbrecht
David, I do not see any other way than programmatically separating the "lines" of the SQL query. Is this doable ? Like, if it's a backup, it probably has a chance that each query is a line, or ? If yes, then it should be pretty easy to use a LineNumberReader and feed each line as an SQL q

RE: [jelly] How to make a large Jelly-SQL script more memory efficient?

2007-07-09 Thread Karr, David
Each insert is a separate "call" to a separate "insert" tag that I defined in my dbutils. Each insert is in a separate transaction. So, for instance, here's my "insert" tag: FAILED INSERT. I essentia

Re: [jelly] How to make a large Jelly-SQL script more memory efficient?

2007-07-09 Thread Paul Libbrecht
Oh, sorry, hadn't grasped, but then I doubt jelly can do anything... am I wrong or it is normal for an SQL driver to keep an amount based in memory as long as the transaction is not committed ? Do you see something jelly code that stores something ? Or would it be something with tag-caching

RE: [jelly] How to make a large Jelly-SQL script more memory efficient?

2007-07-09 Thread Karr, David
I'm saying that every sql insert is in an individual transaction. After an insert is completed, the transaction commits, and then the next transaction starts and the next insert is performed and committed. You'll see that the "sql:transaction" element wraps the "sql:update" call. I'm only usi

Re: dbcp HSQL issue

2007-07-09 Thread Vernon
On Sun, 2007-07-08 at 21:53 -0700, Phil Steitz wrote: > Looks like you have the pool configured to validate objects when they > are borrowed (testOnBorrow = true) and the validation is failing. > This appears to be configured in the setupConnectionPool method here: > http://jamwiki.svn.sourceforge.

Re: dbcp HSQL issue

2007-07-09 Thread Phil Steitz
Vernon, I am travelling now so can't double check, but if I recall correctly what I saw in the stack traces, it looked like the client (tomcat, I assume) was successfully connecting to the database, but the validation query was failing, so unless there are database user-level problems, most like