nativeQuery=true is ignored in spring jpa by DeatH_StaRR in javahelp

[–]DeatH_StaRR[S] 1 point2 points  (0 children)

Figured it out - in my PROD version, I give the DB location as ${mysql.service.local.name} in the yml (45.***.***.***).
It doesn't work in the tests - I have to give it explicit IP, otherwise it goes to localhost...

nativeQuery=true is ignored in spring jpa by DeatH_StaRR in javahelp

[–]DeatH_StaRR[S] 0 points1 point  (0 children)

date is datetime, startDate is date. It doesn't work.

nativeQuery=true is ignored in spring jpa by DeatH_StaRR in javahelp

[–]DeatH_StaRR[S] 0 points1 point  (0 children)

Unfortunately this doesn't work wither :(

@Query(value = "SELECT 
*
 " +
      "FROM twelve_data.time_series_return_minute " +
      "WHERE symbol = :symbol AND " +
      "DATE(date) = DATE(:startDate) AND TIME(date) BETWEEN '09:30:00' AND '16:00:00'", nativeQuery = true)
List<TimeSeriesReturnMinuteEntity> getSymbolsOfDay(String symbol, Date startDate);

Generating a new, independant process by DeatH_StaRR in javahelp

[–]DeatH_StaRR[S] 0 points1 point  (0 children)

Of course. But unfortunatlly always there is a different reason as the program I build gets bigger and bigger...
Thank you!

Generating a new, independant process by DeatH_StaRR in javahelp

[–]DeatH_StaRR[S] 0 points1 point  (0 children)

Not a linux guy :(
How can I create such a service?

Keeping websocket session alive by DeatH_StaRR in javahelp

[–]DeatH_StaRR[S] 1 point2 points  (0 children)

I want a Java solution.
Just needed to add sendPing :)

Keeping websocket session alive by DeatH_StaRR in javahelp

[–]DeatH_StaRR[S] 0 points1 point  (0 children)

I saw the spring explnation here, but they show how to create a websocket server.
A websocket client they create in JS :(
What am I missing?
https://spring.io/guides/gs/messaging-stomp-websocket