Date columns in SQL-Server 2008 (sqljdbc4.jar ) running under Java 1.8 retrieved as 2 days in the past.

Hi All,

Today(22/11/2016,Tue) I have faced one issue regarding jdbc driver.

I was using jdk 1.8 and sqljdbc4.jar on SQL-Server 2008 .

In my database column datatype is  DateTime2 which contain '2016-03-31 00:00:00' value

when I fired query from sql  qeury browser then records retrived  correctly.

when retrived using jdbc driver then I was getting '2016-03-26 00:00:00'

For resolving above issue I have replaced sqljdbc4.jar by sqljdbc42.jar and its working fine.

Thank you.

 

tomcat server automaticaly shutdown issue has been resolved.

From Last two day i am facing Apache tomcat server  automatically  shutdown issue. Now i have resolved this issue and i want share with you.


What i was doing
1: I have not installed apache-tomcat exe file. I just copy and paste from other location.
2: I have fired below command from command prompt on windows for start tomcat server

D:\Local Disk\server\apache-tomcat-7.0.28\bin>start.bat
3:when i fired above command then tomcat start successfully and another console open for logs

and application successful started

when i close the logs console then application is shutting down

this problem occurred because  of  in D:\Local Disk\server\apache-tomcat-7.0.39\bin\setclasspath.sh

_RUNJAVA path set like _RUNJAVA="$JRE_HOME"/bin/java


Soution:

for the above problem i have change _RUNJAVA path in
D:\Local Disk\server\apache-tomcat-7.0.39\bin\setclasspath.sh file

_RUNJAVA="$JRE_HOME"/bin/javaw

This is working fine for me