Doing this exactly as you described.
-----Original Message-----
From: Alex Paransky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 2:03 PM
To: Mishkin, Ernest; [EMAIL PROTECTED]
Subject: RE: JBoss - HeuristicRollbackException
How are you getting your connection to the Database? Are you using
container provided facilities by J2EE?
InitialContext context = new InitialContext();
DataSource dataSource = (DataSource) context.lookup(dataSourceName);
Connection connection = dataSource.getConnection();
-AP_
-----Original Message-----
From: A mailing list for Enterprise JavaBeans development
[mailto:[EMAIL PROTECTED]]On Behalf Of Mishkin, Ernest
Sent: Thursday, August 02, 2001 10:45 AM
To: [EMAIL PROTECTED]
Subject: JBoss - HeuristicRollbackException
** Tried to post this to JBOSS-USER forum but didn't get any feedback... **
Hello folks,
Kind of new to the EJBs in general and JBoss in particular, so please bear
with me if the question is dumb.
I have a simple stateless session bean with one business method that
executes a query (SELECT) agains Oracle 7.3 database. ejb-jar.xml sets
transaction to container-managed but does not explicitly define transaction
type (which defaults to "Required", doesn't it ?). I also have a connection
pool with 1 min. and 10 max. connections.
Now the problem: if I invoke the bean for the fisrt time, works fine. If I
then make next invocation after a long period of time, I'm getting
HeuristicRollbackException. Subsequent call works again. I realize something
is happening with JDBC Connection but can't figure out what exactly and why.
I know that oracle session itself doesn't get killed.
Any advices will be appreciated !
Regards,
Ernest
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
