how to insert date format yyyyMMddHHmmss in timestamp ?!! java +Cassandra + jemeter

[Imen Jaouani]

Hi all ;

I have to fill a table using jmeeter !

My Cassandra table include timestamp as a date form and with jmeter i use the function ${__time(yyyyMMddHHmmss)} wich return a date with yyyyMMddHHmmss form !

so how can i convert this form with java code to make it adequate to insert in timestamp field in the table ! thank you

[Olivier Michallat]

Hi Imen,

The driver uses java.util.Date to map timestamp columns. If your question is how to convert a String into a java.util.Date, the answer is DateFormat.parse and you should easily find examples online (this is not specific to the driver).

On a side note, could you check your email client's configuration? You've been sending duplicate messages to the list a couple of times.

To unsubscribe from this group and stop receiving emails from it, send an email to java-driver-us...@lists.datastax.com.

--

Olivier Michallat

Drivers & Tools Engineer, DataStax

[Imen Jaouani]

ok thank you !

i'm sorry , i will check :

[Imen Jaouani]

i try to clarify :

Date d=new Date();

   

    select.putString("statement", "INSERT INTO arcdb.session (Session_id,User_oidval,mco,Service_type,sync_key,"

    + "terminal_type,counter,authentication_date,session_invalidation_date) values ('"+session_id+"',"+i_user_oidval+",'"+i_mco+"','"+i_service_type+"','"+i_sync_key+"','"+i_terminal_type+"','"+i_counter+"',"+d+","+d+")");

 

the error is :

{"status":"error","message":"[Cassandra Persistor] line 1:240 no viable alternative at input 'Aug'"}

[Olivier Michallat]

Don't use string concatenation to build your queries. You should use bind markers and provide the values separately. For one-time queries use Session.execute(String, Object...) [1, 2], otherwise use prepared statements [3].

A few examples:

            // one-time statement

            session.execute("INSERT INTO foo (i) VALUES (?)", 1);

            // prepared statement

            PreparedStatement ps = session.prepare("INSERT INTO foo (i) VALUES (?)");

            session.execute(ps.bind(1));

            // prepared statement with named marker

            ps = session.prepare("INSERT INTO foo (i) VALUES (:value)");

            session.execute(ps.bind().setInt("value", 1));

[1] http://www.datastax.com/drivers/java/2.0/com/datastax/driver/core/Session.html#execute(java.lang.String,%20java.lang.Object...)

[2] http://www.datastax.com/drivers/java/2.0/com/datastax/driver/core/SimpleStatement.html#SimpleStatement(java.lang.String,%20java.lang.Object...)

[3] http://www.datastax.com/documentation/developer/java-driver/2.0/java-driver/quick_start/qsSimpleClientBoundStatements_t.html

To unsubscribe from this group and stop receiving emails from it, send an email to java-driver-us...@lists.datastax.com.