Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# 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 time zone. 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

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

Copyright © 2009-2025. Cloud Software Group, Inc. All Rights Reserved.