Re: opening multiple databases from same program

It is actually possible to dissassociate sessions from threads, and thus have several.  But that is a very odd thing to want to do.  What are you trying to achieve?

(Ususally trying to open a session on a thread that already has an open session means that you did not close the previous session, leading to a connection leak, which is why SimpleOrm fails fast.)

Anthony

At 02:02 AM 10/07/2010, you wrote:
>  
>
>Hi,
>
>well, AFAIK, you can't do that... !
>
>SSessionJdbc has built-in checks that a connection is single threaded
>using a ThreadLocal object. [I think Hibernate has some kind of best
>practice to achieve the same goal (I'm not formal here, I didn't use
>hibernate for years)]
>
>There is only one dataSource per SSessionJdbc and one SSessionJdbc per
>thread.
>
>You could implement a different strategy to handle this part. Some work
>was done along this path in a previous version of Simpleorm, for using a
>single JTA transaction per session. But it is not maintained.
>See simpleorm/extras/SConnectionEJB.java
>
>My question would be : what are you trying to achieve ?
>
>Franck
>
>Le vendredi 09 juillet 2010 à 17:11 +0200, Noel Grandin a écrit :
>> 
>> 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]
>> [0@17:08:40.976] !SE>: at
>> simpleorm.sessionjdbc.SSessionJdbc.innerOpen(SSessionJdbc.java:129)
>> [0@17:08:40.976] !SE>: at
>> simpleorm.sessionjdbc.SSessionJdbc.open(SSessionJdbc.java:88)
>> [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
>> 
>> 
>> 
>> 
>> 
>
>


Spreadsheet Detective,
Southern Cross Software Queensland Pty Limited
54 Gerler Street
Bardon, Queensland 4065, Australia.

Email: [email protected]
www.SpreadsheetDetective.com
Ph: +61 427 830248 (Australian Eastern Standard Time)

"If the model seems correct only because the numbers look right, 
then why build the model in the first place?"



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

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/