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/JDbpbeuJbossSap.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
