that's exactly what i'm doing,but it's giving me the
exception i posted earlier, I get the sqlmapclient
starttransaction commit and end
my transactionamanager config is
<transactionManager commitRequired="true" type="JDBC">
<property name="DefaultAutoCommit" value="false"/>
<property name="SetAutoCommitAllowed"
value="false"/>
<dataSource type="JNDI">
<property name="DataSource"
value="jdbc/myDatasource"/>
</dataSource>
</transactionManager>
--- Jeff Butler <[EMAIL PROTECTED]> wrote:
> I think it might help to see some of your code...are
> you using DAO or not?
> I wasn't sure from your previous posts.
> SqlMapClient calls should look like
> this:
>
> try {
> sqlMap.startTransaction();
> sqlMap.insert(...);
> sqlMap.update(...);
> sqlMap.commitTransaction();
> } finally {
> sqlMap.endTransaction();
> }
>
> Also, please see this page for information about
> configuring iBATIS on
> WebSphere:
>
>
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Environment+Specific+Information
>
> Jeff Butler
>
>
>
> On 7/18/06, Bing Lu <[EMAIL PROTECTED]> wrote:
> >
> > btw, the application server is websphere 5.1 and
> I've
> > specified the jndi datasource and have a
> > transactionmanger="jdbc", can anyone tell me what
> i'm
> > doing wrong?
> >
> > thanks
> > --- Bing Lu <[EMAIL PROTECTED]> wrote:
> >
> > > I'm trying the sqlmapclient.starttransaction,
> > > committrasaction for now. but it's giving me the
> > > following exception can anyone tell me what i
> might
> > > be
> > > doing wrong? And I did call
> > > sqlmapclient.starttransaction
> > >
> > > thanks
> > >
> > >
> com.ibatis.common.jdbc.exception.NestedSQLException:
> > > Could not commit transaction. Cause:
> > >
> >
>
com.ibatis.sqlmap.engine.transaction.TransactionException:
> > > TransactionManager could not commit. No
> transaction
> > > is started.
> > > Caused by:
> > >
> >
>
com.ibatis.sqlmap.engine.transaction.TransactionException:
> > > TransactionManager could not commit. No
> transaction
> > > is started.
> > > [7/18/06 10:57:18:969 EDT] 63967dea SystemErr
> R
> > > at
> > >
> >
>
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.commitTransaction(
> > SqlMapExecutorDelegate.java:761)
> > > [7/18/06 10:57:18:969 EDT] 63967dea SystemErr
> R
> > > at
> > >
> >
>
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.commitTransaction(
> > SqlMapSessionImpl.java:133)
> > > [7/18/06 10:57:18:969 EDT] 63967dea SystemErr
> R
> > > at
> > >
> >
>
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.commitTransaction(
> > SqlMapClientImpl.java:110)
> > >
> > > --- "Mkhitaryan, Aram"
> > > <[EMAIL PROTECTED]> wrote:
> > >
> > > > Hi,
> > > >
> > > > Try this:
> > > >
> > > > try {
> > > > daoManager.startTransaction();
> > > > ....
> > > > //Delete
> > > > //Insert
> > > > ...
> > > > daoManager.endTransaction();
> > > > } finally {
> > > > daoManager.endTransaction();
> > > > }
> > > >
> > > > Best,
> > > > Aram
> > > >
> > > > -----Original Message-----
> > > > From: Bing Lu [mailto:[EMAIL PROTECTED]
> > > > Sent: Tuesday, July 18, 2006 1:24 AM
> > > > To: [email protected]
> > > > Subject: transaction help please
> > > >
> > > > Hi, how do I do a delete&insert operation in
> one
> > > > transaction in ibatis? do I need to specify
> > > anything
> > > > in the transactionManager for this?
> > > >
> > > > thanks
> > > >
> > > >
> __________________________________________________
> > > > Do You Yahoo!?
> > > > Tired of spam? Yahoo! Mail has the best spam
> > > > protection around
> > > > http://mail.yahoo.com
> > > >
> > >
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam? Yahoo! Mail has the best spam
> > > protection around
> > > http://mail.yahoo.com
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
