Poor JDBC implementation

[World]

Hello,

I've been trying to develop a Java application that access a Filemaker 5.5 Developer DB using the supplied JDBC drivers.

It has been a nightmare so far.... Many of some basic JDBC functions are not implemented in the drivers. Simple functions such as getFetchSize(), beforeFirst(), etc return me an error message at runtime.

How can you guys work with these drivers? How have you developed your workarounds? Any words from FM as to when we should get decent drivers ?

I am not developing a web application by the way. I have to do a program that will insert data coming from EDI flat files into the FM tables.

[omiossec]

The Filemaker JDBC driver is not a real jdbc driver in the sens that it don't include basic JDBC api feature.

In fact the jdbc driver is more a java bridge to filemaker using the web companion so It get the same limitation (and all feature in web companion are not realy implemented in the driver).

JDBC driver is poor for web programing, it can be use for basic data exanche with filemaker.

[World]

Merci Olivier

Yes, since it basically only allow you to submit a SQL statement and read the resultSet forward and only once I circumvent the problem by creating a class that transfers the resultSet, using another simple class that matches the data in the resultSet, in a Vector. Vectors allow me to move ofrard/backerd etc easily.

Not nice but it works.

World