Todos os Exemplos que vejo na web, todos são voltados para MySQL, e para PostgreSQL ?:
o meu ta dando erro:
segue o código:<!-- DataSource PostgreSQL -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" destroy-method="close">
<property name="driverClassName" value="org.postgresql.Driver"/>
<property name="url" value="jdbc:postgresql://localhost:5432/nutec"/>
<property name="username" value="root"/>
<property name="password" value="debian23"/>
<security:authentication-manager alias="authManager">
<security:authentication-provider>
<security:password-encoder hash="plaintext"/>
<security:jdbc-user-service data-source-ref="dataSource"
users-by-username-query=""
authorities-by-username-query=""/>
</security:authentication-provider>
</security:authentication-manager>
-- 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;
SELECT
users.username,
users."password",
users.authority
FROM
public.users;