Hi All, Summary:
Appfuse + Webwork 1.9.4, Tomcat 5.5, Postgresql 8.2 - simple Appfuse webapp works fine (using container managed authentication). Appfuse + Webwork 1.8.4, Tomcat 5.5, Acegi security - app (I've inherited) works fine against an Oracle DB, but I can't login with the same app pointing at a Postgres DB. Error "Bad SQL grammar" and "org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer;" Details: I have inherited a web application that's partly finished and I have the task of finishing it off. It's been built with AppFuse and Webwork (version 1.9.3 AFAICT). This is my first project with AppFuse, though I'm a relatively experienced J2EE developer. In my development environment, I'm deploying to Tomcat 5.5 and Postgresql. The client's production environment has Tomcat 5.5 and Oracle. The application deployed to the production environment (by the previous developer) works fine and I can login. I've downloaded AppFuse 1.9. built a simple test app (following the excellent tutorials) which runs fine against Postgres - I can login. However, when I build my proper application against the Postgres database, I can't login. After much sleuthing, I've established that it's using Acegi security whereas the default for Appfuse 1.9.x appears to be Container Managed. The problem appears to be with the SQL used in the applicationContext-security.xml file. The SQL that is causing the problem is: SELECT u.username,u.password,u.enabled FROM users u, company c WHERE u.username = ? AND c.id = u.company_id AND u.enabled = 1 The specific issue seems to be with the "u.enabled = 1" part, Postgres won't accept that as a valid expression because it won't cast the 1 literal to a boolean. I've tried to download a fresh copy of applicationContext-security.xml so I can see if my predecessor modified the original SQL (possibly to make it work with Oracle), however, the links to it on http://raibledesigns.com/wiki/Wiki.jsp?page=AppFuseAuthentication are unfortunately broken. I've done a bit of a hunt through the appfuse svn repository, but couldn't locate it there. So, my questions are: 1. Has this SQL been changed from the original in applicationContext- security.xml 2. Is it possible to get a copy of the original applicationContext-security.xml from somewhere. Cheers, Rob Hills Waikiki, Western Australia Mobile +61 (412) 904-357 Fax: +61 (8) 9529-2137 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
