[SPAGOBI-635] Error using mysql-connector-java-5.1.xxx for spagobi mysql metadata database, on LOV, Checks, Analytical drivers, Engines etc. GUI's lists. Created: 12/Jul/11  Updated: 09/Jul/12  Resolved: 12/Jul/11

Status: Closed
Project: SpagoBI
Component/s: SERVER/Core
Affects Version/s: 3.0.0
Fix Version/s: 3.1.0

Type: Bug Priority: Major
Reporter: Monica Franceschini Assignee: Monica Franceschini
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

The error is "column not found" each time you try to access one of the menu items above.

Comment by Monica Franceschini [ 12/Jul/11 ]
To solve this bug, simply edit your server.xml spagobi resource tag as follows:
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" name="jdbc/spagobi" url="jdbc:mysql://localhost/spagobi?useOldAliasMetadataBehavior=true"................/>.
This enables use of aliases as in mysql drivers older than 5.1.
Comment by Monica Franceschini [ 12/Jul/11 ]
Edit JNDI spagobi url, by adding parameter: useOldAliasMetadataBehavior=true
Comment by slava slava [ 09/Jul/12 ]
The parameter doesn't work for version 3.4.0 of Spagobi
Mysql connector version 5.1.21
Generated at Sat Oct 01 04:55:16 CEST 2022 using JIRA 7.2.2#72004-sha1:9d5132893cc8c728a3601a9034a1f8547ef5c7be.