Re: config database in Tomcat

Tue, 24 Nov 2009 02:40:19 -0800 

You can also use c3p0 with Tomcat JNDI, e. g.

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/SupportPortal">
    <Resource   name="jdbc/MYSQL"
                auth="Container"
                type="com.mchange.v2.c3p0.ComboPooledDataSource"
description="DB Connection" jdbcUrl="jdbc:mysql://server:3306/mysql?autoReconnect=true" 
                driverClass="com.mysql.jdbc.Driver"
                user="root"
                password="password"
                maxPoolSize="20"
                minPoolSize="1"
                initialPoolSize="1"
                acquireIncrement="1"
                maxConnectionAge="0"
                maxIdleTime="1800"
                maxIdleTimeExcessConnections="120"
                idleConnectionTestPeriod="30"
                testConnectionOnCheckout="true"

connectionCustomizerClassName="de.pma.dbobjects.DefaultConnectionCustomizer"
                factory="org.apache.naming.factory.BeanFactory"
    />
</Context>


and a hibernate config file like:


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd";> 

<hibernate-configuration>
    <session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="hibernate.connection.datasource">java:comp/env/jdbc/MYSQL</property> 
        <property name="hibernate.show_sql">false</property>
        <property name="hibernate.format_sql">false</property>
<property name="hibernate.current_session_context_class">thread</property> <property name="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</property> 
    </session-factory>
</hibernate-configuration>




dishmily schrieb:

thank you, it works!

there are two factor need to mention:

1) as i used hibernate to create Database-connection before, the connection
pool C3P0 was used in hibernate. but when i try to maintain
Database-connection through JNDI in tomcat, i donn't need C3P0 anymore. so,
i SHOULD delete configuration about C3P0 in hibernate configuration file.
The error message i got had something to do with it.

2) I SHOULD add a ResourceLink in the Context.xml, in order to let Hibernate
using the global resource, witch is in read only mode.
(https://forums.hibernate.org/viewtopic.php?f=1&t=937920&start=0)
<ResourceLink name="jdbc/mysql" global="jdbc/mysql"
type="javax.sql.DataSource"/>







Pid Ster wrote:

On 23/11/2009 16:03, dishmily wrote:

i have made few changes, but it didn't work.
(my project uses tomcat and hibernate.)

You didn't mention that before.
You need to configure Hibernate to use the DataSource "jdbc/mysql" that you've created. It doesn't appear to be correctly configured at the 
moment.


You can test that the db connection pool is working:

  InitialContext ic = new InitialContext();
  DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/mysql");
  Connection conn = ds.getConnection();




1) $Tomcat_Home\conf\context.xml was changed to:
This is the default context definition, rather than a web app specific one. Just so you know.
To configure it for a specific web app, include a context.xml definition in the META-INF folder of your webapp. 


p



<Context>

     <WatchedResource>WEB-INF/web.xml</WatchedResource>
        
        <Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
                maxActive="100" maxIdle="30" maxWait="10000"
                username="db" password="pwd"
driverClassName="com.mysql.jdbc.Driver"
                url="jdbc:mysql://localhost:3306/db"/>

</Context>

2)<resource-ref>  was added into
$Tomcat_Home\webapps\axis2\WEB-INF\web.xml
:

<web-app>
...
<resource-ref>
        <description>DB Connection</description>
        <res-ref-name>jdbc/mysql</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
        </resource-ref>
....
</web-app>

wenn i ran the web application, i got the error message:

INFO: Initializing c3p0 pool...
com.mchange.v2.c3p0.poolbackeddatasou...@29fb0733 [
connectionPoolDataSource
->  com.mchange.v2.c3p0.wrapperconnectionpooldatasou...@dd3d444b [
acquireIncrement ->  5, acquireRetryAttempts ->  30, acquireRetryDelay ->
1000, autoCommitOnClose ->  false, automaticTestTable ->  null,
breakAfterAcquireFailure ->  false, checkoutTimeout ->  0,
connectionCustomizerClassName ->  null, connectionTesterClassName ->
com.mchange.v2.c3p0.impl.DefaultConnectionTester,
debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, 
forceIgnoreUnresolvedTransactions ->  false, identityToken ->
1hgeigx859d0cr2vfrvc8|1ba92db, idleConnectionTestPeriod ->  7200,
initialPoolSize ->  10, maxAdministrativeTaskTime ->  0, maxConnectionAge
->
0, maxIdleTime ->  14400, maxIdleTimeExcessConnections ->  0, maxPoolSize
->
100, maxStatements ->  100, maxStatementsPerConnection ->  0, minPoolSize
->
10, nestedDataSource -> com.mchange.v2.c3p0.drivermanagerdatasou...@b33bd229 [ description -> null, driverClass -> null, factoryClassLocation -> null, 
identityToken ->  1hgeigx859d0cr2vfrvc8|87ad67, jdbcUrl ->  null,
properties
->  {useUnicode=true, autocommit=false, characterEncoding=UTF8} ],
preferredTestQuery ->  null, propertyCycle ->  0, testConnectionOnCheckin
->
false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, 
usesTraditionalReflectiveProxies ->  false; userOverrides: {} ],
dataSourceName ->  null, factoryClassLocation ->  null, identityToken ->
1hgeigx859d0cr2vfrvc8|15b55bc, numHelperThreads ->  3 ]
23.11.2009 16:51:25
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
WARNUNG:
com.mchange.v2.async.threadpoolasynchronousrunner$deadlockdetec...@170ec24
-- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending
tasks!
23.11.2009 16:51:25
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
WARNUNG:
com.mchange.v2.async.threadpoolasynchronousrunner$deadlockdetec...@170ec24
-- APPARENT DEADLOCK!!! Complete Status:
        Managed Threads: 3
        Active Threads: 3
        Active Tasks:
                com.mchange.v2.resourcepool.basicresourcepool$acquiret...@c5d9c1
(com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
                
com.mchange.v2.resourcepool.basicresourcepool$acquiret...@15b4ad2
(com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
                com.mchange.v2.resourcepool.basicresourcepool$acquiret...@8d3d62
(com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
        Pending Tasks:
                com.mchange.v2.resourcepool.basicresourcepool$acquiret...@b9132a
                com.mchange.v2.resourcepool.basicresourcepool$acquiret...@996b65
                com.mchange.v2.resourcepool.basicresourcepool$acquiret...@59c8b5
                com.mchange.v2.resourcepool.basicresourcepool$acquiret...@881cb3
                com.mchange.v2.resourcepool.basicresourcepool$acquiret...@143753
                
com.mchange.v2.resourcepool.basicresourcepool$acquiret...@13c4c09
                
com.mchange.v2.resourcepool.basicresourcepool$acquiret...@1a40247
Pool thread stack traces:

Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
                java.lang.Thread.sleep(Native Method)
        
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
        
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
                java.lang.Thread.sleep(Native Method)
        
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
        
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
                java.lang.Thread.sleep(Native Method)
        
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
        
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)


23.11.2009 16:51:34
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
WARNUNG: com.mchange.v2.resourcepool.basicresourcepool$acquiret...@c5d9c1
--
Acquisition Attempt Failed!!! Clearing pending acquires. While trying to
acquire a needed new resource, we failed to succeed more than the maximum
number of allowed acquisition attempts (30). Last acquisition attempt
exception:
java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
        at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
        at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
        at java.sql.DriverManager.getDriver(DriverManager.java:253)
        at
com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
        at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)
        at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
        at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
        at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
        at
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
        at
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
        at
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
        at
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)




Pid Ster wrote:

On 23/11/2009 13:00, dishmily wrote:

i use 3 tomcats in one PC, in each tomcat i have a webservice, for each
webservice i use a mysql database.

my question is:

how can i write a config file in each tomcat to let tomcat1 load DB1,
tomcat2 load DB2 and tomcat3 load DB3.

thanks.


I'm guessing that you're using Tomcat 6.0, because you didn't say.
The extensive documentation is often a good place to start:

http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html


p

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org





---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org








---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to