mysql test data adapter works, but no metadata

[marcat]

I created a mysql data adapter in Studio 5.5 and when I click 'Test', I get the 'Successful' message.  In fact, I can see the connection in mysql when I type 'show processlist'.  However, in the Report Wizard, when I select that data adapter, it doesn't list the tables -- there is no Metadata at all (even after double clicking).  If I manually type in a query, I can get results, so the connection is definitely working.

I tried using a user with more privileges, but I still get no metadata in the report wizard.  I also tried using a newer (currently the newest) mysql driver from Oracle.  I don't see any errors in either the Error view or in the workspace .metadata/.log file.  Is there another location I can look?

Any ideas what I am missing?

Thanks.

[chicuslavic]

I fixed the problem yerstaday, mysql use catalogs not schemas

you will get the fix with next update

[fancellu]

I'm seeing this too. Any ETA on a fix? Is this a new bug? Don't a previous version work ok? I can't believe that Jaspersoft studio never worked with MySQL, its quite a commonly used database. Thanks.

[Massimo Rabbi]

Hi,

we actually don't have any date for the next release. It will probably be in synch with a JR one. Not sure when.

This bug was related to the new SQL Editor that was introduced since version 5.2.0, so a relative new feature. Some bugs like this are being fixed while discovered.

 

Best regards,

Massimo.

 

 

[marcat]

Is there any chance you can release an update to just this plugin?

[atartakovsky]

It seems it will essentially render product unusable for all mysql community - any workarounds/patches/class replacements you can offer? Is there particular class/implementation we may override in JDBC jar to become "compliant"?

 

[glenn.smith]

This bug makes JR almost unuseable : am evaluating on Win7 and am ready to drop this product - it's *SO* laborious to have to write a complex SQL just to get the columns from a 5-table database...

[Massimo Rabbi]

Hi all,

we started providing temporary beta/integration versions.

They will be available here: https://sourceforge.net/projects/jasperstudio/files/beta-release/

 

The packages folder will contain the product files for the different platforms as usual.

The updatesite folder will contain the update site content for the plug-in version.

Please read the README in the sourceforge location.

 

Please recall, that the SQL editor available can not be considered as a fully replacement for tools like DbVisualizer, SquirrelSQL, TOAD or similar softwares. In JSS we are trying to give the ability to compose query in a graphical way. Moreover we try to provide support for common SQL syntax, and not database specific.

Therefore if you need to create a very complex query it can happen that the internal SQL editor is not enough, and you will have to use one of the mentioned tools.

Plus you can still enter the query manually how it was done in the previous versions of JSS (prior to 5.2.0). I would not define it as "unuseable".

 

Best regards,

Massimo.

[lmbaptista]

Someone can tell me what happening since I'm using Studio 5.6.2 and this problem persists?