Hi, It looks like the transaction is not committed, I don't know what could be the reason. A simple way to debug the problem is to enable the trace option in H2. Usually I use jdbc:h2:~/test;TRACE_LEVEL_FILE=3 - and then inspect the file test.trace.db. You should see all JDBC method calls executed. See also
http://www.h2database.com/html/features.html#trace_options Regards, Thomas On Sat, Dec 6, 2008 at 7:19 PM, Dhruv Patel <[EMAIL PROTECTED]> wrote: > > Hi Thomas, > > i am ablt rectify problem > there is facility of providing external ConnectionProvider > > so now i am using my custom COnnectionProvider for quartz and it it > working fine. > > but FYI i am surprised they are using BasicDataSource of DBCP > > and H2 is not working as expected with it. > > i would like to say CHEERS :) :) and Keep it up to H2 Team. > > H2 is very handy and very professional open source DB i have ever > seen. > > > > > > > > > > On Dec 5, 10:58 pm, Dhruv Patel <[EMAIL PROTECTED]> wrote: >> does any body face problems using Quartz with H2 in embedded mode. >> >> Problem : >> -------------------------------------- >> >> Quartz stores jobs and triggers in database >> >> if application is shutdown unexpectedly jobs and triggers are not >> visible in H2 DB. >> >> it stores only when Schedulet.shutdown() is called >> >> i have debug with checkpoint and found that >> >> even though in H2 JdbcConnection.commit is getting executed for adding >> each job and triggers >> >> but entries are not visible when we open db using H2 web console or >> application query >> >> Quartz uses DBCP for DataSource pooling. >> >> when i saw code of Scheduler.shutdown() code >> >> it does closing on BasicDataSource of DBCP from poolin. >> >> Thomas please help me rectifying such problem. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
