Informix and JDBC versions compatibility
Igor A. Walter
Does anybody know if the Informix On Line Database version 7.12.UC1
supports Informix JDBC driver 1.22.JC1? Which daemons should be running
on AIX to listen to JDBC connections and on which port?
Any other JDBC I could use to acces this DBMS?
uname -a gives me:
AIX host 2 3 002124004800
TIA, Igor
--
(opinions stated are not necessarily those of my employer)
Allan Gould
> Does anybody know if the Informix On Line Database version 7.12.UC1
> supports Informix JDBC driver 1.22.JC1? Which daemons should be running
> on AIX to listen to JDBC connections and on which port?
>
> Any other JDBC I could use to acces this DBMS?
>
> uname -a gives me:
> AIX host 2 3 002124004800
You could try our JDBC driver: SCO SQL-Retriever. Take a look at
http://www.sco.com/vision/products/sqlretriever/ for more information
and a downloadable eval. It works fine on AIX 3.2.5 (which is I think
what you have) against Informix 7.
Allan Gould
SCO CID Support, Leeds, UK
(allang at sco dot com)
(Please remove anti-spam measures if replying)
n sopha
"Igor A. Walter" <iawa...@my-dejanews.com> wrote:
>Hi,>
>Does anybody know if the Informix On Line Database version 7.12.UC1
>supports Informix JDBC driver 1.22.JC1? Which daemons should be running
>on AIX to listen to JDBC connections and on which port?
>
>Any other JDBC I could use to acces this DBMS?
>
>uname -a gives me:
>AIX host 2 3 002124004800
>
>
>--
>(opinions stated are not necessarily those of my employer)
>
>
I have no problem using this version of jdbc (version 1.40
is also available for download) with the Dynamic Server 7.x.
I believe this jdbc allow you a direct connect to the Informix server
provided that you got port number and server name correctly formatted.
there is an example come with the driver that's very helpful...
at first i had problem with classpath...but that's quite easy to fix
-----------------** -- Posted from CodeGuru -- **-----------------
http://www.codeguru.com/java The website for Java programmers.
Igor A. Walter
I can identify the following problems:
-all docs refer to Informix Dynamic Server 7.x, Informix SE 5.x or Informix
On line Server 5.x. We have Informix On Line server 7.x, what should it
correspond to? Is it an unsupported version of Informix ?
- I guess we should have a daemon listening to a specific port (in examples
it's always 1533) in order to connect with JDBC. The doc shows how to launch
a lib/sqlexecd daemon but we don't have it. We have lib/sqlrm, is it the
equivalent? [I hope sqlrm stands for remote sql and not rm sql. :) ] Or
should we launch bin/sqldemo?
Below, the ouptut of ps-ef on AIX 3.2.5 and the Java test error messages
(It's JDBC driver 1.22JC1, we have just downloaded the version 1.40).
Thanks, Igor
that's the output from one demo:
>>>Create Database test.
URL =
"jdbc:informix-sqli://host:1533:informixserver=dbserver_tcp;user=userName;password=pwd;TRACE=3;PROTOCOLTRACE=2"
ERROR: failed to connect!
ERROR: Attempt to connect to database server (%s) failed.
java.sql.SQLException: Attempt to connect to database server (%s) failed.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:160)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:346)
at com.informix.jdbc.IfxDriver.connect(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java:141)
at CreateDB.main(CreateDB.java:58)
------------------------------------------------------------
USER PID PPID C STIME TTY TIME CMD
root 1 0 0 Nov 30 - 44:29 /etc/init
root 1315 1 0 Nov 30 - 0:00 /etc/srcmstr
root 1591 4926 0 12:30:02 - 0:00 telnetd
root 1837 1315 0 Nov 30 - 1:24 /etc/syslogd
root 2817 1 0 Nov 30 - 14:22 /etc/syncd 60
root 3376 1315 0 Nov 30 - 0:47 /usr/lib/sendmail -bd -q30m
root 3587 1 0 Nov 30 - 0:00 /usr/lib/errdemon
root 4673 1315 0 Nov 30 - 5:47 /usr/sbin/snmpd
root 4926 1315 0 Nov 30 - 0:15 /etc/inetd
root 5191 1 1 Nov 30 - 7148:54 /usr/informix/bin/oninit
root 5448 5191 0 Nov 30 - 46:50 /usr/informix/bin/oninit
root 5705 5191 0 Nov 30 - 39:07 /usr/informix/bin/oninit
root 5962 5191 1 Nov 30 - 39:17 /usr/informix/bin/oninit
root 6219 5191 0 Nov 30 - 39:26 /usr/informix/bin/oninit
root 6476 5191 0 Nov 30 - 0:13 /usr/informix/bin/oninit
root 6733 5191 0 Nov 30 - 39:13 /usr/informix/bin/oninit
root 6990 5191 0 Nov 30 - 39:26 /usr/informix/bin/oninit
root 7247 5191 0 Nov 30 - 39:33 /usr/informix/bin/oninit
root 7504 5191 0 Nov 30 - 39:49 /usr/informix/bin/oninit
root 7761 5191 0 Nov 30 - 39:15 /usr/informix/bin/oninit
root 8020 1 0 Nov 30 - 3:49 /etc/cron
root 8282 1 0 Nov 30 - 0:00 /etc/uprintfd
root 8534 1315 0 Nov 30 - 0:16 /etc/qdaemon
root 8793 1315 0 Nov 30 - 0:00 /etc/writesrv
root 9052 1 0 Nov 30 ? 0:00 /etc/getty /dev/pts/10
root 9309 1 0 Nov 30 ? 0:00 /etc/getty /dev/pts/11
root 9566 1 0 Nov 30 ? 0:00 /etc/getty /dev/pts/12
root 9823 1 0 Nov 30 ? 0:00 /etc/getty /dev/pts/13
myComp 10038 1 0 05:57:22 - 0:00 /project/myComp/bin/Trace -N
Trace
myComp 10306 1 0 05:57:26 - 0:07 HOM
root 10602 1 0 Nov 30 - 7:25 ./pciconsvr.ip -D0 -L0 -b
root 10857 1 0 Nov 30 - 7:19 ./pcimapsvr.ip -D0
myComp 11077 1 0 05:57:26 - 0:02 DSM
myComp 11441 16044 2 09:31:13 pts/2 1:06 OPP
myComp 11595 1 0 05:57:34 - 0:33 /project/myComp/bin/Trace -N
TraceTOM
informix 12091 13112 2 12:30:59 pts/0 0:00 ps -ef
myComp 12788 13555 0 11:34:36 pts/1 0:00 -ksh
myComp 12860 1 0 05:57:25 - 4:04 TOM
informix 13112 1591 0 12:30:06 pts/0 0:00 -ksh
root 13555 4926 0 11:34:34 - 0:00 telnetd
myComp 14137 1 0 05:57:25 - 1:06 NT_Driver
/project/myComp/etc/NT_Driver.cfg
myComp 14619 16922 0 05:22:04 - 0:00
/project/myComp/bin/Net_Server
myComp 14920 1 0 05:57:26 - 0:18
/project/myComp/bin/TMS_Supervisor
myComp 15155 1 0 05:57:19 - 0:27 SLP -i -P
myComp 15377 1 0 05:22:01 - 0:02
/project/myComp/bin/Net_Server
myComp 16044 16555 0 09:31:01 pts/2 0:00 -ksh
myComp 16153 15377 0 05:22:02 - 0:00
/project/myComp/bin/Net_Server
root 16555 4926 0 09:30:58 - 0:00 telnetd
root 16859 1 0 Feb 01 0 0:00 /etc/getty /dev/console
myComp 16922 15377 0 05:22:04 - 0:00
/project/myComp/bin/Net_Server
myComp 17174 1 0 05:22:01 - 0:00
/project/myComp/bin/MMS_Supervisor -zFALSE
myComp 17659 12788 2 11:46:00 pts/1 0:17 OPP
myComp 17727 1 0 05:57:25 - 0:20 TOM_TrChck
myComp 17990 14137 0 05:57:26 - 0:08 NT_Driver
/project/myComp/etc/NT_Driver.cfg
n sopha wrote:
> "Igor A. Walter" <iawa...@my-dejanews.com> wrote:
> >Hi,>
> >Does anybody know if the Informix On Line Database version 7.12.UC1
> >supports Informix JDBC driver 1.22.JC1? Which daemons should be running
> >on AIX to listen to JDBC connections and on which port?
> >
>
Rico Jansen
>> Does anybody know if the Informix On Line Database version 7.12.UC1
>> supports Informix JDBC driver 1.22.JC1? Which daemons should be running
>> on AIX to listen to JDBC connections and on which port?
Make sure you have tcp connections type in sqlhosts
Also the URL should look something like :
jdbc:informix-sqli://$HOST:$PORT/$DBM:informixserver=digitaal1;user=wwwtech
Where host,port are the ip and port where your server is and dbm is the database
and 'digitaal1' is your server name.
Also they are at 1.40 now
You can also look at examples.informix.com, they have a connect example there.
--
Rico Jansen (ri...@vpro.nl)
http://james.vpro.nl/ James a Webserver in Java.
"You call it untidy, I call it LRU ordered" -- Daniel Barlow
Igor A. Walter
>
> Make sure you have tcp connections type in sqlhosts
What do you mean by that? All we have is an entry like:
dbserver_tcp onipcshm agvs xyz
>
> You can also look at examples.informix.com, they have a connect example there.
Thank you, Igor.