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

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.