[RESOLVIDO] Hibernate + Spring Security

Allan.Lima · Fevereiro 7, 2013, 3:54am

Boa noite à Todos,

Estou desenvolvendo um aplicativo, mas ando quebrando a cabeça com algumas coisas… Estou utilizando hibernate e Spring Security. Após ter implantado o Spring Security, estou tendo algumas dificuldades para subir a aplicação.

Segue o erro:

Fev 07, 2013 12:41:09 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\Intel\iCLS Client;C:\Program Files\Intel\iCLS Client;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\Intel\Intel® Management Engine Components\DAL;C:\Program Files\Intel\Intel® Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel® Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel® Management Engine Components\IPT;C:\Program Files\Java\jdk1.7.0_10\bin;% M2_HOME%\ bin;;.
Fev 07, 2013 12:41:10 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source’ to ‘org.eclipse.jst.jee.server:scs’ did not find a matching property.
Fev 07, 2013 12:41:10 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [“http-bio-8080”]
Fev 07, 2013 12:41:10 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [“ajp-bio-8009”]
Fev 07, 2013 12:41:10 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 703 ms
Fev 07, 2013 12:41:10 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Fev 07, 2013 12:41:10 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.34
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/fmt_rt is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/scriptfree is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/sql is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/core is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/xml_rt is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/sql_rt is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/permittedTaglibs is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/xml is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/core_rt is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/core is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/functions is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/fmt is already defined
Fev 07, 2013 12:41:14 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
00:41:14,291 INFO [localhost-startStop-1] ContextLoader:187 - Root WebApplicationContext: initialization started
00:41:14,325 INFO [localhost-startStop-1] XmlWebApplicationContext:456 - Refreshing Root WebApplicationContext: startup date [Thu Feb 07 00:41:14 GMT-03:00 2013]; root of context hierarchy
00:41:14,387 INFO [localhost-startStop-1] XmlBeanDefinitionReader:315 - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
00:41:14,496 INFO [localhost-startStop-1] XmlBeanDefinitionReader:315 - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext-security.xml]
00:41:14,588 INFO [localhost-startStop-1] SpringSecurityCoreVersion:22 - You are running with Spring Security Core 3.0.5.RELEASE
00:41:14,589 INFO [localhost-startStop-1] SecurityNamespaceHandler:57 - Spring Security ‘config’ module version is 3.0.5.RELEASE
00:41:14,677 INFO [localhost-startStop-1] HttpSecurityBeanDefinitionParser:188 - Checking sorted filter chain: [Root bean: class [org.springframework.security.web.context.SecurityContextPersistenceFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 300, Root bean: class [org.springframework.security.web.authentication.logout.LogoutFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 400, Root bean: class [org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 800, Root bean: class [org.springframework.security.web.savedrequest.RequestCacheAwareFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 1300, Root bean: class [org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 1400, Root bean: class [org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 1500, Root bean: class [org.springframework.security.web.authentication.AnonymousAuthenticationFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 1600, Root bean: class [org.springframework.security.web.session.SessionManagementFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 1700, Root bean: class [org.springframework.security.web.access.ExceptionTranslationFilter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = 1800, <org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0>, order = 1900]
00:41:14,823 INFO [localhost-startStop-1] DefaultListableBeanFactory:549 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@47d16843: defining beans [scsDataSource,org.springframework.security.web.PortMapperImpl#0,org.springframework.security.web.context.HttpSessionSecurityContextRepository#0,org.springframework.security.web.authentication.session.SessionFixationProtectionStrategy#0,org.springframework.security.authentication.ProviderManager#0,org.springframework.security.access.vote.AffirmativeBased#0,org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0,org.springframework.security.web.access.DefaultWebInvocationPrivilegeEvaluator#0,org.springframework.security.authentication.AnonymousAuthenticationProvider#0,org.springframework.security.web.authentication.rememberme.TokenBasedRememberMeServices#0,org.springframework.security.authentication.RememberMeAuthenticationProvider#0,org.springframework.security.web.savedrequest.HttpSessionRequestCache#0,org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter#0,org.springframework.security.config.http.UserDetailsServiceInjectionBeanPostProcessor#0,org.springframework.security.filterChainProxy,org.springframework.security.provisioning.JdbcUserDetailsManager#0,org.springframework.security.authentication.dao.DaoAuthenticationProvider#0,org.springframework.security.authentication.DefaultAuthenticationEventPublisher#0,org.springframework.security.authenticationManager]; root of factory hierarchy
00:41:14,917 INFO [localhost-startStop-1] JdbcUserDetailsManager:130 - No authentication manager set. Reauthentication of users when changing passwords will not be performed.
00:41:15,005 INFO [localhost-startStop-1] FilterSecurityInterceptor:156 - Validated configuration attributes
00:41:15,138 INFO [localhost-startStop-1] ContextLoader:214 - Root WebApplicationContext: initialization completed in 845 ms
Fev 07, 2013 12:41:15 AM com.sun.faces.config.ConfigureListener contextInitialized
INFO: Inicializando Mojarra 2.0.9 (FCS 20120216) para o contexto '/scs’
Fev 07, 2013 12:41:15 AM com.sun.faces.spi.InjectionProviderFactory createInstance
INFO: JSF1048: Anotações PostConstruct/PreDestroy presentes. Os métodos ManagedBeans marcados com essas anotações informarão as anotações processadas.
00:41:16,224 INFO [localhost-startStop-1] Version:37 - HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
00:41:16,231 INFO [localhost-startStop-1] Version:41 - HHH000412: Hibernate Core {4.1.9.Final}
00:41:16,234 INFO [localhost-startStop-1] Environment:224 - HHH000205: Loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=org.h2.Driver, hibernate.dialect=org.hibernate.dialect.H2Dialect, hibernate.max_fetch_depth=5, hibernate.format_sql=true, hibernate.generate_statistics=true, hibernate.connection.username=sa, hibernate.connection.url=jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE, hibernate.bytecode.use_reflection_optimizer=false, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=5}
00:41:16,235 INFO [localhost-startStop-1] Environment:342 - HHH000021: Bytecode provider name : javassist
00:41:16,283 INFO [localhost-startStop-1] Configuration:1933 - HHH000043: Configuring from resource: /hibernate.cfg.xml
00:41:16,284 INFO [localhost-startStop-1] Configuration:1952 - HHH000040: Configuration resource: /hibernate.cfg.xml
00:41:16,307 WARN [localhost-startStop-1] DTDEntityResolver:74 - HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!
00:41:16,338 INFO [localhost-startStop-1] Configuration:2074 - HHH000041: Configured SessionFactory: null
00:41:16,552 INFO [localhost-startStop-1] Dialect:123 - HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
00:41:16,562 INFO [localhost-startStop-1] LobCreatorBuilder:85 - HHH000422: Disabling contextual LOB creation as connection was null
00:41:16,578 INFO [localhost-startStop-1] TransactionFactoryInitiator:68 - HHH000399: Using default transaction strategy (direct JDBC transactions)
00:41:16,584 INFO [localhost-startStop-1] ASTQueryTranslatorFactory:48 - HHH000397: Using ASTQueryTranslatorFactory
00:41:16,989 INFO [localhost-startStop-1] SchemaUpdate:182 - HHH000228: Running hbm2ddl schema update
00:41:16,989 INFO [localhost-startStop-1] SchemaUpdate:193 - HHH000102: Fetching database metadata
00:41:16,991 ERROR [localhost-startStop-1] SchemaUpdate:245 - HHH000299: Could not complete schema update
java.lang.UnsupportedOperationException: Not supported by BasicDataSource
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1062)
at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)
at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:194)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:17
at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:503)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1750)
at scs.util.HibernateUtil.buildSessionFactory(HibernateUtil.java:17)
at scs.util.HibernateUtil.(HibernateUtil.java:9)
at scs.filter.ConexaoHibernateFilter.init(ConexaoHibernateFilter.java:17)
at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:27
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:259)
at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:383)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:104)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4650)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5306)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Fev 07, 2013 12:41:17 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-bio-8080”]
Fev 07, 2013 12:41:17 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“ajp-bio-8009”]
Fev 07, 2013 12:41:17 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 6690 ms

Alguém tem uma luz?!

Valeu!!

CristianPalmaSola10 · Fevereiro 7, 2013, 10:27am

Bom pelo que vi voce teve ter configurado um BasicDatasource em algum lugar na sua aplicacao e teve ter usado este para a configuração de acesso a base de dados e ele disse para voce que essa operação não é suportada, posta o arquivo aonde voce configuro esse datasource…

Allan.Lima · Fevereiro 10, 2013, 12:59am

Web.xml:

<?xml version="1.0" encoding="UTF-8"?>

scs

<context-param>
	<param-name>contextConfigLocation</param-name>
	<param-value>
		/WEB-INF/applicationContext.xml
		/WEB-INF/applicationContext-security.xml
	</param-value>
</context-param>

<filter>
	<filter-name>springSecurityFilterChain</filter-name>
	<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>
</filter>

<filter-mapping>
	<filter-name>springSecurityFilterChain</filter-name>
	<url-pattern>/*</url-pattern>
</filter-mapping>

<listener>
	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

Faces Servlet javax.faces.webapp.FacesServlet 1 Faces Servlet *.jsf index.html conexaoFilter scs.filter.ConexaoHibernateFilter conexaoFilter *.jsf DataSource scsDB jdbc/scsDB javax.sql.DataSource Container

hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?> org.hibernate.dialect.MySQLDialect java:/comp/env/jdbc/scsDB thread update

	<mapping class="scs.usuario.Usuario"/>
</session-factory>

applicationContext.xml:

<?xml version="1.0" encoding="UTF-8"?>

<bean id="scsDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
	<property name="jndiName">
		<value>java:comp/env/jdbc/scsDB</value>
	</property>
</bean>

applicationContext-security.xml:

<?xml version="1.0" encoding="UTF-8"?>

<b:beans xmlns="http://www.springframework.org/schema/security"
xmlns:b="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation=“http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.0.xsd”>

	<intercept-url pattern="/admin/**" access="ROLE_ADMINISTRADOR" />
	<intercept-url pattern="/restrito/**" access="ROLE_USUARIO" />
	<form-login login-page="/publico/login.jsf"
		always-use-default-target="true" 
		default-target-url="/restrito/principal.jsf"
		authentication-failure-url="/publico/login.jsf?login_error=1" />
	<logout/>
	<remember-me />
</http>

<authentication-manager>
	<authentication-provider>
		<jdbc-user-service data-source-ref="scsDataSource"
			authorities-by-username-query="SELECT u.login, p.permissao 
										 FROM usuario u, usuario_permissao p 
										WHERE u.id_usuario = p.id_usuario 
										  AND u.login = ?"

			users-by-username-query="SELECT login, senha, ativo 
								   FROM usuario 
								  WHERE login = ?" />
	</authentication-provider>
</authentication-manager>

</b:beans>

LPJava · Fevereiro 10, 2013, 1:31pm

[quote=Allan.Lima]Web.xml:

<?xml version="1.0" encoding="UTF-8"?>

scs

<context-param>
	<param-name>contextConfigLocation</param-name>
	<param-value>
		/WEB-INF/applicationContext.xml
		/WEB-INF/applicationContext-security.xml
	</param-value>
</context-param>

<filter>
	<filter-name>springSecurityFilterChain</filter-name>
	<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>
</filter>

<filter-mapping>
	<filter-name>springSecurityFilterChain</filter-name>
	<url-pattern>/*</url-pattern>
</filter-mapping>

<listener>
	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

Faces Servlet javax.faces.webapp.FacesServlet 1 Faces Servlet *.jsf index.html conexaoFilter scs.filter.ConexaoHibernateFilter conexaoFilter *.jsf DataSource scsDB jdbc/scsDB javax.sql.DataSource Container

hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?> org.hibernate.dialect.MySQLDialect java:/comp/env/jdbc/scsDB thread update

	<mapping class="scs.usuario.Usuario"/>
</session-factory>

applicationContext.xml:

<?xml version="1.0" encoding="UTF-8"?>

<bean id="scsDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
	<property name="jndiName">
		<value>java:comp/env/jdbc/scsDB</value>
	</property>
</bean>

applicationContext-security.xml:

<?xml version="1.0" encoding="UTF-8"?>

<b:beans xmlns="http://www.springframework.org/schema/security"
xmlns:b="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation=“http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.0.xsd”>

	<intercept-url pattern="/admin/**" access="ROLE_ADMINISTRADOR" />
	<intercept-url pattern="/restrito/**" access="ROLE_USUARIO" />
	<form-login login-page="/publico/login.jsf"
		always-use-default-target="true" 
		default-target-url="/restrito/principal.jsf"
		authentication-failure-url="/publico/login.jsf?login_error=1" />
	<logout/>
	<remember-me />
</http>

<authentication-manager>
	<authentication-provider>
		<jdbc-user-service data-source-ref="scsDataSource"
			authorities-by-username-query="SELECT u.login, p.permissao 
										 FROM usuario u, usuario_permissao p 
										WHERE u.id_usuario = p.id_usuario 
										  AND u.login = ?"

			users-by-username-query="SELECT login, senha, ativo 
								   FROM usuario 
								  WHERE login = ?" />
	</authentication-provider>
</authentication-manager>

</b:beans>
[/quote]

favor: http://www.guj.com.br/java/50115-voce-e-novo-no-guj-vai-criar-um-topico-e-colar-seu-codigo-fonte-leia-aqui-antes-por-favor

Allan_Lima · Fevereiro 12, 2013, 4:32pm

Me passei em relação à formatação. Não irá acontecer mais.

valeu!

Allan_Lima · Fevereiro 12, 2013, 4:46pm

Seguem os arquivos formatados!

web.xml:

<?xml version="1.0" encoding="UTF-8"?> 
<web-app 
xmlns si="http://www.w3.org/2001/XMLSchema-instance" 
xmlns="http://java.sun.com/xml/ns/javaee" 
xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" 
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0"> 

<display-name>scs</display-name> 

<!-- Spring Security --> 
<context-param> 
<param-name>contextConfigLocation</param-name> 
<param-value> 
/WEB-INF/applicationContext.xml 
/WEB-INF/applicationContext-security.xml 
</param-value> 
</context-param> 

<filter> 
<filter-name>springSecurityFilterChain</filter-name> 
<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class> 
</filter> 

<filter-mapping> 
<filter-name>springSecurityFilterChain</filter-name> 
<url-pattern>/*</url-pattern> 
</filter-mapping> 

<listener> 
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> 
</listener> 

<!-- Faces Servlet --> 
<servlet> 
<servlet-name>Faces Servlet</servlet-name> 
<servlet-class>javax.faces.webapp.FacesServlet</servlet-class> 
<load-on-startup>1</load-on-startup> 
</servlet> 


<!-- Faces Servlet Mapping --> 
<servlet-mapping> 
<servlet-name>Faces Servlet</servlet-name> 
<url-pattern>*.jsf</url-pattern> 
</servlet-mapping> 

<welcome-file-list> 
<welcome-file>index.html</welcome-file> 
</welcome-file-list> 

<filter> 
<filter-name>conexaoFilter</filter-name> 
<filter-class>scs.filter.ConexaoHibernateFilter</filter-class> 
</filter> 

<filter-mapping> 
<filter-name>conexaoFilter</filter-name> 
<url-pattern>*.jsf</url-pattern> 
</filter-mapping> 

<resource-ref> 
<description>DataSource scsDB</description> 
<res-ref-name>jdbc/scsDB</res-ref-name> 
<res-type>javax.sql.DataSource</res-type> 
<res-auth>Container</res-auth> 
</resource-ref> 
</web-app>

hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?> 
<!DOCTYPE hibernate-configuration PUBLIC 
"-//Hibernate/Hibernate Configuration DTD//EN" 
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> 
<hibernate-configuration> 
<session-factory> 
<property name="dialect">org.hibernate.dialect.MySQLDialect</property> 
<property name="connection.datasource">java:/comp/env/jdbc/scsDB</property> 
<property name="current_session_context_class">thread</property> 
<property name="hibernate.hbm2ddl.auto">update</property> 

<mapping class="scs.usuario.Usuario"/> 
</session-factory> 
</hibernate-configuration>

applicationContext.xml:

<?xml version="1.0" encoding="UTF-8"?> 
<beans xmlns="http://www.springframework.org/schema/beans" 
xmlns si="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://www.springframework.org/schema/beans 
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"> 

<bean id="scsDataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> 
<property name="jndiName"> 
<value>java:comp/env/jdbc/scsDB</value> 
</property> 
</bean> 
</beans>

applicationContext-security:

<?xml version="1.0" encoding="UTF-8"?> 
<b:beans xmlns="http://www.springframework.org/schema/security" 
xmlns:b="http://www.springframework.org/schema/beans" 
xmlns si="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd 
http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.0.xsd"> 
<http> 

<intercept-url pattern="/admin/**" access="ROLE_ADMINISTRADOR" /> 
<intercept-url pattern="/restrito/**" access="ROLE_USUARIO" /> 
<form-login login-page="/publico/login.jsf" 
always-use-default-target="true" 
default-target-url="/restrito/principal.jsf" 
authentication-failure-url="/publico/login.jsf?login_error=1" /> 
<logout/> 
<remember-me /> 
</http> 

<authentication-manager> 
<authentication-provider> 
<jdbc-user-service data-source-ref="scsDataSource" 
authorities-by-username-query="SELECT u.login, p.permissao 
FROM usuario u, usuario_permissao p 
WHERE u.id_usuario = p.id_usuario 
AND u.login = ?" 

users-by-username-query="SELECT login, senha, ativo 
FROM usuario 
WHERE login = ?" /> 
</authentication-provider> 
</authentication-manager> 
</b:beans>

Allan.Lima · Fevereiro 14, 2013, 9:03pm

Boa tarde Pessoal,

Alguém tem uma alguma dica desse problema???

Agradeço muito!!!

system · Janeiro 6, 2016, 2:27am

[RESOLVIDO] Hibernate + Spring Security

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI