[jboss-jira] [JBoss JIRA] Resolved: (JBPM-623) DatabaseServerLoginModule in login-config.xml does not work with oracle

[Ronald van Kuijk (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBPM-623?page=all ]

Ronald van Kuijk resolved JBPM-623.
-----------------------------------

    Resolution: Done

Seems to work in 3.2 head....

> DatabaseServerLoginModule in login-config.xml does not work with oracle
> -----------------------------------------------------------------------
>
>                 Key: JBPM-623
>                 URL: http://jira.jboss.com/jira/browse/JBPM-623
>             Project: JBoss jBPM
>          Issue Type: Bug
>          Components: Web Interface
>    Affects Versions: jBPM 3.2 alpha 1
>         Environment: linux kernel 2.6.xx, sun jdk 1.5.0_06, jboss 4.0.3sp1, cvs head from 04/04/06
>            Reporter: Ronald van Kuijk
>         Assigned To: Tom Baeyens
>            Priority: Minor
>
> The select statement for the rolesQuery does not work on oracle, at least not on 'Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production'  with the 9 or 10 drivers.
> The error I get is that the command is not properly ended:
> Error Code: 933, SQL State: 42000]  ORA-00933: SQL command not properly ended
> removing the 'as' statements in the select solves the problem, so
>              SELECT g.NAME_ ,'Roles' 
>              FROM JBPM_ID_USER as u,
>                   JBPM_ID_MEMBERSHIP as m,
>                   JBPM_ID_GROUP as g
>              WHERE g.TYPE_='security-role'
>                AND m.GROUP_ = g.ID_
>                AND m.USER_ = u.ID_
>                AND u.NAME_=?
> does not work, but
>              SELECT g.NAME_ ,'Roles' 
>              FROM JBPM_ID_USER u,
>                   JBPM_ID_MEMBERSHIP m,
>                   JBPM_ID_GROUP g
>              WHERE g.TYPE_='security-role'
>                AND m.GROUP_ = g.ID_
>                AND m.USER_ = u.ID_
>                AND u.NAME_=?
> does.... 
> my sql knowledge is very, very little, so do not ask me to seek out why one is working and the other isn't. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira