ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xianwinwin <xianwin...@gmail.com>
Subject RE: JDBC.ConnectionURL problem. Changed from 'localhost' to 'IP-number'
Date Sun, 28 Sep 2008 18:30:42 GMT

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.


Mime
View raw message