Re: How to correct the time out problem?

2010-05-12 Thread Martin Ellis
On 12 May 2010 02:31, 陈抒 wrote: > Caused by: java.lang.NullPointerException >     at freebird.business.Email.getReceiverList(Email.java:105) What caused this NullPointerException? Is it really related to the connection option? Martin -

Re: How to correct the time out problem?

2010-05-12 Thread 陈抒
I don't know. But I took one hour to test my application again,it works fine if the 'time out' problem doesn't occurs. Now I add two properties,let's wait and see if it can solve this or not. 陈抒 Best regards http://blog.csdn.net/sheismylife On Wed, May 12, 2010 at 6:46 PM, Martin Ellis wrote:

Re: How to correct the time out problem?

2010-05-12 Thread François Schiettecatte
陈抒 Not sure which RDBMS you are using. Ideally you want to set the idle connection timeout in your pool to a value smaller than the idle connection timeout on the server end, the errors you were seeing suggests that the server has dropped the connection while the pool thinks it is still ok. Fro

Re: How to correct the time out problem?

2010-05-12 Thread 陈抒
Hello: Thanks a lot! I am worrying about the overhead,because I don't know what iBatis3 will do when I enable poolPingQuery. I will try your idea soon.Thanks again! 陈抒 Best regards http://blog.csdn.net/sheismylife 2010/5/12 François Schiettecatte > 陈抒 > > Not sure which RDBMS you are using. I

Re: How to correct the time out problem?

2010-05-12 Thread François Schiettecatte
陈抒 It is all explained on page 20 of the user guide: http://svn.apache.org/repos/asf/ibatis/java/ibatis-3/trunk/doc/en/iBATIS-3-User-Guide.pdf the relevant section is: • poolPingQuery – The Ping Query is sent to the database to validate that a connection is in good working orde

Fwd: New to Ibatis / Ibator / Eclipse

2010-05-12 Thread SMe Software - Rocky Castaneda
Hi Clinton, I have a table named TIMMAIN and I have successfully ran Ibator in eclipse and generated the following structure: com.mycompany.dao TIMMAINDAO.java com.mycompany.dao.ibatis.ibatis.maps TIMMAIN_SqlMap.xml com.smartermanager.dao.ibatis.impl TIMMAINDAOImpl.java

Re: New to Ibatis / Ibator / Eclipse

2010-05-12 Thread Jeff Butler
Dude - please stop sending the same email over and over again! Read the iBATIS documentation, do a google search for "ibatis tutorial", etc. Jeff Butler On Wed, May 12, 2010 at 10:36 AM, SMe Software - Rocky Castaneda wrote: > > Hi Clinton, > I have a table named TIMMAIN and I have successfull

Way to use sql in mapper interface, without having to create a corresponding xml mapping file?

2010-05-12 Thread Rick R
Larry showed me his cool no xml config setup which I'd love to implement at some point. For this current project using ibatis3 it's too late to refactor a real lot at this stage and we're using your typical sqlMapConfig file. Overall we still prefer to code all of our sql in xml files, but I just