To which Java data types can I map TIMESTAMP WITH TIME ZONE or TIMESTAMP WITH LOCAL TIME ZONE?

To which Java data types can (or should) my application map Oracle column types TIMESTAMP WITH TIME ZONE or TIMESTAMP WITH LOCAL TIME ZONE? Can the Oracle JDBC driver map these types to either Date or Calendar objects? Does Calendar preserve the time zone value whereas Date does not?

Answers


The JDBC 4.0 Specification does not even mention time zones, so JDBC does not specify how a JDBC driver should handle SQL type TIMEZONE WITH TIME ZONE or how to interpret the time zone that may appear in a TIMESTAMP literal value. So, the JDBC specification leaves time zone interpretation entirely up to the JDBC driver implementation!


Need Your Help

Why do I get “Errno::ENOENT: No such file or directory” when joining a filename?

ruby-on-rails ruby rgeo

I have a file I'm trying to open in a Rails application. For some reason Ruby is splitting the name of the file.

How to give a image name as parameter in insert query

c# .net sql sql-server tsql

I am getting trouble on how to give image name which is selected from the hardcoded value as below.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.