11:05 a.m.
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/jira/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public (Everyone can see)
Affects Versions: jBPM 4.x
Reporter: Peter Horvath
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:05 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2792) Data manipulation with HQL / SQL nodes
[
https://jira.jboss.org/jira/browse/JBPM-2792?page=com.atlassian.jira.plug...
]
Peter Horvath updated JBPM-2792:
--------------------------------
Component/s: Runtime Engine
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/jira/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.x
Reporter: Peter Horvath
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:07 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2792) Data manipulation with HQL / SQL nodes
[
https://jira.jboss.org/jira/browse/JBPM-2792?page=com.atlassian.jira.plug...
]
Peter Horvath updated JBPM-2792:
--------------------------------
Description:
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
was:
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/jira/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.x
Reporter: Peter Horvath
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:07 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2792) Data manipulation with HQL / SQL nodes
[
https://jira.jboss.org/jira/browse/JBPM-2792?page=com.atlassian.jira.plug...
]
Peter Horvath updated JBPM-2792:
--------------------------------
Description:
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
was:
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/jira/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.x
Reporter: Peter Horvath
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:01 p.m.
New subject: [JBoss JIRA] Updated: (JBPM-2792) Data manipulation with HQL / SQL nodes
[
https://jira.jboss.org/browse/JBPM-2792?page=com.atlassian.jira.plugin.sy...
]
Huisheng Xu updated JBPM-2792:
------------------------------
Fix Version/s: jBPM 4.x
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.x
Reporter: Peter Horvath
Fix For: jBPM 4.x
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:10 a.m.
New subject: [JBoss JIRA] Assigned: (JBPM-2792) Data manipulation with HQL / SQL nodes
[
https://jira.jboss.org/browse/JBPM-2792?page=com.atlassian.jira.plugin.sy...
]
Huisheng Xu reassigned JBPM-2792:
---------------------------------
Assignee: Huisheng Xu
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.x
Reporter: Peter Horvath
Assignee: Huisheng Xu
Fix For: jBPM 4.x
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:10 a.m.
New subject: [JBoss JIRA] Work started: (JBPM-2792) Data manipulation with HQL / SQL nodes
[
https://jira.jboss.org/browse/JBPM-2792?page=com.atlassian.jira.plugin.sy...
]
Work on JBPM-2792 started by Huisheng Xu.
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.x
Reporter: Peter Horvath
Assignee: Huisheng Xu
Fix For: jBPM 4.x
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:20 a.m.
New subject: [JBoss JIRA] Work stopped: (JBPM-2792) Data manipulation with HQL / SQL nodes
[
https://jira.jboss.org/browse/JBPM-2792?page=com.atlassian.jira.plugin.sy...
]
Work on JBPM-2792 stopped by Huisheng Xu.
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.x
Reporter: Peter Horvath
Assignee: Huisheng Xu
Fix For: jBPM 4.x
Attachments: JBPM-2792.patch
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:20 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2792) Data manipulation with HQL / SQL nodes
[
https://jira.jboss.org/browse/JBPM-2792?page=com.atlassian.jira.plugin.sy...
]
Huisheng Xu updated JBPM-2792:
------------------------------
Attachment: JBPM-2792.patch
patch and testcase
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.x
Reporter: Peter Horvath
Assignee: Huisheng Xu
Fix For: jBPM 4.x
Attachments: JBPM-2792.patch
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:10 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2792) Data manipulation with HQL / SQL nodes
[
https://jira.jboss.org/browse/JBPM-2792?page=com.atlassian.jira.plugin.sy...
]
Huisheng Xu updated JBPM-2792:
------------------------------
Fix Version/s: jBPM 4.5
(was: jBPM 4.x)
Affects Version/s: jBPM 4.4
(was: jBPM 4.x)
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.4
Reporter: Peter Horvath
Assignee: Huisheng Xu
Fix For: jBPM 4.5
Attachments: JBPM-2792.patch
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:58 a.m.
New subject: [JBoss JIRA] Resolved: (JBPM-2792) Data manipulation with HQL / SQL nodes
[
https://jira.jboss.org/browse/JBPM-2792?page=com.atlassian.jira.plugin.sy...
]
Huisheng Xu resolved JBPM-2792.
-------------------------------
Resolution: Done
checked in r6574
Data manipulation with HQL / SQL nodes
--------------------------------------
Key: JBPM-2792
URL: https://jira.jboss.org/browse/JBPM-2792
Project: jBPM
Issue Type: Feature Request
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.4
Reporter: Peter Horvath
Assignee: Huisheng Xu
Fix For: jBPM 4.5
Attachments: JBPM-2792.patch
Currently HQL / SQL nodes only allow you to run queries. It would be great if it was
possible to run data manipulation operations (INSERT / UPDATE / DELETE) as well.
It should be quite easy to implement this by adding a new possible flag to the hql / sql
node and calling org.hibernate.Query.executeUpdate() from
org.jbpm.jpdl.internal.activity.HqlActivity.perform(OpenExecution) method:
public class HqlActivity extends JpdlAutomaticActivity {
// ...
public void perform(OpenExecution execution) {
// ...
if(isUpdate) { // isUpdate: this a new flag that indicates that this is a data
manipulation operation
// execute update and store the number of entities / rows affected (inserted, updated or
deleted) by this operation into the result variable
result = q.executeUpdate();
} else { if (isResultUnique) {
result = q.uniqueResult();
} else {
result = q.list();
}
}
// ...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5269
days inactive
5446
days old
10 comments
2 participants
participants (2)
-
Huisheng Xu (JIRA) -
Peter Horvath (JIRA)