Jaspersoft Studio v5.5.0 will not display tables

Hi,

I am using Jaspersoft Studio 5.5.0. I don't know why i can't select table from Datasorce. It don't show list tables when i double click TABLE on datasource.

With this datasource if  i use Ireport 5.5.0, it will return result very good.

Please help me!

Nhut

nhutnhut79's picture
Joined: Mar 21 2013 - 8:38am
Last seen: 6 years 5 months ago

2 Answers:

Hi,
this is a known problem that has already been fixed. You are probably using MySQL or MS SQL. Since we can not release an official build yet, we will start providing temporary beta/integration versions.
I think that by the end of the day, or tomorrow a build 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.

Best regards,
Massimo. 

P.S: you can still enter the query manually how it was done in the previous versions of JSS (prior to 5.2.0). However please check the location later today or tomorrow, in order to have a temporary workaround.

mrabbi's picture
24977
Joined: Oct 31 2011 - 9:20am
Last seen: 1 day 2 hours ago

Thanks Mrabbi, but i am using window 32bit. "https://sourceforge.net/projects/jasperstudio/files/beta-release/" for windows 64bit. When run the JaspersoftStudio.exe i get a message "JaspersoftStudio.exe is not a valid win32 application". Please help me pass this!

nhutnhut79 - 9 years 9 months ago

Hi, are you sure you downloaded the correct package for win32?
This is the correct one: http://sourceforge.net/projects/jasperstudio/files/beta-release/packages...

I've just checked into a Windows XP 32 bit Virtual Machine: it installs and runs fine.

Best regards,
Massimo.

mrabbi - 9 years 9 months ago

I tried the version 5.6.0 of Jasperstudio, I use MySQL as the database, it is now possible to see the tables could not see before, but when making inquiries with this visual diagram puts quotes to sql language which marks Error since MySQL does not accept the SELECT field, field FROM table with the quotes and you need to remove them manually. Schedule an example:    

SELECT "sicdatos"."transfcfe_mstr"."no_transbanco",
    "sicdatos"."transfcfe_mstr"."no_bancotransf",
    "sicdatos"."transfcfe_mstr"."no_cuentacfe",
    "sicdatos"."transfcfe_mstr"."arch_foto",
    "sicdatos"."transfcfe_mstr"."fecha_censo"
FROM "sicdatos"."transfcfe_mstr"

as you can see put quotes and quotes should not take for MySQL.

 

Thank you.

 

apozaso's picture
32
Joined: Oct 18 2013 - 6:03pm
Last seen: 1 year 10 months ago
Feedback
randomness