Re: Oracle JDBC Job Error

2020-01-06 Thread Karl Wright
Hi Cihad, You need to change the query. The code is perfectly fine. Follow the instructions: Try using quotes around $(IDCOLUMN) variable, e.g. \" $(IDCOLUMN)\" . Your query should look like this: SELECT PERSONID AS "$(IDCOLUMN)" FROM PERSON Karl On Mon, Jan 6, 2020 at 7:50 PM Cihad Guzel

Re: Oracle JDBC Job Error

2020-01-06 Thread Cihad Guzel
Hi, I have debugged the MFC-2.15 codes and caught the problem. JDBCConnector.java line:270 Object o = row.getValue(JDBCConstants.idReturnColumnName); if (o == null) throw new ManifoldCFException("Bad seed query; doesn't return $(IDCOLUMN) column. Try using quotes around $(IDCOLUMN)