search

crate / crate-jdbc

A JDBC driver for CrateDB.
https://crate.io/docs/jdbc/
Apache License 2.0
23 stars 29 forks source link

Cannot connect to Crate from Jaspersoft Studio #19

Closed mfelsche closed 10 years ago

mfelsche commented 10 years ago

reported by @megastef in issue #18:

But I get connection using connect string:

crate://localhost:4300

Netcat connects to TCP 4300. I tried also via my IP on the en0 interface ... loopback and en0 works. Now I upgraded to 0.38.3 - same message:

Crate 0.38.0 is running and listening to 4200/4300. But this is the exception I get a ClassNotFoundException: ...NoNodeAvailableException' in

io.crate.client.jdbc.CrateDriver.connect(CrateDriver.java:57)

The exception says that there is a missing class in the driver, when it tries to connect. Pls .check your build.

mfelsche commented 10 years ago

@megastef could you please provide the whole traceback and the config file and startup logs of the crate instance being run while getting this error?

megastef commented 10 years ago

I used crate-jdbc-1.0.3.jar Driver: io.crate.client.jdbc.CrateDriver Connect-String: crate://127.0.0.1:4300

This is the exception copied from Jspaer Window:

java.lang.NoClassDefFoundError: org/elasticsearch/client/transport/NoNodeAvailableException
    at io.crate.client.jdbc.CrateDriver.connect(CrateDriver.java:57)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:168)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128)
    at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:129)
    at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:163)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: java.lang.ClassNotFoundException: org.elasticsearch.client.transport.NoNodeAvailableException
    at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    ... 6 more

There is no log entry in CRATE server - regular startup messages. 

[2014-06-06 10:11:41,632][INFO ][node                     ] [Centurius] version[1.1.1], pid[13173], build[${build/NA]
[2014-06-06 10:11:41,632][INFO ][node                     ] [Centurius] initializing ...
[2014-06-06 10:11:41,714][INFO ][plugins                  ] [Centurius] loaded [blob, sql, udc, crate-core, admin-ui], sites [bigdesk, crate-admin, head, segmentspy]
[2014-06-06 10:11:41,995][INFO ][io.crate.module.CrateCoreModule] configuring crate. version: 0.38.3
[2014-06-06 10:11:44,189][INFO ][io.crate.rest.CrateRestFilter] Elasticsearch HTTP REST API not enabled
[2014-06-06 10:11:44,337][INFO ][node                     ] [Centurius] initialized
[2014-06-06 10:11:44,337][INFO ][node                     ] [Centurius] starting ...
[2014-06-06 10:11:44,338][INFO ][io.crate.blob.BlobService] [Centurius] BlobService.doStart() io.crate.blob.BlobService@f3ca40
[2014-06-06 10:11:44,389][INFO ][http                     ] [Centurius] bound_address {inet[/0:0:0:0:0:0:0:0:4200]}, publish_address {inet[/192.168.1.4:4200]}
[2014-06-06 10:11:44,424][INFO ][transport                ] [Centurius] bound_address {inet[/0:0:0:0:0:0:0:0:4300]}, publish_address {inet[/192.168.1.4:4300]}
[2014-06-06 10:11:47,445][INFO ][cluster.service          ] [Centurius] new_master [Centurius][avSs7cVzSSioMKtGhqaIgA][Stefans-iMac.local][inet[/192.168.1.4:4300]]{http_address=http://192.168.1.4:4200}, reason: zen-disco-join (elected_as_master)
[2014-06-06 10:11:47,464][INFO ][discovery                ] [Centurius] crate/avSs7cVzSSioMKtGhqaIgA
[2014-06-06 10:11:47,604][INFO ][gateway                  ] [Centurius] recovered [6] indices into cluster_state
[2014-06-06 10:11:47,606][INFO ][node                     ] [Centurius] started
seut commented 10 years ago

you need the crate-jdbc-standalone.jar which bundles the crate-client java resources. unfortunately the standalone download location is not documented yet, we'll document this asap. here is the link: http://dl.bintray.com/crate/crate/io/crate/crate-jdbc-standalone/1.0.3/crate-jdbc-standalone-1.0.3.jar sorry for pointing you to the wrong direction! ;-)

megastef commented 10 years ago

THX! Connection works!

seut commented 10 years ago

you're welcome :)