Re: [SignServer-develop] Problem with signserver-ce-3.7.0 and oracle database

[Markus K. <ma...@pr...>]

On 05/23/2016 11:50 AM, Tung, Tran wrote:
> 
> How to turn on SQL logging ?

One way could be to edit the persistence.xml and make sure both
persistence-units has the following property and value:
<property name="hibernate.show_sql" value="true"/>

A quick way of making this change is to edit
lib/SignServer-Entities-x.y.z.jar which has the persistence.xml under
/META-INF/.
Note: that this change will be removed in case you rebuild SignServer.

After changing this file you need to deploy again:
$ bin/signserver deploy

Then when running you should see outputs like this for each SQL query it
tries to perform:
14:59:08,829 INFO  [stdout] (ServerService Thread Pool -- 88) Hibernate:
select max(auditrecor0_.sequenceNumber) as col_0_0_ from AuditRecordData
auditrecor0_ where auditrecor0_.nodeId=?

Regards,
Markus
PrimeKey Solutions AB