was fixed on trunk i guess btw just switch to dbcp using DataSourceCreator property (value = dbcp) in the datasource definition. I think it should be enough
*Romain Manni-Bucau* *Twitter: @rmannibucau <https://twitter.com/rmannibucau>* *Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/> *LinkedIn: **http://fr.linkedin.com/in/rmannibucau* *Github: https://github.com/rmannibucau* 2012/11/7 Jean-Louis MONTEIRO <jeano...@gmail.com> > 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 > > > > >
