Query is not being processed

Hibernate ORM
1

Hello,
I have two typed queries, one for the master table and one for the details table. Both queries are completely prepared and both queries work well in the hibernate query tool in Intellij. Here I get a valid SQL query and also results.

In the code the details query is being executed first. I request a stream with getResultStream(). I can see, that the SQL query is send to Oracle. But I’ve never get a response in some computers. On the target system (and most computers) I always get an result and can continue to get the second stream for the master table.

The confusing part is, that I cant see any specific conditions on the environments, which have that trouble.

I appreciate any help like some brain stroming about this issue.

Thanks!

2

Why do you use stream. Better use pagination and get a better chance of using an index.

But I’ve never get a response in some computers.

This can be due to networking issues or because the query takes a lot of time.

The confusing part is, that I cant see any specific conditions on the environments, which have that trouble.

Problems like this can only be tracked on-site. It’s impossible to figure out what the problem might be. Try to log as much as possible:

  • DB logs
  • networking logs
  • application logs

This is a good way to get a better idea what’s going on.