Thank you Knut and Rick very much it now works a treat.
> Date: Tue, 12 Jan 2010 10:20:33 +0100 > From: Knut.Hatlen@Sun.COM > Subject: Re: Importing > To: email@example.com > > Glenn Ambrose <firstname.lastname@example.org> 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