You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "Rainer Döbele (JIRA)" <em...@incubator.apache.org> on 2012/08/16 14:37:37 UTC
[jira] [Created] (EMPIREDB-158) Avoid accidentally missng command
parameter values when using DBDatabase.executeSQL
Rainer Döbele created EMPIREDB-158:
--------------------------------------
Summary: Avoid accidentally missng command parameter values when using DBDatabase.executeSQL
Key: EMPIREDB-158
URL: https://issues.apache.org/jira/browse/EMPIREDB-158
Project: Empire-DB
Issue Type: Improvement
Reporter: Rainer Döbele
Assignee: Rainer Döbele
For executing insert, update and delete command the method DBDatabase.executeSQL must be used.
When using prepared statements however it is necessary to use the overload that allows to specify the commands parameter values like this:
db.executeSQL(cmd.getInsert(), cmd.getParamValues(), conn)
In order to avoid that user use the wrong overload and forget to provided the command param values, the simple overload should be depreated.
Instead new overlaods taking a command object should be supplied.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (EMPIREDB-158) Avoid accidentally missng command
parameter values when using DBDatabase.executeSQL
Posted by "Rainer Döbele (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rainer Döbele resolved EMPIREDB-158.
------------------------------------
Resolution: Fixed
Fix Version/s: empire-db-2.4.1
new methods in DBDatabase:
- executeInsert
- executeUpdate
- executeDelete
> Avoid accidentally missng command parameter values when using DBDatabase.executeSQL
> -----------------------------------------------------------------------------------
>
> Key: EMPIREDB-158
> URL: https://issues.apache.org/jira/browse/EMPIREDB-158
> Project: Empire-DB
> Issue Type: Improvement
> Reporter: Rainer Döbele
> Assignee: Rainer Döbele
> Fix For: empire-db-2.4.1
>
>
> For executing insert, update and delete command the method DBDatabase.executeSQL must be used.
> When using prepared statements however it is necessary to use the overload that allows to specify the commands parameter values like this:
> db.executeSQL(cmd.getInsert(), cmd.getParamValues(), conn)
> In order to avoid that user use the wrong overload and forget to provided the command param values, the simple overload should be depreated.
> Instead new overlaods taking a command object should be supplied.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (EMPIREDB-158) Avoid accidentally missng command
parameter values when using DBDatabase.executeSQL
Posted by "Francis De Brabandere (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13436026#comment-13436026 ]
Francis De Brabandere commented on EMPIREDB-158:
------------------------------------------------
agree
> Avoid accidentally missng command parameter values when using DBDatabase.executeSQL
> -----------------------------------------------------------------------------------
>
> Key: EMPIREDB-158
> URL: https://issues.apache.org/jira/browse/EMPIREDB-158
> Project: Empire-DB
> Issue Type: Improvement
> Reporter: Rainer Döbele
> Assignee: Rainer Döbele
>
> For executing insert, update and delete command the method DBDatabase.executeSQL must be used.
> When using prepared statements however it is necessary to use the overload that allows to specify the commands parameter values like this:
> db.executeSQL(cmd.getInsert(), cmd.getParamValues(), conn)
> In order to avoid that user use the wrong overload and forget to provided the command param values, the simple overload should be depreated.
> Instead new overlaods taking a command object should be supplied.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira