users@glassfish.java.net

Re: JDBCRealm problem

From: <glassfish_at_javadesktop.org>
Date: Tue, 27 Jan 2009 16:26:34 PST

Perhaps rename the "password" column to something like "pwd" since the word password is a reserved word in many databases (unsure about Postgresql specifically). I've done this before with other databases and it solved problems like this.

Also I'm curious why the column names for password and version are in quotes in your create table scripts -- perhaps the column name is being created in Postgresql as literally "password" including the quotes?
[Message sent by forum member 'wfay' (wfay)]

http://forums.java.net/jive/thread.jspa?messageID=328525