Spring Security - acesso ao banco de dados

Front-end
#1

Olá, estou usando o Spring Security e estou tentando buscar os usuários no banco de dados, porém não esta funcionando, quando faço o login não acontece nada apenas da este log:

08/07/2010 08:11:30 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
08/07/2010 08:11:30 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]

este é o meu arquivo de configuração:


	<http auto-config="true">
		<intercept-url pattern="/welcome" access="IS_AUTHENTICATED_ANONYMOUSLY"/>
		<intercept-url pattern="/static/css/**" access="IS_AUTHENTICATED_ANONYMOUSLY"/>
		<intercept-url pattern="/admin/**" access="ROLE_ADMIN" />
		<form-login login-page='/welcome' default-target-url="/admin/teste" authentication-failure-url="/welcome?login_error=1"/>
	</http>
	
	<authentication-manager>
		<authentication-provider>
			<jdbc-user-service data-source-ref="dataSource"
				users-by-username-query="SELECT username, password, enabled FROM user WHERE username=?"
				authorities-by-username-query="SELECT username, authority FROM authorities, user WHERE username=?"
			/>
		</authentication-provider>
	</authentication-manager>
	
	<beans:bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
		<beans:property name="url" value="jdbc:postgresql://localhost:5432/sas" />
		<beans:property name="driverClassName" value="org.postgresql.Driver" />
		<beans:property name="username" value="postgres" />
		<beans:property name="password" value="database" />
	</beans:bean>

Alguém pode me ajudar?

#2

Vc conseguiu resolver? Estou com o mesmo problema…

#3

A tabela USER … nao seria na verdade userS ???

http://www.mularien.com/blog/2008/07/07/5-minute-guide-to-spring-security/

#4

Estou com o mesmo problema.

O pior é que tava conectando e logando normal, de repente parou e agora não vai mais.
O log:

13:15:44,020 INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader] (http-localhost-127.0.0.1-8080-1) Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml] 13:15:44,064 INFO [org.springframework.jdbc.support.SQLErrorCodesFactory] (http-localhost-127.0.0.1-8080-1) SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]

XML:

[code] sec:authentication-manager
sec:authentication-provider
<sec:password-encoder hash=“md5” />
<sec:jdbc-user-service data-source-ref=“dataSourceLogin”
users-by-username-query=“SELECT username, password, enable FROM usuario WHERE username=?”
authorities-by-username-query=“SELECT usuario_username as username, autorizacoes_nome as authority FROM tusuario_autorizacao WHERE usuario_username=?” />
</sec:authentication-provider>
</sec:authentication-manager>

<beans:bean id="dataSourceLogin" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
	<beans:property name="driverClassName" value="com.mysql.jdbc.Driver" />
    <beans:property name="url" value="jdbc:mysql://us-cdbr-cb-east-01.cleardb.net:3306/cb_erp_ps_transp" />
	<beans:property name="username" value="b5707d7b4c8f57" />
	<beans:property name="password" value="*********" />				
</beans:bean>

[/code]

#5