Query Designer produces broken output - iReport Designer - Jaspersoft Community

Jump to content

Query Designer produces broken output
By stevenell

April 5, 2010
Share

Followers 0
Assigned User Giulio Toffoli

CategoryBug report

PriorityNormal

ReproducibilityAlways

ResolutionOpen

SeverityMinor

StatusAssigned
there seems to be a 16 char limit on some of the output strings produced by the query designer... for instance... this is sql code i generated from the query designer

SELECT
COMPANYMASTER."COMPANYCODE" AS COMPANYMASTER_CO,
COMPANYMASTER."COMPANY_NAME" AS COMPANYMASTER_CO
FROM
"my-db"."COMPANYMASTER" COMPANYMASTER

so that code doesnt work because of the identical aliases... it should look like this

SELECT
COMPANYMASTER."COMPANYCODE" AS COMPANYMASTER_COMPANYCODE,
COMPANYMASTER."COMPANY_NAME" AS COMPANYMASTER_COMPANY_NAME
FROM
"my-db"."COMPANYMASTER" COMPANYMASTER
Share
Followers 0
Go to bugs

User Feedback
1 Comment
Recommended Comments

stevenell 0

Posted April 23, 2010

Share this comment

The 16 char limit is probably coming from the JDBC driver for our specific database... these issues don't occur when I test the report designer against MySQL.

I reported this issue to our database vendor... their response:
"...there is nothing in the driver that would cause this unless iReport is using max column size value to truncate aliases. The max column size is 16, but that doesn't affect the size of aliases..." They are still looking into it.. i will let you know if I hear anything else from them.

Link to comment

Share on other sites

×

×

Create New...