Hello.

I'm testing the driver against JDBC 2.0 core. After some patches not yet included in the CVS repository, the driver comply with
JDBC 2.0
core with some features and methods not implemented, some of it required by the specification and some optional. I don't test
gets/sets and
callable statements yet.

About the JDBC javax.sql there are implementations for some of the classes including RowSet and DataSource.

The following optional features (excluding javax.sql) was not yet supported
- Batch Updates.
- Scrollable resultSets.
- Updatable resultSets.
- Cursors.
- User Defined Types/Type Maps.

The following methods (excluding javax.sql), was not implemented yet

DBMetaData
getBestRowIndentifier.
getVersionColumns
getImportedKeys
getExportedKeys
getCrossReference
getIndexInfo
getUDT

RSMetaData
isReadOnly
isWritable
isDefinitivelyWritable

Statement
all the methods used for batchUpdates.
setEscapeProcessing
get/setFetchSize
get/setMaxFieldSize
get/setMaxRows
get/setQueryTimeout
cancel
setCursorName

PreparedStatement
setObject(index,object,type,scale)
setRef(i)
setClob(i)
setArray(i)
setDate(i,calendar)
setTime(i,calendar)
setTimestamp(i,calendar)

ResultSet
all the methods used only for scrollable resultSets (absolute, relative, etc)
all the methods used only for updatable resultSets (updateXXX, moveToInsertRow, etc)
isBeforeFirst,isFirst,isLast,isAfterLast
get/setFetchSize.
getCursorName.

getObject(i,Map)
getRef(i)
getClob(i)
getArray(i)
getDate(i,calendar)
getTime(i,calendar)
getTimestamp(i,calendar)

Known bugs
getUpdateCount in Statement return 0 after execute(select) and must return -1.
setXXX(i,val) in PreparedStatement return non SQL Exception where the index is not valid.
getXXX(i) in ResultSet return non SQL Exception where the index is not valid.

I hope this list can be added to the driver documentation.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: <HGFrey@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Thursday, May 16, 2002 9:37 AM
Subject: [Firebird-Java] looking for a featurelist of JCA-JDBC


> Hi,
>
> I'm just evaluating firebird and JCA-JDBC.
> One of the first sentence I found to JCA-JDBC
> was: "Most useful JDBC functionality ("useful"
> in the opinion of the developers)". That means to
> me, this driver does not support a concrete JDBC
> Version. Combined with JCA JDBC-Version 3.0 has to
> be supported, but i found out that programmatically
> update (resultSet.updateString(1, "Blah")) which is
> requiered for JDBC-Version 2.0 is not supported.
>
> Is there a list with functionalities of the JDBC-Spec which
> are supported yet and which are not! That would be a great
> help for me.
>
> thanks
> Hans Georg
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>