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 <mario.biso...@vimar.com> 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:* 'user@manifoldcf.apache.org' > *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:daddy...@gmail.com <daddy...@gmail.com>] > *Inviato:* lunedì 15 settembre 2014 16:26 > > *A:* user@manifoldcf.apache.org > *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 <mario.biso...@vimar.com> > 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:daddy...@gmail.com] > *Inviato:* lunedì 15 settembre 2014 16:21 > > > *A:* user@manifoldcf.apache.org > *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 <mario.biso...@vimar.com> > 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:daddy...@gmail.com] > *Inviato:* lunedì 15 settembre 2014 16:04 > *A:* user@manifoldcf.apache.org > *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 <mario.biso...@vimar.com> > 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* > > > > > > >
