[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 |