I think my original post on this got lost. If you get this twice, I'm sorry.

> Hi,
>
> Can you post the code that cause the error?
>
> Rodolfo

Sure.

First I get my connection in this way:

Class.forName("org.firebirdsql.jdbc.FBDriver");
conn =
DriverManager.getConnection("jdbc:firebirdsql:servername.com:E:\\path\\db001
.gdb", "UserName", "Password");

then

Statement stmt = conn.createStatement();
String sql = "SELECT * FROM ma_journal where ma_mdato >= '2002-07-29' AND
ma_slo NOT LIKE 'P' order by ma_slnr desc"
ResultSet rs = stmt.executeQuery(sql);


and at that last line (ResultSet...) I get this message in return:

java.sql.SQLException: GDSException: org.firebirdsql.gds.GDSException:
Dynamic SQL Error
SQL error code = -901
feature is not supported
at
org.firebirdsql.jdbc.FBStatement.executeQuery(FBStatement.java:118)
at DatabaseUpdater.updateJournal(DatabaseUpdater.java:221)
at DatabaseUpdater.doUpdate(DatabaseUpdater.java:133)
at DatabaseUpdater.run(DatabaseUpdater.java:78)

I have tried several things to fix this. I have changed it to
PreparedStatements, I have renamed some tabel...I have pretty much tried
everything I could think of.

Hence, I'm stuck.

/Mikael Andréasson