RE: JDBC.ConnectionURL problem. Changed from 'localhost' to 'IP-number'

[xianwinwin]

I just tested this issue with a simple JDBC code (simple select) and it works
just fine! same username / password. this leads to the following
conclusions:

1. Its not a firewall issue
2. the problem is with iBatis configuration.

also consider that the same code works fine when the db is localhost

this is the conf file...i'd appritiate if anyone can point the problem.



<!DOCTYPE sqlMapConfig 
            PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" 
            "http://ibatis.apache.org/dtd/sql-map-config-2.dtd";>  
 
<sqlMapConfig>
 
        <settings       cacheModelsEnabled="false" 
                                enhancementEnabled="true" 
                                lazyLoadingEnabled="true" 
                        maxRequests="32" 
                        maxSessions="10" 
                        maxTransactions="10" 
                        useStatementNamespaces="true" />
 
        <transactionManager type="JDBC">
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
            
            
            
            <property name="JDBC.ConnectionURL"
value="jdbc:mysql://69.89.12.165:3306/my_db"/>
            
            <property name="JDBC.Username" value="userA"/>
            <property name="JDBC.Password" value="apple"/>                    
                <property name="Pool.MaximumActiveConnections" value="10"/>
                <property name="Pool.MaximumIdleConnections" value="5"/>
                <property name="Pool.MaximumCheckoutTime" value="120000"/>
                <property name="Pool.TimeToWait" value="10000"/>
                <property name="Pool.PingQuery" value="select * from
dbname.tablename"/>
                <property name="Pool.PingEnabled" value="true"/>
                <property name="Pool.PingConnectionsOlderThan" value="5"/>
                <property name="Pool.PingConnectionsNotUsedFor" value="5"/>
        </dataSource>
        </transactionManager>
                
        <sqlMap resource="com/persistence/ibatis/SqlMap/client_SqlMap.xml" />   
        
</sqlMapConfig>

THANKS FOR ANY POINTERS
-- 
View this message in context: 
http://www.nabble.com/JDBC.ConnectionURL-problem.-Changed-from-%27localhost%27-to-%27IP-number%27-tp19679603p19713181.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.