cicerogomes 16 de jun. de 2010
ola, checou na documentação ?
juniorsatanas 17 de ago. de 2010
LPJava 17 de ago. de 2010
bem eu nao entendi direito o que de fato vc quis dizer, faltou ser um pouco mais especifico. mas, tentei deduzir, veja esse meu post a seguir:
http://blog.camilolopes.com.br/category/spring/
juniorsatanas 18 de ago. de 2010
mysql:
A seguir mostramos com o MySQL . É simples demais , confira :
1
authorities - by - username - query = & quot ; SELECT username , concat ( ' ROLE_ ' , authority ) FROM users where username = ? & quot ;
O código completo fica assim :
1
& lt ; jdbc - user - service data - source - ref = & quot ; dataSource & quot ;
2
3
users - by - username - query = & quot ; SELECT username , password , ' true ' as enable FROM users WHERE username =? & quot ;
4
authorities - by - username - query = & quot ; SELECT username , concat ( ' ROLE_ ' , authority ) FROM users where username = ? & quot ;
5
/& gt ;
ou dessa forma :
1
users - by - username - query = & quot ; SELECT l . login as username , l . senha as password , ' true ' as enable from funcionario l where l . login =? & quot ;
2
authorities - by - username - query = & quot ; SELECT lo . login as username , CONCAT ( ' ROLE_ ' , lo . cargo ) as authority FROM funcionario lo where lo . login =? & quot ; /& gt ;
Outra dica é se a coluna do usuario / password não for o que o Spring Security espera , basta você fazer conforme o código a seguir :
1
users - by - username - query = & quot ; SELECT us . email as username , us . senha as password , ' true ' as enable FROM usuario as us WHERE email =? & quot ;
2
authorities - by - username - query = & quot ; SELECT us . email as username , us . tipo as authority FROM usuario us where email = ? & quot ;
é para PostGreSQL ?
juniorsatanas 18 de ago. de 2010
MEU BD :
-- Table : users
-- DROP TABLE users ;
CREATE TABLE users
(
username character varying ( 15 ) NOT NULL ,
"password" character varying ( 40 ),
authority character varying ( 15 ),
CONSTRAINT users_pkey PRIMARY KEY ( username )
)
WITH (
OIDS = FALSE
);
ALTER TABLE users OWNER TO root ;
meu select:
SELECT
users.username,
users."password",
users.authority
FROM
public.users;
isso me retorna:
usuario , senha, ROLE_USER
e este erro:
quando rodo a aplicalçao:
at java . lang . Thread . run ( Thread . java : 619 )
Caused by : org . xml . sax . SAXParseException : cvc - complex - type . 2.4 . a : Invalid content was found starting with element 'jdbc-user-service' . One of '{"http://www.springframework.org/schema/security":any-user-service, "http://www.springframework.org/schema/security":password-encoder}' is expected .
at com . sun . org . apache . xerces . internal . util . ErrorHandlerWrapper . createSAXParseException ( ErrorHandlerWrapper . java : 195 )
at com . sun . org . apache . xerces . internal . util . ErrorHandlerWrapper . error ( ErrorHandlerWrapper . java : 131 )
at com . sun . org . apache . xerces . internal . impl . XMLErrorReporter . reportError ( XMLErrorReporter . java : 384 )
at com . sun . org . apache . xerces . internal . impl . XMLErrorReporter . reportError ( XMLErrorReporter . java : 318 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator $ XSIErrorReporter . reportError ( XMLSchemaValidator . java : 417 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator . reportSchemaError ( XMLSchemaValidator . java : 3181 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator . handleStartElement ( XMLSchemaValidator . java : 1805 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator . emptyElement ( XMLSchemaValidator . java : 725 )
at com . sun . org . apache . xerces . internal . impl . XMLNSDocumentScannerImpl . scanStartElement ( XMLNSDocumentScannerImpl . java : 377 )
at com . sun . org . apache . xerces . internal . impl . XMLDocumentFragmentScannerImpl $ FragmentContentDriver . next ( XMLDocumentFragmentScannerImpl . java : 2755 )
at com . sun . org . apache . xerces . internal . impl . XMLDocumentScannerImpl . next ( XMLDocumentScannerImpl . java : 648 )
at com . sun . org . apache . xerces . internal . impl . XMLNSDocumentScannerImpl . next ( XMLNSDocumentScannerImpl . java : 140 )
at com . sun . org . apache . xerces . internal . impl . XMLDocumentFragmentScannerImpl . scanDocument ( XMLDocumentFragmentScannerImpl . java : 511 )
at com . sun . org . apache . xerces . internal . parsers . XML11Configuration . parse ( XML11Configuration . java : 808 )
at com . sun . org . apache . xerces . internal . parsers . XML11Configuration . parse ( XML11Configuration . java : 737 )
at com . sun . org . apache . xerces . internal . parsers . XMLParser . parse ( XMLParser . java : 119 )
at com . sun . org . apache . xerces . internal . parsers . DOMParser . parse ( DOMParser . java : 235 )
at com . sun . org . apache . xerces . internal . jaxp . DocumentBuilderImpl . parse ( DocumentBuilderImpl . java : 284 )
at org . springframework . beans . factory . xml . DefaultDocumentLoader . loadDocument ( DefaultDocumentLoader . java : 75 )
at org . springframework . beans . factory . xml . XmlBeanDefinitionReader . doLoadBeanDefinitions ( XmlBeanDefinitionReader . java : 396 )
... 49 more
18 / 08 / 2010 07 : 19 : 05 org . apache . catalina . core . ApplicationContext log
INFO : Closing Spring root WebApplicationContext
18 / 08 / 2010 07 : 29 : 48 org . apache . catalina . core . ApplicationContext log
INFO : Initializing Spring root WebApplicationContext
18 / 08 / 2010 07 : 29 : 48 org . apache . catalina . core . StandardContext listenerStart
SEVERE : Exception sending context initialized event to listener instance of class org . springframework . web . context . ContextLoaderListener
org . springframework . beans . factory . xml . XmlBeanDefinitionStoreException : Line 63 in XML document from class path resource [ applicationContext . xml ] is invalid ; nested exception is org . xml . sax . SAXParseException : cvc - complex - type . 2.4 . a : Invalid content was found starting with element 'jdbc-user-service' . One of '{"http://www.springframework.org/schema/security":any-user-service, "http://www.springframework.org/schema/security":password-encoder}' is expected .
at org . springframework . beans . factory . xml . XmlBeanDefinitionReader . doLoadBeanDefinitions ( XmlBeanDefinitionReader . java : 404 )
at org . springframework . beans . factory . xml . XmlBeanDefinitionReader . loadBeanDefinitions ( XmlBeanDefinitionReader . java : 342 )
at org . springframework . beans . factory . xml . XmlBeanDefinitionReader . loadBeanDefinitions ( XmlBeanDefinitionReader . java : 310 )
at org . springframework . beans . factory . support . AbstractBeanDefinitionReader . loadBeanDefinitions ( AbstractBeanDefinitionReader . java : 143 )
at org . springframework . beans . factory . support . AbstractBeanDefinitionReader . loadBeanDefinitions ( AbstractBeanDefinitionReader . java : 178 )
at org . springframework . beans . factory . support . AbstractBeanDefinitionReader . loadBeanDefinitions ( AbstractBeanDefinitionReader . java : 149 )
at org . springframework . web . context . support . XmlWebApplicationContext . loadBeanDefinitions ( XmlWebApplicationContext . java : 124 )
at org . springframework . web . context . support . XmlWebApplicationContext . loadBeanDefinitions ( XmlWebApplicationContext . java : 92 )
at org . springframework . context . support . AbstractRefreshableApplicationContext . refreshBeanFactory ( AbstractRefreshableApplicationContext . java : 123 )
at org . springframework . context . support . AbstractApplicationContext . obtainFreshBeanFactory ( AbstractApplicationContext . java : 422 )
at org . springframework . context . support . AbstractApplicationContext . refresh ( AbstractApplicationContext . java : 352 )
at org . springframework . web . context . ContextLoader . createWebApplicationContext ( ContextLoader . java : 255 )
at org . springframework . web . context . ContextLoader . initWebApplicationContext ( ContextLoader . java : 199 )
at org . springframework . web . context . ContextLoaderListener . contextInitialized ( ContextLoaderListener . java : 45 )
at org . apache . catalina . core . StandardContext . listenerStart ( StandardContext . java : 3934 )
at org . apache . catalina . core . StandardContext . start ( StandardContext . java : 4429 )
at org . apache . catalina . core . ContainerBase . addChildInternal ( ContainerBase . java : 791 )
at org . apache . catalina . core . ContainerBase . addChild ( ContainerBase . java : 771 )
at org . apache . catalina . core . StandardHost . addChild ( StandardHost . java : 526 )
at org . apache . catalina . startup . HostConfig . deployDescriptor ( HostConfig . java : 630 )
at org . apache . catalina . startup . HostConfig . deployDescriptors ( HostConfig . java : 556 )
at org . apache . catalina . startup . HostConfig . deployApps ( HostConfig . java : 491 )
at org . apache . catalina . startup . HostConfig . start ( HostConfig . java : 1206 )
at org . apache . catalina . startup . HostConfig . lifecycleEvent ( HostConfig . java : 314 )
at org . apache . catalina . util . LifecycleSupport . fireLifecycleEvent ( LifecycleSupport . java : 119 )
at org . apache . catalina . core . ContainerBase . start ( ContainerBase . java : 1053 )
at org . apache . catalina . core . StandardHost . start ( StandardHost . java : 722 )
at org . apache . catalina . core . ContainerBase . start ( ContainerBase . java : 1045 )
at org . apache . catalina . core . StandardEngine . start ( StandardEngine . java : 443 )
at org . apache . catalina . core . StandardService . start ( StandardService . java : 516 )
at org . apache . catalina . core . StandardServer . start ( StandardServer . java : 710 )
at org . apache . catalina . startup . Catalina . start ( Catalina . java : 583 )
at sun . reflect . NativeMethodAccessorImpl . invoke0 ( Native Method )
at sun . reflect . NativeMethodAccessorImpl . invoke ( NativeMethodAccessorImpl . java : 39 )
at sun . reflect . DelegatingMethodAccessorImpl . invoke ( DelegatingMethodAccessorImpl . java : 25 )
at java . lang . reflect . Method . invoke ( Method . java : 597 )
at org . apache . catalina . startup . Bootstrap . start ( Bootstrap . java : 288 )
at org . apache . catalina . startup . Bootstrap . main ( Bootstrap . java : 413 )
Caused by : org . xml . sax . SAXParseException : cvc - complex - type . 2.4 . a : Invalid content was found starting with element 'jdbc-user-service' . One of '{"http://www.springframework.org/schema/security":any-user-service, "http://www.springframework.org/schema/security":password-encoder}' is expected .
at com . sun . org . apache . xerces . internal . util . ErrorHandlerWrapper . createSAXParseException ( ErrorHandlerWrapper . java : 195 )
at com . sun . org . apache . xerces . internal . util . ErrorHandlerWrapper . error ( ErrorHandlerWrapper . java : 131 )
at com . sun . org . apache . xerces . internal . impl . XMLErrorReporter . reportError ( XMLErrorReporter . java : 384 )
at com . sun . org . apache . xerces . internal . impl . XMLErrorReporter . reportError ( XMLErrorReporter . java : 318 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator $ XSIErrorReporter . reportError ( XMLSchemaValidator . java : 417 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator . reportSchemaError ( XMLSchemaValidator . java : 3181 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator . handleStartElement ( XMLSchemaValidator . java : 1805 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator . emptyElement ( XMLSchemaValidator . java : 725 )
at com . sun . org . apache . xerces . internal . impl . XMLNSDocumentScannerImpl . scanStartElement ( XMLNSDocumentScannerImpl . java : 377 )
at com . sun . org . apache . xerces . internal . impl . XMLDocumentFragmentScannerImpl $ FragmentContentDriver . next ( XMLDocumentFragmentScannerImpl . java : 2755 )
at com . sun . org . apache . xerces . internal . impl . XMLDocumentScannerImpl . next ( XMLDocumentScannerImpl . java : 648 )
at com . sun . org . apache . xerces . internal . impl . XMLNSDocumentScannerImpl . next ( XMLNSDocumentScannerImpl . java : 140 )
at com . sun . org . apache . xerces . internal . impl . XMLDocumentFragmentScannerImpl . scanDocument ( XMLDocumentFragmentScannerImpl . java : 511 )
at com . sun . org . apache . xerces . internal . parsers . XML11Configuration . parse ( XML11Configuration . java : 808 )
at com . sun . org . apache . xerces . internal . parsers . XML11Configuration . parse ( XML11Configuration . java : 737 )
at com . sun . org . apache . xerces . internal . parsers . XMLParser . parse ( XMLParser . java : 119 )
at com . sun . org . apache . xerces . internal . parsers . DOMParser . parse ( DOMParser . java : 235 )
at com . sun . org . apache . xerces . internal . jaxp . DocumentBuilderImpl . parse ( DocumentBuilderImpl . java : 284 )
at org . springframework . beans . factory . xml . DefaultDocumentLoader . loadDocument ( DefaultDocumentLoader . java : 75 )
at org . springframework . beans . factory . xml . XmlBeanDefinitionReader . doLoadBeanDefinitions ( XmlBeanDefinitionReader . java : 396 )
... 37 more
18 / 08 / 2010 07 : 29 : 49 org . apache . catalina . core . ApplicationContext log
INFO : Closing Spring root WebApplicationContext
18 / 08 / 2010 07 : 29 : 51 org . apache . catalina . core . ApplicationContext log
INFO : Initializing Spring root WebApplicationContext
18 / 08 / 2010 07 : 29 : 51 org . apache . catalina . core . StandardContext listenerStart
SEVERE : Exception sending context initialized event to listener instance of class org . springframework . web . context . ContextLoaderListener
org . springframework . beans . factory . xml . XmlBeanDefinitionStoreException : Line 63 in XML document from class path resource [ applicationContext . xml ] is invalid ; nested exception is org . xml . sax . SAXParseException : cvc - complex - type . 2.4 . a : Invalid content was found starting with element 'jdbc-user-service' . One of '{"http://www.springframework.org/schema/security":any-user-service, "http://www.springframework.org/schema/security":password-encoder}' is expected .
at org . springframework . beans . factory . xml . XmlBeanDefinitionReader . doLoadBeanDefinitions ( XmlBeanDefinitionReader . java : 404 )
at org . springframework . beans . factory . xml . XmlBeanDefinitionReader . loadBeanDefinitions ( XmlBeanDefinitionReader . java : 342 )
at org . springframework . beans . factory . xml . XmlBeanDefinitionReader . loadBeanDefinitions ( XmlBeanDefinitionReader . java : 310 )
at org . springframework . beans . factory . support . AbstractBeanDefinitionReader . loadBeanDefinitions ( AbstractBeanDefinitionReader . java : 143 )
at org . springframework . beans . factory . support . AbstractBeanDefinitionReader . loadBeanDefinitions ( AbstractBeanDefinitionReader . java : 178 )
at org . springframework . beans . factory . support . AbstractBeanDefinitionReader . loadBeanDefinitions ( AbstractBeanDefinitionReader . java : 149 )
at org . springframework . web . context . support . XmlWebApplicationContext . loadBeanDefinitions ( XmlWebApplicationContext . java : 124 )
at org . springframework . web . context . support . XmlWebApplicationContext . loadBeanDefinitions ( XmlWebApplicationContext . java : 92 )
at org . springframework . context . support . AbstractRefreshableApplicationContext . refreshBeanFactory ( AbstractRefreshableApplicationContext . java : 123 )
at org . springframework . context . support . AbstractApplicationContext . obtainFreshBeanFactory ( AbstractApplicationContext . java : 422 )
at org . springframework . context . support . AbstractApplicationContext . refresh ( AbstractApplicationContext . java : 352 )
at org . springframework . web . context . ContextLoader . createWebApplicationContext ( ContextLoader . java : 255 )
at org . springframework . web . context . ContextLoader . initWebApplicationContext ( ContextLoader . java : 199 )
at org . springframework . web . context . ContextLoaderListener . contextInitialized ( ContextLoaderListener . java : 45 )
at org . apache . catalina . core . StandardContext . listenerStart ( StandardContext . java : 3934 )
at org . apache . catalina . core . StandardContext . start ( StandardContext . java : 4429 )
at org . apache . catalina . core . ContainerBase . addChildInternal ( ContainerBase . java : 791 )
at org . apache . catalina . core . ContainerBase . addChild ( ContainerBase . java : 771 )
at org . apache . catalina . core . StandardHost . addChild ( StandardHost . java : 526 )
at org . apache . catalina . startup . HostConfig . deployDescriptor ( HostConfig . java : 630 )
at org . apache . catalina . startup . HostConfig . deployApps ( HostConfig . java : 514 )
at org . apache . catalina . startup . HostConfig . check ( HostConfig . java : 1288 )
at sun . reflect . NativeMethodAccessorImpl . invoke0 ( Native Method )
at sun . reflect . NativeMethodAccessorImpl . invoke ( NativeMethodAccessorImpl . java : 39 )
at sun . reflect . DelegatingMethodAccessorImpl . invoke ( DelegatingMethodAccessorImpl . java : 25 )
at java . lang . reflect . Method . invoke ( Method . java : 597 )
at org . apache . tomcat . util . modeler . BaseModelMBean . invoke ( BaseModelMBean . java : 297 )
at com . sun . jmx . interceptor . DefaultMBeanServerInterceptor . invoke ( DefaultMBeanServerInterceptor . java : 836 )
at com . sun . jmx . mbeanserver . JmxMBeanServer . invoke ( JmxMBeanServer . java : 761 )
at org . apache . catalina . manager . ManagerServlet . check ( ManagerServlet . java : 1473 )
at org . apache . catalina . manager . ManagerServlet . deploy ( ManagerServlet . java : 824 )
at org . apache . catalina . manager . ManagerServlet . doGet ( ManagerServlet . java : 350 )
at javax . servlet . http . HttpServlet . service ( HttpServlet . java : 617 )
at javax . servlet . http . HttpServlet . service ( HttpServlet . java : 717 )
at org . apache . catalina . core . ApplicationFilterChain . internalDoFilter ( ApplicationFilterChain . java : 290 )
at org . apache . catalina . core . ApplicationFilterChain . doFilter ( ApplicationFilterChain . java : 206 )
at org . netbeans . modules . web . monitor . server . MonitorFilter . doFilter ( MonitorFilter . java : 196 )
at org . apache . catalina . core . ApplicationFilterChain . internalDoFilter ( ApplicationFilterChain . java : 235 )
at org . apache . catalina . core . ApplicationFilterChain . doFilter ( ApplicationFilterChain . java : 206 )
at org . apache . catalina . core . StandardWrapperValve . invoke ( StandardWrapperValve . java : 233 )
at org . apache . catalina . core . StandardContextValve . invoke ( StandardContextValve . java : 191 )
at org . apache . catalina . authenticator . AuthenticatorBase . invoke ( AuthenticatorBase . java : 525 )
at org . apache . catalina . core . StandardHostValve . invoke ( StandardHostValve . java : 128 )
at org . apache . catalina . valves . ErrorReportValve . invoke ( ErrorReportValve . java : 102 )
at org . apache . catalina . core . StandardEngineValve . invoke ( StandardEngineValve . java : 109 )
at org . apache . catalina . connector . CoyoteAdapter . service ( CoyoteAdapter . java : 293 )
at org . apache . coyote . http11 . Http11Processor . process ( Http11Processor . java : 849 )
at org . apache . coyote . http11 . Http11Protocol $ Http11ConnectionHandler . process ( Http11Protocol . java : 583 )
at org . apache . tomcat . util . net . JIoEndpoint $ Worker . run ( JIoEndpoint . java : 454 )
at java . lang . Thread . run ( Thread . java : 619 )
Caused by : org . xml . sax . SAXParseException : cvc - complex - type . 2.4 . a : Invalid content was found starting with element 'jdbc-user-service' . One of '{"http://www.springframework.org/schema/security":any-user-service, "http://www.springframework.org/schema/security":password-encoder}' is expected .
at com . sun . org . apache . xerces . internal . util . ErrorHandlerWrapper . createSAXParseException ( ErrorHandlerWrapper . java : 195 )
at com . sun . org . apache . xerces . internal . util . ErrorHandlerWrapper . error ( ErrorHandlerWrapper . java : 131 )
at com . sun . org . apache . xerces . internal . impl . XMLErrorReporter . reportError ( XMLErrorReporter . java : 384 )
at com . sun . org . apache . xerces . internal . impl . XMLErrorReporter . reportError ( XMLErrorReporter . java : 318 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator $ XSIErrorReporter . reportError ( XMLSchemaValidator . java : 417 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator . reportSchemaError ( XMLSchemaValidator . java : 3181 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator . handleStartElement ( XMLSchemaValidator . java : 1805 )
at com . sun . org . apache . xerces . internal . impl . xs . XMLSchemaValidator . emptyElement ( XMLSchemaValidator . java : 725 )
at com . sun . org . apache . xerces . internal . impl . XMLNSDocumentScannerImpl . scanStartElement ( XMLNSDocumentScannerImpl . java : 377 )
at com . sun . org . apache . xerces . internal . impl . XMLDocumentFragmentScannerImpl $ FragmentContentDriver . next ( XMLDocumentFragmentScannerImpl . java : 2755 )
at com . sun . org . apache . xerces . internal . impl . XMLDocumentScannerImpl . next ( XMLDocumentScannerImpl . java : 648 )
at com . sun . org . apache . xerces . internal . impl . XMLNSDocumentScannerImpl . next ( XMLNSDocumentScannerImpl . java : 140 )
at com . sun . org . apache . xerces . internal . impl . XMLDocumentFragmentScannerImpl . scanDocument ( XMLDocumentFragmentScannerImpl . java : 511 )
at com . sun . org . apache . xerces . internal . parsers . XML11Configuration . parse ( XML11Configuration . java : 808 )
at com . sun . org . apache . xerces . internal . parsers . XML11Configuration . parse ( XML11Configuration . java : 737 )
at com . sun . org . apache . xerces . internal . parsers . XMLParser . parse ( XMLParser . java : 119 )
at com . sun . org . apache . xerces . internal . parsers . DOMParser . parse ( DOMParser . java : 235 )
at com . sun . org . apache . xerces . internal . jaxp . DocumentBuilderImpl . parse ( DocumentBuilderImpl . java : 284 )
at org . springframework . beans . factory . xml . DefaultDocumentLoader . loadDocument ( DefaultDocumentLoader . java : 75 )
at org . springframework . beans . factory . xml . XmlBeanDefinitionReader . doLoadBeanDefinitions ( XmlBeanDefinitionReader . java : 396 )
... 49 more
18 / 08 / 2010 07 : 29 : 52 org . apache . catalina . core . ApplicationContext log
INFO : Closing Spring root WebApplicationContext