Forum

General discussion on using the Kognitio Analytical Platform.
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Where can I download a JDBC driver for Kognitio?

by markc » Fri Aug 23, 2013 4:32 pm

I need a JDBC driver on Linux - is one available? Is there something available for Windows as well?

NOTE: THE INFORMATION IN THIS POST REFERS TO THE DEPRECATED JDBC BRIDGE - SEE http://kognitio.com/forums/viewtopic.php?f=4&t=427 FOR INFORMATION ON THE JDBC DRIVER WHICH REPLACES IT
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Where can I download a JDBC driver for Kognitio?

by markc » Fri Aug 23, 2013 4:34 pm

JDBC bridge

Kognitio provides JDBC connectivity via a bridge product which can be installed on Linux or Windows, as discussed below.

You can download the JDBC bridge installer for Linux from http://www.kognitio.com/forums/latest_8 ... _bridge.sh. This is a self-extracting executable, so you should just download it, put the file on a Linux machine, and run the file. The current version is 2.0.5.1006. If you already have an older version of the bridge installed, just specify the directory you installed that to when installing the new version, and the old version will be replaced.

Note that if you are going from an older bridge that used a Kognitio.jar file on the client, you will need to update all clients with the relevant jar file - see the JDBC client section at the end of this post.

Note that if you have an ODBC driver older than the 8.1.0rel161109b version on the JDBC bridge node, you will need to install an 8.1.0rel161109b or later ODBC driver to use with the bridge

The JDBC bridge installer for Windows (current version 2.0.5.1006) can be downloaded from http://www.kognitio.com/forums/latest_8 ... bridge.zip.

An overview of how to use these installers can be downloaded from http://www.kognitio.com/forums/Kognitio ... rview.docx.

The JDBC-ODBC bridge software can be freely distributed provided that it is only used against a Kognitio data source.

JDBC client

Having installed the JDBC bridge, client side installation is covered by the document at http://www.kognitio.com/forums/Kognitio ... rview.docx. This will include downloading the relevant JAR file, although now the file to use depends on the client's version of Java.

Run "java -version" on the client to determine the version, then download In addition, older versions of the client used com.kognitio.jdbc.Driver as the class name of the JDBC driver, but now you should use
  • com.kognitio.jdbc4.Driver if you are using Java version 8
  • com.kognitio.jdbc41.Driver if you are using Java version 7
  • com.kognitio.jdbc42.Driver if you are using Java version 6
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Where can I download a JDBC driver for Kognitio?

by markc » Thu Feb 20, 2014 2:55 pm

If you have any issues with the JDBC bridge, you can collect extra information by switching on debug options.

Simba have some useful documentation on this which can be found at http://www.simba.com/wp-content/uploads ... -Guide.pdf (Simba produce the Kognitio JDBC bridge as well as many other JDBC offerings for other third parties).

Specifically, the LogLevel can be changed to provide more logging, and LogDirectory can be set to a writable directory. Also, if the bridge has been set up to run as a service, there is information on stopping and starting it manually to see if any diagnostic information is generated.
Reply with quote Top
deborahmartin

Can I use the bridge to connect to more than one KAP instanc

by deborahmartin » Tue Feb 28, 2017 11:56 am

Prerequisites : This article assumes that the JDBC-ODBC bridge from Kognitio is installed and running successfully.

See http://kognitio.com/forums/viewtopic.php?f=4&t=89 for details on obtaining, installing and configuring the JDBC-ODBC bridge if this hasn’t already been done.

It is also assumed that the JDBC-ODBC bridge is visible to all the KAP instances it needs to connect to. Typically, a JDBC-ODBC bridge is installed to connect to one KAP instance. But for the configuration below to work, the JDBC-ODBC bridge node must be visible to all the KAP instances defined in the odbc.ini file to work successfully.

Q: Is it possible to have clients use one single JDBC-ODBC bridge instance to connect to different KAP instances ?
A: Yes.

Q: How would I achieve this ?
A: On the JDBC-ODBC bridge node , which, for simplicity, we’ll assume has been installed and running on Linux

Edit the .simbaserver.d2o.ini file and add the following parameter to this file

AllowClientConfiguredDSN=true ; This allows the client to choose which KAP instance it will connect to

Comment out the following parameter using a semi-colon at the start of the line to disable the static DSN

; ServerDSN=<DSN>

NOTE: The "ListenPort=" parameter should not be disabled. However, you can still change the port number if required

You MUST restart the JDBC-ODBC bridge for the above changes to take effect

On the same node, ensure your odbc.ini file contains all the DSN's for the KAP instances that will be used through the JDBC-ODBC
bridge.

Example DSN entries in odbc.ini file

[kap01]
RandomServerAddress=Y
ServerAddress1=172.17.10.64; IP address of KAP01 instance
Driver=/opt/kognitio/wx2/current/lib/Linux64/libwcsodbc_utf16.so
SSLEnabled=N
Timeout=30

[kap02]
RandomServerAddress=Y
ServerAddress1=172.17.10.54; IP address of KAP02 instance
Driver=/opt/kognitio/wx2/current/lib/Linux64/libwcsodbc_utf16.so
SSLEnabled=N
Timeout=30

Where "[kap01]" and "[kap02]" is used purely as an example and should be changed for your KAP instances
Where "Driver=" specfies the location of the Kognitio ODBC Driver

On the client

Normally the connection string would be something like

jdbc:kognitio://<ip_address_JDBC-ODBC_bridge_node>:<port>

And this would force the client to connect to the KAP instance defined by the "ServerDSN" parameter in the ".simba.d2oserver.ini" file using
the port defined by the "ListenPort=" parameter in the same file.

By disabling the "ServerDSN=" parameter and enabling AllowClientConfiguredDSN to true, control is now given to the client as to which KAP
instance you can connect to. You simply need to amend your client’s connection string to also include the DSN that was defined in the
odbc.ini file on the JDBC-ODBC bridge node

jdbc:kognitio://<ip_address_JDBC-ODBC_bridge_node>:<port>;ServerDSN=kap01

jdbc:kognitio://<ip_address_JDBC-ODBC_bridge_node>:<port>;ServerDSN=kap02

So, for every distinct KAP instance you want a client to connect to, it now just has to be added to the odbc.ini file that resides on the
JDBC-ODBC bridge node.

No further restarts of the bridge should be necessary unless you are making any other changes to your “.simbaserver.d2o.ini” file.
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron