you have Definition and url on the same line? definition should be a key so basically:
<Resource ...> ... Definition = url = ... </Resource> Side note: you shouldn't use Definition yourself *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/9 middleware <davide.pasin...@infocamere.it> > This is my conf: > > <Resource id="myDS" type="DataSource"> > JdbcDriver oracle.jdbc.xa.client.OracleXADataSource > Definition url=jdbc:oracle:thin:@*hostname*:1521:ORA > UserName *username* > Password *encripted_password* > PasswordCipher Static3DES > JtaManaged false > </Resource> > > The exception says that I have an invalid URL but the same URL works if I > define the datasource as localTX > > This is the exception: > 2012-11-09 16:56:00,727 INFO [ConnectionProviderFactory.java:173] : > Initializing connection provider: > org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider > 2012-11-09 16:56:00,727 DEBUG [JDBCExceptionReporter.java:225] : SQL > Exception > java.sql.SQLException: È stato specificato un URL Oracle non valido > at > > oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:286) > at > > oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:508) > at > > oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:154) > at > > oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:128) > at > > org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDataSource(PooledConnection.java:215) > at > > org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:180) > at > > org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:699) > at > > org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:631) > at > > org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:187) > at > > org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128) > at > > org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:251) > at > > org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) > at > org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:113) > at > > org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) > at > org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) > at > > org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) > at > > org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:860) > at > > org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:779) > at > > org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211) > at > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477) > at > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417) > at > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) > at > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) > at > > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291) > at > > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) > at > > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288) > at > > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190) > at > > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:563) > at > > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895) > at > > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425) > at > > org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276) > at > > org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197) > at > > org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47) > at > > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791) > at > > org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285) > at > org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) > at > > org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559) > at > > org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549) > at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at java.util.concurrent.FutureTask.run(FutureTask.java:138) > at > > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:662) > > > > -- > View this message in context: > http://openejb.979440.n4.nabble.com/DataSource-Password-Encryption-tp4658424p4658499.html > Sent from the OpenEJB User mailing list archive at Nabble.com. >