db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ali Demir <dem...@yahoo.com>
Subject Re: CSV export
Date Thu, 16 Feb 2006 07:22:10 GMT
Use exact case for table name. Uppercase usually. "ABC.XYZ"
Regards,
Ali


At 11:18 PM 2/15/2006, you wrote:

>Hi Andrej,
>
>exportTable also will not dump the table header. Functionally it is same 
>as exportQuery, just different interfaces to the users.
>
>It is puzzling me also how you are able to export using exportQuery 
>successfully  but not through the exportTable, by quick look at the code I 
>could not find how that could happen. Underneath exportTable just forms a 
>select query based on the table names and the schema name.
>
>Are you passing the same connection object to both the exportTable and the 
>exportQuery ? By any chance the connection you are passing to these 
>functions  has different default schema name than what the XYZ table was 
>created with ?
>
>
> From looking at your code snippet looks like you are calling internal 
> export functions directly, I think they are not supposed to be called by 
> an application directly. This functionality is available to the users 
> through System procedures SYSCS_UTIL.SYSCS_EXPORT_TABLE and 
> SYSCS_UTIL.SYSCS_EXPORT_QUERY.
>
>more info in the docs at:
>http://db.apache.org/derby/docs/10.1/tools/rtoolsimport92876.html
>
>Thanks
>-suresh
>
>Andrej Tibaut wrote:
>>Hi all!
>>Could please someone help me with the following problem. In database I have
>>a table that I need
>>to export into CSV format.
>>If I use these lines
>>try {
>>   Export.exportQuery(conn,"SELECT * FROM XYZ", "c:/export.txt", ",", "\"",
>>"iso-8859-2");
>>} catch (Exception e) {}
>>I get the data in table in CSV format. However, this is only data in table
>>without table header (of
>>course, based on SQL statement).
>>So, if I use these lines (I guess that exportTable returns also the table
>>header)
>>try {
>>   Export.exportTable(conn, null, "XYZ", "c:/export.txt", ",", "\"",
>>"iso-8859-2");
>>} catch (Exception e) {}
>>I get the following exception:
>>SQL Exception: Table 'XYZ' does not exist.
>>With lines
>>try {
>>   Export.exportTable(conn, null, "abc.XYZ", "c:/export.txt", ",", "\"",
>>"iso-8859-2");
>>} catch (Exception e) {}
>>I get the following exception:
>>SQL Exception: Table 'abc.XYZ' does not exist.
>>And, with lines
>>try {
>>   Export.exportTable(conn, "abc", "XYZ", "c:/export.txt", ",", "\"",
>>"iso-8859-2");
>>} catch (Exception e) {}
>>I get the following exception:
>>SQL Exception: Schema 'abc' does not exist.
>>What should I use? And, additional question: does exportTable returns also
>>table
>>header?
>>
>>Thanks in advance!
>>Andrej
>>
>



Mime
View raw message