I'm using this persistence.xml configuration, and it works <persistence xmlns="http://java.sun.com/xml/ns/persistence"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"; version="1.0"> <persistence-unit name="RP" transaction-type="RESOURCE_LOCAL"> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
<class>model.Address</class> <class>model.Business</class> <properties> <property name="openjpa.ConnectionProperties" value="Url=jdbc:db2:RP, DriverClassName=COM.ibm.db2.jdbc.app.DB2Driver, Username=User, Password=User1"/> <property name="openjpa.ConnectionDriverName" value="org.apache.commons.dbcp.BasicDataSource"/> </properties> </persistence-unit> </persistence> Now I need to configure it using openjpa.ConnectionProperties to specify the connection pool information, and It isn't working <persistence xmlns="http://java.sun.com/xml/ns/persistence"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"; version="1.0"> <persistence-unit name="RP" transaction-type="RESOURCE_LOCAL"> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider> <class>model.Address</class> <class>model.Business</class> <properties> <property name="openjpa.ConnectionURL" value="jdbc:db2:RP"/> <property name="openjpa.ConnectionDriverName" value="COM.ibm.db2.jdbc.app.DB2Driver"/> <property name="openjpa.ConnectionUserName" value="User"/> <property name="openjpa.ConnectionPassword" value="User1"/> <property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/> </properties> </persistence-unit> </persistence> I get this 30188 ReportAndPay INFO [main] openjpa.Runtime - Starting OpenJPA 1.2.0 <openjpa-1.2.0-r422266:683325 fatal user error> org.apache.openjpa.persistence.ArgumentException: A connection could not be obtained for driver class "org.apache.commons.dbcp.BasicDataSource" and URL "null". You may have specified an invalid URL. at org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:256) at org.apache.openjpa.jdbc.schema.DataSourceFactory.newDataSource(DataSourceFactory.java:125) at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.createConnectionFactory(JDBCConfigurationImpl.java:784) at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:561) at org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1265) at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:505) at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:430) at org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:103) at org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68) at org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83) at org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:863) at org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:854) at org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:638) at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:183) at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142) at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192) at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:145) at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56) at com.ibm.gatewayservices.util.TransactionManager.beginTransaction(TransactionManager.java:23) at com.ibm.gatewayservices.test.Main.main(Main.java:65) Caused by: java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSource at java.lang.Class.forName(Class.java:130) at org.apache.openjpa.jdbc.schema.DataSourceFactory.newDataSource(DataSourceFactory.java:87) ... 18 more Please, enlight me on this. thank you!
