Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Question about mysql connector installation and configuration:(Install Birt in remote host)
Question about mysql connector installation and configuration: [message #668328] Thu, 05 May 2011 09:03 Go to next message
gin1975  is currently offline gin1975 Friend
Messages: 30
Registered: April 2011
Member
Hello,

I have a question about the installation of a series of reports that I've configured and tested on my localhost and i want to install to another environment.

In my local environment, I have installed xampp and mysql java connector needed to connect jdbc. Example of DataSource's database url: jdbc: mysql: / / localhost: 3306/db_name. The mysql java contector it's installed in "C: \ xampp \ mysql \ mysql-connector-java-01.05.1915".

In the another environment where I want to install and configure BIRT reports should be connected remotely to mysql databases. It means that the DataSource's database url should be like this: jdbc: mysql: / / remote_host: 3306/db_name. I think that this machine should connect to the DB as long as it has connectivity to the remote host, ie, understand that making a "telnet remote_host 3306". My question is where to install the mysql java connector. Should I install it on a local path of the machine and select when creating the MySQL Datasource? Is there any additional evidence to be carried out in order to check the correct jdbc connectivity?

Thank you very much
Re: Question about mysql connector installation and configuration: [message #668417 is a reply to message #668328] Thu, 05 May 2011 15:13 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You can specify the full path to the driver in the data source but you
can also just copy it to the jdbc plugin/drivers directory.

Jason

On 5/5/2011 5:03 AM, gin1975 wrote:
> Hello,
>
> I have a question about the installation of a series of reports that
> I've configured and tested on my localhost and i want to install to
> another environment.
>
> In my local environment, I have installed xampp and mysql java connector
> needed to connect jdbc. Example of DataSource's database url: jdbc:
> mysql: / / localhost: 3306/db_name. The mysql java contector it's
> installed in "C: \ xampp \ mysql \ mysql-connector-java-01.05.1915".
>
> In the another environment where I want to install and configure BIRT
> reports should be connected remotely to mysql databases. It means that
> the DataSource's database url should be like this: jdbc: mysql: / /
> remote_host: 3306/db_name. I think that this machine should connect to
> the DB as long as it has connectivity to the remote host, ie, understand
> that making a "telnet remote_host 3306". My question is where to install
> the mysql java connector. Should I install it on a local path of the
> machine and select when creating the MySQL Datasource? Is there any
> additional evidence to be carried out in order to check the correct jdbc
> connectivity?
>
> Thank you very much
Previous Topic:how to create log to debug
Next Topic:Page numbers in table headers
Goto Forum:
  


Current Time: Wed Apr 24 18:11:28 GMT 2024

Powered by FUDForum. Page generated in 0.02178 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top