[DERBY-3038] SYSCS_IMPORT_TABLE FAILS with No current connection after shutdown/reconnect to encrypted database : 10.3.1.4 regression

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.3.2.1, 10.4.1.3
• Component/s: SQL

Environment

Linux 2.6.21.1 #2 Tue Jun 26 23:24:34 CEST 2007 i686 AMD Athlon(tm) XP 2800+ GNU/Linux (Mandriva 2007 Spring)
java version "1.6.0"
Java(TM) SE Runtime Environment (build 1.6.0-b105)
Java HotSpot(TM) Client VM (build 1.6.0-b105, mixed mode, sharing)

• Urgency: Normal
• Bug behavior facts: Regression
• Assignee: Dag H. Wanvik
• Reporter: EDAH-TALLY
• Created: 02/Sep/07 08:06
• Updated: 30/Jun/09 15:55
• Resolved: 12/Sep/07 12:36

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.

Issue Links

• is related to: DERBY-2264 Restrict shutdown, upgrade, and encryption powers to the database owner