Hi Matt, Many thanks for the speedy reply.
On 3 Sep 2007 at 13:04, Matt Raible wrote: > You might try searching SVN's history at > http://fisheye4.cenqua.com/browse/appfuse. > > Later versions of AppFuse don't have SQL in their security file. OK, that's good to know, I was wondering if my revisions to the SQL would work with Oracle - don't have access to it to test it yet. Tomorrow (it's 3:30am here!) I'll try the simpler, "SQL-free" variant of the jdbcAuthenticationProvider bean you've got there, it looks much more flexible to me! Also, I note from the SVN changes and annotations to applicationContext- security.xml that it's been renamed back to security.xml - should I be doing this too? Is it just a case of simply renaming it, or were there changes in the file at the same time? > On 9/3/07, Rob Hills <[EMAIL PROTECTED]> wrote: > > 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;" 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]
