Hi,

> I read in some message that following database types are mapped to
> Java Object when using getObject(int columnIndex):
> > INTEGER - java.lang.Integer
> > NUMERIC(18,0) - java.lang.Long
> > DOUBLE PRECISION - java.lang.Double
> > CHAR or VARCHAR - java.lang.String
> > BLOB with custom type - java.sql.Blob
> > BLOB SUB_TYPE 0 or 1 - byte[]
> > TIME - java.sql.Time
> > DATE - java.sql.Date
> > TIMESTAMP - java.sql.Timestamp
> 1) What about SMALLINT and NUMERIC(p,s) with s > 0, examples:
> NUMERIC(12,2) and NUMERIC(10,2)?

SMALLINT is java.lang.Short
NUMERIC(p, s) with s > o is java.math.BigDecimal

We have implemented JDBC type conversion table you can find in the
JDBC specification for getXXX and setXXX methods.

> 2) I suppose it also works with getObject(String columnName)?

Yes.

> 3) I read the release notes of the FirebirdSQL-1.0_RC1 driver but
> where can I find more documentation?

It is not available. We do not have any user manual or something like
that yet. We try to be as close to specification as possible, so you
can take any correct JDBC tutorial and use it as a manual. All
deviations from the specification or features can be found in release
notes.

Also, if you have any problem, you can always post it here.

Best regards,
Roman Rokytskyy