Thanks very much. It worked like a charm. This configuration wasn't apparent to me from reading the documentation. Thanks for making it clear.
--- Christian Haul <[EMAIL PROTECTED]> wrote: > On 24.Oct.2002 -- 09:38 PM, Samuel Bruce wrote: > > Hello, > > > > I'm using the latest CVS, TC 4.1.12, JDK 1.4.01. > > > > The mod-db action inserts the first row correctly, > but > > fails on the second row insert. It seems to also > fail > > attempting to rollback. > > > > Anything you can do to help is appreciated. > > > Thread-10/DatabaseAction: Rolling back > transaction. > > Caused by Syntax error or access violation: You > have > > an error in your SQL syntax near 'CALL IDENTITY()' > at > > line 1 > > DEBUG (2002-10-24) 23:56.37:520 > > [sitemap.action.mod-db-add] () > > Thread-10/DatabaseAction: There was an error > rolling > > back the transaction > > java.sql.SQLException: General error: Warning: > Some > > non-transactional changed tables couldn't be > rolled > > back > > at > > > > org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) > > at > > So, you are trying to use the autoincrement module > for HSQLDB with > MySQL. That just won't work. Please use the MySQL > one. For this, you > need to edit the cocoon.xconf and uncomment the > correct module and > comment out the hsqldb one. mod-db uses the one with > shorthand "auto" > unless instructed otherwise. > > Chris. > -- > C h r i s t i a n H a u l > [EMAIL PROTECTED] > fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 > 6856 335A 9E08 > > > --------------------------------------------------------------------- > Please check that your question has not already > been answered in the > FAQ before posting. > <http://xml.apache.org/cocoon/faq/index.html> > > To unsubscribe, e-mail: > <[EMAIL PROTECTED]> > For additional commands, e-mail: > <[EMAIL PROTECTED]> > __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
