topic Re: 64 Bit JDBC driver installed and Select statement is disabled in QlikView

64 Bit JDBC driver installed and Select statement is disabled

Anonymous — Tue, 29 Jan 2013 00:47:48 GMT

Hi ,

I am trying to use 64 bit JDBC driver. After installing from the dowloads provided in QCommunity select button is disabled. Any one has any thoughts how to make it enable and proceed on using JDBC driver?.

I am trying to connect composite JDBC driver. Here is my jdbc connection string:

jdbc:compositesw:dbapi@CompD1-jiov:9401?domain=composite&dataSource=TestDataSource

Thanks

Dasu.G

Re: 64 Bit JDBC driver installed and Select statement is disabled

danielrozental — Tue, 29 Jan 2013 02:22:44 GMT

If the wizard isn't working for you, you can still write in the LOAD/SQL SELECT statement to the table you wan't to load.

You should try that.

Re: 64 Bit JDBC driver installed and Select statement is disabled

Anonymous — Tue, 29 Jan 2013 03:03:55 GMT

I tried to connect and I am getting below error:

No suitable driver found for jdbc:compositesw:dbapi@CompD1-jiov:9401

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:compositesw:dbapi@CompD1-jiov:9401?domain=composite&dataSource=DataSource;XUserId=AUOHATFNSbceVRRNJLZcGaNOBDbKWZFMTbcKGaNOfCZCGaFMWLaUHGD;XPassword=KUQHJSFMULYMXUJPSG;"

Re: 64 Bit JDBC driver installed and Select statement is disabled

avastani — Tue, 29 Jan 2013 03:35:14 GMT

use ODBC driver instead. Composite software is rolled in with an ODBC driver which is native read in QV via System DSN.

Re: 64 Bit JDBC driver installed and Select statement is disabled

Anonymous — Tue, 29 Jan 2013 15:16:39 GMT

Thank you for the response.

We have verified already with composite ODBC and It is working but it has some issues like after every select statement we wil have to disconnect and connect to the virtual database again and again.

See Below Thread:

http://community.qlik.com/message/303861#303861

Composite claimed that with JDBC this issue is not there so we want to validate and use this for our implementation.

Is there any way we can connect and retrieve data using JDBC in QlikView?.

Re: 64 Bit JDBC driver installed and Select statement is disabled

avastani — Tue, 29 Jan 2013 15:37:32 GMT

use for loop with where condition to get date limited records. jdbc, either will have to write a connector or get the one from QVSource

Re: 64 Bit JDBC driver installed and Select statement is disabled

rbecher — Wed, 30 Jan 2013 19:22:53 GMT

Hi,

you have to specify the driver class name:

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:compositesw:dbapi@CompD1-jiov:9401?domain=composite&dataSource=DatasourceName&connector.driverClass=cs.jdbc.driver.CompositeDriver;XUserId=YJCWATFNSbceVRRNJLZcGaNOBDbKWZFMTbcKGaNOfCZCGaFMWLaUHQMf;XPassword=RBbWESFMULYMXUJPbG;"

- Ralf