alexradzin / aerospike-jdbc-driver Goto Github PK

For some reason the latest Java 8 on macOS has a JDK version number of 13, and that seems to interfere with the build.

aerospike-jdbc-driver-master $ ./gradlew fatJar

FAILURE: Build failed with an exception.

* What went wrong:
Could not determine java version from '13'.

* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.

* Get more help at https://help.gradle.org
aerospike-jdbc-driver-master $ javac -version
javac 13

aerospike-jdbc-driver-master $ java -version
java version "13" 2019-09-17
Java(TM) SE Runtime Environment (build 13+33)
Java HotSpot(TM) 64-Bit Server VM (build 13+33, mixed mode, sharing)

Is there any way to publish compiled JAR?
as building on windows is a bit tricky, already spent an hour to figure out which version of JDK and JRE it requires.

c:\temp\aerospike-jdbc-driver>gradlew build

FAILURE: Build failed with an exception.

• What went wrong:
  Execution failed for task ':compileJava'.

Could not find tools.jar. Please check that C:\Program Files\Java\jre1.8.0_221 contains a valid JDK installation.

• Try:
  Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.

• Get more help at https://help.gradle.org

BUILD FAILED in 1s
1 actionable task: 1 executed

Hi,
I'm using DBeaver (Version 6.3.4.202002011957)
and trying to setup connection to aerospike using this aerospike-jdbc-driver
The connection is established correctly, the table browsers shows tables in the object tree view,
however any attempt to fetch data (for example select FIELD from NAMESPACE.Table;)
fails with the following exception:

org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:134)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:486)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:424)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:164)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:416)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:773)
at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:2886)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:110)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:164)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:108)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$17.run(ResultSetViewer.java:3468)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:103)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.sql.SQLException
at com.nosqldriver.util.SneakyThrower.call(SneakyThrower.java:35)
at com.nosqldriver.sql.JavascriptEngineFactory.(JavascriptEngineFactory.java:33)
at com.nosqldriver.aerospike.sql.AerospikeQueryFactory.(AerospikeQueryFactory.java:115)
at com.nosqldriver.aerospike.sql.AerospikeStatement.createQueryFactory(AerospikeStatement.java:514)
at com.nosqldriver.aerospike.sql.AerospikeStatement$StatementType$1.executeQuery(AerospikeStatement.java:58)
at com.nosqldriver.aerospike.sql.AerospikeStatement$StatementType$1.execute(AerospikeStatement.java:66)
at com.nosqldriver.aerospike.sql.AerospikeStatement.execute(AerospikeStatement.java:343)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:338)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)
... 12 more
Caused by: java.lang.NullPointerException
at com.nosqldriver.sql.JavascriptEngineFactory.lambda$new$0(JavascriptEngineFactory.java:46)
at com.nosqldriver.util.SneakyThrower.call(SneakyThrower.java:30)
... 20 more

Going thru the presentation I haven't seen any support for aerospike maps. To narrow it down I was thinking regarding readonly - SELECT only with Maps data available in SELECT FIELDs and WHERE filter fields.

example:
SELECT mapbinlocation[city] as city,mapbinlocation[country] as country where mapbinlocation[country]='USA'

Hi,

On every query there is an exception of "Fetch size other than 1 is not supported right now".
Which connection param should be set in order to make it work?

It seems that the connection string does not support non-standard port (it hard-coded uses 3000).
I assume the connection string should look something like SQL Server's URL in order for this to work (looking at the url parsing code):
jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

This will allow adding ports and later even security features such as user/password.