Hi,

I have an Informix database on my pc which is named INNO040. My
database server is called ol_inno040. When installing Informix, 3
databases where created on my server by the installation process. Using
dbaccess I, created a 4th database called testpush on this server.

I have a Java program that creates tables in my testpush database. For
connecting to the database I use the connection string
"jdbc:informix-sqli://INNO040:1526:informixserver=ol_inno040"
But when I then execute the statement "create table ..." using the
classes in the java.sql package, I get the error:
"Database not selected yet". I understand the problem: ol_inno040
contains 4 databases and JDBC does not know in which one it has to
create the tables. But how do I specify the database that I want to use
in JDBC?

Any ideas?
Veerle