Glenn Ambrose <[email protected]> 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
