You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@manifoldcf.apache.org by Bisonti Mario <Ma...@vimar.com> on 2014/09/15 15:32:29 UTC
Connection status:Threw exception: 'Driver class not found:
com.mysql.jdbc.Driver'
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
Re: Connection status:Threw exception: 'Driver class not found: com.mysql.jdbc.Driver'
Posted by Karl Wright <da...@gmail.com>.
Hi Mario,
Register and log in, and then you can attach a comment.
Karl
On Tue, Sep 16, 2014 at 8:34 AM, Bisonti Mario <Ma...@vimar.com>
wrote:
> MySql Version : '5.5.38'
>
>
>
> ManifoldCF : 1.7
>
>
>
> The problem still remains with single quote ‘ ‘
>
>
>
> How could I attach a comment to the ticket, please?
>
>
>
>
>
> *Mario*
>
>
>
>
>
>
>
>
>
> *Da:* Karl Wright [mailto:daddywri@gmail.com]
> *Inviato:* martedì 16 settembre 2014 14:05
>
> *A:* user@manifoldcf.apache.org
> *Oggetto:* Re: Connection status:Threw exception: 'Driver class not
> found: com.mysql.jdbc.Driver'
>
>
>
> Hi Mario,
>
> I've create CONNECTORS-1032 to track your issue. MySQL queries have
> worked fine in the past against MySQL 5.5. So I suggest that you try
> single-quotes, and if that does not work either, we're going to have to
> have more information and some debugging time.
>
> First -- what version of MySQL is this?
> Second, what version of MCF are you working with?
>
> I will propose a debugging output patch that will let us see what the
> column names the JDBC query is returning if I have that information.
> Please attach it as a comment to the ticket.
>
> Thanks,
> Karl
>
>
>
> On Tue, Sep 16, 2014 at 7:59 AM, Bisonti Mario <Ma...@vimar.com>
> wrote:
>
> Yes, it works, and “ “ aren’t necessary.
>
>
>
> Note this:
> from MySql Client
>
> SELECT command_id AS $(IDCOLUMN) FROM icinga_commands
> not work
> instead
> SELECT command_id AS “$(IDCOLUMN)” FROM icinga_commands
>
> Works.
>
> So it seems that “ “ are necessary, but when I use insiede ManifoldCF it
> doesn’t work with “ “
>
>
>
>
>
> Mario
>
>
>
>
>
>
>
> *Da:* Karl Wright [mailto:daddywri@gmail.com]
> *Inviato:* martedì 16 settembre 2014 13:50
>
>
> *A:* user@manifoldcf.apache.org
> *Oggetto:* Re: Connection status:Threw exception: 'Driver class not
> found: com.mysql.jdbc.Driver'
>
>
>
> 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 <Ma...@vimar.com>
> 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:daddywri@gmail.com]
> *Inviato:* martedì 16 settembre 2014 12:17
>
>
> *A:* user@manifoldcf.apache.org
> *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 <Ma...@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:daddywri@gmail.com <da...@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 <Ma...@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:daddywri@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 <Ma...@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:daddywri@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 <Ma...@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*
>
>
>
>
>
>
>
>
>
>
>
>
>
R: Connection status:Threw exception: 'Driver class not found:
com.mysql.jdbc.Driver'
Posted by Bisonti Mario <Ma...@vimar.com>.
MySql Version : '5.5.38'
ManifoldCF : 1.7
The problem still remains with single quote ‘ ‘
How could I attach a comment to the ticket, please?
Mario
Da: Karl Wright [mailto:daddywri@gmail.com]
Inviato: martedì 16 settembre 2014 14:05
A: user@manifoldcf.apache.org
Oggetto: Re: Connection status:Threw exception: 'Driver class not found: com.mysql.jdbc.Driver'
Hi Mario,
I've create CONNECTORS-1032 to track your issue. MySQL queries have worked fine in the past against MySQL 5.5. So I suggest that you try single-quotes, and if that does not work either, we're going to have to have more information and some debugging time.
First -- what version of MySQL is this?
Second, what version of MCF are you working with?
I will propose a debugging output patch that will let us see what the column names the JDBC query is returning if I have that information. Please attach it as a comment to the ticket.
Thanks,
Karl
On Tue, Sep 16, 2014 at 7:59 AM, Bisonti Mario <Ma...@vimar.com>> wrote:
Yes, it works, and “ “ aren’t necessary.
Note this:
from MySql Client
SELECT command_id AS $(IDCOLUMN) FROM icinga_commands
not work
instead
SELECT command_id AS “$(IDCOLUMN)” FROM icinga_commands
Works.
So it seems that “ “ are necessary, but when I use insiede ManifoldCF it doesn’t work with “ “
Mario
Da: Karl Wright [mailto:daddywri@gmail.com<ma...@gmail.com>]
Inviato: martedì 16 settembre 2014 13:50
A: user@manifoldcf.apache.org<ma...@manifoldcf.apache.org>
Oggetto: Re: Connection status:Threw exception: 'Driver class not found: com.mysql.jdbc.Driver'
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 <Ma...@vimar.com>> 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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: martedì 16 settembre 2014 12:17
A: user@manifoldcf.apache.org<ma...@manifoldcf.apache.org>
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 <Ma...@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<ma...@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:daddywri@gmail.com]
Inviato: lunedì 15 settembre 2014 16:26
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:21
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:04
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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
Re: Connection status:Threw exception: 'Driver class not found: com.mysql.jdbc.Driver'
Posted by Karl Wright <da...@gmail.com>.
Hi Mario,
I've create CONNECTORS-1032 to track your issue. MySQL queries have worked
fine in the past against MySQL 5.5. So I suggest that you try
single-quotes, and if that does not work either, we're going to have to
have more information and some debugging time.
First -- what version of MySQL is this?
Second, what version of MCF are you working with?
I will propose a debugging output patch that will let us see what the
column names the JDBC query is returning if I have that information.
Please attach it as a comment to the ticket.
Thanks,
Karl
On Tue, Sep 16, 2014 at 7:59 AM, Bisonti Mario <Ma...@vimar.com>
wrote:
> Yes, it works, and “ “ aren’t necessary.
>
>
>
> Note this:
> from MySql Client
>
> SELECT command_id AS $(IDCOLUMN) FROM icinga_commands
> not work
> instead
> SELECT command_id AS “$(IDCOLUMN)” FROM icinga_commands
>
> Works.
>
> So it seems that “ “ are necessary, but when I use insiede ManifoldCF it
> doesn’t work with “ “
>
>
>
>
>
> Mario
>
>
>
>
>
>
>
> *Da:* Karl Wright [mailto:daddywri@gmail.com]
> *Inviato:* martedì 16 settembre 2014 13:50
>
> *A:* user@manifoldcf.apache.org
> *Oggetto:* Re: Connection status:Threw exception: 'Driver class not
> found: com.mysql.jdbc.Driver'
>
>
>
> 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 <Ma...@vimar.com>
> 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:daddywri@gmail.com]
> *Inviato:* martedì 16 settembre 2014 12:17
>
>
> *A:* user@manifoldcf.apache.org
> *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 <Ma...@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:daddywri@gmail.com <da...@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 <Ma...@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:daddywri@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 <Ma...@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:daddywri@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 <Ma...@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*
>
>
>
>
>
>
>
>
>
>
>
R: Connection status:Threw exception: 'Driver class not found:
com.mysql.jdbc.Driver'
Posted by Bisonti Mario <Ma...@vimar.com>.
Yes, it works, and “ “ aren’t necessary.
Note this:
from MySql Client
SELECT command_id AS $(IDCOLUMN) FROM icinga_commands
not work
instead
SELECT command_id AS “$(IDCOLUMN)” FROM icinga_commands
Works.
So it seems that “ “ are necessary, but when I use insiede ManifoldCF it doesn’t work with “ “
Mario
Da: Karl Wright [mailto:daddywri@gmail.com]
Inviato: martedì 16 settembre 2014 13:50
A: user@manifoldcf.apache.org
Oggetto: Re: Connection status:Threw exception: 'Driver class not found: com.mysql.jdbc.Driver'
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 <Ma...@vimar.com>> 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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: martedì 16 settembre 2014 12:17
A: user@manifoldcf.apache.org<ma...@manifoldcf.apache.org>
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 <Ma...@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<ma...@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:daddywri@gmail.com]
Inviato: lunedì 15 settembre 2014 16:26
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:21
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:04
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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
Re: Connection status:Threw exception: 'Driver class not found: com.mysql.jdbc.Driver'
Posted by Karl Wright <da...@gmail.com>.
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 <Ma...@vimar.com>
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:daddywri@gmail.com]
> *Inviato:* martedì 16 settembre 2014 12:17
>
> *A:* user@manifoldcf.apache.org
> *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 <Ma...@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:daddywri@gmail.com <da...@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 <Ma...@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:daddywri@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 <Ma...@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:daddywri@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 <Ma...@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*
>
>
>
>
>
>
>
>
>
R: Connection status:Threw exception: 'Driver class not found:
com.mysql.jdbc.Driver'
Posted by Bisonti Mario <Ma...@vimar.com>.
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:daddywri@gmail.com]
Inviato: martedì 16 settembre 2014 12:17
A: user@manifoldcf.apache.org
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 <Ma...@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<ma...@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:daddywri@gmail.com]
Inviato: lunedì 15 settembre 2014 16:26
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:21
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:04
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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
Re: Connection status:Threw exception: 'Driver class not found: com.mysql.jdbc.Driver'
Posted by Karl Wright <da...@gmail.com>.
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 <Ma...@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:daddywri@gmail.com <da...@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 <Ma...@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:daddywri@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 <Ma...@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:daddywri@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 <Ma...@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*
>
>
>
>
>
>
>
R: Connection status:Threw exception: 'Driver class not found:
com.mysql.jdbc.Driver'
Posted by Bisonti Mario <Ma...@vimar.com>.
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:daddywri@gmail.com]
Inviato: lunedì 15 settembre 2014 16:26
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:21
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:04
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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
R: Connection status:Threw exception: 'Driver class not found:
com.mysql.jdbc.Driver'
Posted by Bisonti Mario <Ma...@vimar.com>.
Thanks a lot!
Connection now is working!
Mario
Da: Karl Wright [mailto:daddywri@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:21
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:04
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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
Re: Connection status:Threw exception: 'Driver class not found: com.mysql.jdbc.Driver'
Posted by Karl Wright <da...@gmail.com>.
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 <Ma...@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:daddywri@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 <Ma...@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:daddywri@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 <Ma...@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*
>
>
>
>
>
R: Connection status:Threw exception: 'Driver class not found:
com.mysql.jdbc.Driver'
Posted by Bisonti Mario <Ma...@vimar.com>.
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:daddywri@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 <Ma...@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:daddywri@gmail.com<ma...@gmail.com>]
Inviato: lunedì 15 settembre 2014 16:04
A: user@manifoldcf.apache.org<ma...@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 <Ma...@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
Re: Connection status:Threw exception: 'Driver class not found: com.mysql.jdbc.Driver'
Posted by Karl Wright <da...@gmail.com>.
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 <Ma...@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:daddywri@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 <Ma...@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*
>
>
>
R: Connection status:Threw exception: 'Driver class not found:
com.mysql.jdbc.Driver'
Posted by Bisonti Mario <Ma...@vimar.com>.
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:daddywri@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 <Ma...@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
Re: Connection status:Threw exception: 'Driver class not found: com.mysql.jdbc.Driver'
Posted by Karl Wright <da...@gmail.com>.
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 <Ma...@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*
>