db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Glenn Ambrose <glennambr...@hotmail.com>
Subject RE: Importing
Date Tue, 12 Jan 2010 10:39:10 GMT

Thank you Knut and Rick very much it now works a treat.

Cheers
Glenn

> Date: Tue, 12 Jan 2010 10:20:33 +0100
> From: Knut.Hatlen@Sun.COM
> Subject: Re: Importing
> To: derby-user@db.apache.org
> 
> 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
 		 	   		  
_________________________________________________________________
Time for a new car? Sell your old one fast!
http://clk.atdmt.com/NMN/go/157637060/direct/01/
Mime
View raw message