Re: How to connect Java/JDBC with Connection Manag

Posted in 2013

Summary

User asked how to connect Java/JDBC to Informix with Connection Manager from a Windows client when the server is on AIX. Solution: Create a sqlhosts file locally on Windows, set SQLH_FILE parameter in JDBC connection URL, and install Informix CSDK on Windows client. For dbaccess access, use setnet32 to define the server.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Java & JDBC Development

JINMING XIAO — Mon, 08 Jul 2013 19:55:48 — source: IIUG Forums & Mailing Lists

Yes, it's on the JDBC side, create the sqlhosts file and in the url set SQLH_FILE pointing to it. for example String url ="jdbc:informix-sqli:/sysmaster:informixserver=oltp;use r=informix;password=xxxxxxxx;SQLH_TYPE=FILE;SQLH_FILE=c:\\\\\\\\informix\\\\\\\\jdbc\\\\\\\\test\\\\\\\\ sqlhosts.cm"; my sqlhosts file oltp group - - i=100,e=oltp2 oltp1 onsoctcp mach1 9910 g=oltp oltp2 onsoctcp mach1 9920 g=oltp and the test program can connect.

↪ replying to JINMING XIAO

O KHAN — Mon, 08 Jul 2013 20:39:25 — source: IIUG Forums & Mailing Lists

Hi, Just a little confused, you might be able to help me. As my client is running in Windows OS, and my Informix server & CM is on AIX. So if I want to connect it from client using JDBC, then do I need to have both client SDK installed on Windows and I also have to do make the sqlhosts file locally on windows? Or by simply having created the sqlhosts file is sufficient?

↪ replying to O KHAN

Link, David — Mon, 08 Jul 2013 20:52:40 — source: IIUG Forums & Mailing Lists

You will need the version of the Java jar which supports this syntax and you will need the sqlhost file on your windows server. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of O KHAN Sent: Monday, July 08, 2013 3:39 PM To: ids@iiug.org Subject: Re: How to connect Java/JDBC with Connection Manag [30788] Hi, Just a little confused, you might be able to help me. As my client is running in Windows OS, and my Informix server & CM is on AIX. So if I want to connect it from client using JDBC, then do I need to have both client SDK installed on Windows and I also have to do make the sqlhosts file locally on windows? Or by simply having created the sqlhosts file is sufficient? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to O KHAN

Art Kagel — Mon, 08 Jul 2013 21:11:56 — source: IIUG Forums & Mailing Lists

You need the CSDK in order to get the ODBC/JDBC drivers, so, both. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jul 8, 2013 at 4:39 PM, O KHAN <theultimateboy@hotmail.com> wrote: > Hi, > > Just a little confused, you might be able to help me. > > As my client is running in Windows OS, and my Informix server & CM is on > AIX. > > So if I want to connect it from client using JDBC, then do I need to have > both > client SDK installed on Windows and I also have to do make the sqlhosts > file > locally on windows? > > Or by simply having created the sqlhosts file is sufficient? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b342c90570a4c04e1067df7

↪ replying to Art Kagel

O KHAN — Thu, 11 Jul 2013 14:05:24 — source: IIUG Forums & Mailing Lists

Hi Art, I dont think that JDBC is part of windows CSDK, I have installed (Informix CSDK 4.10 TC1DE) and I am unable to find the JDBC driver. Also, after installing the CSDK, I am unable to find the dbaccess as well on my windows client side. Do i need to perform anything extra to be able to use dbaccess with Informix CSDK? Thanks. Regards, Khan

↪ replying to O KHAN

Art Kagel — Thu, 11 Jul 2013 14:31:56 — source: IIUG Forums & Mailing Lists

To use dbaccess you need to define the server using setnet32. My understanding is that JDBC uses the ODBC driver which is included in the CSDK. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jul 11, 2013 at 10:05 AM, O KHAN <theultimateboy@hotmail.com> wrote: > Hi Art, > > I dont think that JDBC is part of windows CSDK, I have installed (Informix > CSDK 4.10 TC1DE) and I am unable to find the JDBC driver. > > Also, after installing the CSDK, I am unable to find the dbaccess as well > on > my windows client side. > > Do i need to perform anything extra to be able to use dbaccess with > Informix > CSDK? > > Thanks. > > Regards, > Khan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b3439a4d3a31504e13d4062

Glossary

sqlhosts