Issue with DAS.createCommand(String sql)
----------------------------------------
Key: TUSCANY-3494
URL: https://issues.apache.org/jira/browse/TUSCANY-3494
Project: Tuscany
Issue Type: Bug
Components: Java DAS RDB
Affects Versions: Java-DAS-beta1
Reporter: Florian Pinel
The implementation of DAS.createCommand(String sql) assumes that all SELECT
statements start with the letter S, which is not true.
For example, a select statement in DB2 can start with a Common Table Expression:
WITH identifier AS (select stmt) select stmt
There may be other database-dependent examples for other kinds of commands.
I suggest that we add the following method to the DAS interface:
/**
* Creates a Command of the specified kind based on the provided SQL
statement
*
* @param sql
* The SQL statement
* @param sql
* The Command kind (select, insert, update, delete or
procedure), case-insensitive
* @return returns a Command instance
*/
Command createCommand(String sql, String kind);
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
