Re: adding col in between....

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: cjpengel.dbalert@xxxxxxxxx
  • Date: Tue, 19 Jul 2005 06:48:02 -0400

But I thought all java programmers ever need is a clob since they store 
everything in a big string.

On 7/19/05, Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx> wrote:
> 
> Maybe the 'why' question can be answered. I was involved in a project, 
> where all queries were 'select * from.....'. And all updates updated every 
> single column, of course, whether the contents changed or not.
> 
> Yes, it was Java. They 'generated' the SQL, and required all columns to be 
> in alphabetical order. 


Yeah, time to fire the dumb design and bring in some natural commen sense 
back. I'd never let java programmers design anything, just let them 
implement a prepared design. 

Okay, now I'll wait for java programmers to 'throw' exception at my 
comments. I, however have a preparedStatement() for them.

Raj

Other related posts: