Olá,
quando incluo essa linha no arquivo
<property name="username" value="${jdbc.username}"/>
da erro abaixo :
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:497)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:279)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 13 more
o que estou fazendo de errado pois queria ler o arquivo properties e não consigo…
alguém pode me ajudar …
Obs. não é um projeto WEB e coloquei o properties junto com o arquivo spring-config.xml
que se encontra br/com/xxxxxx/nl/xxxxxx/util ???
abs
<context:property-placeholder location="br/com/xxxxxx/nl/xxxxxx/util/jdbc.properties"/>
<!-- DAO de USUARIO -->
<bean id="usuarioDAO"
class="br.com.xxxxxx.nl.xxxxxx.dao.impl.PubUsuarioDAOImpl">
<property name="sessionFactory" ref="automacaoSessionFactory"/>
</bean>
<!-- DAO de NIVEL -->
<bean id="nivelDAO"
class="br.com.xxxxxx.nl.xxxxxx.dao.impl.PubNivelDAOImpl">
<property name="sessionFactory" ref="automacaoSessionFactory"/>
</bean>
<!-- DAO de FILIAL -->
<bean id="filialDAO"
class="br.com.xxxxxx.nl.xxxxxx.dao.impl.PubFilialDAOImpl">
<property name="sessionFactory" ref="automacaoSessionFactory"/>
</bean>
<!-- Datasource JDBC para o banco de dados -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="url">
<value>jdbc:oracle:thin:@128.1.30.247:1521:ATMDES
</value>
</property>
<property name="username" value="${jdbc.username}"/>
<property name="password">
<value>xxxxxx</value>
</property>
</bean>
<!-- SessionFactory Spring -->
<bean id="automacaoSessionFactory"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>
<prop key="hibernate.connection.release_mode">after_transaction</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
</props>
</property>
<property name="annotatedClasses">
<list>
<value>br.com.xxxxxx.nl.xxxxxx.bean.PubUsuario</value>
<value>br.com.xxxxxx.nl.xxxxxx.bean.PubFilial</value>
<value>br.com.xxxxxx.nl.xxxxxx.bean.PubNivel</value>
</list>
</property>
</bean>
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager"
/>
<tx:annotation-driven/>
<aop:aspectj-autoproxy proxy-target-class="true"/>
--arquivo jdbc.properties
jdbc.url=jdbc:oracle:thin:@128.1.30.247:1521:ATMDES
jdbc.username=xxxxxx_DES
jdbc.password=xxxxxx
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.dialect=org.hibernate.dialect.Oracle9Dialect
datasource.min_size=5
datasource.max_size=20