2 Replies Latest reply on Sep 7, 2012 1:07 AM by nickarls

    Date format mismatch in jboss 5 and jboss7

    rvijaiganesh

      Hi,

       

              When we use jBoss 5 server the date format from the oracle10g server is returning 21 characters(ex : 2011-10-17 04:05:45.0) but when we tried to run the same app. in Jboss 7 it is  returning 19 characters (ex : 2011-10-17 04:05:45).

       

               Pls tell me how to solve this issue.

        • 1. Re: Date format mismatch in jboss 5 and jboss7
          wdfink

          date and timestamps are always tricky, especially if there are timezones.

           

          Do you checked that you read the same data?

          It could be a driver issue, or the session is different openend (i.e. different datasource definition or just different default of the datasource subsystem).

           

          Do you read the timestamp as String? What if you read it as timestamp do you get exact the same?

          • 2. Re: Date format mismatch in jboss 5 and jboss7
            nickarls

            It could also be worth trying with parameters as -Duser.timezone=EET (or appropriate) as some components might have become more picky in later versions.

             

            You might also want to check the DB on a session level from some v$-view if there is some specific NLS setting in the connection that differ between AS5 and AS7