From: "Werner Guttmann" <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: <[email protected]>
Subject: RE: [castor-user] Problem seeing what SQL is executed.
Date: Fri, 18 Nov 2005 13:58:39 +0100
Andreas,
What does your JDO config file look like (again) ?
Werner
> -----Original Message-----
> From: Andreas Rutvik [mailto:[EMAIL PROTECTED]
> Sent: Freitag, 18. November 2005 13:56
> To: [email protected]
> Subject: Re: [castor-user] Problem seeing what SQL is executed.
>
> Hi Ralf,
>
> thank you very much for your suggestion. Actually I used
> another method to solve this. I used a 3:rd hand library
> called P6SPY that wraps the database connection and logs all
> SQL executed on the database. The SQL actually causing the
> problem is the following :
>
> INSERT INTO "status_workflow"
> ("msg_id","domain","tmstamp","uuid","event","status","class_na
> me","status_msg","userID")
> VALUES ('4028fb85079f151e01079f15255f0004','SWIFT','2005-11-17
> 17:36:02.093','4028fb85079f151e01079f1525ad0005','N/A','PENDIN
> G_IFAST_ORDER_SENT','com.ffusion.msgbroker.generated.MessageBr
> oker.mdf.iFASTOrderInput.TypeXML_API','',SERVER')
>
> and the problem is that the tablename and the column names
> are surrounded by quotes. This caused no problems when using
> Sybase. If I omit quotes, and run the SQL directly from
> command line everything is ok.
>
> So the next question to which I haven't found any solution
> yet, is how to omit the quotes ? The last call I can control is :
>
> db.create ( obj );
>
> and after that the failing SQL is generated and executed.
>
> Best regards and thanks for your help
> /Andreas
>
>
> >From: Ralf Joachim <[EMAIL PROTECTED]>
> >Reply-To: [email protected]
> >To: [email protected]
> >Subject: Re: [castor-user] Problem seeing what SQL is executed.
> >Date: Thu, 17 Nov 2005 14:36:31 +0100
> >
> >Hi Andreas,
> >
> >your old version of castor logs the sql statements only when the
> >prepared statements gets created and this happens when the
> database.xml
> >together with the mapping.xml is loaded. Therefore the logging you
> >enabled for the Database instance do not help you as you have
> >recognized. You have to enable logging on the JDO instance
> before your
> >configuration gets loaded. To give you an idea how this should look
> >like, I'll provide you with some lines of code from an old project.
> >
> >-------------------------------
> >
> > private static Logger _log =
> > Logger.getLogger(JDOConfiguration.class);
> >
> >-------------------------------
> >
> > _jdo = new JDO();
> > _jdo.setLogWriter(getLogWriter("castor", Priority.DEBUG));
> > _jdo.setConfiguration(configuration );
> > _jdo.setDatabaseName(name);
> >
> >-------------------------------
> >
> > public org.exolab.castor.util.Logger getLogWriter(
> > String prefix, Priority priority) {
> > JDOLogWriter writer = new JDOLogWriter(_log, priority);
> >
> > org.exolab.castor.util.Logger logger = null;
> > logger = new org.exolab.castor.util.Logger(writer);
> > logger.setPrefix(prefix);
> >
> > return logger;
> > }
> >
> >-------------------------------
> >
> > private class JDOLogWriter extends StringWriter {
> >
> > private Logger _logger;
> > private Priority _priority;
> >
> > public JDOLogWriter(Logger logger, Priority priority) {
> > super();
> >
> > _logger = logger;
> > _priority = priority;
> > }
> >
> > /**
> > * Flush the stream.
> > */
> > public void flush() {
> > super.flush();
> >
> > // Pass the buffer on to log4j
> > _logger.log(_priority, super.toString());
> >
> > // Empty the buffer.
> > super.getBuffer().setLength(0);
> > }
> > }
> >
> >-------------------------------
> >
> >Another option to log the SQL statements may be to check if
> poolman or
> >mysql offers such an option.
> >
> >Out of your stacktrace i have no idea what's going wrong. The only
> >thing i can guess is that there may be something wrong with
> the mapping
> >of the class you want to db.create() an instance of.
> >
> >Regards
> >Ralf
> >
> >
> >Andreas Rutvik schrieb:
> > > Hi Ralf,
> > >
> > > thank you for your suggestion concerning logging. I used an
> > > interceptor that I set on the JDO instance like this :
> > >
> > > org.apache.log4j.Category cat = Category.getInstance (
> this.getClass
> > > ( ).getName ( ) );
> > > Log4jStringWriter out = new Log4jStringWriter( cat,
> > > Priority.DEBUG );
> > > org.exolab.castor.persist.OutputLogInterceptor
> sqlInterceptor = new
> > > OutputLogInterceptor( out );
> > >
> > > db.setLogInterceptor ( sqlInterceptor );
> > >
> > > But I'm not so helped by this, in means of being able to
> see the SQL
> > > executed. This is the stack trace I get :
> > >
> > > workflow.core.WorkflowStatus
> > >
> (<4028fb85079df30301079df30de20004(1406095458),SWIFT(79300001),Thu
> > > Nov
> > > 17 12:19:10 CET 2005(-1645015225)>)
> > > [17/11/05 12:19:10][WFlowP0 ][DEBUG]
> > > com.util.GenesysTransaction - CASTOR - Castor: Creating
> > > workflow.core.WorkflowStatus
> > >
> (<4028fb85079df30301079df30de20004(1406095458),SWIFT(79300001),Thu
> > > Nov
> > > 17 12:19:10 CET 2005(-1645015225)>)
> > > [17/11/05 12:19:10][WFlowP0 ][DEBUG]
> > > com.util.GenesysTransaction - CASTOR - Castor: Creating
> > > workflow.core.WorkflowStatus
> > >
> (<4028fb85079df30301079df30de20004(1406095458),SWIFT(79300001),Thu
> > > Nov
> > > 17 12:19:10 CET 2005(-1645015225)>)
> > > [17/11/05 12:19:10][WFlowP0 ][ERROR]
> > > com.util.GenesysTransaction - 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"
> > > 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"
> > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
> > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
> > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
> > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2281)
> > > at
> > >
> >com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatem
> ent.java:1
> >825)
> > > at
> > >
> >com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatem
> ent.java:1
> >667)
> > > at
> > >
> >com.codestudio.sql.PoolManPreparedStatement.executeUpdate(Poo
> lManPrepar
> >edStatement.java:123)
> > >
> > > at
> org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:616)
> > > at
> >org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:895)
> > > at
> org.exolab.castor.persist.LockEngine.create(LockEngine.java:458)
> > > at
> > >
> >org.exolab.castor.persist.TransactionContext.create(Transacti
> onContext.
> >java:833)
> > >
> > > at
> > >
> org.exolab.castor.jdo.engine.DatabaseImpl.create(DatabaseImpl.java:3
> > > 45)
> > >
> > >
> > > Any ideas of what this can be, since I can't see the SQL
> executed ?
> > >
> > > Best 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: Thu, 17 Nov 2005 11:20:40 +0100
> > >>
> > >> 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]
> > >> -------------------------------------------------
> > >>
> > >
> > > _________________________________________________________________
> > > Lättare att hitta drömresan med MSN Resor http://www.msn.se/resor/
> > >
> > >
> > > -------------------------------------------------
> > > 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]
> >-------------------------------------------------
> >
>
> _________________________________________________________________
> Nyhet! Hotmail direkt i din Mobil! http://mobile.msn.com/
>
>
> -------------------------------------------------
> If you wish to unsubscribe from this list, please send an
> empty message to the following address:
>
> [EMAIL PROTECTED]
> -------------------------------------------------
>
>
>
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
