Hi Mario, What's happening is that the JDBC connector cannot find the proper column in the resultset.
Can you do the following in the mysql client: SELECT command_id AS lcf__id FROM icinga_commands Please let me know what the returned columns are. If there is not a column that precisely matches "lcf__id" then that explains the error. Karl On Tue, Sep 16, 2014 at 7:41 AM, Bisonti Mario <[email protected]> wrote: > Yes, but I obtained the same error. > > > > SELECT command_id AS “$(IDCOLUMN)” FROM icinga_commands > > I tried the query SELECT command_id AS $(IDCOLUMN) FROM icinga_commands > by a MySql Client and it works. > > > > > > > > > > > > > > > > *Da:* Karl Wright [mailto:[email protected]] > *Inviato:* martedì 16 settembre 2014 12:17 > > *A:* [email protected] > *Oggetto:* Re: Connection status:Threw exception: 'Driver class not > found: com.mysql.jdbc.Driver' > > > > Hi Mario, > > Did you try putting quotes in your query around "$(IDCOLUMN)" as it > suggests? For some databases this is necessary to preserve case properly. > > Karl > > > > On Tue, Sep 16, 2014 at 4:53 AM, Bisonti Mario <[email protected]> > wrote: > > When I start a test job to extract a table I obtain: > > > > Error: Bad seed query; doesn't return $(IDCOLUMN) column. Try using quotes > around $(IDCOLUMN) variable, e.g. "$(IDCOLUMN)". > > > > My configuration: > > > > Seeding query: > > SELECT command_id AS $(IDCOLUMN) FROM icinga_commands > > > > Data query: > SELECT command_id AS $(IDCOLUMN), command_line AS $(URLCOLUMN),object_id > AS $(DATACOLUMN) FROM icinga_commands where command_id IN $(IDLIST) > > > > What could I check? > > > > Thanks a lot > > > > Mario > > > > > > *Da:* Bisonti Mario > *Inviato:* martedì 16 settembre 2014 09:58 > *A:* '[email protected]' > *Oggetto:* R: Connection status:Threw exception: 'Driver class not found: > com.mysql.jdbc.Driver' > > > > Thanks a lot! > > > > Connection now is working! > > > > Mario > > > > > > > > *Da:* Karl Wright [mailto:[email protected] <[email protected]>] > *Inviato:* lunedì 15 settembre 2014 16:26 > > > *A:* [email protected] > *Oggetto:* Re: Connection status:Threw exception: 'Driver class not > found: com.mysql.jdbc.Driver' > > > > Hi Mario, > > You can download the -src and -lib distribution, and then run "ant > make-deps build", and you should be able to use proprietary MySQL database > connections. > > Thanks, > Karl > > > > On Mon, Sep 15, 2014 at 10:24 AM, Bisonti Mario <[email protected]> > wrote: > > I understood. > > > > Infact, I haven’t example-proprietary because I use a binary version of > ManifoldCF so i can’t use MySQL as repository connection. > > > > Thanks a lot. > > > > > > > > > > *Da:* Karl Wright [mailto:[email protected]] > *Inviato:* lunedì 15 settembre 2014 16:21 > > > *A:* [email protected] > *Oggetto:* Re: Connection status:Threw exception: 'Driver class not > found: com.mysql.jdbc.Driver' > > > > Hi Mario, > > cd /usr/share/manifoldcf/example-proprietary > sudo java –jar start.jar > > If you do not have example-proprietary, it is because you did not actually > build ManifoldCF yourself. In order to use MySQL as a backend, you must > build ManifoldCF yourself. > > Thanks, > Karl > > > > On Mon, Sep 15, 2014 at 10:14 AM, Bisonti Mario <[email protected]> > wrote: > > I am on > > /usr/share/manifoldcf/example/ > > and I execute: sudo java –jar start.jar > > > > Instead *mysql-connector-java-5.1.32-bin.jar is in > /usr/share/manifoldcf/connector-lib-proprietary/* > > *So, how could I run ManifoldCF ?* > > *Excuse me but I am not a linux expertise…* > > *Thanks a lot.* > > > > > > > > *Da:* Karl Wright [mailto:[email protected]] > *Inviato:* lunedì 15 settembre 2014 16:04 > *A:* [email protected] > *Oggetto:* Re: Connection status:Threw exception: 'Driver class not > found: com.mysql.jdbc.Driver' > > > > Hi Mario, > > You need to run ManifoldCF out of one of the example-proprietary > directories in order for it to pick up the mysql jar in the classpath. > > Thanks, > Karl > > > > On Mon, Sep 15, 2014 at 9:32 AM, Bisonti Mario <[email protected]> > wrote: > > > > > > *Hallo.* > > > > *I tried to setup a mysql repository connection but I obtain the error > mentioned.* > > > > *I put mysql-connector-java-5.1.32-bin.jar in * > > */apache-manifoldcf-1.7/connector-lib-proprietary* > > *and* > > */apache-manifoldcf-1.7/lib-proprietary* > > *folder but I obtain the error in the object* > > > > *What could I check?* > > > > *Thanks a lot* > > > > *Mario* > > > > > > > > >
