db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kempff, Malte" <Malte.Kem...@de.equens.com>
Subject AW: Problems with import of CSV to Table
Date Tue, 24 Jun 2014 15:45:43 GMT
I found my problem now, it was a not existing file for input, I had overseen in the error report.
FEHLER XIE04: Nicht gefundene Datendatei: memorecords.dat

But I have also another question. When I tried to give nulls in the import export statement
using the procedures, ij gave me an syntax error.
What do I need to do that ij accepts my null-values for using the defaults?

Thanks for hints

Malte

Von: Kempff, Malte
Gesendet: Dienstag, 24. Juni 2014 17:21
An: Derby Discussion (derby-user@db.apache.org)
Betreff: Problems with import of CSV to Table

Hi,
I have this Table
ij(DB_8_2)> describe memo_records;
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
RECORD_ID           |VARCHAR  |NULL|NULL|512   |NULL      |1024      |NO
INPUTFILE_ID        |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
TMPST_IN            |TIMESTAMP|9   |10  |29    |CURRENT_T&|NULL      |NO
TMPST_USED          |TIMESTAMP|9   |10  |29    |NULL      |NULL      |YES
STATE               |CHAR     |NULL|NULL|1     |'I'       |2         |NO

And I have this CSV-Structure for importing it.
"174145"|1382|"2014-03-28 05:09:44.441"||"I"
"174146"|1382|"2014-03-28 05:09:44.558"||"I"
"174147"|1382|"2014-03-28 05:09:44.585"||"I"
"174507"|1424|"2014-04-07 05:09:56.649"|"2014-04-10 18:11:45.388"|"U"
"174508"|1424|"2014-04-07 05:09:56.738"||"I"
I am getting this Error in ij:
FEHLER 38000: Bei der Auswertung eines Ausdrucks wurde die Ausnahme 'java.sql.SQLException:
Bei der Auswertung eines Ausdrucks wurde die Ausnahme 'java.lang.reflect.InvocationTargetException'
ausgel÷st.' ausgel÷st.
FEHLER 38000: Bei der Auswertung eines Ausdrucks wurde die Ausnahme 'java.lang.reflect.InvocationTargetException'
ausgel÷st.

Well actually I cannot find the problem, I suspect that it might be the date.
But shouldn't an export produce csv correctly for the import?

Here is the Statement for export:
call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select RECORD_ID
                                          ,INPUTFILE_ID
                                          ,TMPST_IN
                                          ,TMPST_USED
                                          ,STATE
                                    from memo_records ',
                                   'memorecords.dat', '|', '"', 'utf8');
And here is my statement for import:
call syscs_util.syscs_import_table ('APP', 'MEMO_RECORDS', 'memorecords.dat', '|', '"', 'utf8',0);

I am using right now 10.8.2 needing to migrate down to 10.1.1.0 (crazy, isn't it?).
Got somebody an idea what I could do here to solve the problem?

Thanks a lot in advance

Malte

------------------------------------------------------------------------------------------------
Disclaimer: The contents of this electronic mail message are only binding upon Equens or its
affiliates, if the contents of the message are accompanied by a lawfully recognised type of
signature. The contents of this electronic mail message are privileged and confidential and
are intended only for use by the addressee. If you have received this electronic mail message
by error, please notify the sender and delete the message without taking notices of its content,
reproducing it and using it in any way. ------------------------------------------------------------------------------------------------

Mime
View raw message