David, I'm in no way sqlite specialist :) I'm just trying to help SQLiteJDBC to be 'nice' from the point of JDBC driver user :)
One of my daily tasks in ensuring that our project runs smoothly (with no changes) on HSQLDB, MySQL 5.x, Oracle 10+, MSSQL 2005+ and latest PostgreSQL. Thus I systematically observe differences in DDL & DML dialects and vendor specific JDBC driver behavior. My feedback on SQLiteJDBC is based on my experience of evaluating it as backing storage for our project, so now I pinpoint cases where SQLiteJDBC behavior is significantly different from de-facto standard behavior that I can derive from all of abovementioned drivers. On May 11, 10:14 am, "David Crawshaw" <[EMAIL PROTECTED]> wrote: > 2008/5/10 neuro <[EMAIL PROTECTED]>: > > > I think this is same as > >http://groups.google.com/group/sqlitejdbc/browse_thread/thread/4b6926... > > Sorry, but I think you're both wrong. First neuro159, your patch > assumes that SQLite returns <table>.<column>, yet SQLite's behaviour > is unspecified: > > 'The name of a result column is the value of the "AS" > clause for that column, if there is an AS clause. If there > is no AS clause then the name of the column is > unspecified and may change from one release of SQLite > to the next.' --http://sqlite.org/c3ref/column_name.html > > Though I am still considering your patch, as it will make the driver > more rigorous. However both what you and Máté want to do, namely: > > getInt("tablename.colname") > > Does not seem to be anything like what the JavaDoc suggests: > > "columnLabel - the label for the column specified with > the SQL AS clause. If the SQL AS clause was not > specified, then the label is the name of the column" > -- ResultSet.getInt(String) > > I see no reading that would support tablename.colname as "the name of > the column". It seems to me that the real problem here is your select > statements. If there are ambiguities, use the AS construction. > > d. --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
