Use SimpleJdbcInsert to insert into a collection column
I'm trying to use the org.springframework.jdbc.core.simple.SimpleJdbcInsert class to insert into a Cassandra table which I built as such:
CREATE TABLE test.profs(id text PRIMARY KEY,
accountid text,
enable boolean,
modifieddate bigint,
name text,
rules set<text>)
When I send the following request:
{
"name": "a",
"rules": [
"s", "22",
"ss",
"sfsf"
],
"enable": true,
"accountId": "sss"
}
(it creates an id, no worries - tested)
But when I'm trying to insert, it throws me the following exception:
PreparedStatementCallback; SQL [INSERT INTO test.profs (accountId, enable, id, modifiedDate, name, rules) VALUES(?, ?, ?, ?, ?, ?)the column index : 7 is greater than the count of bound variable markers in the CQL: 6; nested exception is java.sql.SQLRecoverableException: the column index : 7 is greater than the count of bound variable markers in the CQL: 6
I think it's something to do with the rules column since when I try to insert with an array of one element, it does succeed.
EDIT:
I've tried to use the following class:
@Data
@AllArgsConstructor
private class CollectionHolder {
private Collection<?> collection;
@Override
public String toString() {
StringBuilder list = new StringBuilder("{");
for (Object obj : collection) {
list.append(obj.toString());
list.append(',');
}
list.delete(list.length()-1, list.length());
list.append('}');
return list.toString();
}
}
And it did seem to succeed, but now rules is inserted as null..
Any help?
java spring-boot jdbc cassandra
asked Nov 25 '18 at 8:04
Ben YaakobiBen Yaakobi
1317
add a comment |
I'm trying to use the org.springframework.jdbc.core.simple.SimpleJdbcInsert class to insert into a Cassandra table which I built as such:
CREATE TABLE test.profs(id text PRIMARY KEY,
accountid text,
enable boolean,
modifieddate bigint,
name text,
rules set<text>)
When I send the following request:
{
"name": "a",
"rules": [
"s", "22",
"ss",
"sfsf"
],
"enable": true,
"accountId": "sss"
}
(it creates an id, no worries - tested)
But when I'm trying to insert, it throws me the following exception:
PreparedStatementCallback; SQL [INSERT INTO test.profs (accountId, enable, id, modifiedDate, name, rules) VALUES(?, ?, ?, ?, ?, ?)the column index : 7 is greater than the count of bound variable markers in the CQL: 6; nested exception is java.sql.SQLRecoverableException: the column index : 7 is greater than the count of bound variable markers in the CQL: 6
I think it's something to do with the rules column since when I try to insert with an array of one element, it does succeed.
EDIT:
I've tried to use the following class:
@Data
@AllArgsConstructor
private class CollectionHolder {
private Collection<?> collection;
@Override
public String toString() {
StringBuilder list = new StringBuilder("{");
for (Object obj : collection) {
list.append(obj.toString());
list.append(',');
}
list.delete(list.length()-1, list.length());
list.append('}');
return list.toString();
}
}
And it did seem to succeed, but now rules is inserted as null..
Any help?
java spring-boot jdbc cassandra
asked Nov 25 '18 at 8:04
Ben YaakobiBen Yaakobi
1317
add a comment |
I'm trying to use the org.springframework.jdbc.core.simple.SimpleJdbcInsert class to insert into a Cassandra table which I built as such:
CREATE TABLE test.profs(id text PRIMARY KEY,
accountid text,
enable boolean,
modifieddate bigint,
name text,
rules set<text>)
When I send the following request:
{
"name": "a",
"rules": [
"s", "22",
"ss",
"sfsf"
],
"enable": true,
"accountId": "sss"
}
(it creates an id, no worries - tested)
But when I'm trying to insert, it throws me the following exception:
PreparedStatementCallback; SQL [INSERT INTO test.profs (accountId, enable, id, modifiedDate, name, rules) VALUES(?, ?, ?, ?, ?, ?)the column index : 7 is greater than the count of bound variable markers in the CQL: 6; nested exception is java.sql.SQLRecoverableException: the column index : 7 is greater than the count of bound variable markers in the CQL: 6
I think it's something to do with the rules column since when I try to insert with an array of one element, it does succeed.
EDIT:
I've tried to use the following class:
@Data
@AllArgsConstructor
private class CollectionHolder {
private Collection<?> collection;
@Override
public String toString() {
StringBuilder list = new StringBuilder("{");
for (Object obj : collection) {
list.append(obj.toString());
list.append(',');
}
list.delete(list.length()-1, list.length());
list.append('}');
return list.toString();
}
}
And it did seem to succeed, but now rules is inserted as null..
Any help?
java spring-boot jdbc cassandra
asked Nov 25 '18 at 8:04
Ben YaakobiBen Yaakobi
1317
I'm trying to use the org.springframework.jdbc.core.simple.SimpleJdbcInsert class to insert into a Cassandra table which I built as such:
CREATE TABLE test.profs(id text PRIMARY KEY,
accountid text,
enable boolean,
modifieddate bigint,
name text,
rules set<text>)
When I send the following request:
{
"name": "a",
"rules": [
"s", "22",
"ss",
"sfsf"
],
"enable": true,
"accountId": "sss"
}
(it creates an id, no worries - tested)
But when I'm trying to insert, it throws me the following exception:
PreparedStatementCallback; SQL [INSERT INTO test.profs (accountId, enable, id, modifiedDate, name, rules) VALUES(?, ?, ?, ?, ?, ?)the column index : 7 is greater than the count of bound variable markers in the CQL: 6; nested exception is java.sql.SQLRecoverableException: the column index : 7 is greater than the count of bound variable markers in the CQL: 6
I think it's something to do with the rules column since when I try to insert with an array of one element, it does succeed.
EDIT:
I've tried to use the following class:
@Data
@AllArgsConstructor
private class CollectionHolder {
private Collection<?> collection;
@Override
public String toString() {
StringBuilder list = new StringBuilder("{");
for (Object obj : collection) {
list.append(obj.toString());
list.append(',');
}
list.delete(list.length()-1, list.length());
list.append('}');
return list.toString();
}
}
And it did seem to succeed, but now rules is inserted as null..
Any help?
java spring-boot jdbc cassandra
java spring-boot jdbc cassandra
asked Nov 25 '18 at 8:04
Ben YaakobiBen Yaakobi
1317
asked Nov 25 '18 at 8:04
Ben YaakobiBen Yaakobi
1317
edited Nov 25 '18 at 9:29
Ben Yaakobi
asked Nov 25 '18 at 8:04
Ben YaakobiBen Yaakobi
1317
asked Nov 25 '18 at 8:04
Ben YaakobiBen Yaakobi
1317
asked Nov 25 '18 at 8:04
Ben YaakobiBen Yaakobi
1317
1317
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53465691%2fuse-simplejdbcinsert-to-insert-into-a-collection-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53465691%2fuse-simplejdbcinsert-to-insert-into-a-collection-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
