datetime - JPA, Glassfish, Mysql: UTC time conversion occuring twice -

-

I am getting mad ... I have recently seen that time is wrong in my JPA-managed organizations I have a date area:

  • reaching my personal timezone CET, even for a machine running a glassfish and a MySQL.
  • Glassfish is instructed to use the default time zone as UTC: a @ startup -bine set
  • Caching is disabled in persistence.xml

    Here's what:

    • In the unit A, the field SyncTimestamp of java.util is date .
    • When a particular resource is triggered, the timestamp is now set: a.setSyncTimestamp (new date ()) . Let's take my watch on the wall 14: 30: 00 hours (the date left for brevity).
    • The institution is managed, so the update ends in DB. The expected value of the database in the database (type DATETIME ) is "12: 30: 00 H" - CET is currently 2h ahead of UTC.
    • Shows the transaction timestamp as "12: 30: 00.123 Z" (notes milliseconds).
    • After retrieving the unit from the database again, accessing the recipient (disabled caching) in a different transaction, output "10: 30: 00Z"

      So when the unit is loaded from the DB, it seems that JPA is a timetamp of UTC CET, which is useless for 2 hours, it changes again.

      I have read a lot of posts about JPA and timezone, etc. What I have learned: neither do I understand the timezone on java.util.Date nor MySQL DATETIME . This should not be a problem, unless everything is always considered "UTC", right? Now Why can change the value of JPA (I think?)?

      (PS: I've got a post. It suggests to put JVVM in UTC at the time of time - but no, what does my startup bean do?)

      Edit : An important information was detected which had disappeared. To prepare for glassfish clustering, I had transferred the database to my MySQL db for EJB timer service. Consequently, the JDBC driver was extracted from the application in the glassfish Lib-directory.

      OK, I came to know what's going on, and how to fix it.

      It seems that due to the start of EJB timer service first my @ startup -bien, mysql JDBC driver is loading and timezone Starting with (which is the system default = CEST at that time)

      Setting default timezone to UTC does not affect the JDBC driver later (is it possibly a glassfish bug?).

      The solution is to define the default timezone of UTC's GMM: 

        asadmin create-jvm-options -Duser.timezone = UTC asadmin restart- domain

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

ruby on rails - Convert a Activerecord result with has_one associations into a single hash per record -

-
If I have any results from the Active Records, then I have an array of hashes, if I have a reliable load, then every Each organization hash in record hash has a nested hash of its associated records My question is, is there a quick rail system that allows you to merge these nested hashes into a hash per record? An analogy will be changing the records table rows Another resemblance will be converted into a hash at one level of nested hashes. approach 1: select them in the section Include class user has_one: profile end is for square profile: user # street 1, street 2, city etc. end profile = profile.junks (user :). Selection ("User. *, Profile. *") All profiles. First.login Approach 2: Use delegation for class profiles : User # Street 1, Road 2, City etc. Representative: Name ,: name =,: email,: email = ,: from = to & gt; : End of user
Read more

c# - Confused over DLL entry points (entry point not found exception) -

-
I'm learning how to use DLL in C #. I have a very simple DLL to do my basic test. // using the MainForm.cs system; Using System.Collections.Generic; Using System.ComponentModel; Using System.Data; Using System.Drawing; Using System.Linq; Using System.Text; Using System.Windows.Forms; Using System.Runtime.InteropServices; Namespace DLL_Test {public partial class} Form 1: Form {{DllImport ("TestDLL.dll", EntryPoint = "? @ @ YGHHH Add @, Accurate Spelling = True, Calling Communication = Calling Conference. STCL}] Add public static extern int ( Int a, int b); public form 1 () {initialization ();} private zeros button 1_Click (object sender, eventArgs e) {int num; try {num = add (2, 3); RichTextBox1.AppendText (num. ToString () + "\ n");} Hold (DllNotFoundException Pre) {Message Box.Show (ex.ToString ());} Hold (EntryPointNotFoundException Pre) {Message Box.Show (ex.ToString ())}} }} more DLL code: // TestDLL.cpp __declspec (dllexport) Add int __std...
Read more