Kathey Marsden (JIRA) skrev:
[
https://issues.apache.org/jira/browse/DERBY-3038?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kathey Marsden resolved DERBY-3038.
-----------------------------------
Resolution: Cannot Reproduce
Closing this issue Cannot Reproduce. Please reopen if you get a reproduction for this problem.
Hello Kathey,
You say you are closing the issue, but it is only marked as resolved.
Is this intentional, or can the issue be marked as closed as well?
As a general note, I believe one can specify the resolution from the
"Close" screen/dialog. Saves one message and a few clicks :)
I am aware that mostly marking an issue resolved and closed will be
carried out by different persons and thus done in two steps.
regards,
--
Kristian
SYSCS_IMPORT_TABLE FAILS : 10.3.1.4 regression ?
------------------------------------------------
Key: DERBY-3038
URL: https://issues.apache.org/jira/browse/DERBY-3038
Project: Derby
Issue Type: Bug
Components: Tools
Affects Versions: 10.3.1.4
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)
Reporter: EDAH-TALLY
Attachments: create_table.txt, lst_pays.csv, stacktrace.txt,
sysinfo.txt, Test3038.java
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.
