//discussion on multiple resource XA Transaction and single-resource nonXA DataSource at
http://www.theserverside.com/discussions/thread.tss?thread_id=21385
//this documentation from the Spring Documentation explains how to configure DataSource
http://static.springframework.org/spring/docs/2.5.x/api/org/springframework/scheduling/quartz/SchedulerFactoryBean.html
//Sets the DataSource to be used by the Scheduler
//for non-transactional access.(scheduler/cron jobs)
public void setNonTransactionalDataSource(DataSource nonTransactionalDataSource)
XA Data Source:
This is only necessary if the default DataSource is an XA DataSource that will
always participate in transactions (global/multiple resources coordinated by TransactionMgr)
Non-XA DataSource:
A non-XA version of that DataSource should
be specified as "nonTransactionalDataSource" in such a scenario(single Resource Servlet/Bean)
Excluding local DataSource:
This is not relevant with a local DataSource instance and Spring transactions.
Specifying a single default DataSource as "dataSource" is sufficient there.
public void setDataSource(DataSource dataSource)
See Also:setDataSource(javax.sql.DataSource),
LocalDataSourceJobStore
FWIW
Martin
______________________________________________
Disclaimer and confidentiality note
This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to please inform the sender. Any unauthorised dissemination or copying hereof is prohibited. This message serves for information purposes only and shall not have any legally binding effect. Given that e-mails can easily be subject to manipulation, we can not accept any liability for the content provided.
> Date: Fri, 27 Mar 2009 12:48:12 -0700
> From: glassfish_at_javadesktop.org
> To: users_at_glassfish.dev.java.net
> Subject: Re: Server is hanging when multiple users logged in.
>
> I'm confused... Do both pools point to the same database (you didn't add those details to the output)? Do you use them both in the same app or do you switch between the 2 for your testing?
>
> What is the purpose of setting non-transactional access to true on the XA pool? Can it be the cause of the problem?
>
> thanks,
> -marina
> [Message sent by forum member 'mvatkina' (mvatkina)]
>
> http://forums.java.net/jive/thread.jspa?messageID=339392
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
_________________________________________________________________
Internet Explorer 8 – Get your Hotmail Accelerated. Download free!
http://clk.atdmt.com/MRT/go/141323790/direct/01/