How to use JDBC in Spring Security 2.0 RC1? class, like, direction, property, someone

amy

Hi guys, trying to figure out how to use JDBC autorhization with Spring 2.0 can someone point me in the right direction please?
(hard coded works)

My approach now is like this:

Code:
lt;authentication-provider user-service-ref=quot;userServicequot;gt;       lt;password-encoder hash=quot;md5quot; /gt;   lt;/authentication-providergt;
  lt;beans:bean id=quot;userServicequot; class=quot;org..security.userdetails.jdbc.JdbcDaoImplquot;gt;       lt;beans:property name=quot;dataSourcequot; ref=quot;dataSourcequot; /gt;       lt;beans:property name=quot;authoritiesByUsernameQueryquot;gt;lt;beans:valuegt;SELECT username, authority FROM users WHERE username = ?lt;/beans:valuegt;       lt;/beans:propertygt;   lt;/beans:beangt;
My database have a table(users) with column username, password and authority.

If you have a working example please share asap!

SOLVED!

dbinit.txt