make them use Java prepared statements. I ended up having to turn cursor sharing to force to deal with the fact that the programmers refused to use prepared statements and insisted on literals.
--- "Jack C. Applewhite" <[EMAIL PROTECTED]> wrote: > Dennis, > > I've had to keep after the Java developers here to use bind variables > instead of literals. Apparently, it's much easier for them to > construct > literal SQL. They now understand the importance and use bind > variable > pretty much all the time. > > A few months ago they started spawning multiple threads of some Java > processes and used a "thingey" called Connection Pooling to mediate > connections to Oracle. They fell back to using literal SQL, until > they > figured out how to use bind variables with Connection Pooling. > Apparently, > it's even harder to use bind variables with Connection Pooling. If > you make > the Java developers aware of these issues up front, maybe they'll go > ahead > and learn how to code it "right" initially. > > Sorry I can't give details, 'cause all I know about Java is how to > spell it! > ;-) > > Jack > > -------------------------------- > Jack C. Applewhite > Database Administrator/Developer > OCP Oracle8 DBA > iNetProfit, Inc. > Austin, Texas > www.iNetProfit.com > [EMAIL PROTECTED] > (512)327-9068 > > > -----Original Message----- > WILLIAMS > Sent: Monday, April 01, 2002 11:20 AM > To: Multiple recipients of list ORACLE-L > > > Oh, I guess I'm a little slow on Monday. I've enjoyed the discussion > so far. > Very close to my situation. > > Given my situation - i.e., we haven't had many SQL statement > problems, but > expecting to receive more with Java, I'm wondering how I can get > ahead of > the game. I have worked on a set of SQL statement recommendations, > simple > stuff like make sure screen queries use and index. I am considering > creating > a checklist form for SQL statements for the developers to use. Like > include > the listing from EXPLAIN PLAN. Does anyone have any thoughts on this > approach? I'm not sure if the developers/management would go for it, > but I > thought it would be worth asking as a starting point. Everybody is > new to > Java and a little nervous, so they are probably more open to > suggestions. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack C. Applewhite > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________________________ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
