EstablishingJCC connections for IDS
While working with the open beta of IBMData Server Developer Workbench 9.5 , I noticed that inaddition to that product you also become open beta participants for theJava Common Client (JCC) driver. In fact, the Workbench uses the JCCdriver by default. On the one hand, this is absolutely great, because ithelps you see where IBM's long range direction is with clients. On theother hand, JCC requires some special setup on the IDS instance level.This article will detail how to setup you instance to handle JCCconnections, and then will use the Developer Workbench to show how youconnect using JCC.
Whathappened to my SQLI?The reason why JCC connections require engine configuration changes isthe default means by which IDS instance communicate is through the SQLIprotocol, whereas JCC needs the DRDA protocol. Currently IDS does notallow for both SQLI and DRDA to connect through the same listenerthread, so this means is we need to configure a listener thread andport to accept DRDA calls.
This is done by making a simple change to the SQLHOSTS file as shownbelow:
<instance name> drsoctcp<hostname> <service/port>
<instance name> drsipcshm<hostname> <service/port>
As you can see the protocols look the same as our old ones, exceptinstead of the prefix ol,you use dr.
And full example is below:
cheetah_dr drsoctcp gofishsqlexec2
After changing the SQLHOST all you need to do is place this entry in youonconfig file, in the DBSERVERALIASES variable. So if you use theexample SQLHOSTS entry above and had no aliases currently you wouldhave the following in you onconfig file:
Now just bring your instance off-line and then back on-line, and then weare ready to use the Developer Workbench.
Setting up yourJCC Driver for 11.10 in Developer Workbench 9.5Now that you have set your IDS instance up to accept JCC driverconnections, let's establish one using the Developer Workbench 9.5
In your Database Explorer window, select Connection->New Connectionas below:
This will bring you to the Connection Settings window. Below is anexample of the JCC driver with all field filled in:
As you can see, you do not need an INFORMIXSERVER for your connection,just the Database, Host and Port Number. Once you configure this foryour server, just click the TestConnection button. After that just click the Finish button. Younow have a JCC connection that you can use for your Applicationrunning against IDS 11.10