venu gopal [https://community.jboss.org/people/venu7239] created the discussion
"How to use reportsevice.xml in place of reportds.xml" To view the discussion, visit: https://community.jboss.org/message/782540#782540 -------------------------------------------------------------- Hi i am using Jboss as 4.3 server ,up to now i am using ds.xml to connect my DB where i mention database connection details,it is working fine but i want to use service.xml to connect with DB ,but i am not able to connect DB ,i am getting the following exceptions.i have no idea where to change JBoss server to look my service.xml for DB connections This is my reportds.xml <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE datasources PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN" " http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd";> <datasources> <local-tx-datasource> <jndi-name>mobeereportDatasource</jndi-name> <connection-url>jdbc:oracle:thin:@localhost:1521:mobee</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>reportuser</user-name> <password>reportpasswd</password> </local-tx-datasource> </datasources> This is the reportservice.xml which now i want use <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE server> <server> <mbean code="com.mchange.v2.c3p0.jboss.C3P0PooledDataSource" name="jboss:service=C3P0PooledDataSource"> <attribute name="JndiName">java:mobeereportDatasource</attribute> <attribute name="JdbcUrl">jdbc:oracle:thin:@localhost:1521:mobee</attribute> <attribute name="DriverClass">oracle.jdbc.driver.OracleDriver</attribute> <attribute name="User">reportuser</attribute> <attribute name="Password">reportpasswd</attribute> <attribute name="MinPoolSize">0</attribute> <attribute name="MaxPoolSize">10</attribute> <attribute name="AcquireIncrement">3</attribute> <depends>jboss:service=Naming</depends> </mbean> </server> This is the stacktrace: Caused by: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.ReportScheduler': java.sql.SQLException: Connections could not be acquired from the underlying database! [See nested exception: java.sql.SQLException: Connections could not be acquired from the underlying database!] at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:167) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3652) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3624) at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:693) at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:555) ... 181 more Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:236) at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94) at com.mchange.v2.c3p0.ComboPooledDataSource.getConnection(ComboPooledDataSource.java:521) at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125) at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112) at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:164) ... 185 more Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source. at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970) at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232) ... 190 more Can anyone please help me where and which file i have to change in Jboss server. thanks in advance venu -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/782540#782540] Start a new discussion in JBoss Tools at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2128]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
