Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: newbie question on db-history
You might be able to capture the info. you need by setting the
SQL_TRACE at the database level. Change SQL_TRACE to true in the
init.ora during the period you want to do the trace and set it back to
false immediately after.
heyvaert <pol.heyvaert_at_acunia.com> wrote in message news:<3DB7AA02.1030102_at_acunia.com>...
> heyvaert wrote:
>
> > When I try to deploy some CMP-beans on an Oracle9i database, the tables
> > are created by the ApplicationServer.
>
> (The ApplicationServer used is jboss).
>
> >
> > However, I allways get a "java.sql.SQLException: ORA-00904: invalid
> > column name"-error.
> > To know where the problem is, I want to see how the tables are created
> > (what sql-statements are being sent to the database).
> >
> > Where can I find logs or history of the statements, and which settings
> > must be set to log the statements ?
> >
> > Thanks
> >
> > Pol
> >
Received on Thu Oct 24 2002 - 13:11:06 CDT