при чтении из БД (ms sql server) валится такое исключение:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache.

и далее содержимое стека:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.setupTempFiles(Unknown Source)

at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.postSetupInitialize(Unknown Source)

at com.microsoft.jdbc.base.BaseImplServiceResultSet.postSetupInitialize(Unknown Source)

at com.microsoft.jdbc.base.BaseResultSet.<init>(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.commonGetNextResultSet(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)

at client.base.MsSQLds.getResultSet(MsSQLds.java:201)

at base.AddOps.getPPVNumberBySocialID(AddOps.java:284)

at base.AddOps.migratePerson(AddOps.java:1761)

at base.MainFrame.migrateAllPensioners(MainFrame.java:327)


то есть падает всё на следующем выражении:
<<< MsSQLds.java:201

stmt = getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
result = stmt.executeQuery(ruledQuery);

никак не могу понять в чем проблема!

помогите кто-нить, пжалста.

А.Грасоff™а так?
stmt = getConnection().createStatement();

сейчас попробую

А.Грасоff™а так?
stmt = getConnection().createStatement();

а так валится другое исключение:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported method: ResultSet.first

котыJTDS попробуй

а чё это такое?

уф, вроде проблема решена.

в строке:
stmt = getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);

изменил в вызове второй параметр на ResultSet.CONCUR_READ_ONLY

блин опять, двадцать пять
теперь такое:
java.sql.SQLException: ORA-01000: количество открытых курсоров превысило допустимый максимум


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)

at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:791)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1032)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2884)

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2975)

at base.AddOps.AddDlmRef(AddOps.java:1492)

at base.MainFrame.migrateAllPensioners(MainFrame.java:569)

at base.MainFrame.jButton2_actionPerformed(MainFrame.java:229)

at base.MainFrame.access$6000171(MainFrame.java:28)

at base.MainFrame$2.actionPerformed(MainFrame.java:116)

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

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

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

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

at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

java.sql.SQLException: ORA-01000: количество открытых курсоров превысило допустимый максимум

падает на команде execute, в след. коде:

PreparedStatement insStmt =
conn.prepareStatement ("update pl_persons set dlm_object_id=? where id=? ");

insStmt.setLong(1, dlmObjectId); // The first ? is for EMPNO
insStmt.setInt (2, personID); // The second ? is for ENAME

insStmt.execute();
insStmt.close();

А.Грасоff™ Riddler
at base.MainFrame.migrateAll Pensioners (MainFrame.java:569)

прикольно :) с днем программиста, риддлер!

и тебя тоже с ентим днём, антон.

ЗЫ
тебе понравилось слово "Пенсионеры" в названии метода?