Re: JDBC thin driver truncates "FOR UPDATE"??

Thomas Kyte was amazingly quick at answering my question, once it had gotten to the right newsgroup. If you're interested, see our mail conversation below. I think I'll stick to this group, it seems mighty interesting ;-)

See ya,
/Anders
(and, yes, it was me messing things up. I should've hardcoded the thing... ;^)

~ From: Anders Olsson [mailto:epkanol_at_s1.epk.ericsson.se]
~ Sent: Thursday, October 28, 1999 11:20 AM
~ To: tkyte_at_us.oracle.com
~ Subject: RE: JDBC thin driver truncates "FOR UPDATE"??
~
~
~ Hi Thomas,
~
~ Thanks for helping me with the trace stuff. I had struggled with this
~ for days, and now when I saw the actual SQL being sent, I also
~ noticed that
~ it indeed was me sending the wrong (non-for-update-select) statement.
~ I just didn't realize that. (the danger of being too parameter-driven...)
~

great -- can you followup on the newsgroups so others don't think it is broken in some way?

~ 1000 thanks again & best wishes,
~ /Anders
~
~ > From: "Thomas Kyte" <tkyte_at_us.oracle.com>
~ > To: "Anders Olsson" <epkanol_at_s1.epk.ericsson.se>
~ > Subject: RE: JDBC thin driver truncates "FOR UPDATE"??
~ > Date: Thu, 28 Oct 1999 10:31:17 -0400
~ >
~ > enable SQL_TRACE and see what is really being submitted to the database.
~ >
~ > Statement stmt = connection.createStatement ();
~ > stmt.execute( "alter session set sql_trace=true" );
~ >
~ > after your program runs, a trace file will be created on the
~ database server
~ > machine in the directory specified by the USER_DUMP_DESTINATION init.ora
~ > parameter (typically $ORACLE_HOME/admin/$ORACLE_SID/udump).
~ use the tkprof
~ > command line tool to convert this trace file into something
~ readable. all
~ > sql you submitted will be in there -- see if the for update is getting
~ > chomped or not.
~ >
~ >
~ > --
~ > Thanks,
~ >
~ > Thomas Kyte tkyte_at_us.oracle.com
~ > Oracle Service Industries 703.364.2519
~ >
~ > Oracle tips and papers http://osi.oracle.com/~tkyte/
~ >
~ >
~ >
~ > > -----Original Message-----
~ > > From: Anders Olsson [mailto:epkanol_at_s1.epk.ericsson.se]
~ > > Sent: Thursday, October 28, 1999 10:23 AM
~ > > To: tkyte_at_us.oracle.com
~ > > Subject: Re: JDBC thin driver truncates "FOR UPDATE"??
~ > >
~ > >
~ > >
~ > > > From: Thomas Kyte <tkyte_at_us.oracle.com>
~ > > :
~ > > >
~ > > > beware -- jdbc auto commits by default. have you:
~ > > >
~ > > > connection.setAutoCommit(false);
~ > > >
~ > >
~ > > Yep, unfortunately I have ;-)
~ > >
~ > > _db.setAutoCommit(false);
~ > > _db.setReadOnly(false);
~ > >
~ > > No other ideas?
~ > > /Anders
~ > >
~ > >
~
~
Received on Thu Oct 28 1999 - 17:31:23 CEST