March 2020 - hibernate-issues - Jboss List Archives

[JIRA] (HSEARCH-3847) Customize enabled syntax elements in simple query strings

by Yoann Rodière (JIRA)

4 years, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-3845) Prefix query in SimpleQueryString predicate is case sensitive

by Yoann Rodière (JIRA)

4 years, 9 months

1
0
0 / 0

[JIRA] (HHH-13888) Allow custom SQL loggers by subclassing SqlStatementLogger

by Ivan Březina (JIRA)

Ivan Březina ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e5ec83... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGQ5YmNiOWUy... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiNGQ5Ym... ) HHH-13888 ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiNGQ5Ym... ) Allow custom SQL loggers by subclassing SqlStatementLogger ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiNGQ5Ym... ) Change By: Ivan Březina ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e5ec83... ) Logging of slow SQLs from Hibernate is a cool feature, but it would be even better if you allowed custom loggers. By adding setSqlStatementLogger into JdbcServices. The background: * it is not guaranteed that calling Statement.toString() will return actual SQL statement. For example Oracle's data replay datasource generates instances of proxy for TxnReplayableStatement. This class implements java.sql.Statement interface but toString() returns hexadecimal number. * as a DBA I face situations where I need to correlate customer's action with slow running query. A custom logger can be extended and can also use Thread context to log slow SQL together with applications request id. * Oracle internally identifies SQL by hash string called SQL_ID (last 8 bytes from MD5 checksum). For me it is hard to to translate fragments of SQLs logged into SQL_ID. But I can implement custom logger, which can compute and log the same SQL_ID log it also on application's side. The is a link to sample POC: [https://github.com/ibre5041/ucptest/tree/master/standalone-jpa/src/main/j...] The class * CustomSqlStatementLogger uses several reflection steps to get SQL from datatype TxnReplayableStatement. It also contains example how SQL_ID is computed. * AppHibernate is a sample application which uses Oracle's UCP connection pool and uses reflection to replace instance of SqlStatementLogger with CustomSqlStatementLogger. At the end the app logs something like this: {{ SlowQuery: 2582 milliseconds. SQL_ID: 'bd4aqyt8dzfvf' }} The rest about the query I can find in Oracle's Active session history {{ : }} \ { \ {SQL> select sql_text from gv$SQL where sql_id = ‘bd4aqyt8dzfvf’; }} \ { \ {SQL_TEXT }} \ { \ { ================================================================== }} {{ select bookentity0_.id as id1_0_0_, bookentity0_.author as author2_0_0_, bookentity0_.name as name3_0_0_ from BOOK bookentity0_ where bookentity0_.id=:1 }} So practically I need to add setSqlStatementLogger and setSqlExceptionHelper to jdbcService. (or some config option identifying a class used to format SQLs logged by Hibernate). thx Ivan ( https://hibernate.atlassian.net/browse/HHH-13888#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13888#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100121- sha1:d2b7993 )

4 years, 9 months

1
0
0 / 0

[JIRA] (HHH-13888) Allow custom SQL loggers by subclassing SqlStatementLogger

by Ivan Březina (JIRA)

Ivan Březina ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e5ec83... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiM2RhZDY1Zjdi... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiM2RhZD... ) HHH-13888 ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiM2RhZD... ) Allow custom SQL loggers by subclassing SqlStatementLogger ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiM2RhZD... ) Change By: Ivan Březina ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e5ec83... ) Logging of slow SQLs from Hibernate is a cool feature, but it would be even better if you allowed custom loggers. By adding setSqlStatementLogger into JdbcServices. The background: * it is not guaranteed that calling Statement.toString() will return actual SQL statement. For example Oracle's data replay datasource generates instances of proxy for TxnReplayableStatement. This class implements java.sql.Statement interface but toString() returns hexadecimal number. * as a DBA I face situations where I need to correlate customer's action which with slow running query. A custom logger can be extended and can also use Thread context to log slow SQL together with applications request id. * Oracle internally identifies SQL by hash string called SQL_ID (last 8 bytes from MD5 checksum). For me it is hard to to translate fragments of SQLs logged into SQL_ID. But I can implement custom logger, which can compute and log the same SQL_ID log it also on application's side. The is a link to sample POC: [https://github.com/ibre5041/ucptest/tree/master/standalone-jpa/src/main/j...] The class * CustomSqlStatementLogger uses several reflection steps to get SQL from datatype TxnReplayableStatement. It also contains example how SQL_ID is computed. * AppHibernate is a sample application which uses Oracle's UCP connection pool and uses reflection to replace instance of SqlStatementLogger with CustomSqlStatementLogger. At the end the app logs something like this: {{ SlowQuery: 2582 milliseconds. SQL_ID: 'bd4aqyt8dzfvf' }} The rest about the query I can find in Oracle's Active session history: \{\{SQL> select sql_text from gv$SQL where sql_id = ‘bd4aqyt8dzfvf’; }} \{\{SQL_TEXT }} \{\{select bookentity0_.id as id1_0_0_, bookentity0_.author as author2_0_0_, bookentity0_.name as name3_0_0_ from BOOK bookentity0_ where bookentity0_.id=:1 }} So practically I need to add setSqlStatementLogger and setSqlExceptionHelper to jdbcService. (or some config option identifying a class used to format SQLs logged by Hibernate). thx Ivan ( https://hibernate.atlassian.net/browse/HHH-13888#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13888#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100121- sha1:d2b7993 )

4 years, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-3851) Entities whose indexing failed are not reported when even just one document ID cannot be converted

by Yoann Rodière (JIRA)

4 years, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-3845) Prefix query in SimpleQueryString predicate is case sensitive

by Yoann Rodière (JIRA)

4 years, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-3852) Failure to index reports the wrong document ID with Elasticsearch discriminator multi-tenancy

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiOTY1NTFh... ) / Bug ( https://hibernate.atlassian.net/browse/HSEARCH-3852?atlOrigin=eyJpIjoiOTY... ) HSEARCH-3852 ( https://hibernate.atlassian.net/browse/HSEARCH-3852?atlOrigin=eyJpIjoiOTY... ) Failure to index reports the wrong document ID with Elasticsearch discriminator multi-tenancy ( https://hibernate.atlassian.net/browse/HSEARCH-3852?atlOrigin=eyJpIjoiOTY... ) Change By: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Pull Request: https://github.com/hibernate/hibernate-search/pull/2233 Status: In Progress Pull Request Sent ( https://hibernate.atlassian.net/browse/HSEARCH-3852#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-3852#add-comment?atlOrigin... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100121- sha1:d2b7993 )

4 years, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-3851) Entities whose indexing failed are not reported when even just one document ID cannot be converted

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiY2E5MjMy... ) / Bug ( https://hibernate.atlassian.net/browse/HSEARCH-3851?atlOrigin=eyJpIjoiY2E... ) HSEARCH-3851 ( https://hibernate.atlassian.net/browse/HSEARCH-3851?atlOrigin=eyJpIjoiY2E... ) Entities whose indexing failed are not reported when even just one document ID cannot be converted ( https://hibernate.atlassian.net/browse/HSEARCH-3851?atlOrigin=eyJpIjoiY2E... ) Change By: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Status: In Progress Pull Request Sent ( https://hibernate.atlassian.net/browse/HSEARCH-3851#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-3851#add-comment?atlOrigin... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100121- sha1:d2b7993 )

4 years, 9 months

1
0
0 / 0

[JIRA] (HHH-13888) Allow custom SQL loggers by subclassing SqlStatementLogger

by Ivan Březina (JIRA)

Ivan Březina ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e5ec83... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDc4N2UzODU2... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiMDc4N2... ) HHH-13888 ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiMDc4N2... ) Allow custom SQL loggers by subclassing SqlStatementLogger ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiMDc4N2... ) Change By: Ivan Březina ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e5ec83... ) Logging of slow SQLs from Hibernate is a cool feature, but it would be even better if you added allowed custom loggers. By adding setSqlStatementLogger into JdbcServices. The background: * it is not guaranteed that calling Statement.toString() will return actual SQL statement. For example Oracle's data replay datasource generates instances of proxy for TxnReplayableStatement. This class implements java.sql.Statement interface but toString() returns hexadecimal number. * as a DBA I face situations where I need to correlate customer's action which slow running query. A custom logger can be extended and can also use Thread context to log slow SQL together with applications request id. * Oracle internally identifies SQL by hash string called SQL_ID (last 8 bytes from MD5 checksum). For me it is hard to to translate fragments of SQLs logged into SQL_ID. But I can implement custom logger, which can compute and log the same SQL_ID log it also on application's side. The is a link to sample POC: [https://github.com/ibre5041/ucptest/tree/master/standalone-jpa/src/main/j...] The class * CustomSqlStatementLogger uses several reflection steps to get SQL from datatype TxnReplayableStatement. It also contains example how SQL_ID is computed. * AppHibernate is a sample application which uses Oracle's UCP connection pool and uses reflection to replace instance of SqlStatementLogger with CustomSqlStatementLogger. At the end the app logs something like this: {{ SlowQuery: 2582 milliseconds. SQL_ID: 'bd4aqyt8dzfvf' }} The rest about the query I can find in Oracle's Active session history: \{\{SQL> select sql_text from gv$SQL where sql_id = ‘bd4aqyt8dzfvf’; }} \{\{SQL_TEXT }} \{\{select bookentity0_.id as id1_0_0_, bookentity0_.author as author2_0_0_, bookentity0_.name as name3_0_0_ from BOOK bookentity0_ where bookentity0_.id=:1 }} So practically I need to add setSqlStatementLogger and setSqlExceptionHelper to jdbcService. (or some config option identifying a class used to format SQLs logged by Hibernate). thx Ivan ( https://hibernate.atlassian.net/browse/HHH-13888#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13888#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100121- sha1:d2b7993 )

4 years, 9 months

1
0
0 / 0

[JIRA] (HHH-13888) Allow custom SQL loggers by subclassing SqlStatementLogger

by Ivan Březina (JIRA)

Ivan Březina ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e5ec83... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOGJhOGFkZGRi... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiOGJhOG... ) HHH-13888 ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiOGJhOG... ) Allow custom SQL loggers by subclassing SqlStatementLogger ( https://hibernate.atlassian.net/browse/HHH-13888?atlOrigin=eyJpIjoiOGJhOG... ) Change By: Ivan Březina ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e5ec83... ) Logging of slow SQLs from Hibernate is a cool feature, but it would be even better if you added custom loggers. By adding setSqlStatementLogger into JdbcServices. The background: * it is not guaranteed that calling Statement.toString() will return actual SQL statement. For example Oracle's data replay datasource generates instances of proxy for TxnReplayableStatement. This class implements java.sql.Statement interface but toString() returns hexadecimal number. * as a DBA I face situations where I need to correlate customer's action which slow running query. A custom logger can be extended and can also use Thread context to log slow SQL together with applications request id. * Oracle internally identifies SQL by hash string called SQL_ID (last 8 bytes from MD5 checksum). For me it is hard to to translate fragments of SQLs logged into SQL_ID. But I can implement custom logger, which can compute and log the same SQL_ID log it also on application's side. The is a link to sample POC: [https://github.com/ibre5041/ucptest/tree/master/standalone-jpa/src/main/j...] The class * CustomSqlStatementLogger uses several reflection steps to get SQL from datatype TxnReplayableStatement. It also contains example how SQL_ID is computed. * AppHibernate is a sample application which uses Oracle's UCP connection pool and uses reflection to replace instance of SqlStatementLogger with CustomSqlStatementLogger. At the end the app logs something like this: {{ SlowQuery: 2582 milliseconds. SQL_ID: 'bd4aqyt8dzfvf' }} The rest about the query I can find in Oracle's Active session history: \{\{SQL> select sql_text from gv$SQL where sql_id = ‘bd4aqyt8dzfvf’; }} \{\{SQL_TEXT }} \{\{select bookentity0_.id as id1_0_0_, bookentity0_.author as author2_0_0_, bookentity0_.name as name3_0_0_ from BOOK bookentity0_ where bookentity0_.id=:1 }} So practically I need to add setSqlStatementLogger and setSqlExceptionHelper to jdbcService. (or some config option identifying a class used to format SQLs logged by Hibernate). thx Ivan ( https://hibernate.atlassian.net/browse/HHH-13888#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13888#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100121- sha1:d2b7993 )

4 years, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues March 2020