[jira] Commented: (CAY-1287) SQLTemplate for not-mapping (DataRow) queries

["Evgeny Ryabitskiy (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAY-1287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12761484#action_12761484 ] 

Evgeny Ryabitskiy commented on CAY-1287:
----------------------------------------

So... why I set it bug and not a new feature....
If you look at Javadoc of SQLTemplate constructor, I can see:

    public SQLTemplate(Class rootClass, String defaultTemplate) {
        setDefaultTemplate(defaultTemplate);
        setRoot(rootClass);
    }

So lets look at setRoot(rootClass) method:

 /**
     * Sets the root of the query
     * 
     * @param value The new root
     * @throws IllegalArgumentException if value is not a String, ObjEntity, DbEntity,
     *             Procedure, DataMap, Class or null. < --- look here!
     */
    public void setRoot(Object value) {...... }

But (!!!) if I pass null it throws exception! Looks like it was expected before to work without mapping for queries....
but implementation not follows it.... 

> SQLTemplate for not-mapping (DataRow) queries
> ---------------------------------------------
>
>                 Key: CAY-1287
>                 URL: https://issues.apache.org/jira/browse/CAY-1287
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library
>    Affects Versions: 2.0 branch
>            Reporter: Evgeny Ryabitskiy
>             Fix For: 3.0
>
>
> I wish to use nice SQLTemplate scripting engine for my simple not-mapping (DataRow) runtime-formed queries.
> But now I should pass a DataObject to SQLTemplate constructor.
> The question is: "For what?"
> To do mapping???
> If my query is like: "SELECT max(id) as MAX_ID from Table1" it has no sense!
> I want to add constructor like: SQLTemplate(String defaultTemplate, Map parameter)
> and teach DataContext to perform such queries well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.