[jira] [Resolved] (CASSANDRA-8170) Issues Inserting Collections (List) into Cassandra using Mulesoft driver 1.2.2 - mulesoft/CassandraDB-connector

["Sylvain Lebresne (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-8170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sylvain Lebresne resolved CASSANDRA-8170.
-----------------------------------------
    Resolution: Invalid

This is a driver error, not a Cassandra one, so you should contact your driver vendor (MuleSoft apparently).

> Issues Inserting Collections (List) into Cassandra using Mulesoft driver 1.2.2 - mulesoft/CassandraDB-connector 
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-8170
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8170
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Drivers (now out of tree)
>         Environment: Windows, MuleSoft
>            Reporter: Kiran Challa
>
> I was trying to insert records into Cassandra using "Execute cql query" operation for CassandraDB connector (ver 1.2.2). The query is made up of ints and strings, with the last 4 fields being Collection type List. 
> If I test by inserting the exact same query directly into cqlsh or DataStax Dev Center (and add a trailing semicolon), the insert works fine. But if I try it from within a Mule flow, I get the following error: 
> org.mule.api.MessagingException: Failed to invoke executeCqlQuery. 
>  com.mulesoft.mule.cassandradb.CassandraDBException 
>  InvalidRequestException(why:line 1:1056 no viable alternative at character ']') 
> Can someone help me with the resolution. Thanks
> cassandradb:execute-cql-query config-ref="CassandraGenesisDB" query="INSERT INTO genesis.document_master (doc_id, doc_number,doc_number_formatted,doc_state_abbr,doc_state_name,doc_state_fips,doc_county_name,doc_county_fips,doc_county_id, doc_recording_date,doc_title,doc_cmt_id,doc_cmt_description,doc_alt_document_number,doc_alt_document_number_formatted,doc_alt_cmt_id,doc_alt_cmt_description, doc_type,doc_seq,doc_record_type,doc_modified_date,doc_amount,doc_anr_flag,doc_loan_type,doc_questionalble,doc_fee_number,doc_remarks,doc_title_company,doc_ocr_file_location,doc_post_process_text_location,doc_image_file_location,doc_inserted_date,doc_hoa,doc_attorney,doc_escrow,doc_lender,name) values ('1-06-059-2014.15','2014.15','2014.15 ','CA', 'CALIFORNIA','06', 'ORANGE','059','OR', 20140102, 'CORPORATE ASSIGNMENT OF DEED OF TRUST','1', '2014.15', 'null','null', '-14','null', 'AS ',0, 'I', 20140102,'0', 'N', 'null','null', '00000000000015','', 'null', 'null','null', 'null',0, 'null', 'null','null', 'null' ,['NATIONSTAR MTG LLC - ASSIGNOR', 'SARM 2007-4 TRUST FUND - ASSIGNEE', 'DAVIS ALANA R - BORROWER1'])" doc:name="CassandraDB" 
> Note that if we eliminate the last column, which is called "name", and the corresponding string array of values for this field, the query works fine. 
> Mulesoft info: 
> cassandra-thrift-2.0.6.jar 
>  mule-module-cassandradb-1.2.2.jar 
> Here is our Cassandra info: 
> Search 4.6 
>  DSE 4.5.2 
>  Cassandra 2.0.10.71”



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)