db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Importing
Date Tue, 12 Jan 2010 09:20:33 GMT
Glenn Ambrose <glennambrose@hotmail.com> writes:

> This is what happens when you don't subscribe first.
>
> Replying to Rick (thanks for the response)
>
> Hi Glenn,
>
> It doesn't look to me like you are putting single quotes around the file 
> name when you construct the statement which calls SYSCS_IMPORT_TABLE. 
> The file name is a string argument to the procedure and so needs to be 
> single-quoted.
>
> Hope this helps,
> -Rick
>
> I added single quotes to the file name
>
> carrier.execute(
>             "CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (null,'elements'," +
>                     "'" + dataSource + "'" + ",null,null,null,0)"
>             );
>
> Now I get a different error message
>
> Exception in thread "main" java.sql.SQLException: Table 'ROOT.elements' does
> not exist. 

Try 'ELEMENTS' instead of 'elements'. Derby converts unquoted
identifiers to upper case internally, and the arguments to
SYSCS_IMPORT_TABLE must exactly match the canonical form of the
identifier.

-- 
Knut Anders

Mime
View raw message