Using the ActiveSpaces JDBC Driver With Third Party Tools

Date and time values stored in ActiveSpaces are stored in UTC time. By default, third party JDBC clients use the default timezone of the JVM where the client was started when retrieving date and time values. To see dates and times in a particular time zone when they are retrieved from the data grid, you can use one of the JDBC methods that helps you specify a timezone. Another alternative is to configure your JDBC client to display date and time information in UTC time. For example, when using the SQuirreL JDBC client you can modify the script file used to start SQuirreL and specify the following additional command line option where the SQuirreL executable is invoked:

-Duser.timezone=UTC