Database connector for CASSANDRA

Stephane_MERLE · March 5, 2015, 10:36am

Hi,

I just install my first VM with lucee (been using railo for now ), and I
would like to try the cassandra BDD to replace MSSQL … is there a simple
way to setup the connector ?

Thanks for your help

Stéphane

Chris_Blackwell · March 5, 2015, 10:55am

I’ve never used Cassandra, but a quick google turns up a jdbc compliant
driver. So thats where i’d start
https://code.google.com/a/apache-extras.org/p/cassandra-jdbc/

install that, along with any dependencies in your /lib directory, restart
lucee/tomcat and then create a datasource of type “Other” with a type
of “org.apache.cassandra.cql.jdbc.CassandraDriver”.

Igal · March 5, 2015, 5:17pm

a couple of pitfalls that you might want to avoid:

the jdbc driver requires several files and they should all be in your
classpath (unlike most drivers that keep all the prerequisites in one jar).
the connection string in the SO link that you posted contains
exemplary, unneeded, arguments, for example it specifies multiple hosts,
multiple datacenters, and most importantly a “database” named
“keyspace1” which if you don’t have (and there’s a good chance you
don’t) will throw an unrelated error message which will throw you in a
wild goose chase.

you can easily define a datasource named “cassandra” by adding this into
your Application.cfc body assuming localhost, port 9160, and a database
named “test”:

this.datasources.cassandra = {
class: ‘org.apache.cassandra.cql.jdbc.CassandraDriver’
,connectionString:
‘jdbc:cassandra://localhost:9160/test?consistency=QUORUM’
};

Igal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/On 3/5/2015 3:52 AM, Stéphane MERLE wrote:

“From there, you’ll have to experiment and see what happens”
this is where I got stuck

expecially with the connection string … I found :
java - Using Apache Cassandra In Coldfusion - Stack Overflow
I try to experiment around this … with no luck for now … I was
expecting something as simple as MSSQL connectors …sic …

Thanks for your help !!

Stéphane

Le jeudi 5 mars 2015 11:56:28 UTC+1, Chris Blackwell a écrit :
I've never used Cassandra, but a quick google turns up a jdbc
compliant driver.  So thats where i'd start
https://code.google.com/a/apache-extras.org/p/cassandra-jdbc/
<https://code.google.com/a/apache-extras.org/p/cassandra-jdbc/>

install that, along with any dependencies in your /lib directory,
restart lucee/tomcat and then create a datasource of type "Other"
with a type of "org.apache.cassandra.cql.jdbc.CassandraDriver".

From there, you'll have to experiment and see what happens




On 5 March 2015 at 10:36, Stéphane MERLE <stephan...@gmail.com <javascript:>> wrote:

    Hi,

    I just install my first VM with lucee (been using railo for
    now ;) ), and I would like to try the cassandra BDD to replace
    MSSQL ... is there a simple way to setup the connector ?

    http://cassandra.apache.org/

    Thanks for your help

    Stéphane
    -- 
    You received this message because you are subscribed to the
    Google Groups "Lucee" group.
    To unsubscribe from this group and stop receiving emails from
    it, send an email to lucee+un...@googlegroups.com <javascript:>.
    To post to this group, send email to lu...@googlegroups.com
    <javascript:>.
    To view this discussion on the web visit
    https://groups.google.com/d/msgid/lucee/a04008ac-f36d-4553-a689-a984d2dec509%40googlegroups.com
    <https://groups.google.com/d/msgid/lucee/a04008ac-f36d-4553-a689-a984d2dec509%40googlegroups.com?utm_medium=email&utm_source=footer>.
    For more options, visit https://groups.google.com/d/optout
    <https://groups.google.com/d/optout>.
–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+unsubscribe@googlegroups.com
mailto:lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com
mailto:lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/5dd792bb-cf51-4132-9799-6bac1d4ae9ff%40googlegroups.com
https://groups.google.com/d/msgid/lucee/5dd792bb-cf51-4132-9799-6bac1d4ae9ff%40googlegroups.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.

Stephane_MERLE · March 6, 2015, 11:41am

Thanks IGAL,

for 1) I think I did good …
for 2) I use the admin connection manager like that the dev doesnt get too
much informations on the production databases … but I get this error
after validating :

org.apache.thrift.transport.TTransportException: Cannot write to null
outputStream

I use :

CLASS : org.apache.cassandra.cql.jdbc.CassandraDriver
Connection String : jdbc:cassandra://IPV4:9160/mykeyspace?consistency=QUORUM

where ipv4 is the ip of the cassandra server (only one for now)
I am assuming that TEST is the keyspace, which I created with the name :
“mykeyspace” so this should work …

my main problem is to know if it’s a cassandra config error or
railo/lucee/jdbc …for now, there is NO firewall between the 2 serveurs …

StéphaneLe jeudi 5 mars 2015 18:17:47 UTC+1, Igal a écrit :

a couple of pitfalls that you might want to avoid:

the jdbc driver requires several files and they should all be in your
classpath (unlike most drivers that keep all the prerequisites in one jar).

the connection string in the SO link that you posted contains
exemplary, unneeded, arguments, for example it specifies multiple hosts,
multiple datacenters, and most importantly a “database” named “keyspace1”
which if you don’t have (and there’s a good chance you don’t) will throw an
unrelated error message which will throw you in a wild goose chase.

you can easily define a datasource named “cassandra” by adding this into
your Application.cfc body assuming localhost, port 9160, and a database
named “test”:

this.datasources.cassandra = {
class: ‘org.apache.cassandra.cql.jdbc.CassandraDriver’
,connectionString:
‘jdbc:cassandra://localhost:9160/test?consistency=QUORUM’
};

Igal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/
On 3/5/2015 3:52 AM, Stéphane MERLE wrote:

“From there, you’ll have to experiment and see what happens”
this is where I got stuck

expecially with the connection string … I found :
java - Using Apache Cassandra In Coldfusion - Stack Overflow
I try to experiment around this … with no luck for now … I was
expecting something as simple as MSSQL connectors …sic …

Thanks for your help !!

Stéphane

Le jeudi 5 mars 2015 11:56:28 UTC+1, Chris Blackwell a écrit :

I’ve never used Cassandra, but a quick google turns up a jdbc compliant
driver. So thats where i’d start
Google Code Archive - Long-term storage for Google Code Project Hosting.

install that, along with any dependencies in your /lib directory,
restart lucee/tomcat and then create a datasource of type “Other” with a
type of “org.apache.cassandra.cql.jdbc.CassandraDriver”.

From there, you’ll have to experiment and see what happens

On 5 March 2015 at 10:36, Stéphane MERLE stephan...@gmail.com wrote:

Hi,

I just install my first VM with lucee (been using railo for now ),
and I would like to try the cassandra BDD to replace MSSQL … is there a
simple way to setup the connector ?

http://cassandra.apache.org/

Thanks for your help

Stéphane

You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/a04008ac-f36d-4553-a689-a984d2dec509%40googlegroups.com
https://groups.google.com/d/msgid/lucee/a04008ac-f36d-4553-a689-a984d2dec509%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/5dd792bb-cf51-4132-9799-6bac1d4ae9ff%40googlegroups.com
https://groups.google.com/d/msgid/lucee/5dd792bb-cf51-4132-9799-6bac1d4ae9ff%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

Igal · March 6, 2015, 3:34pm

yes, “test” was a keyspace in that example.

do you have a full stacktrace of the error? please post it.

Igal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/On 3/6/2015 3:41 AM, Stéphane MERLE wrote:

Thanks IGAL,

for 1) I think I did good …
for 2) I use the admin connection manager like that the dev doesnt get
too much informations on the production databases … but I get this
error after validating :

org.apache.thrift.transport.TTransportException: Cannot write to null
outputStream

I use :

CLASS : org.apache.cassandra.cql.jdbc.CassandraDriver
Connection String
: jdbc:cassandra://IPV4:9160/mykeyspace?consistency=QUORUM

where ipv4 is the ip of the cassandra server (only one for now)
I am assuming that TEST is the keyspace, which I created with the name
: “mykeyspace” so this should work …

my main problem is to know if it’s a cassandra config error or
railo/lucee/jdbc …for now, there is NO firewall between the 2
serveurs …

Stéphane

Le jeudi 5 mars 2015 18:17:47 UTC+1, Igal a écrit :

a couple of pitfalls that you might want to avoid:

1) the jdbc driver requires several files and they should all be
in your classpath (unlike most drivers that keep all the
prerequisites in one jar).

2) the connection string in the SO link that you posted contains
exemplary, unneeded, arguments, for example it specifies multiple
hosts, multiple datacenters, and most importantly a "database"
named "keyspace1" which if you don't have (and there's a good
chance you don't) will throw an unrelated error message which will
throw you in a wild goose chase.

you can easily define a datasource named "cassandra" by adding
this into your Application.cfc body assuming localhost, port 9160,
and a database named "test":

  this.datasources.cassandra = {
     class: 'org.apache.cassandra.cql.jdbc.CassandraDriver'
    ,connectionString:
'jdbc:cassandra://localhost:9160/test?consistency=QUORUM'
  };


Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>

On 3/5/2015 3:52 AM, Stéphane MERLE wrote:

"From there, you'll have to experiment and see what happens"
this is where I got stuck ;)

expecially with the connection string ... I found :
http://stackoverflow.com/questions/26584607/using-apache-cassandra-in-coldfusion
<http://stackoverflow.com/questions/26584607/using-apache-cassandra-in-coldfusion>
I try to experiment around this ... with no luck for now ... I
was expecting something as simple as MSSQL connectors ....sic ...

Thanks for your help !!

Stéphane



Le jeudi 5 mars 2015 11:56:28 UTC+1, Chris Blackwell a écrit :

    I've never used Cassandra, but a quick google turns up a jdbc
    compliant driver.  So thats where i'd start
    https://code.google.com/a/apache-extras.org/p/cassandra-jdbc/
    <https://code.google.com/a/apache-extras.org/p/cassandra-jdbc/>

    install that, along with any dependencies in your /lib
    directory, restart lucee/tomcat and then create a datasource
    of type "Other" with a type
    of "org.apache.cassandra.cql.jdbc.CassandraDriver".

    From there, you'll have to experiment and see what happens




    On 5 March 2015 at 10:36, Stéphane MERLE <stephan...@gmail.com> wrote:

        Hi,

        I just install my first VM with lucee (been using railo
        for now ;) ), and I would like to try the cassandra BDD
        to replace MSSQL ... is there a simple way to setup the
        connector ?

        http://cassandra.apache.org/

        Thanks for your help

        Stéphane
        -- 
        You received this message because you are subscribed to
        the Google Groups "Lucee" group.
        To unsubscribe from this group and stop receiving emails
        from it, send an email to lucee+un...@googlegroups.com.
        To post to this group, send email to lu...@googlegroups.com.
        To view this discussion on the web visit
        https://groups.google.com/d/msgid/lucee/a04008ac-f36d-4553-a689-a984d2dec509%40googlegroups.com
        <https://groups.google.com/d/msgid/lucee/a04008ac-f36d-4553-a689-a984d2dec509%40googlegroups.com?utm_medium=email&utm_source=footer>.
        For more options, visit
        https://groups.google.com/d/optout
        <https://groups.google.com/d/optout>.


-- 
You received this message because you are subscribed to the
Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com
<javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/5dd792bb-cf51-4132-9799-6bac1d4ae9ff%40googlegroups.com
<https://groups.google.com/d/msgid/lucee/5dd792bb-cf51-4132-9799-6bac1d4ae9ff%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+unsubscribe@googlegroups.com
mailto:lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com
mailto:lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/99810254-23b9-4f64-a050-a4ed36dbe19e%40googlegroups.com
https://groups.google.com/d/msgid/lucee/99810254-23b9-4f64-a050-a4ed36dbe19e%40googlegroups.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.

Igal · March 19, 2015, 10:00pm

I’m glad you got it to work!

Igal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/On 3/19/2015 2:59 PM, Stéphane MERLE wrote:

Thanks IGAL !

I did it, just needed to setup a little more the one node “cluster” of
test for cassandra …

Thanks for your time !

Stéphane

Le vendredi 6 mars 2015 16:35:29 UTC+1, Igal a écrit :

yes, "test" was a keyspace in that example.

do you have a full stacktrace of the error?  please post it.


Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>

On 3/6/2015 3:41 AM, Stéphane MERLE wrote:

Thanks IGAL,

for 1) I think I did good ...
for 2) I use the admin connection manager like that the dev
doesnt get too much informations on the production databases ...
but I get this error after validating :

org.apache.thrift.transport.TTransportException: Cannot write to
null outputStream


I use : 

CLASS : org.apache.cassandra.cql.jdbc.CassandraDriver
Connection String
: jdbc:cassandra://IPV4:9160/mykeyspace?consistency=QUORUM

where ipv4 is the ip of the cassandra server (only one for now)
I am assuming that TEST is the keyspace, which I created with the
name : "mykeyspace" so this should work ...

my main problem is to know if it's a cassandra config error or
railo/lucee/jdbc ...for now, there is NO firewall between the 2
serveurs ...

Stéphane






Le jeudi 5 mars 2015 18:17:47 UTC+1, Igal a écrit :

    a couple of pitfalls that you might want to avoid:

    1) the jdbc driver requires several files and they should all
    be in your classpath (unlike most drivers that keep all the
    prerequisites in one jar).

    2) the connection string in the SO link that you posted
    contains exemplary, unneeded, arguments, for example it
    specifies multiple hosts, multiple datacenters, and most
    importantly a "database" named "keyspace1" which if you don't
    have (and there's a good chance you don't) will throw an
    unrelated error message which will throw you in a wild goose
    chase.

    you can easily define a datasource named "cassandra" by
    adding this into your Application.cfc body assuming
    localhost, port 9160, and a database named "test":

      this.datasources.cassandra = {
         class: 'org.apache.cassandra.cql.jdbc.CassandraDriver'
        ,connectionString:
    'jdbc:cassandra://localhost:9160/test?consistency=QUORUM'
      };


    Igal Sapir
    Lucee Core Developer
    Lucee.org <http://lucee.org/>

    On 3/5/2015 3:52 AM, Stéphane MERLE wrote:

    "From there, you'll have to experiment and see what happens"
    this is where I got stuck ;)

    expecially with the connection string ... I found :
    http://stackoverflow.com/questions/26584607/using-apache-cassandra-in-coldfusion
    <http://stackoverflow.com/questions/26584607/using-apache-cassandra-in-coldfusion>
    I try to experiment around this ... with no luck for now ...
    I was expecting something as simple as MSSQL connectors
    ....sic ...

    Thanks for your help !!

    Stéphane



    Le jeudi 5 mars 2015 11:56:28 UTC+1, Chris Blackwell a écrit :

        I've never used Cassandra, but a quick google turns up a
        jdbc compliant driver.  So thats where i'd start
        https://code.google.com/a/apache-extras.org/p/cassandra-jdbc/
        <https://code.google.com/a/apache-extras.org/p/cassandra-jdbc/>

        install that, along with any dependencies in your /lib
        directory, restart lucee/tomcat and then create a
        datasource of type "Other" with a type
        of "org.apache.cassandra.cql.jdbc.CassandraDriver".

        From there, you'll have to experiment and see what happens




        On 5 March 2015 at 10:36, Stéphane MERLE <stephan...@gmail.com> wrote:

            Hi,

            I just install my first VM with lucee (been using
            railo for now ;) ), and I would like to try the
            cassandra BDD to replace MSSQL ... is there a simple
            way to setup the connector ?

            http://cassandra.apache.org/

            Thanks for your help

            Stéphane
            -- 
            You received this message because you are subscribed
            to the Google Groups "Lucee" group.
            To unsubscribe from this group and stop receiving
            emails from it, send an email to
            lucee+un...@googlegroups.com.
            To post to this group, send email to
            lu...@googlegroups.com.
            To view this discussion on the web visit
            https://groups.google.com/d/msgid/lucee/a04008ac-f36d-4553-a689-a984d2dec509%40googlegroups.com
            <https://groups.google.com/d/msgid/lucee/a04008ac-f36d-4553-a689-a984d2dec509%40googlegroups.com?utm_medium=email&utm_source=footer>.
            For more options, visit
            https://groups.google.com/d/optout
            <https://groups.google.com/d/optout>.


    -- 
    You received this message because you are subscribed to the
    Google Groups "Lucee" group.
    To unsubscribe from this group and stop receiving emails
    from it, send an email to lucee+un...@googlegroups.com.
    To post to this group, send email to lu...@googlegroups.com.
    To view this discussion on the web visit
    https://groups.google.com/d/msgid/lucee/5dd792bb-cf51-4132-9799-6bac1d4ae9ff%40googlegroups.com
    <https://groups.google.com/d/msgid/lucee/5dd792bb-cf51-4132-9799-6bac1d4ae9ff%40googlegroups.com?utm_medium=email&utm_source=footer>.
    For more options, visit https://groups.google.com/d/optout
    <https://groups.google.com/d/optout>.

-- 
You received this message because you are subscribed to the
Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com
<javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/99810254-23b9-4f64-a050-a4ed36dbe19e%40googlegroups.com
<https://groups.google.com/d/msgid/lucee/99810254-23b9-4f64-a050-a4ed36dbe19e%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.

–
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+unsubscribe@googlegroups.com
mailto:lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com
mailto:lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/aa3a9976-ae25-44f9-be04-2b68afa95762%40googlegroups.com
https://groups.google.com/d/msgid/lucee/aa3a9976-ae25-44f9-be04-2b68afa95762%40googlegroups.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.

Stephane_MERLE · March 19, 2015, 9:59pm

Thanks IGAL !

I did it, just needed to setup a little more the one node “cluster” of test
for cassandra …

Thanks for your time !

StéphaneLe vendredi 6 mars 2015 16:35:29 UTC+1, Igal a écrit :

yes, “test” was a keyspace in that example.

do you have a full stacktrace of the error? please post it.

Igal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/
On 3/6/2015 3:41 AM, Stéphane MERLE wrote:

Thanks IGAL,

for 1) I think I did good …
for 2) I use the admin connection manager like that the dev doesnt get too
much informations on the production databases … but I get this error
after validating :

org.apache.thrift.transport.TTransportException: Cannot write to null
outputStream

I use :

CLASS : org.apache.cassandra.cql.jdbc.CassandraDriver
Connection String
: jdbc:cassandra://IPV4:9160/mykeyspace?consistency=QUORUM

where ipv4 is the ip of the cassandra server (only one for now)
I am assuming that TEST is the keyspace, which I created with the name :
“mykeyspace” so this should work …

my main problem is to know if it’s a cassandra config error or
railo/lucee/jdbc …for now, there is NO firewall between the 2 serveurs …

Stéphane

Le jeudi 5 mars 2015 18:17:47 UTC+1, Igal a écrit :

a couple of pitfalls that you might want to avoid:

the jdbc driver requires several files and they should all be in your
classpath (unlike most drivers that keep all the prerequisites in one jar).

the connection string in the SO link that you posted contains
exemplary, unneeded, arguments, for example it specifies multiple hosts,
multiple datacenters, and most importantly a “database” named “keyspace1”
which if you don’t have (and there’s a good chance you don’t) will throw an
unrelated error message which will throw you in a wild goose chase.

you can easily define a datasource named “cassandra” by adding this into
your Application.cfc body assuming localhost, port 9160, and a database
named “test”:

this.datasources.cassandra = {
class: ‘org.apache.cassandra.cql.jdbc.CassandraDriver’
,connectionString:
‘jdbc:cassandra://localhost:9160/test?consistency=QUORUM’
};

Igal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/
On 3/5/2015 3:52 AM, Stéphane MERLE wrote:

“From there, you’ll have to experiment and see what happens”
this is where I got stuck

expecially with the connection string … I found :
java - Using Apache Cassandra In Coldfusion - Stack Overflow
I try to experiment around this … with no luck for now … I was
expecting something as simple as MSSQL connectors …sic …

Thanks for your help !!

Stéphane

Le jeudi 5 mars 2015 11:56:28 UTC+1, Chris Blackwell a écrit :

I’ve never used Cassandra, but a quick google turns up a jdbc compliant
driver. So thats where i’d start
Google Code Archive - Long-term storage for Google Code Project Hosting.

install that, along with any dependencies in your /lib directory,
restart lucee/tomcat and then create a datasource of type “Other” with a
type of “org.apache.cassandra.cql.jdbc.CassandraDriver”.

From there, you’ll have to experiment and see what happens

On 5 March 2015 at 10:36, Stéphane MERLE stephan...@gmail.com wrote:

Hi,

I just install my first VM with lucee (been using railo for now ),
and I would like to try the cassandra BDD to replace MSSQL … is there a
simple way to setup the connector ?

http://cassandra.apache.org/

Thanks for your help

Stéphane

You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/a04008ac-f36d-4553-a689-a984d2dec509%40googlegroups.com
https://groups.google.com/d/msgid/lucee/a04008ac-f36d-4553-a689-a984d2dec509%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/5dd792bb-cf51-4132-9799-6bac1d4ae9ff%40googlegroups.com
https://groups.google.com/d/msgid/lucee/5dd792bb-cf51-4132-9799-6bac1d4ae9ff%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/99810254-23b9-4f64-a050-a4ed36dbe19e%40googlegroups.com
https://groups.google.com/d/msgid/lucee/99810254-23b9-4f64-a050-a4ed36dbe19e%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

Anders_Thulin · June 30, 2015, 10:40am

Did anyone make the jdbc driver to work on Lucee?

I have downloaded the google project and dependencies to /lib and restarted
Lucee.

Setting up the data source with other -JDBC Driver and get stucked.

Class: org.apache.cassandra.cql.jdbc.CassandraDriver
Connection string;
jdbc:cassandra://host1–host2–host3:9160/keyspace1?primarydc=DC1&backupdc=DC2&consistency=QUORUM

I get a strange Lucee Admin message

tried to access field org.slf4j.impl.StaticLoggerBinder.SINGLETON from
class org.slf4j.LoggerFactory

The 2nd time I try I just get:
Could not initialize class org.apache.cassandra.cql.jdbc.CassandraDriver

Im running the latest DataStax Cassandra 2.0.13
and
Lucee 4.5.1.008 final

CQL Shell access works fine.

Any ideas?

Den torsdag 5 mars 2015 kl. 11:36:50 UTC+1 skrev Stéphane MERLE:>

Hi,

I just install my first VM with lucee (been using railo for now ), and
I would like to try the cassandra BDD to replace MSSQL … is there a
simple way to setup the connector ?

http://cassandra.apache.org/

Thanks for your help

Stéphane

David_Sedeno · July 1, 2015, 2:05pm

Hi Anders,

I have setup the datasource successfuly with the connection string:

jdbc:cassandra://ipaddress:9160/keyspace?consistency=QUORUM

(only one ipaddress, I couldn’t setup the other nodes ip address)—
David

El martes, 30 de junio de 2015, 12:40:20 (UTC+2), Anders Thulin escribió:

Did anyone make the jdbc driver to work on Lucee?

I have downloaded the google project and dependencies to /lib and
restarted Lucee.

Setting up the data source with other -JDBC Driver and get stucked.

Class: org.apache.cassandra.cql.jdbc.CassandraDriver
Connection string;
jdbc:cassandra://host1–host2–host3:9160/keyspace1?primarydc=DC1&backupdc=DC2&consistency=QUORUM

I get a strange Lucee Admin message

tried to access field org.slf4j.impl.StaticLoggerBinder.SINGLETON from
class org.slf4j.LoggerFactory

The 2nd time I try I just get:
Could not initialize class org.apache.cassandra.cql.jdbc.CassandraDriver

Im running the latest DataStax Cassandra 2.0.13
and
Lucee 4.5.1.008 final

CQL Shell access works fine.

Any ideas?

Den torsdag 5 mars 2015 kl. 11:36:50 UTC+1 skrev Stéphane MERLE:

Hi,

I just install my first VM with lucee (been using railo for now ), and
I would like to try the cassandra BDD to replace MSSQL … is there a
simple way to setup the connector ?

http://cassandra.apache.org/

Thanks for your help

Stéphane

Anders_Thulin · July 24, 2015, 12:03pm

Solved it.
cassandra.yaml had wrong setting.
enabled by start_rpc: true

Den fredag 24 juli 2015 kl. 12:53:19 UTC+2 skrev Anders Thulin:>

Great, whats the trick then?

I managed to solve the slf4j error by downloading the latest version of
that.
But now I get the same error as Stéphane:

org.apache.thrift.transport.TTransportException: Cannot write to null
outputStream

Do I need to make changes to cassandra.yaml?

Den onsdag 1 juli 2015 kl. 16:05:40 UTC+2 skrev David Sedeño:

Hi Anders,

I have setup the datasource successfuly with the connection string:

jdbc:cassandra://ipaddress:9160/keyspace?consistency=QUORUM

(only one ipaddress, I couldn’t setup the other nodes ip address)

David

El martes, 30 de junio de 2015, 12:40:20 (UTC+2), Anders Thulin escribió:

Did anyone make the jdbc driver to work on Lucee?

I have downloaded the google project and dependencies to /lib and
restarted Lucee.

Setting up the data source with other -JDBC Driver and get stucked.

Class: org.apache.cassandra.cql.jdbc.CassandraDriver
Connection string;
jdbc:cassandra://host1–host2–host3:9160/keyspace1?primarydc=DC1&backupdc=DC2&consistency=QUORUM

I get a strange Lucee Admin message

tried to access field org.slf4j.impl.StaticLoggerBinder.SINGLETON from
class org.slf4j.LoggerFactory

The 2nd time I try I just get:
Could not initialize class org.apache.cassandra.cql.jdbc.CassandraDriver

Im running the latest DataStax Cassandra 2.0.13
and
Lucee 4.5.1.008 final

CQL Shell access works fine.

Any ideas?

Den torsdag 5 mars 2015 kl. 11:36:50 UTC+1 skrev Stéphane MERLE:

Hi,

I just install my first VM with lucee (been using railo for now ),
and I would like to try the cassandra BDD to replace MSSQL … is there a
simple way to setup the connector ?

http://cassandra.apache.org/

Thanks for your help

Stéphane

Anders_Thulin · July 24, 2015, 10:53am

Great, whats the trick then?

I managed to solve the slf4j error by downloading the latest version of
that.
But now I get the same error as Stéphane:

org.apache.thrift.transport.TTransportException: Cannot write to null
outputStream

Do I need to make changes to cassandra.yaml?

Den onsdag 1 juli 2015 kl. 16:05:40 UTC+2 skrev David Sedeño:>

Hi Anders,

I have setup the datasource successfuly with the connection string:

jdbc:cassandra://ipaddress:9160/keyspace?consistency=QUORUM

(only one ipaddress, I couldn’t setup the other nodes ip address)

David

El martes, 30 de junio de 2015, 12:40:20 (UTC+2), Anders Thulin escribió:

Did anyone make the jdbc driver to work on Lucee?

I have downloaded the google project and dependencies to /lib and
restarted Lucee.

Setting up the data source with other -JDBC Driver and get stucked.

Class: org.apache.cassandra.cql.jdbc.CassandraDriver
Connection string;
jdbc:cassandra://host1–host2–host3:9160/keyspace1?primarydc=DC1&backupdc=DC2&consistency=QUORUM

I get a strange Lucee Admin message

tried to access field org.slf4j.impl.StaticLoggerBinder.SINGLETON from
class org.slf4j.LoggerFactory

The 2nd time I try I just get:
Could not initialize class org.apache.cassandra.cql.jdbc.CassandraDriver

Im running the latest DataStax Cassandra 2.0.13
and
Lucee 4.5.1.008 final

CQL Shell access works fine.

Any ideas?

Den torsdag 5 mars 2015 kl. 11:36:50 UTC+1 skrev Stéphane MERLE:

Hi,

I just install my first VM with lucee (been using railo for now ),
and I would like to try the cassandra BDD to replace MSSQL … is there a
simple way to setup the connector ?

http://cassandra.apache.org/

Thanks for your help

Stéphane