> I've patched the driver but cannot compile it because 
> the sources downloaded from the site are not complete 
> (NameHandling.java is missing). 

Put the original .jar into the CLASSPATH and you should be able to compile
your new version.

> P.S.: I've already submitted a bug to jboss but they rejected 
> it with the reason that's a JDBC driver bug. I agree with them 
> because SQL should be case insensitive and so should behave the MetaData
class 

SAP DB supports mixed case identifiers
- in SQL statements if properly quoted
- in system tables

Simply converting the various arguments to the MetaData methods to uppercase
is not the solution because this would render any database objects with
mixed case identifiers invisible.

- the driver could apply the same quoting rules to parameters as the kernel
does to SQL commands (something I personally resent, because you couldn't
feed the output of one meta data query as a parameter into another one)
- the application would have to be written as if all identifiers are case
sensitive (could be very complicated as everything would have to be quoted
in SQL statements)
- the driver gets a connect option to switch to case insensitive meta data
(haven't thought about all the implications yet)

Daniel Dittmar

--
Daniel Dittmar
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to