iReport to conect with Informix but don\'t list fields

[fabiobasso]

Hi,

 

  I need to connect the Informix Database (11.50). The connection in the "Database JDBC connection" is ok, when click in the button "Test", show the message "Connection test succesful!", but for to create a new report, in the windows "Report query", show the message: "Error: SQL Problems: Database not selected yet."

[jimmo]

Does your database contain CLOBs? Ours does and we had to include the table name and column name in double quotes:

 

select "column1","column2" from "tablename"

[mdahlman]

fabiobasso,

I don't know Informix. With MySQL this is a valid url:
jdbc:mysql://localhost

But it's uncommon. The test will work fine. But it won't work when I try to select * from some_table. A more common (and better) url is this with a database specified:
jdbc:mysql://localhost/foodmart

What is your JDBC url? Does it specify a database?

Regards,
Matt

[fabiobasso]

Hi,

 

  My URL is jdbc:informix-sqli://192.168.0.242:1527:informixserver=dadfiasini

[fabiobasso]

Hi,

 

  The problem was the url... :)

  incorrect: jdbc:informix-sqli://192.168.0.242:1525:informixserver=prdfiasini

  correct: incorrect: jdbc:informix-sqli://192.168.0.242:1525:informixserver=prdfiasini

 

Thanks for all

[gramberg]

Hi,

 

what was the correct URL ?

you posted the incorrect version twice