[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 |
Description |
The error is "column not found" each time you try to access one of the menu items above.
|
Comments |
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 |