MySQL Data Source hangs when testing

Hi,

I have BIRT running on my Mac OS X. I have ran it on several WinXP setups with no problem. I'm simply trying to connect BIRT to my local MySQL server -- I have no problem accessing the MySQL server through a different GUI tool.

The actual BIRT interface works fine. When I go to add a MySQL data source, however, it just hangs when I click "test connection". I can close the dialog by clicking "Finish", and it appears that it works, until I try to go to create a data set. The data set screen will not let me continue beyond the choosing data source screen.

I've made sure to add the most recent JDBC driver from mysql.com. I've also tried using older ones as well.

Anyone have a similar problem? I've heard of this occurring on other systems so I'm not sure if it's directly Mac related or not.

Find more posts tagged with

Comments

mwilliams

Hi andybaird,

What version of BIRT are you using? You're only having problems with the MAC machine, correct?

cyu

Hi there,

It's been a long way since the previous post. But I've run into the same kind of problem with BIRT 2.5.0. I'm working on Mac OSX 10.5.8.

The problem in the BIRT designer is, if I've got an incorrect Driver URL in the Data source configuration, the "Test Connection" will hang the application.

It has been really frustrating for me, considering that I am working on three/four database instances at the moment.

Is there any workaround to this problem?

Thanks in advance

stf

I encountered with the same problem using oracle.
There are no problems with the driver class, url,username/password, for they were successfully used to connect to oracle before.
Further more, the oracle account was locked when i entered a wrong name/password and clicked the "test connections" button for several times.

But when I close the design engine and open it again, it works well again.
why?