datasource succes, but no fields

[icet18]

Hi,

Im using the ireport plugin for netbeans (and a mysql database with type innodb). now when im useing ireport i can connect to the database using the wizard. everything works fine!

But when i want to create a report, i use the sql statement:

-----------------------------------

use test;
select * from customer;

------------------------------------

I'm getting an Mysql Error. What i'm doing wrong?

________________________________________________________________

Query error
 
Message:
    net.sf.jasperreports.engine.JRException: SQL problems:
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 'select * from customer' at line 2
Level:
    SEVERE
Stack Trace:
SQL problems: 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 'select * from customer' at line 2
    com.jaspersoft.ireport.designer.data.fieldsproviders.SQLFieldsProvider.getFields(SQLFieldsProvider.java:360)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.readFields(JDBCConnection.java:479)
    com.jaspersoft.ireport.designer.wizards.ConnectionSelectionWizardPanel.validate(ConnectionSelectionWizardPanel.java:126)
    org.openide.WizardDescriptor$7.run(WizardDescriptor.java:1357)
    org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
    org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)

---------------------------------------------------------------------------------------------------------------------

Thanks for your help!

iceT

[svenn]

Never tried it but I doubt that it can handle mutiple SQL commands.