Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3038

SYSCS_IMPORT_TABLE FAILS with No current connection after shutdown/reconnect to encrypted database : 10.3.1.4 regression

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 10.3.1.4
    • 10.3.2.1, 10.4.1.3
    • SQL
    • None
    • Normal
    • Regression

    Description

      I used to import data with CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE procedure with
      success in JAVA and DERBY 10.2.2.0.

      Since 10.3.1.4, the import procedure fails.

      The error message is :
      The exception 'java.sql.SQLException: No current connection.' was thrown while
      evaluating an expression.

      I'm sure there is a connection, the same which created the statement :
      ***************************************************************************************************
      protected boolean importTableDataCOUNTRIES() {
      try

      { java.sql.Statement st = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE); String sql = ""; sql = "CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('NMSET', 'PAYS', '/tmp/lst_pays.csv', null, null, null, 1)"; st.executeUpdate(sql); return true; }

      catch (SQLException ex)

      { debug(ex.getMessage()); }

      return false;
      }
      ***************************************************************************************************
      The database is not being accessed by another application. The table does
      exist. The CSV file is comma separated and strings are enclosed by ".

      Thank you for considering this issue.

      Attachments

        1. Test3038.java
          2 kB
          Katherine Marsden
        2. sysinfo.txt
          2 kB
          EDAH-TALLY
        3. stacktrace.txt
          3 kB
          EDAH-TALLY
        4. Reproduce3038.zip
          2 kB
          EDAH-TALLY
        5. DERBY-3038-2.stat
          0.2 kB
          Dag H. Wanvik
        6. DERBY-3038-2.diff
          3 kB
          Dag H. Wanvik
        7. DERBY-3038.stat
          0.1 kB
          Dag H. Wanvik
        8. DERBY-3038.diff
          0.5 kB
          Dag H. Wanvik
        9. ASF.LICENSE.NOT.GRANTED--lst_pays.csv
          5 kB
          EDAH-TALLY
        10. ASF.LICENSE.NOT.GRANTED--derby.log
          0.8 kB
          EDAH-TALLY
        11. ASF.LICENSE.NOT.GRANTED--create_table.txt
          0.8 kB
          EDAH-TALLY

        Issue Links

          Activity

            People

              dagw Dag H. Wanvik
              nmset EDAH-TALLY
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: