Derek Broughton wrote: > 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.
Ah. Now I do. Oracle doesn't have boolean columns - therefore, USERS.ENABLED in Oracle is either a numeric or character column, presumably having values of 0 or 1. Your PostGRE database apparently has USERS.ENABLED defined as boolean, so you get an invalid comparison to 1. -- derek --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
