Re: JDBC Realm with case insensitive user name

2007-10-26 Thread Pedro
OK PID then you tell me where the jar goes hey? Pid wrote: Pedro wrote: Thanks for stating the obvious Tim, in 5.5 the 'server' directory is supposed to be the correct place! the question is if the implementation is valid. You referred to ClassNotFoundException's - his answer is

Re: JDBC Realm with case insensitive user name

2007-10-26 Thread Pedro
Hi Christopher, I knew that MySql does this, but I am using Postgres for this project and don't know if it is possible, the default is case sensitive for Postgres. The unique key option is out, as it has to be an id field for our database beans to work, but a unique constraint is possible I

Re: JDBC Realm with case insensitive user name

2007-10-26 Thread Pid
Pedro wrote: OK PID then you tell me where the jar goes hey? That's a lot of attitude for someone who wants help from the list. Or am I misreading your tone? I refer to my previous question: Perhaps you can elaborate on when you're getting this exception if we're to help you. (An actual

[OT] Re: JDBC Realm with case insensitive user name

2007-10-26 Thread Pid
Peter Stavrinides wrote: The most common reason...blah blah You know pid, just because people ask questions doesn't mean they are stupid, so why treat them that way? If you can read 'carefully' you can notice that the path was given as well as the relevant config in server.xml. So If the

Re: JDBC Realm with case insensitive user name

2007-10-26 Thread Peter Stavrinides
The most common reason...blah blah You know pid, just because people ask questions doesn't mean they are stupid, so why treat them that way? If you can read 'carefully' you can notice that the path was given as well as the relevant config in server.xml. So If the path was incorrect you could

Re: [OT] Re: JDBC Realm with case insensitive user name

2007-10-26 Thread David Smith
Peter -- cool it. As quoted from the OP below: I tried this approach but get class not found exceptions, I am using tomcat6 in development and 5.5 in production. I package this class in a jar and drop it in the $CATALENA_BASE/server/lib folder. Tim Funk actually (and correctly) asked the OP

Re: [OT] Re: JDBC Realm with case insensitive user name

2007-10-26 Thread Pid
Pid wrote: Peter Stavrinides wrote: The most common reason...blah blah You know pid, just because people ask questions doesn't mean they are stupid, so why treat them that way? If you can read 'carefully' you can notice that the path was given as well as the relevant config in server.xml. So

Re: [OT] Re: JDBC Realm with case insensitive user name

2007-10-26 Thread Peter Stavrinides
David, you are also arrogant!! I know what I wrote, and I know where the classloader looks for things so Tims answer is irrelevant and so is yours given that I have placed the jar in the correct place already and configured server.xml correctly. You also lack basic reading skills if you cant

JDBC Realm with case insensitive user name

2007-10-25 Thread Pedro
Hi all, I basically need to implement case insensitive user names, can this be done with a servlet filter or do I need to subclass JDBC realm: public class CustomJdbcRealm extends JDBCRealm { public CustomJdbcRealm() { super(); } public Principal authenticate(String

Re: JDBC Realm with case insensitive user name

2007-10-25 Thread Tim Funk
The dir structure changed from 5.5 to 6 so you need to place your files in different directories depending on the version. See the version specific docs details. -Tim Pedro wrote: Hi all, I basically need to implement case insensitive user names, can this be done with a servlet filter or

Re: JDBC Realm with case insensitive user name

2007-10-25 Thread Pedro
Thanks for stating the obvious Tim, in 5.5 the 'server' directory is supposed to be the correct place! the question is if the implementation is valid. Tim Funk wrote: The dir structure changed from 5.5 to 6 so you need to place your files in different directories depending on the version. See

Re: JDBC Realm with case insensitive user name

2007-10-25 Thread Tim Funk
In that case - (I think) it probably won't work - override instead: protected PreparedStatement credentials(Connection dbConnection, String username) protected synchronized PreparedStatement roles(Connection dbConnection, String username)

Re: JDBC Realm with case insensitive user name

2007-10-25 Thread Pid
Pedro wrote: Thanks for stating the obvious Tim, in 5.5 the 'server' directory is supposed to be the correct place! the question is if the implementation is valid. You referred to ClassNotFoundException's - his answer is therefore valid. Perhaps you can elaborate on when you're getting this

Re: JDBC Realm with case insensitive user name

2007-10-25 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pedro, Pedro wrote: I basically need to implement case insensitive user names, can this be done with a servlet filter or do I need to subclass JDBC realm: Er, before you get too far on this, check to see if your database already does this without