org.hibernate.hql.internal.ast.QuerySyntaxException: expecting OPEN, found 'from' near line 1, column 23...
-1
I have a project in Spring Boot 1.5 with mysql database. I have 2 entity class BackupOTP & OTP and I want to copy data from OTP table to BackupOTP table using HQL. For that, I have written this code.
Query query=session.createQuery("insert into BackupOTP from OTP where isExpired=:boolean");
query.setBoolean("boolean", true);
int i=query.executeUpdate();
System.err.println("i = "+i);
But I am getting this exception
org.hibernate.hql.internal.ast.QuerySyntaxException:
expecting OPEN, found 'from' near line 1, column 23
[insert into BackupOTP from com.groupbima.central.entity.OTP where isExpired=:boolean]
How to resolve this issue?
java mysql hibernate spring-boot hql
asked Nov 23 at 10:00
Altaf
3110
add a comment |
-1
I have a project in Spring Boot 1.5 with mysql database. I have 2 entity class BackupOTP & OTP and I want to copy data from OTP table to BackupOTP table using HQL. For that, I have written this code.
Query query=session.createQuery("insert into BackupOTP from OTP where isExpired=:boolean");
query.setBoolean("boolean", true);
int i=query.executeUpdate();
System.err.println("i = "+i);
But I am getting this exception
org.hibernate.hql.internal.ast.QuerySyntaxException:
expecting OPEN, found 'from' near line 1, column 23
[insert into BackupOTP from com.groupbima.central.entity.OTP where isExpired=:boolean]
How to resolve this issue?
java mysql hibernate spring-boot hql
asked Nov 23 at 10:00
Altaf
3110
why are you using where clause for insert?
– Alien
Nov 23 at 10:02
It is necessary for our requirement. If OTP is expired then we need to back up otherwise we don't want to backup that's why we have taken isExpired=true
– Altaf
Nov 23 at 10:03
That's not valid HQL. Here's the documentation for insert statements: docs.jboss.org/hibernate/orm/current/userguide/html_single/…. Everything becomes smpler when you read the documentation.
– JB Nizet
Nov 23 at 10:08
What is the reason for down vote?
– Altaf
Nov 23 at 11:30
The reason is that you asked without first doing the most basic research: read the documentation about insert statements.
– JB Nizet
Nov 23 at 13:08
add a comment |
-1
-1
-1
I have a project in Spring Boot 1.5 with mysql database. I have 2 entity class BackupOTP & OTP and I want to copy data from OTP table to BackupOTP table using HQL. For that, I have written this code.
Query query=session.createQuery("insert into BackupOTP from OTP where isExpired=:boolean");
query.setBoolean("boolean", true);
int i=query.executeUpdate();
System.err.println("i = "+i);
But I am getting this exception
org.hibernate.hql.internal.ast.QuerySyntaxException:
expecting OPEN, found 'from' near line 1, column 23
[insert into BackupOTP from com.groupbima.central.entity.OTP where isExpired=:boolean]
How to resolve this issue?
java mysql hibernate spring-boot hql
asked Nov 23 at 10:00
Altaf
3110
I have a project in Spring Boot 1.5 with mysql database. I have 2 entity class BackupOTP & OTP and I want to copy data from OTP table to BackupOTP table using HQL. For that, I have written this code.
Query query=session.createQuery("insert into BackupOTP from OTP where isExpired=:boolean");
query.setBoolean("boolean", true);
int i=query.executeUpdate();
System.err.println("i = "+i);
But I am getting this exception
org.hibernate.hql.internal.ast.QuerySyntaxException:
expecting OPEN, found 'from' near line 1, column 23
[insert into BackupOTP from com.groupbima.central.entity.OTP where isExpired=:boolean]
How to resolve this issue?
java mysql hibernate spring-boot hql
java mysql hibernate spring-boot hql
asked Nov 23 at 10:00
Altaf
3110
asked Nov 23 at 10:00
Altaf
3110
edited Nov 23 at 10:04
asked Nov 23 at 10:00
Altaf
3110
asked Nov 23 at 10:00
Altaf
3110
asked Nov 23 at 10:00
Altaf
3110
3110
why are you using where clause for insert?
– Alien
Nov 23 at 10:02
It is necessary for our requirement. If OTP is expired then we need to back up otherwise we don't want to backup that's why we have taken isExpired=true
– Altaf
Nov 23 at 10:03
That's not valid HQL. Here's the documentation for insert statements: docs.jboss.org/hibernate/orm/current/userguide/html_single/…. Everything becomes smpler when you read the documentation.
– JB Nizet
Nov 23 at 10:08
What is the reason for down vote?
– Altaf
Nov 23 at 11:30
The reason is that you asked without first doing the most basic research: read the documentation about insert statements.
– JB Nizet
Nov 23 at 13:08
add a comment |
why are you using where clause for insert?
– Alien
Nov 23 at 10:02
It is necessary for our requirement. If OTP is expired then we need to back up otherwise we don't want to backup that's why we have taken isExpired=true
– Altaf
Nov 23 at 10:03
That's not valid HQL. Here's the documentation for insert statements: docs.jboss.org/hibernate/orm/current/userguide/html_single/…. Everything becomes smpler when you read the documentation.
– JB Nizet
Nov 23 at 10:08
What is the reason for down vote?
– Altaf
Nov 23 at 11:30
The reason is that you asked without first doing the most basic research: read the documentation about insert statements.
– JB Nizet
Nov 23 at 13:08
why are you using where clause for insert?
– Alien
Nov 23 at 10:02
why are you using where clause for insert?
– Alien
Nov 23 at 10:02
It is necessary for our requirement. If OTP is expired then we need to back up otherwise we don't want to backup that's why we have taken isExpired=true
– Altaf
Nov 23 at 10:03
It is necessary for our requirement. If OTP is expired then we need to back up otherwise we don't want to backup that's why we have taken isExpired=true
– Altaf
Nov 23 at 10:03
That's not valid HQL. Here's the documentation for insert statements: docs.jboss.org/hibernate/orm/current/userguide/html_single/…. Everything becomes smpler when you read the documentation.
– JB Nizet
Nov 23 at 10:08
That's not valid HQL. Here's the documentation for insert statements: docs.jboss.org/hibernate/orm/current/userguide/html_single/…. Everything becomes smpler when you read the documentation.
– JB Nizet
Nov 23 at 10:08
What is the reason for down vote?
– Altaf
Nov 23 at 11:30
What is the reason for down vote?
– Altaf
Nov 23 at 11:30
The reason is that you asked without first doing the most basic research: read the documentation about insert statements.
– JB Nizet
Nov 23 at 13:08
The reason is that you asked without first doing the most basic research: read the documentation about insert statements.
– JB Nizet
Nov 23 at 13:08
add a comment |
1 Answer
1
active
oldest
votes
0
Finally, I got the answer.
Actually, It was the problem with HQL syntax. My HQL syntax was wrong. I looked into Hibernate insert query documentation and modified my insert syntax like this
Query query=session.createQuery("insert into BackupOTP (otpId, createdTime, encryptedOTP, isExpired, updatedTime)"
+ " select otpId, createdTime, encryptedOTP, isExpired, updatedTime from OTP where isExpired=:boolean");
query.setBoolean("boolean", true);
int i=query.executeUpdate();
System.err.println("i = "+i);
Now it is working.
answered Nov 23 at 10:24
Altaf
3110
add a comment |
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
});
}
});
draft saved
draft discarded
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%2f53444439%2forg-hibernate-hql-internal-ast-querysyntaxexception-expecting-open-found-from%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Finally, I got the answer.
Actually, It was the problem with HQL syntax. My HQL syntax was wrong. I looked into Hibernate insert query documentation and modified my insert syntax like this
Query query=session.createQuery("insert into BackupOTP (otpId, createdTime, encryptedOTP, isExpired, updatedTime)"
+ " select otpId, createdTime, encryptedOTP, isExpired, updatedTime from OTP where isExpired=:boolean");
query.setBoolean("boolean", true);
int i=query.executeUpdate();
System.err.println("i = "+i);
Now it is working.
answered Nov 23 at 10:24
Altaf
3110
add a comment |
0
Finally, I got the answer.
Actually, It was the problem with HQL syntax. My HQL syntax was wrong. I looked into Hibernate insert query documentation and modified my insert syntax like this
Query query=session.createQuery("insert into BackupOTP (otpId, createdTime, encryptedOTP, isExpired, updatedTime)"
+ " select otpId, createdTime, encryptedOTP, isExpired, updatedTime from OTP where isExpired=:boolean");
query.setBoolean("boolean", true);
int i=query.executeUpdate();
System.err.println("i = "+i);
Now it is working.
answered Nov 23 at 10:24
Altaf
3110
add a comment |
0
0
0
Finally, I got the answer.
Actually, It was the problem with HQL syntax. My HQL syntax was wrong. I looked into Hibernate insert query documentation and modified my insert syntax like this
Query query=session.createQuery("insert into BackupOTP (otpId, createdTime, encryptedOTP, isExpired, updatedTime)"
+ " select otpId, createdTime, encryptedOTP, isExpired, updatedTime from OTP where isExpired=:boolean");
query.setBoolean("boolean", true);
int i=query.executeUpdate();
System.err.println("i = "+i);
Now it is working.
answered Nov 23 at 10:24
Altaf
3110
Finally, I got the answer.
Actually, It was the problem with HQL syntax. My HQL syntax was wrong. I looked into Hibernate insert query documentation and modified my insert syntax like this
Query query=session.createQuery("insert into BackupOTP (otpId, createdTime, encryptedOTP, isExpired, updatedTime)"
+ " select otpId, createdTime, encryptedOTP, isExpired, updatedTime from OTP where isExpired=:boolean");
query.setBoolean("boolean", true);
int i=query.executeUpdate();
System.err.println("i = "+i);
Now it is working.
answered Nov 23 at 10:24
Altaf
3110
answered Nov 23 at 10:24
Altaf
3110
answered Nov 23 at 10:24
Altaf
3110
answered Nov 23 at 10:24
Altaf
3110
3110
add a comment |
add a comment |
draft saved
draft discarded
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
draft saved
draft discarded
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%2f53444439%2forg-hibernate-hql-internal-ast-querysyntaxexception-expecting-open-found-from%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
why are you using where clause for insert?
– Alien
Nov 23 at 10:02
It is necessary for our requirement. If OTP is expired then we need to back up otherwise we don't want to backup that's why we have taken isExpired=true
– Altaf
Nov 23 at 10:03
That's not valid HQL. Here's the documentation for insert statements: docs.jboss.org/hibernate/orm/current/userguide/html_single/…. Everything becomes smpler when you read the documentation.
– JB Nizet
Nov 23 at 10:08
What is the reason for down vote?
– Altaf
Nov 23 at 11:30
The reason is that you asked without first doing the most basic research: read the documentation about insert statements.
– JB Nizet
Nov 23 at 13:08