Subject | Re: [Firebird-Java] Firebird does not ... |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-07-29T14:22:16Z |
>> * The Firebird JDBC driver does not have proper support for batchNo, since JayBird 1.5.x.
>> updates, so batch updates are disabled.
> Is this still the case with Jaybird?
>> * Firebird does not support auto-increment columns.The Statement.getGeneratedKeys() method will not be supported for FB < 2.0
> We know these are handled differently, and that generators get round the
> problem of 'miss generating' and auto-increment.
that should implement the RETURNING clause for INSERTs. Will appear in
JayBird 2.1.
>> * Firebird does not support the LOWER, SUBSTRING, or INSTR SQLLOWER and SUBSTRING are supported, I have no idea what INSTR is.
>> functions, which means that toLowerCase(), indexOf(), and substring()
>> methods in JDOQL cannot be used.
> This is out of date, so what is the current state of play in relation to
> Jaybird?
JayBird has a switch that tells it to assume that standard UDF lib is
installed and it will support those functions in escaped synatax too.
Roman