Hi, the problem is that you have catched the difference between XML and a simple text file ...
By replacing any occurence of plain '&' with '&' you will make the parser happy, and the parser will make the JDBC driver happy by reconverting '&' 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 > > Settings in my Project: > ----------------------- > > ----------Url in > sapdb-service.xml:------------------------------------ > > <config-property name="ConnectionURL" type="java.lang.String">\ > jdbc:sapdb://SAPDB-TEST/DBTEST?autocommit=off</config-property> > ----------Url in > sapdb-service.xml:------------------------------------ > > > The stateful Message-Bean has the following settings with xdoclet: > ----------Code-Snippet---------------------------------------- > ---------------------- > * @ejb:bean name="myPackage/MainSession" > * display-name="Display MainSession Bean" > * type="Stateful" > * jndi-name="ejb/myPackage/MainSession" > * > * @ejb:security-role-ref role-name="EchoCaller" > * role-link="Echo" > * > * @ejb:env-entry name="DataSourceName" > * value="java:/SapdbDS" > * > * @ejb:permission role-name="EchoCaller" > * > * @ejb:transaction type="Required" > * > > ----------Code-Snippet---------------------------------------- > ---------------------- > > In ejbCreate i do a Connection to the Database > > ----------Code-Snippet---------------------------------------- > ---------------------- > private Connection getConnection() { > try { > DataSource lDataSource = getDataSource(); > Connection lConnection = lDataSource.getConnection(); > log.info("_______________________Status autocommit: " + > lConnection.getAutoCommit() ) ; > return lConnection; > } catch ( SQLException ne1 ) { > throw new EJBException( "SqlExc: " + ne1.getMessage() ); > } > } > ----------Code-Snippet---------------------------------------- > ---------------------- > > > ______________________________________________________________ > ________________ > Wie waere das: mehrere E-Mail Adressen - aber nur ein Postfach ? > Kein Problem mit WEB.DE FreeMail - http://freemail.web.de/features/?mc=021127 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
