Results 1 to 4 of 4

Thread: SQL in finders

  1. #1
    Join Date
    Jul 2009
    Posts
    18

    Default SQL in finders

    Hello,

    Encountered an issue in my finder aj file eg Product_Roo_Finder. The query starts with
    FROM Product AS product.
    I inserted
    SELECT Product
    @the start of the query and now its working.Another issue/question shouldn't the searchterm be surrounded by
    %%
    in the like queries? I'm using SVN rc1.0.

    Kind regards,

    Ronald Vermeire

  2. #2
    Join Date
    Jul 2009
    Posts
    18

    Default

    Hello,

    In addition to my previous post.Aren't there finders for @ManyToOne fields? Is this planned?

    Kind regards,

    Ronald Vermeire

  3. #3
    Join Date
    Mar 2008
    Location
    Sydney, AU
    Posts
    974

    Default

    Hi Ronald,

    Interesting, can you let me know which DB and ORM provider you are using in your sample? As always, a small Roo script would help us pin down the issue faster.

    The improvement of the like method for finders is already on my TODO list for this week .

    The @ManyToOne relationship is currently not supported but this is something that will probably be supported at some stage. Are you interested in contributing to this? Please open an 'improvement' Jira ticket for this.

    Regards,
    Stefan

  4. #4
    Join Date
    Jul 2009
    Posts
    18

    Default

    Hi Stefan,

    from persistence.xml:
    <property name="openjpa.jdbc.DBDictionary" value="org.apache.openjpa.jdbc.sql.HSQLDictionary"/>
    I created http://jira.springframework.org/browse/ROO-149

    I am interested in contributing but i don't think my knowledge-level is sufficient (yet), also since there is not a lot of documentation. Or can you provide more details than the -excellent- Roo related blogs?

    Kind regards,

    Ronald Vermeire

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •