Hi Andreas, sometimes the version of a software is an interesting information ;-)
Seams you are using something like 0.9.5.x. Having said that a lot of things have changed since that time. Only to show some of the new features: - At 0.9.6 we introduced commons-logging which replaced castors internal logging. - At 0.9.9 we added a debugging SQL proxy. If it is an option for you i would suggest you to switch to a newer release of castor e.g. 0.9.9.1 that's been released some days ago. I can not remember exactly how the logging at 0.9.5 worked but you may need to provide a log interceptor that have to be set on the JDO instance. Maybe you can find some hints in the documentation (e.g. FAQ) of this release which can still be downloaded from: http://dist.codehaus.org/castor/ Regards Ralf Andreas Rutvik schrieb: > Actually I am using an old version of Castor which was distributed > 17/1-2003. This distribution doesn't have this > > org.exolab.castor.persist.useProxy=true > > Anyway, in the castor.properties file there is a property called > > org.exolab.castor.debug, which I have set to true, but I can't see any > castor logging anyway ? > > Regards > /Andreas > > >> From: Ralf Joachim <[EMAIL PROTECTED]> >> Reply-To: [email protected] >> To: [email protected] >> Subject: Re: [castor-user] Problem seeing what SQL is executed. >> Date: Wed, 16 Nov 2005 18:27:56 +0100 >> >> Hi Andreas, >> >> have a look at: >> >> http://castor.codehaus.org/how-to-connection-proxies.html >> >> Regards >> Ralf >> >> >> Andreas Rutvik schrieb: >> > Hi all, >> > >> > since I am a newbie on Castor, as detailed help as possible would be >> > appreciated. >> > >> > I have migrated from Sybase to MySQL, and getting problems when trying >> > to create an Object in the persistent storage. >> > >> > My code looks like this : >> > >> > // use the Castor database connection to persist >> > org.exolab.castor.jdo.Database db = getDBConnection ( ); >> > db.create ( obj ); // THIS CALL GIVES ME THE EXCEPTION >> > >> > and I just get the following exception : >> > cannot create object of type workflow.core.WorkflowStatus Nested error: >> > java.sql.SQLException: Syntax error or access violation message from >> > server: "You have an error in your SQL syntax; check the manual that >> > corresponds to your MySQL server version for the right syntax to use >> > near '"status_workflow" >> > ("msg_id","domain","tmstamp","uuid","event","status","class_na' at >> line 1" >> > >> > But this is not much to help since I can't view the whole SQL to be >> > executed. Is there any easy way to view the actual SQL being executed ? >> > >> > Regards >> > /Andreas >> > >> > _________________________________________________________________ >> > Hitta rätt på nätet med MSN Search http://search.msn.se/ >> > >> > >> > ------------------------------------------------- >> > If you wish to unsubscribe from this list, please send an empty message >> > to the following address: >> > >> > [EMAIL PROTECTED] >> > ------------------------------------------------- >> >> -- >> >> Syscon Ingenieurbüro für >> Meß- und Datentechnik GmbH >> Ralf Joachim >> Raiffeisenstraße 11 >> D-72127 Kusterdingen >> Germany >> >> Tel. +49 7071 3690 52 >> Mobil: +49 173 9630135 >> Fax +49 7071 3690 98 >> >> Email: [EMAIL PROTECTED] >> Web: www.syscon-world.de >> >> ------------------------------------------------- >> If you wish to unsubscribe from this list, please >> send an empty message to the following address: >> >> [EMAIL PROTECTED] >> ------------------------------------------------- >> > > _________________________________________________________________ > Chatt: Träffa nya nätkompisar på Habbo Hotel > http://habbohotel.msn.se/habbo/sv/channelizer > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please send an empty message > to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- -- Syscon Ingenieurbüro für Meß- und Datentechnik GmbH Ralf Joachim Raiffeisenstraße 11 D-72127 Kusterdingen Germany Tel. +49 7071 3690 52 Mobil: +49 173 9630135 Fax +49 7071 3690 98 Email: [EMAIL PROTECTED] Web: www.syscon-world.de ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
