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)

Oracle JDBC Job Error

2020-01-05 Thread Cihad Guzel
Hi, I try JDBC connector with Oracle (version: 11.2.0.4). I added to classpath ojdbc6.jar. My seed query as follows: "SELECT PERSONID AS $(IDCOLUMN) FROM PERSON" and I have an error as follow: "Error: Bad seed query; doesn't return $(IDCOLUMN) column. Try using quotes around $(IDCOLUMN)