Rob Hills wrote: > 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 > I don't see how this can be a problem with PostGre and not Oracle - oracle doesn't _have_ boolean column values. -- derek
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
