Re: Database Report Generator - beta testers needed

Hans Forbrich wrote:

> I strongly encourage you to read the first chapter of Thomas Kyte's
> "Expert One on One Oracle" book and then review your post and these
> comments in
> particular. I suspect you now have something to be ashamed about.
>
> /Hans

Expansion ...

Please note that my comments are based on the observation that most cross-platform developers automatically assume the JBDC (or OBDC) layer provides isolation from the RDBMS engine peculiarities while maintaining efficiency across all RDBMSs. This assumption is based on the SQL being a standard language and the further assumption that the engines implementing that language are sufficiently similar.

Time and again the assumption is proven wrong - things I develop for Oracle will not necessarily work well for SQL Server or DB2 and vice-versa. I need to change the WAY I use the tools when I approach different engines.

By analogy, this is much the same way I need to (subtly) change my approach to driving or repairing a rotary engine vs traditional piston engine in a car.

If you have avoided cross-platform issues with only 3 days experience in Oracle AND you have not succumbed to the typical Java workarounds (such as attempting to recreate a RDBMS inside the Java core, for example, pulling all data to the JVM and do manual joins - which is not scalable) then my suspicion is likely wrong.

If, after reading and understanding the first chapter of that book, you still honestly believe you have created a credible cross-platform product, then I would be pleased to attend a presentation and/or read a paper on how you accomplished this. (Which I would hope to see announced in comp.databases.oracle.marketplace) In that case, in spite of several more years at SQL than you, I probably have much to learn from you.

/Hans
contactforbrich at telusplanet dot net (remove contact)

ps: when I started developing in Java, and prior to that in C/C++, I believed all RDBMSs were made equal - in spite of having used RDBMSs since 1979 (one called GERM) and Oracle, DB/2 and SQL/DS since 1983-84 time frame. Took me a long time to realize how wrong I was. Received on Sun May 16 2004 - 09:44:52 CDT