Subject Resource Exception
Author haug22
Hi All

I am running firebird java driver against a DB running on firebird V
0.9.xx when I try to connect I'm getting this exception:
Resource Exception. SQLDA missing or incorrect version, or incorrect
number/type of variables

(see below for a full stack trace)

Im using the latest CVS build. With the RC1 release I didn't have
this problem.

Here is the code causing the problem:
ConnectionDescriptor connecctoinDescriptor = new
ConnectionDescriptor(getDbURL(), "user", "password",
false, "org.firebirdsql.jdbc.FBDriver");
Properties properties = new Properties();
properties.setProperty("charSet",
interbase.interclient.CharacterEncodings.UTF8);
connecctoinDescriptor.setProperties(properties);
dbTransparency.setConnection(connecctoinDescriptor);
dbTransparency.setTransactionIsolation
(java.sql.Connection.TRANSACTION_REPEATABLE_READ);
dbTransparency.setAutoCommit(false);

The exception happens at the last line.

Thanks for any help..

See com.borland.dx.dataset.DataSetException error code: BASE+66

com.borland.dx.dataset.DataSetException: Resource Exception. SQLDA
missing or incorrect version, or incorrect number/type of variables
Reason: SQLDA missing or incorrect version, or incorrect number/type
of variables

at com.borland.dx.dataset.DataSetException.a(Unknown Source)

at com.borland.dx.dataset.DataSetException.throwException
(Unknown Source)

at com.borland.dx.dataset.DataSetException.SQLException
(Unknown Source)

at com.borland.dx.sql.dataset.Database.openConnection(Unknown
Source)

at com.borland.dx.sql.dataset.Database.setAutoCommit(Unknown
Source)

at transparency.globalDataModule.jbInit
(globalDataModule.java:93)

at transparency.globalDataModule.<init>
(globalDataModule.java:76)

at transparency.globalDataModule.getDataModule
(globalDataModule.java:69)

at jtc.JTCObjectDialog.<init>(JTCObjectDialog.java:34)

at jtc.JTCObjectDialog.<init>(JTCObjectDialog.java:38)

at jtc.EmployeeFrame.<init>(EmployeeFrame.java:80)

at jtc.MainMenu.jMenuEmployees_actionPerformed
(MainMenu.java:373)

at jtc.MainMenu$9.actionPerformed(MainMenu.java:153)

at javax.swing.AbstractButton.fireActionPerformed
(AbstractButton.java:1450)

at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed
(AbstractButton.java:1504)

at javax.swing.DefaultButtonModel.fireActionPerformed
(DefaultButtonModel.java:378)

at javax.swing.DefaultButtonModel.setPressed
(DefaultButtonModel.java:250)

at javax.swing.AbstractButton.doClick(AbstractButton.java:279)

at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased
(BasicMenuItemUI.java:886)

at java.awt.Component.processMouseEvent(Component.java:3715)

at java.awt.Component.processEvent(Component.java:3544)

at java.awt.Container.processEvent(Container.java:1164)

at java.awt.Component.dispatchEventImpl(Component.java:2593)

at java.awt.Container.dispatchEventImpl(Container.java:1213)

at java.awt.Component.dispatchEvent(Component.java:2497)

at java.awt.LightweightDispatcher.retargetMouseEvent
(Container.java:2451)

at java.awt.LightweightDispatcher.processMouseEvent
(Container.java:2216)

at java.awt.LightweightDispatcher.dispatchEvent
(Container.java:2125)

at java.awt.Container.dispatchEventImpl(Container.java:1200)

at java.awt.Window.dispatchEventImpl(Window.java:914)

at java.awt.Component.dispatchEvent(Component.java:2497)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy
(EventDispatchThread.java:131)

at java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:98)

at java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run
(EventDispatchThread.java:85)

Chained exception:

org.firebirdsql.jdbc.FBSQLException: Resource Exception. SQLDA
missing or incorrect version, or incorrect number/type of variables
Reason: SQLDA missing or incorrect version, or incorrect number/type
of variables

at org.firebirdsql.jdbc.FBDataSource.getConnection
(FBDataSource.java:107)

at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:273)

at java.sql.DriverManager.getConnection
(DriverManager.java:517)

at java.sql.DriverManager.getConnection
(DriverManager.java:146)

at com.borland.dx.sql.dataset.Database.openConnection(Unknown
Source)

at com.borland.dx.sql.dataset.Database.setAutoCommit(Unknown
Source)

at transparency.globalDataModule.jbInit
(globalDataModule.java:93)

at transparency.globalDataModule.<init>
(globalDataModule.java:76)

at transparency.globalDataModule.getDataModule
(globalDataModule.java:69)

at jtc.JTCObjectDialog.<init>(JTCObjectDialog.java:34)

at jtc.JTCObjectDialog.<init>(JTCObjectDialog.java:38)

at jtc.EmployeeFrame.<init>(EmployeeFrame.java:80)

at jtc.MainMenu.jMenuEmployees_actionPerformed
(MainMenu.java:373)

at jtc.MainMenu$9.actionPerformed(MainMenu.java:153)

at javax.swing.AbstractButton.fireActionPerformed
(AbstractButton.java:1450)

at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed
(AbstractButton.java:1504)

at javax.swing.DefaultButtonModel.fireActionPerformed
(DefaultButtonModel.java:378)

at javax.swing.DefaultButtonModel.setPressed
(DefaultButtonModel.java:250)

at javax.swing.AbstractButton.doClick(AbstractButton.java:279)

at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased
(BasicMenuItemUI.java:886)

at java.awt.Component.processMouseEvent(Component.java:3715)

at java.awt.Component.processEvent(Component.java:3544)

at java.awt.Container.processEvent(Container.java:1164)

at java.awt.Component.dispatchEventImpl(Component.java:2593)

at java.awt.Container.dispatchEventImpl(Container.java:1213)

at java.awt.Component.dispatchEvent(Component.java:2497)

at java.awt.LightweightDispatcher.retargetMouseEvent
(Container.java:2451)

at java.awt.LightweightDispatcher.processMouseEvent
(Container.java:2216)

at java.awt.LightweightDispatcher.dispatchEvent
(Container.java:2125)

at java.awt.Container.dispatchEventImpl(Container.java:1200)

at java.awt.Window.dispatchEventImpl(Window.java:914)

at java.awt.Component.dispatchEvent(Component.java:2497)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy
(EventDispatchThread.java:131)

at java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:98)

at java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run
(EventDispatchThread.java:85)

at org.firebirdsql.gds.GDSException: SQLDA missing or incorrect
version, or incorrect number/type of variables

at org.firebirdsql.jgds.GDS_Impl.parseTruncDatabaseInfo
(GDS_Impl.java:401)

at org.firebirdsql.jgds.GDS_Impl.parseDatabaseInfo
(GDS_Impl.java:322)

at org.firebirdsql.jgds.GDS_Impl.isc_database_info
(GDS_Impl.java:307)

at org.firebirdsql.jgds.GDS_Impl.isc_attach_database
(GDS_Impl.java:275)

at org.firebirdsql.jgds.GDS_Impl.isc_attach_database
(GDS_Impl.java:240)

at
org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle
(FBManagedConnectionFactory.java:541)

at org.firebirdsql.jca.FBManagedConnection.<init>
(FBManagedConnection.java:104)

at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection
(FBManagedConnectionFactory.java:372)

at
org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection
(FBStandAloneConnectionManager.java:58)

at org.firebirdsql.jdbc.FBDataSource.getConnection
(FBDataSource.java:104)

at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:273)

at java.sql.DriverManager.getConnection
(DriverManager.java:517)

at java.sql.DriverManager.getConnection
(DriverManager.java:146)

at com.borland.dx.sql.dataset.Database.openConnection(Unknown
Source)

at com.borland.dx.sql.dataset.Database.setAutoCommit(Unknown
Source)

at transparency.globalDataModule.jbInit
(globalDataModule.java:93)

at transparency.globalDataModule.<init>
(globalDataModule.java:76)

at transparency.globalDataModule.getDataModule
(globalDataModule.java:69)

at jtc.JTCObjectDialog.<init>(JTCObjectDialog.java:34)

at jtc.JTCObjectDialog.<init>(JTCObjectDialog.java:38)

at jtc.EmployeeFrame.<init>(EmployeeFrame.java:80)

at jtc.MainMenu.jMenuEmployees_actionPerformed
(MainMenu.java:373)

at jtc.MainMenu$9.actionPerformed(MainMenu.java:153)

at javax.swing.AbstractButton.fireActionPerformed
(AbstractButton.java:1450)

at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed
(AbstractButton.java:1504)

at javax.swing.DefaultButtonModel.fireActionPerformed
(DefaultButtonModel.java:378)

at javax.swing.DefaultButtonModel.setPressed
(DefaultButtonModel.java:250)

at javax.swing.AbstractButton.doClick(AbstractButton.java:279)

at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased
(BasicMenuItemUI.java:886)

at java.awt.Component.processMouseEvent(Component.java:3715)

at java.awt.Component.processEvent(Component.java:3544)

at java.awt.Container.processEvent(Container.java:1164)

at java.awt.Component.dispatchEventImpl(Component.java:2593)

at java.awt.Container.dispatchEventImpl(Container.java:1213)

at java.awt.Component.dispatchEvent(Component.java:2497)

at java.awt.LightweightDispatcher.retargetMouseEvent
(Container.java:2451)

at java.awt.LightweightDispatcher.processMouseEvent
(Container.java:2216)

at java.awt.LightweightDispatcher.dispatchEvent
(Container.java:2125)

at java.awt.Container.dispatchEventImpl(Container.java:1200)

at java.awt.Window.dispatchEventImpl(Window.java:914)

at java.awt.Component.dispatchEvent(Component.java:2497)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy
(EventDispatchThread.java:131)

at java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:98)

at java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run
(EventDispatchThread.java:85)

See com.borland.dx.dataset.DataSetException error code: BASE+66

com.borland.dx.dataset.DataSetException: Resource Exception. SQLDA
missing or incorrect version, or incorrect number/type of variables
Reason: SQLDA missing or incorrect version, or incorrect number/type
of variables

at com.borland.dx.dataset.DataSetException.a(Unknown Source)

at com.borland.dx.dataset.DataSetException.throwException
(Unknown Source)

at com.borland.dx.dataset.DataSetException.SQLException
(Unknown Source)

at com.borland.dx.sql.dataset.Database.openConnection(Unknown
Source)

at transparency.globalDataModule.getOpenDbTransparency
(globalDataModule.java:216)

at jtc.EmployeeFrame.jbInit(EmployeeFrame.java:100)

at jtc.EmployeeFrame.<init>(EmployeeFrame.java:83)

at jtc.MainMenu.jMenuEmployees_actionPerformed
(MainMenu.java:373)

at jtc.MainMenu$9.actionPerformed(MainMenu.java:153)

at javax.swing.AbstractButton.fireActionPerformed
(AbstractButton.java:1450)

at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed
(AbstractButton.java:1504)

at javax.swing.DefaultButtonModel.fireActionPerformed
(DefaultButtonModel.java:378)

at javax.swing.DefaultButtonModel.setPressed
(DefaultButtonModel.java:250)

at javax.swing.AbstractButton.doClick(AbstractButton.java:279)

at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased
(BasicMenuItemUI.java:886)

at java.awt.Component.processMouseEvent(Component.java:3715)

at java.awt.Component.processEvent(Component.java:3544)

at java.awt.Container.processEvent(Container.java:1164)

at java.awt.Component.dispatchEventImpl(Component.java:2593)

at java.awt.Container.dispatchEventImpl(Container.java:1213)

at java.awt.Component.dispatchEvent(Component.java:2497)

at java.awt.LightweightDispatcher.retargetMouseEvent
(Container.java:2451)

at java.awt.LightweightDispatcher.processMouseEvent
(Container.java:2216)

at java.awt.LightweightDispatcher.dispatchEvent
(Container.java:2125)

at java.awt.Container.dispatchEventImpl(Container.java:1200)

at java.awt.Window.dispatchEventImpl(Window.java:914)

at java.awt.Component.dispatchEvent(Component.java:2497)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy
(EventDispatchThread.java:131)

at java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:98)

at java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run
(EventDispatchThread.java:85)

Chained exception:

org.firebirdsql.jdbc.FBSQLException: Resource Exception. SQLDA
missing or incorrect version, or incorrect number/type of variables
Reason: SQLDA missing or incorrect version, or incorrect number/type
of variables

at org.firebirdsql.jdbc.FBDataSource.getConnection
(FBDataSource.java:107)

at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:273)

at java.sql.DriverManager.getConnection
(DriverManager.java:517)

at java.sql.DriverManager.getConnection
(DriverManager.java:146)

at com.borland.dx.sql.dataset.Database.openConnection(Unknown
Source)

at transparency.globalDataModule.getOpenDbTransparency
(globalDataModule.java:216)

at jtc.EmployeeFrame.jbInit(EmployeeFrame.java:100)

at jtc.EmployeeFrame.<init>(EmployeeFrame.java:83)

at jtc.MainMenu.jMenuEmployees_actionPerformed
(MainMenu.java:373)

at jtc.MainMenu$9.actionPerformed(MainMenu.java:153)

at javax.swing.AbstractButton.fireActionPerformed
(AbstractButton.java:1450)

at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed
(AbstractButton.java:1504)

at javax.swing.DefaultButtonModel.fireActionPerformed
(DefaultButtonModel.java:378)

at javax.swing.DefaultButtonModel.setPressed
(DefaultButtonModel.java:250)

at javax.swing.AbstractButton.doClick(AbstractButton.java:279)

at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased
(BasicMenuItemUI.java:886)

at java.awt.Component.processMouseEvent(Component.java:3715)

at java.awt.Component.processEvent(Component.java:3544)

at java.awt.Container.processEvent(Container.java:1164)

at java.awt.Component.dispatchEventImpl(Component.java:2593)

at java.awt.Container.dispatchEventImpl(Container.java:1213)

at java.awt.Component.dispatchEvent(Component.java:2497)

at java.awt.LightweightDispatcher.retargetMouseEvent
(Container.java:2451)

at java.awt.LightweightDispatcher.processMouseEvent
(Container.java:2216)

at java.awt.LightweightDispatcher.dispatchEvent
(Container.java:2125)

at java.awt.Container.dispatchEventImpl(Container.java:1200)

at java.awt.Window.dispatchEventImpl(Window.java:914)

at java.awt.Component.dispatchEvent(Component.java:2497)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy
(EventDispatchThread.java:131)

at java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:98)

at java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run
(EventDispatchThread.java:85)

at org.firebirdsql.gds.GDSException: SQLDA missing or incorrect
version, or incorrect number/type of variables

at org.firebirdsql.jgds.GDS_Impl.parseTruncDatabaseInfo
(GDS_Impl.java:401)

at org.firebirdsql.jgds.GDS_Impl.parseDatabaseInfo
(GDS_Impl.java:322)

at org.firebirdsql.jgds.GDS_Impl.isc_database_info
(GDS_Impl.java:307)

at org.firebirdsql.jgds.GDS_Impl.isc_attach_database
(GDS_Impl.java:275)

at org.firebirdsql.jgds.GDS_Impl.isc_attach_database
(GDS_Impl.java:240)

at
org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle
(FBManagedConnectionFactory.java:541)

at org.firebirdsql.jca.FBManagedConnection.<init>
(FBManagedConnection.java:104)

at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection
(FBManagedConnectionFactory.java:372)

at
org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection
(FBStandAloneConnectionManager.java:58)

at org.firebirdsql.jdbc.FBDataSource.getConnection
(FBDataSource.java:104)

at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:273)

at java.sql.DriverManager.getConnection
(DriverManager.java:517)

at java.sql.DriverManager.getConnection
(DriverManager.java:146)

at com.borland.dx.sql.dataset.Database.openConnection(Unknown
Source)

at transparency.globalDataModule.getOpenDbTransparency
(globalDataModule.java:216)

at jtc.EmployeeFrame.jbInit(EmployeeFrame.java:100)

at jtc.EmployeeFrame.<init>(EmployeeFrame.java:83)

at jtc.MainMenu.jMenuEmployees_actionPerformed
(MainMenu.java:373)

at jtc.MainMenu$9.actionPerformed(MainMenu.java:153)

at javax.swing.AbstractButton.fireActionPerformed
(AbstractButton.java:1450)

at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed
(AbstractButton.java:1504)

at javax.swing.DefaultButtonModel.fireActionPerformed
(DefaultButtonModel.java:378)

at javax.swing.DefaultButtonModel.setPressed
(DefaultButtonModel.java:250)

at javax.swing.AbstractButton.doClick(AbstractButton.java:279)

at
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased
(BasicMenuItemUI.java:886)

at java.awt.Component.processMouseEvent(Component.java:3715)

at java.awt.Component.processEvent(Component.java:3544)

at java.awt.Container.processEvent(Container.java:1164)

at java.awt.Component.dispatchEventImpl(Component.java:2593)

at java.awt.Container.d