Morning,

jai un probleme pour configurer spagobi with spagobi.j'utilise spagobi 5.0.
Pour ma configuration, je commence à ajouter un nouveau data source.voici comment je configure mo, datasource mysql

Label: Testmysql
Description: Connexion en base Mysql
Dialect: Mysql
Multischema: (vide)
Read only: Read and write
Write Default: (vide)
Type: Jdbc
URL: jdbc:mysql://localhost:3306/foodmart
User: root
Password: root

Je l'enregistre
afrès j'ajoute un nouveau dataset

Label: Test
Name: Test
Description: (vide)
Category: (vide)
Scope: public / user


DataSet Type: Query
Data source: TestMysql
Query: select * from customer

quand je clique sur preview pour executer ma requete.this is an error when i see

An unexpected error occured while executing dataset: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1 Query statement: [select * from customer]
however i query execute correctly in mysql editor.
when i try with qbe.I have error when i want to execute to spagobi server.
this an error

An unexpected error occured while executing dataset: No content to map due to

end-of-input at [Source: java.io.StringReader@14aa78c; line: 1, column: 1]

A noter que j'ai déjà mentionner ceci dans le server.xml
<Resource name="jdbc/foodmart" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/foodmart"/>


merci de votre aide