0

Let's say I have a database table:

ID     | DESCRIPTION
1      | Some value '123' added
2      | Deleted value '333' by 'Someone'

Jpa entity:

@Entity
@Table(name = "LOG")
public class Log {

    @Id
    @Column(name = "ID")
    private Long id;

    @Column(name = "DESCRIPTION")
    private String description;
    ...
}

And working jpa query to retrieve first found numeric value inside single quotas:

    @Query(value = "select distinct REGEXP_SUBSTR( log.DESCRIPTION, '''(\\d+)''',1,1,'',1) from Log log where 1=1 ", nativeQuery = true)
    List<String> findObjectIdsInDescription();

I'm working on Oracle database hence REGEXP_SUBSTR + native query, which is working fine for me right now.

Is there a database independent approach using jpa query only? I'm asking as I also need it for different databases.

Improve this question
4
  • Would it make sense to have a custom getter Log.getIdsInDescription where you parse the description in java yourself? Therefore, you would pull the log, then call your getter. Or do you need to extract the ids from all the logs? Commented Feb 23, 2023 at 9:41
  • I was hoping to create a solution where database handles it and returns only necessary values. But if nothing works then ofc retrieving whole content of column and parsing/filtering it in java would work. Commented Feb 23, 2023 at 10:34
  • I'm not sure. But can u check if this helps stackoverflow.com/a/44738213/2353403 Commented Feb 23, 2023 at 12:05
  • I'm getting to conclusion that string manipulation in scope of database query is dependent on database hence only native queries can solve it. Commented Feb 24, 2023 at 9:33
Related questions
0
Next build command fails: error Command failed with exit code 1
9
Next.js - `npm run build` failed
4
Build errors in NextJS in __webpack_require__
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.