Current Status

Actively playing with all possible backend services

31 December, 2012

What a year 2012



Today, December 31, 2012? end of an year? But to me it is not just another year.  So many interesting milestones had happened to me in this year.
It has been a year of plentiful hard work and it has been a fruitful year. In last day of the year I will share some of the fruit with you..

In January I and my family shifted to my newly build house , it was a result of an almost 2 years hard work of me and whole my family.
In march, I got engagement !..  I promise to my fiancĂ©e that will take her home sooner..
Yes as promised in august we had our wedding..  6th of August unforgotten day of my life.. my wedding day
In September in my career I was promoted as a ‘Senior’ , huh? I am a Senior SE now.. more responsibilities… J

Except these it was journeyful  year, I could travel to nuwaraeliya, diyathalawa, kandy, Anuradhapura and to many other locations around the country.

thanks everybody who made my life a joy.. 
waiting to have much fruitful, exciting and courageous year 2013!
Happy new year 2013!

06 December, 2012

Informix database - INFORMIXCONRETRY and INFORMIXCONTIME



com.informix.jdbc.IfxSqliConnect.(IfxSqliConnect.java)

I got above error when making below connection in java file :

Class.forName("com.informix.jdbc.IfxDriver");
        Connection conn = DriverManager.getConnection("jdbc:informix-sqli://192.168.1.1:1000/databasename:INFORMIXSERVER=server_name;user=gayan;password=password;");


So I chaneged the connection as follows:

Class.forName("com.informix.jdbc.IfxDriver");
        Connection conn = DriverManager.getConnection("jdbc:informix-sqli://192.168.1.1:1000/databasename:INFORMIXSERVER=server_name;user=gayan;password=password;INFORMIXCONTIME=60;INFORMIXCONRETRY=3");


What does it realy mean?

If INFORMIXCONTIME is set to 60 and INFORMIXCONRETRY is set to 3, attempts to connect to the database server (after the initial attempt at 0 seconds) are made at 20, 40, and 60 seconds, if necessary, before aborting. This 20-second interval is the result of INFORMIXCONTIME divided by INFORMIXCONRETRY. If you attempt to set INFORMIXCONTIME to zero, the database server automatically resets it to the default value of 60 seconds.
       

INFORMIXCONRETRY Specifies the maximum number of additional connection attempts that can be
made to each database server by the client during the time limit specified by
the default value of INFORMIXCONTIME


INFORMIXCONTIME Sets the timeout period for an attempt to connect to the database server. If a
connection attempt does not succeed in this time, the attempt is aborted and a
connection error is reported.

Some Popular Posts