Problems with autocommit true in Jboss

[ajit_cus]

Hi Matthias,
  I had serious trouble with Jboss and SAPDB sometime back.(Jboss was messing up my 
autocommit settings by randomly setting  queries to autocommit true/false causing 
table locks to be set and not released.).I primarily wanted to use Jboss to maintain a 
connection pool.
        If you do get it working ok, please can you send me a copy of your 
sapdb-service.xml and let me know which version of the jdbc driver/Jboss you use.
Thanks and regards,
Ajit
--__--__--

Message: 2
From: "Schroeder, Alexander" <[EMAIL PROTECTED]>
To: =?iso-8859-1?Q?=27Matthias_Lak=E4mper=27?= <[EMAIL PROTECTED]>,
   [EMAIL PROTECTED]
Subject: RE: Problems with autocommit true in Jboss
Date: Thu, 6 Feb 2003 12:02:19 +0100 

Hi,

the problem is that you have catched the difference between
XML and a simple text file ...

By replacing any occurence of plain '&' with '&amp;' you will
make the parser happy, and the parser will make the JDBC driver
happy by reconverting '&amp;' into a single '&'.

BTW, normally JBoss should do the right 'commit' setting if
the transaction attributes (requires) is set in the deployment.

Regards

Alexander Schr�der
SAP Labs Berlin

> -----Original Message-----
> From: Matthias Lak�mper [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 06, 2003 11:35 AM
> To: [EMAIL PROTECTED]
> Subject: Problems with autocommit true in Jboss
> 
> 
> Hi,
> 
> I have a problem with transactions using Stateful 
> SessionBeans. The Connection
> has always autocommit = true, and in this way i�m not able to 
> work with transactions.
> The logger always shows, that autocommit is set to true.
> Is this a known problem ? 
> 
> Additionally: I think, it is not possible to set more than 
> one property in the
> jdbc-Url within sapdb-service.xml. 
> 
> If i set e.g.
> 
>    
> jdbc:sapdb://SAPDB-TEST/DBTEST?autocommit=off&trace=c:/temp/JD
> bpbeuJbossSap.pct
> 
> i receive a parsing error.
> 
> any help would be appreciated.
> Regards. Matthias Lakaemper
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general