Re: Help with understanding transaction behavior with multiple threads

2006-06-09 Thread Clinton Begin
Fortunately the answer is simple, unfortunately you're probably not going to like it. :-)NEVER cross thread boundaries within (what you expect to be) a single transaction.  Never.  Cheers,Clinton On 6/5/06, Eric T. Blue <[EMAIL PROTECTED]> wrote: Hi,I want to find out the easiest possible way to st

Re: Help with understanding transaction behavior with multiple threads

2006-06-09 Thread Brandon Goodin
Maybe if you provided us with more context around your thread creation and how it dovetails in with ibatis. To be honest we can't offer you advice on something we know nothing about. Brandon On 6/9/06, Eric T. Blue <[EMAIL PROTECTED]> wrote: No takers on this one? On 6/5/06, Eric T. Blue <[E

Re: Help with understanding transaction behavior with multiple threads

2006-06-09 Thread Eric T. Blue
No takers on this one?On 6/5/06, Eric T. Blue <[EMAIL PROTECTED]> wrote: Hi,I want to find out the easiest possible way to start a transaction, create a thread that performs DAO inserts, and still have the newly created thread honor the start and end transaction from the launching application. I'm

Re: Problem SQL Maps with Oracle DbLink

2006-06-09 Thread Marco Rossi
Diran,thanks for your replay.I tried with another Oracle Db version, and the code works. Probably it's an Oracle problem.MarcoOn 6/9/06, Diran Ayandele <[EMAIL PROTECTED]> wrote: Marco, this isn't really an iBatis question.  You'd be better offposting it in an oracle forum.  Anyway, we select over

Re: problem with selectKey and parameter map

2006-06-09 Thread Jeff Butler
One solution that's guaranteed to work - get rid of the parameterMap.  You don't need to use parameterMaps unless you are calling stored procedures.   If you really want to use parameterMaps, then you need to change the syntax of your insert statement...it should be like this:     

problem with selectKey and parameter map

2006-06-09 Thread Steven Pannell
Hi, I am unable to get the option working with a parameter map. say I have this: select mytable_seq.nextval from dual insert into table(id, name) (#id#, #name#) Running this I get an error because the insert reads the ID

Re: Problem SQL Maps with Oracle DbLink

2006-06-09 Thread Diran Ayandele
Marco, this isn't really an iBatis question. You'd be better off posting it in an oracle forum. Anyway, we select over dblinks using iBatis without problems. 1. Make a synonym in the schema you're using, just for clarity. 2. The actual error you're getting is for an unrecognized date format w

Problem SQL Maps with Oracle DbLink

2006-06-09 Thread Marco Rossi
Hi, I have a problem to map a select with a Oracle  dblink. When a try to execute my code I catch an unpredictable exception (ORA-01821), but if I create a materialized view all works fine.What's wrong? Thanks in advance, Marco