Jump to content
Changes to the Jaspersoft community edition download ×

can't connect to mysql - help


toms

Recommended Posts

As a topic

I use XP, Java SE 5.0, Apache and MySQL 5.0.19 and IReport 1.2.7.

MySQL started on 3307 port and Apache on 81 port.

I choosed this ports in connection condition but nothing.

I noticed that in /lib/ folder is a driver mysql-connector-java-3.1.11-bin. I dowloaded there mysql-connector-java-5.0.4-bin but still nothing. In other driver like sun.odbc.jdbc nothing too.

Maybe in iReports is place for ports configuration anywhere.

Any ideas?

Link to comment
Share on other sites

  • Replies 8
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

In iReports, across the top there is a Tab called “Dataâ€, then click “Connections/Datasourcesâ€. Then click “new†to set up a connection. I am using MS Sql Server, so your setting will vary.

 

[Name]=enter some name here, example myConnection

-

[Type of connection / datasource]=Database JDBC connection

-

[JDBC Driver]=look for a compatible driver name that you have

-

[JDBC URL]=jdbc:jtds:sqlserver://localhost:1467/udb_paperclickv4resolution;instance=

<the line above is exactly like mine, modify according, sorry about the Message emoticons showing up.>

-

[sever Address]=localhost:1467

<you maybe running on a different port#>

-

[Database]=udb_paperclickv4resolution

-

[username]=

[password]=

-

-

Once set up, you can click the “Test†button at the bottom,

** Note **

I have had to drop in the database driver *.jar file into the “……iReport-1.2.7lib†directory so that iReports can find the driver.

Good luck,

Wally

 

Post edited by: wallyneom, at: 2006/11/15 14:30

 

Post edited by: wallyneom, at: 2006/11/15 14:31

Post edited by: wallyneom, at: 2006/11/15 14:32

Link to comment
Share on other sites

Thanks for your reply.

I did all my best to establish connection.

Downloaded new drivers into /lib/ changed in various method data in connection properties but still I can't establish connection.

In attach I send my screen.

 

Thanks for all future advice why it doesn't work.

Link to comment
Share on other sites

Tom,

 

I am not using MySQL, so these are my best guesses.

 

--Your [JDBC URL] should look something like this;

 

jdbc:mysql://localhost:3307/yourDataBaseName

 

--Your [server Address] should look something like this;

 

localhost:3307

 

--Your [Database] should look like this;

 

yourDataBaseName

 

Give that a wirl.

Wally

Link to comment
Share on other sites

Thanks a lot

It was very simple.

DB "crm" is on 3307 port. Therefore connection properities should be jdbc:mysql://localhost:3307/crm

My foult was that after localhost I wrote the port of http server, not database.

 

Thanks willy.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...