9:17 a.m.
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&...]