Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Not complete answer but just a pointer...</p> <p><strong>QueryCounter</strong></p> <pre><code>public class QueryCounter { private static long COUNTER = 0; private static long next() { return ++COUNTER; } private static String getHintValue() { return "/*Query No. " + next() + " */"; } public static void setQueryCount(Query query) { /* EclipseLink */ //query.setHint(QueryHints.HINT, getHintValue()); query.setHint("eclipselink.sql.hint", getHintValue()); /* OpenJPA + Oracle */ //query.setHint("openjpa.hint.OracleSelectHint", getQueryHint()); /* OpenJPA + MySQL */ //query.setHint("openjpa.hint.MySQLSelectHin", getQueryHint()); } } </code></pre> <p><strong>Usage</strong></p> <pre><code>Organization sun = new Organization("Sun"); em.persist(sun); tx.commit(); Assert.assertNotNull(sun.getEntityId()); Query query = em.createQuery("SELECT org.entityId FROM Organization org WHERE org.entityId = " + sun.getEntityId()); QueryCounter.setQueryCount(query); query.getResultList(); /*ServerSession does NOT log ReadObjectQuery??*/ query = em.createQuery("SELECT org FROM Organization org WHERE org.entityId = " + sun.getEntityId()); QueryCounter.setQueryCount(query); query.getResultList(); query = em.createQuery("SELECT org.entityId FROM Organization org WHERE org.entityId = " + sun.getEntityId()); QueryCounter.setQueryCount(query); query.getResultList(); </code></pre> <p><strong>Console</strong></p> <pre><code>[EL Finest]: 2010-11-20 19:06:16.45--UnitOfWork(717879615)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=Organization sql="SELECT entity_id FROM organization_tt WHERE (entity_id = ?)") [EL Fine]: 2010-11-20 19:06:16.475--ServerSession(699542937)--Connection(1949550475)--Thread(Thread[main,5,main])--SELECT /*Query No. 1 */ entity_id FROM organization_tt WHERE (entity_id = ?) bind =&gt; [1] [EL Finest]: 2010-11-20 19:06:23.372--UnitOfWork(717879615)--Thread(Thread[main,5,main])--Execute query ReadObjectQuery(referenceClass=Organization sql="SELECT entity_id, name FROM organization_tt WHERE (entity_id = ?)") [EL Finest]: 2010-11-20 19:06:35.916--UnitOfWork(717879615)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=Organization sql="SELECT entity_id FROM organization_tt WHERE (entity_id = ?)") [EL Fine]: 2010-11-20 19:06:35.92--ServerSession(699542937)--Connection(1949550475)--Thread(Thread[main,5,main])--SELECT /*Query No. 3 */ entity_id FROM organization_tt WHERE (entity_id = ?) bind =&gt; [1] </code></pre> <p>OpenJPA has similar concept <a href="http://openjpa.apache.org/builds/2.0.1/apache-openjpa-2.0.1/docs/manual/jpa_overview_query.html#d0e6955" rel="nofollow">1.8.7. Database-Specific Hints</a>. See if these specific hints can solve your purpose.</p> <h1><strong>UPDATED ANSWER</strong></h1> <p>@Eddie, see if this can help you...........</p> <p><strong>CustomLogFactory</strong></p> <pre><code> public class MyLogFactory extends org.apache.openjpa.lib.log.LogFactoryImpl { /* copied from LogFactoryImpl.NEWLINE */ private static final String NEWLINE = J2DoPrivHelper.getLineSeparator(); private boolean sqlLogger; @Override public Log getLog(String channel) { if("openjpa.jdbc.SQL".equals(channel)) { // OR equalsIgnoreCase(channel) ??? sqlLogger = true; } return super.getLog(channel); } @Override protected LogImpl newLogImpl() { if(sqlLogger) { sqlLogger = false; /* once an SQL Logger is created, we dont't need any more instances */ return new LogImpl() { private long sqlCounter = 0; @Override protected String formatMessage(short level, String message, Throwable t) { if(isSQLString(message)) { StringBuffer formattedMessage = new StringBuffer(super.formatMessage(level, message, t)); StringBuffer queryNo = new StringBuffer(); queryNo.append(" [Query # ").append(++sqlCounter).append("]").append(NEWLINE); formattedMessage.delete(formattedMessage.length() - NEWLINE.length(), formattedMessage.length()); formattedMessage.append(queryNo); return formattedMessage.toString(); } return super.formatMessage(level, message, t); } /* just a sample implementation; checks whether message contains the word "executing" * more concrete implementation should check the message for SELECT, UPDATE, INSERT INTO, ALTER.... clauses */ private boolean isSQLString(String message) { if(message.contains("executing")) { return true; } return false; } }; } return super.newLogImpl(); } } </code></pre> <p><strong>peristence.xml</strong></p> <pre><code>&lt;property name="openjpa.Log" value="org.opensource.logger.MyLogFactory(DefaultLevel=WARN, Runtime=INFO, Tool=INFO, SQL=TRACE)"/&gt; </code></pre> <p><strong>Test</strong></p> <pre><code>EntityManager em = Persistence.createEntityManagerFactory("default").createEntityManager(); EntityTransaction tx = em.getTransaction(); tx.begin(); Person person = new Person(); person.setName("Bond-OO7"); person.setAge(22); em.persist(person); tx.commit(); em.close(); </code></pre> <p><strong>Console</strong></p> <pre><code>............ 2084 default TRACE [main] openjpa.jdbc.SQL - &lt;t 346613126, conn 1551158018&gt; executing prepstmnt 556472773 SELECT SEQUENCE_OWNER AS SEQUENCE_SCHEMA, SEQUENCE_NAME FROM ALL_SEQUENCES [Query # 1] 2136 default TRACE [main] openjpa.jdbc.SQL - &lt;t 346613126, conn 1551158018&gt; [52 ms] spent 2305 default TRACE [main] openjpa.jdbc.SQL - &lt;t 346613126, conn 2026561073&gt; executing prepstmnt 6637010 INSERT INTO Person (id, age, name) VALUES (?, ?, ?) [params=?, ?, ?] [Query # 2] 2306 default TRACE [main] openjpa.jdbc.SQL - &lt;t 346613126, conn 2026561073&gt; [1 ms] spent ............ </code></pre> <h1><a href="http://openjpa.apache.org/builds/apache-openjpa-2.0.2-SNAPSHOT/docs/manual/ref_guide_logging_custom.html" rel="nofollow">Reference</a></h1>
    singulars
    1. This table or related slice is empty.
    1. POCan we assign custom Query Hints to JPA NamedQueries
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDipesh Rathod
    1. USDipesh Rathod
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    1. COThanks, but it looks like you are just adding comments between /* */ which for OpenJPA can be leverage using the OracleHint. However, QUERYNO is not a comment, but a DB2 query clause, it must be at the end of statements and outside of comment blocks. And as the documentation you point to even suggests, for OpenJPA the hints are only used for Oracle and MySQL. For my DB2 dictionary either hint string is simply ignored.
      singulars
      1. PO
      1. USEddie
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload