Sqlite JDBC :
I have a bug in Jdbc driver. The method DatabaseMetaData.getColumns(String
catalog, String schemaPattern,
String tableNamePattern, String columnNamePattern)
throws SQLException;
does not correctly return the value in resultSet.getInt(11 ) - NULLABLE OR
NOT. Please make sure that also the Primary Key columns have the correct
value here.
I consider a column mandatory ( not null ) if :
DatabaseMetaData.columnNoNulls == rs.getInt(11)
One more request for Sqlite :
Would be great if you would support adding foreign keys after the table has
been created.
This is highly required by database design tools. All users are creating the
foreign keys after the table has been created.
This would be a great advantage for thouse who intend to a real database
design.
So please add commands for ALTER TABLE... ADD CONSTRAINT ... FOREIGN KEY (
col1, col2 ) REFERENCES ... ( col1, col2 ).
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/JDBC-Driver-Issue-tp71705.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
