Re: opening multiple databases from same program

SimpleOrm does indeed take care to protect you from threading issues, and therefor tests session/thread associations carefully.

However, there is a method

  detachFromThread()

which can be used to shuffle sessions -- see LongTransactionTest. 

However, I would generally prefer Abel's solution if the data involved is not huge.

If it is, then there is a place for raw JDBC.  Or maybe an ETL tool if you have a lot to do.

Anthony

At 01:11 AM 10/07/2010, you wrote:
>  
>
>Hi
>
>I'm opening multiple different databases from the same thread, which is triggering this check:
>
> simpleorm.utils.SException$Error: Thread's SSession already open [SS 1.SkyMon]
>[<mailto:0@17:08:40.976>0@17:08:40.976] !SE>:     at simpleorm.sessionjdbc.SSessionJdbc.innerOpen(SSessionJdbc.java:129)
>[<mailto:0@17:08:40.976>0@17:08:40.976] !SE>:     at simpleorm.sessionjdbc.SSessionJdbc.open(SSessionJdbc.java:88)
>[<mailto:0@17:08:40.976>0@17:08:40.976] !SE>:     at simpleorm.sessionjdbc.SSessionJdbc.open(SSessionJdbc.java:108)
>
>
>What do I do?
>
>Thanks, Noel Grandin
>
>
>
>
>
>----------
>Disclaimer: <http://www.peralex.com/disclaimer.html>http://www.peralex.com/disclaimer.html
>
>

Dr Anthony Berglas, [email protected]       Mobile: +61 4 4838 8874
Just because it is possible to push twigs along the ground with ones nose
does not necessarily mean that is the best way to collect firewood.


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/SimpleORM/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/SimpleORM/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/