use the EXTERNAL transaction manager and pass in your own connection. cheers, Clinton
On Tue, Jan 20, 2009 at 4:57 PM, Xiangrong Fang <xrf...@gmail.com> wrote: > Hi There, > > How can I use iBatis without starting an transaction? I try to do: > > PRAGMA synchronous=OFF > > for SQLite database, but iBatis report an SQLExeption that this cannot > be done within an transaction. > > Then I used: > > Connection conn = SqlMapClient.getDataSource.connection; > Statement st = conn.createStatement; > st.execute("PRAGMA synchronous=OFF"); > > But this does not work either. > > Please help. Thank you very much! > > Shannon >