Hello,

Hope someone can help me. My configuration is Jboss3.2.1, Firebird
1.0.2 and Jaybird1.0.0, but I can't make it work.

I get the following message:
[org.firebirdsql.jdbc.FBStatement] GDSException in PreparedStatement
constructor
org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -901
feature is not supported

It seems to me that the problem is with Jaybird when trying to create
table, can anyone confirm that and if so what am I doing wrong? I
couldn't figure out why.

Thanks,
Marcelo

Jboss log:
:
2003-05-09 23:40:40,378 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.Preco] Remove
SQL:
DELETE FROM PRECO WHERE NU_PRECO=?
2003-05-09 23:40:40,438 DEBUG
[org.firebirdsql.jca.FBManagedConnection]
start called:
org.firebirdsql.jca.FBLocalTransaction$FBLocalXid@10e2558
2003-05-09 23:40:40,438 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_transaction
2003-05-09 23:40:40,438 DEBUG [org.firebirdsql.jgds.GDS_Impl] sent
2003-05-09 23:40:40,448 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
2003-05-09 23:40:40,448 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
resp_object: 1
2003-05-09 23:40:40,448 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
resp_blob_id: 0
2003-05-09 23:40:40,448 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
resp_data size: 0
2003-05-09 23:40:40,448 DEBUG [org.firebirdsql.jgds.GDS_Impl]
readStatusVector arg:isc_arg_gds int: 0
2003-05-09 23:40:40,448 DEBUG [org.firebirdsql.jgds.GDS_Impl] received
2003-05-09 23:40:40,468 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_allocate_statement
2003-05-09 23:40:40,468 DEBUG [org.firebirdsql.jgds.GDS_Impl] sent
2003-05-09 23:40:40,478 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
2003-05-09 23:40:40,478 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
resp_object: 2
2003-05-09 23:40:40,478 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
resp_blob_id: 0
2003-05-09 23:40:40,478 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
resp_data size: 0
2003-05-09 23:40:40,478 DEBUG [org.firebirdsql.jgds.GDS_Impl]
readStatusVector arg:isc_arg_gds int: 0
2003-05-09 23:40:40,478 DEBUG [org.firebirdsql.jgds.GDS_Impl] received
2003-05-09 23:40:40,478 DEBUG
[org.firebirdsql.jca.FBManagedConnection]
preparing sql: select null as TABLE_CAT, null as TABLE_SCHEM,
RDB$RELATION_NAME as TABLE_NAME, cast('SYSTEM TABLE' as varchar(31))
as
TABLE_TYPE, RDB$DESCRIPTION as REMARKS, RDB$OWNER_NAME as OWNER_NAME
from
RDB$RELATIONS where ? = 'T' and RDB$SYSTEM_FLAG = 1 and
RDB$VIEW_SOURCE is
null and ? = RDB$RELATION_NAME union select null as TABLE_CAT, null as
TABLE_SCHEM, RDB$RELATION_NAME as TABLE_NAME, cast('TABLE' as varchar
(31))
as TABLE_TYPE, RDB$DESCRIPTION as REMARKS, RDB$OWNER_NAME as
OWNER_NAME from
RDB$RELATIONS where ? = 'T' and RDB$SYSTEM_FLAG = 0 and
RDB$VIEW_SOURCE is
null and ? = RDB$RELATION_NAME union select null as TABLE_CAT, null as
TABLE_SCHEM, RDB$RELATION_NAME as TABLE_NAME, cast('VIEW' as varchar
(31)) as
TABLE_TYPE, RDB$DESCRIPTION as REMARKS, RDB$OWNER_NAME as OWNER_NAME
from
RDB$RELATIONS where ? = 'T' and RDB$VIEW_SOURCE is not null and ? =
RDB$RELATION_NAME
2003-05-09 23:40:40,478 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_prepare_statement
2003-05-09 23:40:40,478 DEBUG [org.firebirdsql.jgds.GDS_Impl] sent
2003-05-09 23:40:40,488 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
2003-05-09 23:40:40,488 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
resp_object: 0
2003-05-09 23:40:40,488 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
resp_blob_id: 0
2003-05-09 23:40:40,488 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
resp_data size: 0
2003-05-09 23:40:40,488 DEBUG [org.firebirdsql.jgds.GDS_Impl]
readStatusVector arg:isc_arg_gds int: 335544569
2003-05-09 23:40:40,488 DEBUG [org.firebirdsql.jgds.GDS_Impl]
readStatusVector arg:isc_arg_gds int: 335544436
2003-05-09 23:40:40,488 DEBUG [org.firebirdsql.jgds.GDS_Impl]
readStatusVector arg:isc_arg_number int: -901
2003-05-09 23:40:40,488 DEBUG [org.firebirdsql.jgds.GDS_Impl]
readStatusVector arg:isc_arg_gds int: 335544378
2003-05-09 23:40:40,488 INFO [org.firebirdsql.jdbc.FBStatement]
GDSException in PreparedStatement constructor
org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -901
feature is not supported
at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1698)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1651)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare(GDS_Impl.java:1162)
at
org.firebirdsql.jca.FBManagedConnection.prepareSQL
(FBManagedConnection.java:
767)
at org.firebirdsql.jdbc.FBConnection.prepareSQL
(FBConnection.java:1107)
at
org.firebirdsql.jdbc.FBStatement.prepareFixedStatement
(FBStatement.java:942)
at
org.firebirdsql.jdbc.FBPreparedStatement.prepareFixedStatement
(FBPreparedSta
tement.java:699)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>
(FBPreparedStatement.java:78)
at
org.firebirdsql.jdbc.FBConnection.prepareStatement
(FBConnection.java:243)
at org.firebirdsql.jdbc.FBConnection.getStatement
(FBConnection.java:1178)
at org.firebirdsql.jdbc.FBConnection.doQuery(FBConnection.java:1203)
at
org.firebirdsql.jdbc.FBDatabaseMetaData.getTables
(FBDatabaseMetaData.java:23
42)
at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists
(SQLUtil.java:726)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable
(JDBCStartCommand
.java:143)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute
(JDBCStartCommand.jav
a:87)
: