Hi I removed the respectCase() methods from all the classes. They compile and everything seems file, but it wouldn't hurt if somebody checked them before committing them to CVS. Regards Leon cvs diff DBWeblogic.java DBSybase.java DBPostgres.java DBOracle.java DBNone.java DBMM.java DBInstantDB.java DBHypersonicSQL.java DBDB2Net.java DBDB2App.java DB.java (in directory C:\apps\turbine\src\java\org\apache\turbine\util\db\pool) Index: DBWeblogic.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DBWeb logic.java,v retrieving revision 1.3 diff -r1.3 DBWeblogic.java 91a92,99 > > /** This method is used to ignore case */ > public String ignoreCase(String in) > { > return in; > } > > Index: DBSybase.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DBSyb ase.java,v retrieving revision 1.2 diff -r1.2 DBSybase.java 83a84,90 > /** This method is used to ignore case */ > public String ignoreCase(String in) > { > return new StringBuffer("UPPER(").append(in).append(")").toString(); > } > > Index: DBPostgres.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DBPos tgres.java,v retrieving revision 1.3 diff -r1.3 DBPostgres.java 91a92,103 > > /** This method is used to ignore case */ > public String ignoreCase(String in) > { > String s = new StringBuffer("UPPER(").append(in).append(")").toString(); > > Log.note("DBPostgres.toUpperCase(" + in + "), returning " + s); > > return s; > } > > Index: DBOracle.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DBOra cle.java,v retrieving revision 1.4 diff -r1.4 DBOracle.java 81a82,89 > > /** This method is used to ignore case */ > public String ignoreCase(String in) > { > return new StringBuffer("UPPER(").append(in).append(")").toString(); > } > > Index: DBNone.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DBNon e.java,v retrieving revision 1.3 diff -r1.3 DBNone.java 90a91,98 > > /** This method is used to ignore case */ > public String ignoreCase(String in) > { > return in; > } > > Index: DBMM.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DBMM. java,v retrieving revision 1.4 diff -r1.4 DBMM.java 88a89,96 > > /** This method is used to ignore case */ > public String ignoreCase(String in) > { > return in; > } > > Index: DBInstantDB.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DBIns tantDB.java,v retrieving revision 1.4 diff -r1.4 DBInstantDB.java 93a94,101 > > /** This method is used to ignore case */ > public String ignoreCase(String in) > { > return in; > } > > Index: DBHypersonicSQL.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DBHyp ersonicSQL.java,v retrieving revision 1.2 diff -r1.2 DBHypersonicSQL.java 100a101,107 > /** This method is used to ignore case */ > public String ignoreCase(String in) > { > return in; > } > > Index: DBDB2Net.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DBDB2 Net.java,v retrieving revision 1.3 diff -r1.3 DBDB2Net.java 91a92,102 > /** This method is used to ignore case */ > public String ignoreCase(String in) > { > String s = new StringBuffer("UPPER(").append(in).append(")").toString(); > > Log.note("DBDB2Net.toUpperCase(" + in + "), returning " + s); > > return s; > } > > Index: DBDB2App.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DBDB2 App.java,v retrieving revision 1.3 diff -r1.3 DBDB2App.java 91a92,103 > > /** This method is used to ignore case */ > public String ignoreCase(String in) > { > String s = new StringBuffer("UPPER(").append(in).append(")").toString(); > > Log.note("DBDB2App.toUpperCase(" + in + "), returning " + s); > > return s; > } > > Index: DB.java =================================================================== RCS file: /products/cvs/turbine/turbine/src/java/org/apache/turbine/util/db/pool/DB.ja va,v retrieving revision 1.7 diff -r1.7 DB.java 83,84c83 < protected DB() < {} --- > protected DB() {} 111a111 > 123a124,138 > > > /** This method is used to ignore case */ > public abstract String ignoreCase(String in); > > /** > * This method is used to ignore case in an ORDER BY clause. Usually it > * is the same as ignoreCase, but some databases (Interbase for example) > * does not use the same SQL in ORDER BY and other clauses. > */ > public String ignoreCaseInOrderBy(String in) > { > return ignoreCase(in); > } > ------------------------------------------------------------ To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Problems?: [EMAIL PROTECTED]