Hi Yousef, Which version are you using? Since latest (1.5.0) we changed the default connection pool to tomcat-pool instead of Apache DBCP. The feature only works for the moment in Apache DBCP.
Regarding the way it works, please have a look to the PasswordCodec interface. http://svn.apache.org/viewvc/openejb/trunk/openejb/container/openejb-core/src/main/java/org/apache/openejb/resource/jdbc/cipher/ This interface is really simple and you can implement your own of course. By default, we provide 2 implementations: PlainText and Static2DES. The second one is only meant to be an example cause if you have a look deeper, you gonna see that the key is store in the source code which is not so good in terms of security. In the real life, you should store the key in an HM or so. Please let us know the version you are using so that we can figure if the tomcat pool stuff is the cause of your problem. Jean-Louis 2012/11/7 Yousef Herzallah <yousef.herzal...@infocamere.it> > Hi Romain, > I tried to use DataSource Password Encryption <http://tomee.apache.org/** > datasource-password-**encryption.html<http://tomee.apache.org/datasource-password-encryption.html>> > following your steps but i missing some information cause it doesn't work. > is TomEE can decode the password without any additional library? > i have this error *Access denied for user 'username'@'hostname.** > infocamere.it <http://hostname.infocamere.it>' (using password: YES)* > it was working with plain text. i used the (openejb cipher P@ssw0rd) to > crypt the password. > and i'm also using spring > please help :) > > > my datasource configuration: > *tomee.xml* > <Resource id="myMccplusDS" type="DataSource"> > JdbcDriver com.mysql.jdbc.Driver > JdbcUrl > jdbc:mysql://hostname.**infocamere.it:3306/mydatabase<http://hostname.infocamere.it:3306/mydatabase> > UserName *username* > Password *KjGfWPfU7xUzVUv5LG7YLA==* > PasswordCipher *Static3DES* > JtaManaged false > </Resource> > *spring.xml* > <bean id="mySqlDataSource" class="org.springframework.** > jndi.JndiObjectFactoryBean"> > <property name="jndiName" value="java:app/myMccplusDS"/> > </bean> > > ciao > Yousef > > > > > <http://tomee.apache.org/**datasource-password-**encryption.html<http://tomee.apache.org/datasource-password-encryption.html> > > > > -- > Yousef Herzallah > >
