Have struggled unsuccessfully to get any query to run using the Jaybird JDBC v 1.5 driver from a java application. The driver loads successfully and doesn't run simple static queries or dynamic queries. The same queries work find with the Interbase Interclient driver.

Class.forName("org.firebirdsql.jdbc.FBDriver");

conn = DriverManager.getConnection(
"jdbc:firebirdsql://127.0.0.1:3050/:c:/EMPLOYEE.fdb", "SYSDBA", "masterkey");

Examples of the queries are :
Static:
SELECT DATA.symbol, SYMBOLS.name, DATA.last, DATA.open, DATA.change, DATA.changeproc, DATA.volume FROM DATA, SYMBOLS WHERE DATA.symbol = SYMBOLS.symbol;
Dynamic:
SELECT DATA.symbol, SYMBOLS.name, DATA.last, DATA.open, DATA.change, DATA.changeproc, DATA.volume FROM DATA, SYMBOLS
WHERE DATA.symbol = SYMBOLS.symbol AND
EXTRACT(MONTH FROM DATA.date1)=? AND EXTRACT(DAY FROM DATA.date1)=? AND EXTRACT(YEAR FROM DATA.date1)=?;

Error for both cases is:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -901
feature is not supported



Any pointers to help resolve the above issue? Also, are there any other drivers that I could use instead of the Jaybird driver?

Thanks


---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!

[Non-text portions of this message have been removed]