[FIXED] Trying to connect to IBM's Informix docker edition with JDBC

Issue

I’m trying to write some Java tests for Informix. I have the docker running from here:

https://hub.docker.com/r/ibmcom/informix-developer-database/

I cannot find any example of the JDBC connection string to use to connect to it.

I used this to run it: docker run -it –name ifx -h ifx –privileged -p 9088:9088 -p 9089:9089 -p 27017:27017 -p 27018:27018 -p 27883:27883 -e LICENSE=accept ibmcom/informix-developer-database:latest

I’m trying this jdbc:informix-sqli://localhost:9088/sysmaster:INFORMIXSERVER=ifx with their default username and password, but I’m getting "INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES."

I also tried with INFORMIXSERVER=dev – same error.

Does anyone know what the JDBC URL would be for this docker image?

Solution

You can use the following JDBC URL string:

jdbc:informix-sqli://localhost:9088/sysmaster:INFORMIXSERVER=informix

You can check the correct value to use for the INFORMIXSERVER parameter as follows:

  1. Connect to your Docker instance as follows:
docker exec -it ifx bash
  1. At the command line, check the contents of the sqlhosts file:
cat $INFORMIXDIR/etc/sqlhosts

You will see something similar to this (assuming a vanilla Docker installation):

############################################################
### DO NOT MODIFY THIS COMMENT SECTION
### HOST NAME = 6b4943a932ab
############################################################
informix        onsoctcp        *6b4943a932ab         9088
informix_dr     drsoctcp        *6b4943a932ab         9089

The entry for port 9088 has the name informix.

Answered By – andrewJames

Answer Checked By – Gilberto Lyons (Easybugfix Admin)

Leave a Reply

(*) Required, Your email will not be published