Subject | Re: SQL error code = -901 feature is not supported |
---|---|
Author | mmathias0 |
Post date | 2003-05-12T02:39:57Z |
Hi Helen,
I'm not wrinting this statement, I believe that Jboss sent a command
to Jaybird asking if a table exists and Jaybird generated this
statement, based on the stack traces.
What I did that make some sense, at least to me, was to take off
the "?='T'" and replace the "and ? = RDB$RELATION_NAME" with "and
<tablename> = RDB$RELATION_NAME". It seems that works fine, it
returns a row if this table exists with some attributes.
Here is the stack traces:
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
(FBPreparedStatement.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:2342)
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.java:87)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager
(JDBCStoreManager.java:499)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start
(JDBCStoreManager.java:410)
at org.jboss.ejb.plugins.CMPPersistenceManager.start
(CMPPersistenceManager.java:170)
at org.jboss.ejb.EntityContainer.startService
(EntityContainer.java:339)
Hope it helps.
Thanks,
Marcelo
I'm not wrinting this statement, I believe that Jboss sent a command
to Jaybird asking if a table exists and Jaybird generated this
statement, based on the stack traces.
What I did that make some sense, at least to me, was to take off
the "?='T'" and replace the "and ? = RDB$RELATION_NAME" with "and
<tablename> = RDB$RELATION_NAME". It seems that works fine, it
returns a row if this table exists with some attributes.
Here is the stack traces:
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
(FBPreparedStatement.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:2342)
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.java:87)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager
(JDBCStoreManager.java:499)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start
(JDBCStoreManager.java:410)
at org.jboss.ejb.plugins.CMPPersistenceManager.start
(CMPPersistenceManager.java:170)
at org.jboss.ejb.EntityContainer.startService
(EntityContainer.java:339)
Hope it helps.
Thanks,
Marcelo