Create an account

Very important

  • To access the important data of the forums, you must be active in each forum and especially in the leaks and database leaks section, send data and after sending the data and activity, data and important content will be opened and visible for you.
  • You will only see chat messages from people who are at or below your level.
  • More than 500,000 database leaks and millions of account leaks are waiting for you, so access and view with more activity.
  • Many important data are inactive and inaccessible for you, so open them with activity. (This will be done automatically)

0Day Forums Coding Database Solr Solr - Import date time field from DB -> 2 hours difference

Thread Rating:
  • 563 Vote(s) - 3.55 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Options
Solr - Import date time field from DB -> 2 hours difference

Offline cortneyydal


Valued member
***
Valued member
Posts: 1
Threads: 1
Joined: Aug 2017
Reputation: 0
Level: 1 [Level]
Total Points: 0
Rank 0 / 1
99% to upload Level
Rank
Activity 0 / 1
99% to upload your Rank
Activity
Experience 1
99% to upload Experience
Experience

Points: 50
#1
07-30-2023, 02:15 PM
I'm importing a datetime column (SQLServer) in Solr, and the values is always 2 hours early in solr that in the DB, with full and delta imports.

I have configured jvm with the correct time (in the logs it's show the correct time).

I think I have to configure something in data-config.xml but I can't find any information.

Thanks in advance.
Reply

Offline sherylsheryle379


Member
*
Member
Posts: 0
Threads: 0
Joined: Sep 2018
Reputation: 0
Level: inf [Level]
Total Points: inf
Rank nan / 1
100% to upload Level
Rank
Activity inf / 1
99% to upload your Rank
Activity
Experience nan
100% to upload Experience
Experience

Points: 50
#2
07-30-2023, 02:23 PM
You need to convert your date/times into UTC format when you use the data import handler. See [this thread][1] on how to do it. AFAIK Solr always expects your dates in UTC format, no matter what the timestamp of the JVM is. Ditto for when you retrieve and display the date (it will be UTC).


[1]:

[To see links please register here]

Reply

« Next Oldest
Next Newest »


Forum Jump:


Users browsing this thread:
1 Guest(s)

©0Day  2016 - 2023 | All Rights Reserved.  Made with    for the community. Connected through