Two services both use H2, both fail to connect

656 views
Skip to first unread message

olddave

unread,
Mar 18, 2008, 6:20:43 AM3/18/08
to H2 Database
Hi,

New to H2 and looking forward to it.

I am using Turbine 2.3.2 from Apache, it uses Excalibir to start the
services, one of which is Torque for which I use the following config.
It does init this one first I checked.

torque.dsfactory.transformer.connection.driver = org.h2.Driver
torque.dsfactory.transformer.connection.url = jdbc:h2:file://C:/Work/
Tomcat/webapps/tranpan/db/tranpan

Along with username and password, all tested through H2 console and
working

Then Excalibur starts a second service ( with a few others in between)
with this config.

<property name="org.quartz.dataSource.stpsh.driver"
value="org.h2.Driver"/>
<property name="org.quartz.dataSource.stpsh.URL"
value="jdbc:h2:tcp://localhost:9092/tranpan"/>

This is for Quartz and uses their standard JDBC
org.quartz.impl.jdbcjobstore.StdJDBCDelegate

It throws this

Caused by: org.h2.jdbc.JdbcSQLException: Table QRTZ_TRIGGERS not
found; SQL statement:
SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE
IS_VOLATILE = ? [42102-66]
at org.h2.message.Message.getSQLException(Message.java:89)
at org.h2.message.Message.getSQLException(Message.java:93)
at org.h2.message.Message.getSQLException(Message.java:71)
at org.h2.command.Parser.readTableOrView(Parser.java:3985)

The table does exist and is accessible through the H2 consol using
the :file: url above.
Then later on Torque throws too when Turbine tries to intialises the
Security service.

Not sure what to try next. I do want the Torque connection to be
embedded for the sheer performance of it, Quartz can use TCP.

Regards,

David

Thomas Mueller

unread,
Mar 18, 2008, 3:02:12 PM3/18/08
to h2-da...@googlegroups.com
Hi,

You have used two different database URL pointing to two databases.

jdbc:h2:file://C:/Work/Tomcat/webapps/tranpan/db/tranpan


jdbc:h2:tcp://localhost:9092/tranpan

If you want to point to the same database, use:

jdbc:h2:file://C:/Work/Tomcat/webapps/tranpan/db/tranpan
jdbc:h2:tcp://localhost:9092/file://C:/Work/Tomcat/webapps/tranpan/db/tranpan

There are other ways, for example by using -baseDir when starting the
TCP server.

Regards,
Thomas

olddave

unread,
Mar 20, 2008, 5:22:56 AM3/20/08
to H2 Database
Hi,

I tried you suggestion using the following URLs. Also making sure the
Torque component hit the database first. I added trace to H2, as I
could see it startup in the process my webapp is runnin gin
.
Torque URL
torque.dsfactory.transformer.connection.driver = org.h2.Driver
torque.dsfactory.transformer.connection.url = jdbc:h2:file://C:/Work/
Tomcat_5.5/webapps/transformer/db/
transformer;IFEXISTS=TRUE;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3

Quartz URL
<property name="org.quartz.dataSource.stpsh.driver"
value="org.h2.Driver"/>
<property name="org.quartz.dataSource.stpsh.URL"
value="jdbc:h2:tcp://localhost:9092/file://C:/Work/Tomcat_5.5/webapps/
transformer/db/transformer"/>

Log from console

03-20 09:01:01 index: Index TRANSFORMER.VAR_CHANGE_DETECT_FK_2_INDEX_3
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.VAR_CHANGE_CACHE_FK_1_INDEX_3
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.VAR_CHANGE_FIELD_FK_2_INDEX_3
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_53 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_5 head
consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.TURBINE_USER_GROUP_ROLE_FK_2_INDEX_5 head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_BB head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_BB head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.STP_RETRIEVAL_FK_1_INDEX_B
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_B6 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_B6 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_BF head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_42 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.VAR_CHANGE_CACHE_FK_1_INDEX_4
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.VAR_CHANGE_CACHE_FK_2_INDEX_4
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_78 head
consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.DOMAIN_META_FIELDS_FK_1_INDEX_7 head consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.DOMAIN_META_FIELDS_FK_2_INDEX_7 head consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.DOMAIN_META_FIELDS_FK_3_INDEX_7 head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_682 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_1B head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.XLS_WORKSHEET_FK_1_INDEX_1
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_ED head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.STP_XMLATTR_VALUE_FK_1_INDEX_E
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_9 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_9 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.XLS_WORKSHEET_FK_1_INDEX_9
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_84 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_84 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.STP_STREAMREQ_FK_1_INDEX_8
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_46 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_46 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_C head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_81 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.STP_FIELD_FK_1_INDEX_8 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_424 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.VAR_CHANGE_FIELD_FK_1_INDEX_4
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.VAR_CHANGE_FIELD_FK_2_INDEX_4
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_7C head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_7 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.STP_ERROR_PROFILE_FK_1_INDEX_7
head consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.STP_CUSTOMINPROFILE_FK_2_INDEX_7 head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_38 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_3 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_38 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_38D head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_38DA head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_38DAF head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_7 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.STP_RETRIEVAL_FK_1_INDEX_7
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_7D head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_7D head
consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.CLEANSING_EXCEPTION_FK_2_INDEX_7 head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_6 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_6 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.STP_TRANSFORM_FK_1_INDEX_6
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_1B0 head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_1 head
consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.CLEANSING_EXCEPTION_FK_1_INDEX_1 head consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.CLEANSING_EXCEPTION_FK_2_INDEX_1 head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.EXCEPTION_VALUE_FK_1_INDEX_1
head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_D head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.CONSTRAINT_INDEX_D head
consistent=true
03-20 09:01:01 index: Index TRANSFORMER.DOMAIN_VALUES_FK_1_INDEX_D
head consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.DOMAIN_META_FIELDS_FK_1_INDEX_D head consistent=true
03-20 09:01:01 index: Index TRANSFORMER.PRIMARY_KEY_3D head
consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.TURBINE_USER_GROUP_ROLE_FK_1_INDEX_3 head consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.TURBINE_USER_GROUP_ROLE_FK_2_INDEX_3 head consistent=true
03-20 09:01:01 index: Index
TRANSFORMER.TURBINE_USER_GROUP_ROLE_FK_3_INDEX_3 head consistent=true
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 lock: 1 exclusive write lock added for SYS
03-20 09:01:01 lock: 1 exclusive write lock unlock SYS
03-20 09:01:01 fileLock: load {method=file,
id=118cb6b7a2fbec74e5e371d1e272d41f8be7c8293cb}
03-20 09:01:01 database: closed
03-20 09:01:01 session: disconnected #2
[ERROR] BaseSecurityService - Failed to retrieve global group object:
<org.apache.turbine.util.security.DataBackendException:
getGroups(Criteria)
failed>org.apache.turbine.util.security.DataBackendException:
getGroups(Criteria) failed
at
org.apache.turbine.services.security.db.DBSecurityService.getGroups(DBSecurityService.java:
484)
at
org.apache.turbine.services.security.BaseSecurityService.getAllGroups(BaseSecurityService.java:
1161)
at
org.apache.turbine.services.security.BaseSecurityService.getGlobalGroup(BaseSecurityService.java:
958)
at
org.apache.turbine.services.security.TurbineSecurity.getGlobalGroup(TurbineSecurity.java:
591)
at
com.stpenable.transformer.services.DatabasePrimer.init(DatabasePrimer.java:
70)
at
org.apache.turbine.services.BaseServiceBroker.initService(BaseServiceBroker.java:
283)
at
org.apache.turbine.services.BaseServiceBroker.doInitService(BaseServiceBroker.java:
363)
at
org.apache.turbine.services.BaseServiceBroker.initServices(BaseServiceBroker.java:
335)
at
org.apache.turbine.services.BaseServiceBroker.init(BaseServiceBroker.java:
152)
at org.apache.turbine.Turbine.configure(Turbine.java:386)
at org.apache.turbine.Turbine.init(Turbine.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:
1139)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:
966)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:
3956)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:
4230)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:
1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:
736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:
1014)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:
448)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.apache.torque.TorqueException:
org.apache.torque.TorqueException:
org.apache.commons.dbcp.SQLNestedException: Could not retrieve
connection info from pool
at
org.apache.turbine.om.security.peer.GroupPeer.doSelect(GroupPeer.java:
155)
at
org.apache.turbine.services.security.db.DBSecurityService.getGroups(DBSecurityService.java:
480)
... 28 more
Caused by: org.apache.torque.TorqueException:
org.apache.commons.dbcp.SQLNestedException: Could not retrieve
connection info from pool
at
org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:
919)
at org.apache.torque.Torque.getConnection(Torque.java:314)
at
org.apache.torque.util.Transaction.beginOptional(Transaction.java:108)
at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:753)
at
org.apache.turbine.om.security.peer.GroupPeer.doSelect(GroupPeer.java:
131)
... 29 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Could not
retrieve connection info from pool
at
org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:
169)
at
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:
631)
at
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:
615)
at
org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:
912)
... 33 more
Caused by: java.util.NoSuchElementException: Could not create a
validated object
at
org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:
783)
at
org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:
165)
... 36 more

03-20 09:01:02 fileLock: watchdog end
03-20 09:01:02 fileLock: watchdog end
03-20 09:01:19 database: opening C:\Work\Tomcat_5.5\webapps\transformer
\db\transformer (build 66)
03-20 09:01:19 fileLock: save {method=file,
id=118cb6bbf851b54ac5b383c556fa2b1a124ea4e9933}
03-20 09:01:19 fileLock: load {method=file,
id=118cb6bbf851b54ac5b383c556fa2b1a124ea4e9933}
03-20 09:01:19 index: open existing SYS rows: 384
03-20 09:01:19 index: open existing STP_DATABASE rows: 0
03-20 09:01:19 index: open existing STP_FILE rows: 0
03-20 09:01:19 index: open existing STP_PROFILE rows: 0
03-20 09:01:19 index: open existing STP_SOURCE rows: 0
03-20 09:01:19 index: open existing STP_SINK rows: 0
03-20 09:01:19 index: open existing STP_RECORD rows: 0
03-20 09:01:19 index: open existing STP_FIELD rows: 0
03-20 09:01:19 index: open existing STP_OPERATION_DOMAIN rows: 0
03-20 09:01:19 index: open existing STP_OPERATION rows: 0
03-20 09:01:19 index: open existing FIELD_UTILISED rows: 0
03-20 09:01:19 index: open existing STP_TRANSFORM rows: 0
03-20 09:01:19 index: open existing STP_COMMAND rows: 0
03-20 09:01:19 index: open existing STP_PROCESS rows: 0
03-20 09:01:19 index: open existing XLS_WORKSHEET rows: 0
03-20 09:01:19 index: open existing STP_VIEW rows: 0
03-20 09:01:19 index: open existing STP_STREAM rows: 0
03-20 09:01:19 index: open existing STP_STREAMREQ rows: 0
03-20 09:01:19 index: open existing STP_SCHEDULE rows: 0
03-20 09:01:19 index: open existing STP_RETRIEVAL rows: 0
03-20 09:01:19 index: open existing STP_ERROR_PROFILE rows: 0
03-20 09:01:19 index: open existing STP_CUSTOMINPROFILE rows: 0
03-20 09:01:19 index: open existing STP_CUSTOM_ERROR rows: 0
03-20 09:01:19 index: open existing STP_MESSAGE rows: 0
03-20 09:01:19 index: open existing STP_MSGUSER rows: 0
03-20 09:01:19 index: open existing STP_XMLDOCUMENT rows: 0
03-20 09:01:19 index: open existing STP_XMLELEMENT rows: 0
03-20 09:01:19 index: open existing STP_XMLATTRIBUTE rows: 0
03-20 09:01:19 index: open existing STP_XMLATTR_VALUE rows: 0
03-20 09:01:19 index: open existing VAR_CHANGE_DETECT rows: 0
03-20 09:01:19 index: open existing VAR_CHANGE_CACHE rows: 0
03-20 09:01:19 index: open existing VAR_CHANGE_FIELD rows: 0
03-20 09:01:19 index: open existing STP_ESB_CLIENT rows: 0
03-20 09:01:19 index: open existing DOMAIN_SET rows: 0
03-20 09:01:19 index: open existing DOMAIN_VALUES rows: 0
03-20 09:01:19 index: open existing DOMAIN_META_FIELDS rows: 0
03-20 09:01:19 index: open existing EXCEPTION_TYPE rows: 0
03-20 09:01:19 index: open existing CLEANSING_EXCEPTION rows: 0
03-20 09:01:19 index: open existing EXCEPTION_VALUE rows: 0
03-20 09:01:19 index: open existing QRTZ_JOB_DETAILS rows: 0
03-20 09:01:19 index: open existing QRTZ_JOB_LISTENERS rows: 0
03-20 09:01:19 index: open existing QRTZ_TRIGGERS rows: 0
03-20 09:01:19 index: open existing QRTZ_SIMPLE_TRIGGERS rows: 0
03-20 09:01:19 index: open existing QRTZ_CRON_TRIGGERS rows: 0
03-20 09:01:19 index: open existing QRTZ_BLOB_TRIGGERS rows: 0
03-20 09:01:19 index: open existing QRTZ_TRIGGER_LISTENERS rows: 0
03-20 09:01:19 index: open existing QRTZ_CALENDARS rows: 0
03-20 09:01:19 index: open existing QRTZ_PAUSED_TRIGGER_GRPS rows: 0
03-20 09:01:19 index: open existing QRTZ_FIRED_TRIGGERS rows: 0
03-20 09:01:19 index: open existing QRTZ_SCHEDULER_STATE rows: 0
03-20 09:01:19 index: open existing QRTZ_LOCKS rows: 5
03-20 09:01:19 index: open existing TURBINE_PERMISSION rows: 2
03-20 09:01:19 index: open existing TURBINE_ROLE rows: 3
03-20 09:01:19 index: open existing TURBINE_GROUP rows: 1
03-20 09:01:19 index: open existing TURBINE_ROLE_PERMISSION rows: 1
03-20 09:01:19 index: open existing TURBINE_USER rows: 2
03-20 09:01:19 index: open existing TURBINE_USER_GROUP_ROLE rows: 2
03-20 09:01:19 lock: 1 exclusive write lock added for STP_DATABASE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_DATABASE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_DATABASE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_DATABASE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_SOURCE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_SOURCE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_SOURCE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_SOURCE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_SINK
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_SINK
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_SINK
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_SINK
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_RECORD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_RECORD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
STP_OPERATION_DOMAIN
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock
STP_OPERATION_DOMAIN
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_OPERATION
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_OPERATION
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for FIELD_UTILISED
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock FIELD_UTILISED
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_TRANSFORM
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_TRANSFORM
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_TRANSFORM
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_TRANSFORM
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_COMMAND
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_COMMAND
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_COMMAND
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_COMMAND
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_PROCESS
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_PROCESS
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_PROCESS
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_PROCESS
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for XLS_WORKSHEET
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock XLS_WORKSHEET
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_VIEW
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_VIEW
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_VIEW
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_VIEW
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_STREAM
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_STREAM
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_STREAM
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_STREAM
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_STREAMREQ
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_STREAMREQ
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_STREAMREQ
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_STREAMREQ
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_SCHEDULE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_SCHEDULE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_SCHEDULE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_SCHEDULE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_RETRIEVAL
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_RETRIEVAL
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
STP_ERROR_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_ERROR_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
STP_ERROR_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_ERROR_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
STP_CUSTOMINPROFILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_CUSTOMINPROFILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_CUSTOM_ERROR
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_CUSTOM_ERROR
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_MESSAGE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_MESSAGE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_MESSAGE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_MESSAGE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_MSGUSER
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_MSGUSER
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_XMLDOCUMENT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_XMLDOCUMENT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_XMLELEMENT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_XMLELEMENT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_XMLATTRIBUTE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_XMLATTRIBUTE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
STP_XMLATTR_VALUE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_XMLATTR_VALUE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
VAR_CHANGE_DETECT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_DETECT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for VAR_CHANGE_CACHE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_CACHE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for VAR_CHANGE_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_ESB_CLIENT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_ESB_CLIENT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_ESB_CLIENT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_ESB_CLIENT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for DOMAIN_SET
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock DOMAIN_SET
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for DOMAIN_SET
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock DOMAIN_SET
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for DOMAIN_VALUES
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock DOMAIN_VALUES
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
DOMAIN_META_FIELDS
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock DOMAIN_META_FIELDS
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for EXCEPTION_TYPE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock EXCEPTION_TYPE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for EXCEPTION_TYPE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock EXCEPTION_TYPE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
CLEANSING_EXCEPTION
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock CLEANSING_EXCEPTION
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
CLEANSING_EXCEPTION
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock CLEANSING_EXCEPTION
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for EXCEPTION_VALUE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock EXCEPTION_VALUE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_RECORD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_RECORD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for FIELD_UTILISED
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock FIELD_UTILISED
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for FIELD_UTILISED
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock FIELD_UTILISED
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for FIELD_UTILISED
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock FIELD_UTILISED
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_TRANSFORM
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_TRANSFORM
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_TRANSFORM
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_TRANSFORM
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_PROCESS
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_PROCESS
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_PROCESS
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_PROCESS
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for XLS_WORKSHEET
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock XLS_WORKSHEET
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_VIEW
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_VIEW
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_DATABASE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_DATABASE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_STREAMREQ
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_STREAMREQ
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_STREAM
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_STREAM
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_RETRIEVAL
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_RETRIEVAL
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_SCHEDULE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_SCHEDULE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
STP_ERROR_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_ERROR_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_MESSAGE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_MESSAGE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
STP_CUSTOMINPROFILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_CUSTOMINPROFILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_CUSTOM_ERROR
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_CUSTOM_ERROR
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
STP_CUSTOMINPROFILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_CUSTOMINPROFILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
STP_ERROR_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_ERROR_PROFILE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_XMLELEMENT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_XMLELEMENT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_XMLDOCUMENT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_XMLDOCUMENT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_XMLATTRIBUTE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_XMLATTRIBUTE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_XMLELEMENT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_XMLELEMENT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
STP_XMLATTR_VALUE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_XMLATTR_VALUE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_XMLATTRIBUTE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_XMLATTRIBUTE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
VAR_CHANGE_DETECT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_DETECT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_TRANSFORM
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_TRANSFORM
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
VAR_CHANGE_DETECT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_DETECT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_VIEW
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_VIEW
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for VAR_CHANGE_CACHE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_CACHE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
VAR_CHANGE_DETECT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_DETECT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for VAR_CHANGE_CACHE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_CACHE
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_VIEW
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_VIEW
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for VAR_CHANGE_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for VAR_CHANGE_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
VAR_CHANGE_DETECT
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock VAR_CHANGE_DETECT
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for DOMAIN_VALUES
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock DOMAIN_VALUES
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for DOMAIN_SET
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock DOMAIN_SET
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
DOMAIN_META_FIELDS
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock DOMAIN_META_FIELDS
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for DOMAIN_SET
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock DOMAIN_SET
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
DOMAIN_META_FIELDS
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock DOMAIN_META_FIELDS
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
DOMAIN_META_FIELDS
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock DOMAIN_META_FIELDS
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
CLEANSING_EXCEPTION
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock CLEANSING_EXCEPTION
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for
CLEANSING_EXCEPTION
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock CLEANSING_EXCEPTION
03-20 09:01:19 lock: 1 exclusive write lock unlock SYS
03-20 09:01:19 lock: 1 exclusive write lock added for EXCEPTION_TYPE
03-20 09:01:19 lock: 1 exclusive write lock added for SYS
03-20 09:01:19 lock: 1 exclusive write lock unlock EXCEPTION_TYPE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for EXCEPTION_VALUE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock EXCEPTION_VALUE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
CLEANSING_EXCEPTION
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock CLEANSING_EXCEPTION
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for EXCEPTION_VALUE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock EXCEPTION_VALUE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_JOB_DETAILS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_JOB_DETAILS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_JOB_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_JOB_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_JOB_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_JOB_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_JOB_DETAILS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_JOB_DETAILS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_JOB_DETAILS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_JOB_DETAILS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_SIMPLE_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_SIMPLE_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_SIMPLE_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_SIMPLE_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_CRON_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_CRON_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_CRON_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_CRON_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_BLOB_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_BLOB_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_BLOB_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_BLOB_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_TRIGGER_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_TRIGGER_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_TRIGGER_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_TRIGGER_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_CALENDARS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_CALENDARS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_PAUSED_TRIGGER_GRPS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_PAUSED_TRIGGER_GRPS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_FIRED_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_FIRED_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_SCHEDULER_STATE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_SCHEDULER_STATE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_LOCKS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_LOCKS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_GROUP
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_GROUP
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_GROUP
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_GROUP
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_USER
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_USER
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_USER
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_USER
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_USER
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_USER
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_GROUP
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_GROUP
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for STP_DATABASE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_DATABASE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_DATABASE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_DATABASE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_FILE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_FILE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_FILE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_FILE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_PROFILE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_PROFILE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_PROFILE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_PROFILE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_SOURCE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_SOURCE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_SOURCE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_SOURCE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_SINK
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_SINK
03-20 09:01:20 lock: 1 exclusive write lock added for STP_SINK
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_SINK
03-20 09:01:20 lock: 1 exclusive write lock added for STP_RECORD
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_RECORD
03-20 09:01:20 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:20 lock: 1 exclusive write lock added for
STP_OPERATION_DOMAIN
03-20 09:01:20 lock: 1 exclusive write lock unlock
STP_OPERATION_DOMAIN
03-20 09:01:20 lock: 1 exclusive write lock added for STP_OPERATION
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_OPERATION
03-20 09:01:20 lock: 1 exclusive write lock added for FIELD_UTILISED
03-20 09:01:20 lock: 1 exclusive write lock unlock FIELD_UTILISED
03-20 09:01:20 lock: 1 exclusive write lock added for STP_TRANSFORM
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_TRANSFORM
03-20 09:01:20 lock: 1 exclusive write lock added for STP_TRANSFORM
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_TRANSFORM
03-20 09:01:20 lock: 1 exclusive write lock added for STP_COMMAND
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_COMMAND
03-20 09:01:20 lock: 1 exclusive write lock added for STP_COMMAND
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_COMMAND
03-20 09:01:20 lock: 1 exclusive write lock added for STP_PROCESS
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_PROCESS
03-20 09:01:20 lock: 1 exclusive write lock added for STP_PROCESS
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_PROCESS
03-20 09:01:20 lock: 1 exclusive write lock added for XLS_WORKSHEET
03-20 09:01:20 lock: 1 exclusive write lock unlock XLS_WORKSHEET
03-20 09:01:20 lock: 1 exclusive write lock added for STP_VIEW
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_VIEW
03-20 09:01:20 lock: 1 exclusive write lock added for STP_VIEW
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_VIEW
03-20 09:01:20 lock: 1 exclusive write lock added for STP_STREAM
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_STREAM
03-20 09:01:20 lock: 1 exclusive write lock added for STP_STREAM
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_STREAM
03-20 09:01:20 lock: 1 exclusive write lock added for STP_STREAMREQ
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_STREAMREQ
03-20 09:01:20 lock: 1 exclusive write lock added for STP_STREAMREQ
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_STREAMREQ
03-20 09:01:20 lock: 1 exclusive write lock added for STP_SCHEDULE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_SCHEDULE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_SCHEDULE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_SCHEDULE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_RETRIEVAL
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_RETRIEVAL
03-20 09:01:20 lock: 1 exclusive write lock added for
STP_ERROR_PROFILE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_ERROR_PROFILE
03-20 09:01:20 lock: 1 exclusive write lock added for
STP_ERROR_PROFILE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_ERROR_PROFILE
03-20 09:01:20 lock: 1 exclusive write lock added for
STP_CUSTOMINPROFILE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_CUSTOMINPROFILE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_CUSTOM_ERROR
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_CUSTOM_ERROR
03-20 09:01:20 lock: 1 exclusive write lock added for STP_MESSAGE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_MESSAGE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_MESSAGE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_MESSAGE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_MSGUSER
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_MSGUSER
03-20 09:01:20 lock: 1 exclusive write lock added for STP_XMLDOCUMENT
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_XMLDOCUMENT
03-20 09:01:20 lock: 1 exclusive write lock added for STP_XMLELEMENT
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_XMLELEMENT
03-20 09:01:20 lock: 1 exclusive write lock added for STP_XMLATTRIBUTE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_XMLATTRIBUTE
03-20 09:01:20 lock: 1 exclusive write lock added for
STP_XMLATTR_VALUE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_XMLATTR_VALUE
03-20 09:01:20 lock: 1 exclusive write lock added for
VAR_CHANGE_DETECT
03-20 09:01:20 lock: 1 exclusive write lock unlock VAR_CHANGE_DETECT
03-20 09:01:20 lock: 1 exclusive write lock added for VAR_CHANGE_CACHE
03-20 09:01:20 lock: 1 exclusive write lock unlock VAR_CHANGE_CACHE
03-20 09:01:20 lock: 1 exclusive write lock added for VAR_CHANGE_FIELD
03-20 09:01:20 lock: 1 exclusive write lock unlock VAR_CHANGE_FIELD
03-20 09:01:20 lock: 1 exclusive write lock added for STP_ESB_CLIENT
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_ESB_CLIENT
03-20 09:01:20 lock: 1 exclusive write lock added for STP_ESB_CLIENT
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_ESB_CLIENT
03-20 09:01:20 lock: 1 exclusive write lock added for DOMAIN_SET
03-20 09:01:20 lock: 1 exclusive write lock unlock DOMAIN_SET
03-20 09:01:20 lock: 1 exclusive write lock added for DOMAIN_SET
03-20 09:01:20 lock: 1 exclusive write lock unlock DOMAIN_SET
03-20 09:01:20 lock: 1 exclusive write lock added for DOMAIN_VALUES
03-20 09:01:20 lock: 1 exclusive write lock unlock DOMAIN_VALUES
03-20 09:01:20 lock: 1 exclusive write lock added for
DOMAIN_META_FIELDS
03-20 09:01:20 lock: 1 exclusive write lock unlock DOMAIN_META_FIELDS
03-20 09:01:20 lock: 1 exclusive write lock added for EXCEPTION_TYPE
03-20 09:01:20 lock: 1 exclusive write lock unlock EXCEPTION_TYPE
03-20 09:01:20 lock: 1 exclusive write lock added for EXCEPTION_TYPE
03-20 09:01:20 lock: 1 exclusive write lock unlock EXCEPTION_TYPE
03-20 09:01:20 lock: 1 exclusive write lock added for
CLEANSING_EXCEPTION
03-20 09:01:20 lock: 1 exclusive write lock unlock CLEANSING_EXCEPTION
03-20 09:01:20 lock: 1 exclusive write lock added for
CLEANSING_EXCEPTION
03-20 09:01:20 lock: 1 exclusive write lock unlock CLEANSING_EXCEPTION
03-20 09:01:20 lock: 1 exclusive write lock added for EXCEPTION_VALUE
03-20 09:01:20 lock: 1 exclusive write lock unlock EXCEPTION_VALUE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_FIELD
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_FIELD
03-20 09:01:20 lock: 1 exclusive write lock added for FIELD_UTILISED
03-20 09:01:20 lock: 1 exclusive write lock unlock FIELD_UTILISED
03-20 09:01:20 lock: 1 exclusive write lock added for FIELD_UTILISED
03-20 09:01:20 lock: 1 exclusive write lock unlock FIELD_UTILISED
03-20 09:01:20 lock: 1 exclusive write lock added for FIELD_UTILISED
03-20 09:01:20 lock: 1 exclusive write lock unlock FIELD_UTILISED
03-20 09:01:20 lock: 1 exclusive write lock added for STP_TRANSFORM
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_TRANSFORM
03-20 09:01:20 lock: 1 exclusive write lock added for STP_PROCESS
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_PROCESS
03-20 09:01:20 lock: 1 exclusive write lock added for XLS_WORKSHEET
03-20 09:01:20 lock: 1 exclusive write lock unlock XLS_WORKSHEET
03-20 09:01:20 lock: 1 exclusive write lock added for STP_VIEW
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_VIEW
03-20 09:01:20 lock: 1 exclusive write lock added for STP_STREAMREQ
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_STREAMREQ
03-20 09:01:20 lock: 1 exclusive write lock added for STP_RETRIEVAL
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_RETRIEVAL
03-20 09:01:20 lock: 1 exclusive write lock added for
STP_ERROR_PROFILE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_ERROR_PROFILE
03-20 09:01:20 lock: 1 exclusive write lock added for
STP_CUSTOMINPROFILE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_CUSTOMINPROFILE
03-20 09:01:20 lock: 1 exclusive write lock added for
STP_CUSTOMINPROFILE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_CUSTOMINPROFILE
03-20 09:01:20 lock: 1 exclusive write lock added for STP_XMLELEMENT
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_XMLELEMENT
03-20 09:01:20 lock: 1 exclusive write lock added for STP_XMLATTRIBUTE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_XMLATTRIBUTE
03-20 09:01:20 lock: 1 exclusive write lock added for
STP_XMLATTR_VALUE
03-20 09:01:20 lock: 1 exclusive write lock unlock STP_XMLATTR_VALUE
03-20 09:01:20 lock: 1 exclusive write lock added for
VAR_CHANGE_DETECT
03-20 09:01:20 lock: 1 exclusive write lock unlock VAR_CHANGE_DETECT
03-20 09:01:20 lock: 1 exclusive write lock added for
VAR_CHANGE_DETECT
03-20 09:01:20 lock: 1 exclusive write lock unlock VAR_CHANGE_DETECT
03-20 09:01:20 lock: 1 exclusive write lock added for VAR_CHANGE_CACHE
03-20 09:01:20 lock: 1 exclusive write lock unlock VAR_CHANGE_CACHE
03-20 09:01:20 lock: 1 exclusive write lock added for VAR_CHANGE_CACHE
03-20 09:01:20 lock: 1 exclusive write lock unlock VAR_CHANGE_CACHE
03-20 09:01:20 lock: 1 exclusive write lock added for VAR_CHANGE_FIELD
03-20 09:01:20 lock: 1 exclusive write lock unlock VAR_CHANGE_FIELD
03-20 09:01:20 lock: 1 exclusive write lock added for VAR_CHANGE_FIELD
03-20 09:01:20 lock: 1 exclusive write lock unlock VAR_CHANGE_FIELD
03-20 09:01:20 lock: 1 exclusive write lock added for DOMAIN_VALUES
03-20 09:01:20 lock: 1 exclusive write lock unlock DOMAIN_VALUES
03-20 09:01:20 lock: 1 exclusive write lock added for
DOMAIN_META_FIELDS
03-20 09:01:20 lock: 1 exclusive write lock unlock DOMAIN_META_FIELDS
03-20 09:01:20 lock: 1 exclusive write lock added for
DOMAIN_META_FIELDS
03-20 09:01:20 lock: 1 exclusive write lock unlock DOMAIN_META_FIELDS
03-20 09:01:20 lock: 1 exclusive write lock added for
DOMAIN_META_FIELDS
03-20 09:01:20 lock: 1 exclusive write lock unlock DOMAIN_META_FIELDS
03-20 09:01:20 lock: 1 exclusive write lock added for
CLEANSING_EXCEPTION
03-20 09:01:20 lock: 1 exclusive write lock unlock CLEANSING_EXCEPTION
03-20 09:01:20 lock: 1 exclusive write lock added for
CLEANSING_EXCEPTION
03-20 09:01:20 lock: 1 exclusive write lock unlock CLEANSING_EXCEPTION
03-20 09:01:20 lock: 1 exclusive write lock added for EXCEPTION_VALUE
03-20 09:01:20 lock: 1 exclusive write lock unlock EXCEPTION_VALUE
03-20 09:01:20 lock: 1 exclusive write lock added for EXCEPTION_VALUE
03-20 09:01:20 lock: 1 exclusive write lock unlock EXCEPTION_VALUE
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_JOB_DETAILS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_JOB_DETAILS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_JOB_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_JOB_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_JOB_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_JOB_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_SIMPLE_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_SIMPLE_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_SIMPLE_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_SIMPLE_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_CRON_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_CRON_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_CRON_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_CRON_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_BLOB_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_BLOB_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_BLOB_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_BLOB_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_TRIGGER_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_TRIGGER_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_TRIGGER_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_TRIGGER_LISTENERS
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_CALENDARS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_CALENDARS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_PAUSED_TRIGGER_GRPS
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_PAUSED_TRIGGER_GRPS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_FIRED_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_FIRED_TRIGGERS
03-20 09:01:20 lock: 1 exclusive write lock added for
QRTZ_SCHEDULER_STATE
03-20 09:01:20 lock: 1 exclusive write lock unlock
QRTZ_SCHEDULER_STATE
03-20 09:01:20 lock: 1 exclusive write lock added for QRTZ_LOCKS
03-20 09:01:20 lock: 1 exclusive write lock unlock QRTZ_LOCKS
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_GROUP
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_GROUP
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_GROUP
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_GROUP
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_USER
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_USER
03-20 09:01:20 lock: 1 exclusive write lock added for TURBINE_USER
03-20 09:01:20 lock: 1 exclusive write lock unlock TURBINE_USER
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_ROLE_PERMISSION
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-20 09:01:20 database: opened C:\Work\Tomcat_5.5\webapps\transformer
\db\transformer
03-20 09:01:20 session: connecting #2 to C:\Work\Tomcat_5.5\webapps
\transformer\db\transformer
03-20 09:01:20 jdbc[2]:
/*SQL*/SET TRACE_LEVEL_SYSTEM_OUT 3;
03-20 09:01:20 jdbc[2]:
/*SQL*/SET TRACE_LEVEL_FILE 3;
03-20 09:01:20 session: connected #2
03-20 09:01:20 jdbc[2]:
/**/Connection conn4 = DriverManager.getConnection("jdbc:h2:file://C:/
Work/Tomcat_5.5/webapps/transformer/db/
transformer;IFEXISTS=TRUE;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3",
"TLOADER", "")
03-20 09:01:20 jdbc[2]:
/**/Statement stat3 = conn4.createStatement();
03-20 09:01:20 jdbc[2]:
/**/ResultSet rs3 = stat3.executeQuery("SELECT 1 FROM TURBINE_USER");
03-20 09:01:20 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table TURBINE_USER not found; SQL
statement:
SELECT 1 FROM TURBINE_USER [42102-66]
at org.h2.message.Message.getSQLException(Message.java:89)
at org.h2.message.Message.getSQLException(Message.java:93)
at org.h2.message.Message.getSQLException(Message.java:71)
at org.h2.command.Parser.readTableOrView(Parser.java:3985)
at org.h2.command.Parser.readTableFilter(Parser.java:885)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:
1372)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1466)
at org.h2.command.Parser.parseSelectSub(Parser.java:1366)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1249)
at org.h2.command.Parser.parseSelect(Parser.java:1237)
at org.h2.command.Parser.parsePrepared(Parser.java:369)
at org.h2.command.Parser.parse(Parser.java:265)
at org.h2.command.Parser.parse(Parser.java:237)
at org.h2.command.Parser.prepareCommand(Parser.java:209)
at org.h2.engine.Session.prepareLocal(Session.java:213)
at org.h2.engine.Session.prepareCommand(Session.java:195)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:
970)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:62)
at
org.apache.commons.dbcp.datasources.KeyedCPDSConnectionFactory.validateObject(KeyedCPDSConnectionFactory.java:
163)
at
org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:
780)
at
org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:
165)
at
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:
631)
at
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:
615)
at
org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:
912)
at org.apache.torque.Torque.getConnection(Torque.java:314)
at
org.apache.torque.util.Transaction.beginOptional(Transaction.java:108)
at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:753)
at
org.apache.turbine.om.security.peer.PermissionPeer.checkExists(PermissionPeer.java:
237)
at
org.apache.turbine.services.security.db.DBSecurityService.checkExists(DBSecurityService.java:
1169)
at
org.apache.turbine.services.security.db.DBSecurityService.addPermission(DBSecurityService.java:
818)
at
org.apache.turbine.services.security.TurbineSecurity.createPermission(TurbineSecurity.java:
619)
at
com.stpenable.transformer.services.DatabasePrimer.init(DatabasePrimer.java:
78)
at
org.apache.turbine.services.BaseServiceBroker.initService(BaseServiceBroker.java:
283)
at
org.apache.turbine.services.BaseServiceBroker.doInitService(BaseServiceBroker.java:
363)
at
org.apache.turbine.services.BaseServiceBroker.initServices(BaseServiceBroker.java:
335)
at
org.apache.turbine.services.BaseServiceBroker.init(BaseServiceBroker.java:
152)
at org.apache.turbine.Turbine.configure(Turbine.java:386)
at org.apache.turbine.Turbine.init(Turbine.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:
1139)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:
966)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:
3956)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:
4230)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:
1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:
736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:
1014)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:
448)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
03-20 09:01:20 jdbc[2]:
/**/stat3.close();
03-20 09:01:20 jdbc[2]:
/**/conn4.close();
03-20 09:01:20 jdbc[2]:
/*SQL*/ROLLBACK;
03-20 09:01:20 session: disconnecting #2
03-20 09:01:20 database: closing C:\Work\Tomcat_5.5\webapps\transformer
\db\transformer
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_4F head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.FIELD_UTILISED_FK_1_INDEX_4
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.FIELD_UTILISED_FK_2_INDEX_4
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.FIELD_UTILISED_FK_3_INDEX_4
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_56 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_XMLELEMENT_FK_1_INDEX_5
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_XMLATTRIBUTE_FK_1_INDEX_56
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_4 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_4 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_VIEW_FK_1_INDEX_4 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_F6 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_97 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_97 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_EE head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_E head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.FIELD_UTILISED_FK_3_INDEX_E
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_TRANSFORM_FK_1_INDEX_E
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_DETECT_FK_1_INDEX_E
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_E9 head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.STP_CUSTOMINPROFILE_FK_1_INDEX_E head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.STP_CUSTOMINPROFILE_FK_2_INDEX_E head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_5 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_FIELD_FK_1_INDEX_5 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.FIELD_UTILISED_FK_1_INDEX_5
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.FIELD_UTILISED_FK_2_INDEX_5
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_FIELD_FK_1_INDEX_5
head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.DOMAIN_META_FIELDS_FK_2_INDEX_5 head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.DOMAIN_META_FIELDS_FK_3_INDEX_5 head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.CLEANSING_EXCEPTION_FK_1_INDEX_5 head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.EXCEPTION_VALUE_FK_2_INDEX_5
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_1 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_A7 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_A head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.TURBINE_ROLE_PERMISSION_FK_1_INDEX_A head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.TURBINE_USER_GROUP_ROLE_FK_3_INDEX_A head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_C6 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_C head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_19 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_19 head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.TURBINE_ROLE_PERMISSION_FK_2_INDEX_1 head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_1E head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_68 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_68 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_PROCESS_FK_1_INDEX_6 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_PROCESS_FK_1_INDEX_68 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_B3 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_B3 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_ERROR_PROFILE_FK_1_INDEX_B
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_B0 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.DOMAIN_VALUES_FK_1_INDEX_B
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_B3D head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_B3D head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_B3D0 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_421 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_42 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_2 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.EXCEPTION_VALUE_FK_1_INDEX_2
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.EXCEPTION_VALUE_FK_2_INDEX_2
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_B1 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_XMLELEMENT_FK_1_INDEX_B
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_50 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_XMLATTRIBUTE_FK_1_INDEX_5
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_XMLATTR_VALUE_FK_1_INDEX_5
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_9C head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_9C head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_STREAMREQ_FK_1_INDEX_9
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_977 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_977 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_VIEW_FK_1_INDEX_9 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_DETECT_FK_2_INDEX_9
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_CACHE_FK_2_INDEX_9
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_A7E head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_A7 head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.TURBINE_USER_GROUP_ROLE_FK_1_INDEX_A head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_7C0 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_F head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_F head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_2E head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_2 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_5C head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.TURBINE_ROLE_PERMISSION_FK_1_INDEX_5 head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.TURBINE_ROLE_PERMISSION_FK_2_INDEX_5 head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_B head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_B head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_8 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_8 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_A head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.STP_CUSTOMINPROFILE_FK_1_INDEX_A head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_E head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_3 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_DETECT_FK_1_INDEX_3
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_DETECT_FK_2_INDEX_3
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_CACHE_FK_1_INDEX_3
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_FIELD_FK_2_INDEX_3
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_53 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_5 head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.TURBINE_USER_GROUP_ROLE_FK_2_INDEX_5 head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_BB head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_BB head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_RETRIEVAL_FK_1_INDEX_B
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_B6 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_B6 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_BF head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_42 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_CACHE_FK_1_INDEX_4
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_CACHE_FK_2_INDEX_4
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_78 head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.DOMAIN_META_FIELDS_FK_1_INDEX_7 head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.DOMAIN_META_FIELDS_FK_2_INDEX_7 head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.DOMAIN_META_FIELDS_FK_3_INDEX_7 head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_682 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_1B head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.XLS_WORKSHEET_FK_1_INDEX_1
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_ED head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_XMLATTR_VALUE_FK_1_INDEX_E
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_9 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_9 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.XLS_WORKSHEET_FK_1_INDEX_9
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_84 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_84 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_STREAMREQ_FK_1_INDEX_8
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_46 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_46 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_C head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_81 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_FIELD_FK_1_INDEX_8 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_424 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_FIELD_FK_1_INDEX_4
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.VAR_CHANGE_FIELD_FK_2_INDEX_4
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_7C head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_7 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_ERROR_PROFILE_FK_1_INDEX_7
head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.STP_CUSTOMINPROFILE_FK_2_INDEX_7 head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_38 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_3 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_38 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_38D head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_38DA head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_38DAF head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_7 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_RETRIEVAL_FK_1_INDEX_7
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_7D head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_7D head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.CLEANSING_EXCEPTION_FK_2_INDEX_7 head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_6 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_6 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.STP_TRANSFORM_FK_1_INDEX_6
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_1B0 head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_1 head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.CLEANSING_EXCEPTION_FK_1_INDEX_1 head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.CLEANSING_EXCEPTION_FK_2_INDEX_1 head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.EXCEPTION_VALUE_FK_1_INDEX_1
head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_D head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.CONSTRAINT_INDEX_D head
consistent=true
03-20 09:01:20 index: Index TRANSFORMER.DOMAIN_VALUES_FK_1_INDEX_D
head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.DOMAIN_META_FIELDS_FK_1_INDEX_D head consistent=true
03-20 09:01:20 index: Index TRANSFORMER.PRIMARY_KEY_3D head
consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.TURBINE_USER_GROUP_ROLE_FK_1_INDEX_3 head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.TURBINE_USER_GROUP_ROLE_FK_2_INDEX_3 head consistent=true
03-20 09:01:20 index: Index
TRANSFORMER.TURBINE_USER_GROUP_ROLE_FK_3_INDEX_3 head consistent=true
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 lock: 1 exclusive write lock added for SYS
03-20 09:01:20 lock: 1 exclusive write lock unlock SYS
03-20 09:01:20 fileLock: load {method=file,
id=118cb6bbf851b54ac5b383c556fa2b1a124ea4e9933}
03-20 09:01:20 database: closed
03-20 09:01:20 session: disconnected #2
03-20 09:01:21 fileLock: watchdog end


Rise to the challenge for Sport Relief with Yahoo! for Good

On Mar 18, 7:02 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:

olddave

unread,
Mar 21, 2008, 8:03:05 AM3/21/08
to H2 Database
Hi,

I am getting nowhere with H2. Gave up on trying to get embedded URL to
work tried straight tcp connections to a Db started through the
listener in web.xml.

Used jdbc:h2:tcp://localhost:9092/file://C:/Work/Tomcat_5.5/webapps/
transformer/db/transformer for the one that starts first and
jdbc:h2:tcp://localhost:9092/transformer for the one that starts
second. Unfortunately the stack trace is so deep through the
connection pooling and Torque layer I cannot see the exception details
in H2.

Then tried straight tcp URLs.

jdbc:h2:tcp://localhost:9092/transformer for both and get

Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken
[90067-66]
at org.h2.message.Message.getSQLException(Message.java:89)
at org.h2.message.Message.getSQLException(Message.java:93)
at org.h2.message.Message.getSQLException(Message.java:71)

Unfortunately I have a deadline and will have to switch back to MySQL
unless I can get this sorted in the next few days. I seem to be not
getting something fundemental about connecting to H2

Thx.

David
> 03-20 09:01:01 lock: 1 ...
>
> read more »

olddave

unread,
Mar 21, 2008, 8:32:59 AM3/21/08
to H2 Database
Some progress.

I changed the URL as is evident in the TRACE below, so as least it has
a connection, but cannot see the table, which does exist in the
transformer schema. This statement is used by Torque to test the
connection.

03-21 12:15:33 jdbc:
/**/Connection conn1 = DriverManager.getConnection("jdbc:h2:tcp://
localhost/
transformer;IFEXISTS=TRUE;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3",
"TLOADER", "")
03-21 12:15:33 jdbc:
/**/conn1.close();
03-21 12:15:33 jdbc: SESSION_PREPARE 0
03-21 12:15:33 jdbc: COMMAND_EXECUTE_UPDATE 0
03-21 12:15:33 jdbc: COMMAND_CLOSE 0
03-21 12:15:33 jdbc: SESSION_CLOSE 0
03-21 12:15:34 jdbc:
/**/Connection conn2 = DriverManager.getConnection("jdbc:h2:tcp://
localhost/
transformer;IFEXISTS=TRUE;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3",
"TLOADER", "")
03-21 12:15:34 jdbc:
/**/Statement stat0 = conn2.createStatement();
03-21 12:15:34 jdbc:
/**/ResultSet rs0 = stat0.executeQuery("SELECT 1 FROM TURBINE_USER");
03-21 12:15:34 jdbc: SESSION_PREPARE 0
03-21 12:15:34 jdbc: SQLException
org.h2.jdbc.JdbcSQLException: Table TURBINE_USER not found; SQL
statement:
SELECT 1 FROM TURBINE_USER [42102-66]
at org.h2.message.Message.getSQLException(Message.java:89)
at org.h2.message.Message.getSQLException(Message.java:93)
at org.h2.message.Message.getSQLException(Message.java:71)

David
> ...
>
> read more »

Thomas Mueller

unread,
Mar 21, 2008, 9:58:49 AM3/21/08
to h2-da...@googlegroups.com
Hi,

> /**/Connection conn1 = DriverManager.getConnection("jdbc:h2:tcp://localhost/transformer;...
> /**/Connection conn2 = DriverManager.getConnection(
> "jdbc:h2:tcp://localhost/transformer;...
> Table TURBINE_USER not found;

The is the same problem as the first one:

Thomas Mueller

unread,
Mar 21, 2008, 10:00:08 AM3/21/08
to h2-da...@googlegroups.com
Hi,

> Then tried straight tcp URLs.
>
> jdbc:h2:tcp://localhost:9092/transformer for both and get
>
> Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken
> [90067-66]


This means the H2 TCP server is not running on this machine, or it is
running on a different port. Also, the URL is probably not correct.

Regards,
Thomas

olddave

unread,
Mar 21, 2008, 12:26:08 PM3/21/08
to H2 Database
Hi,

I moved on from using the port number as in the excerpt you show
below. I start H2 Server by starting the console,
org.h2.tools.Console. Then connected through the console again, by
cutting and pasting the precise URL you see in the trace,
jdbc:h2:tcp://localhost/
transformer;IFEXISTS=TRUE;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3
This works. Then I try the exact same URL in my application for both
services using H2. Then I get the trace shown, repeated here. My
question is, with the exact same URL how come the Console works and
JDBC in the app does not?

/**/Connection conn2 = DriverManager.getConnection("jdbc:h2:tcp://
localhost/
transformer;IFEXISTS=TRUE;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3",
"TLOADER", "")
03-21 12:15:34 jdbc:
/**/Statement stat0 = conn2.createStatement();
03-21 12:15:34 jdbc:
/**/ResultSet rs0 = stat0.executeQuery("SELECT 1 FROM TURBINE_USER");
03-21 12:15:34 jdbc: SESSION_PREPARE 0
03-21 12:15:34 jdbc: SQLException
org.h2.jdbc.JdbcSQLException: Table TURBINE_USER not found; SQL
statement:
SELECT 1 FROM TURBINE_USER [42102-66]
at org.h2.message.Message.getSQLException(Message.java:89)

It does not make any sense.

David

On Mar 21, 2:00 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:

Thomas Mueller

unread,
Mar 21, 2008, 12:43:30 PM3/21/08
to h2-da...@googlegroups.com
Hi,

> I start H2 Server by starting the console, org.h2.tools.Console.

> Then connected through the console again,

> This works. Then I try the exact same URL in my application for both
> services using H2. Then I get the trace shown, repeated here. My
> question is, with the exact same URL how come the Console works and
> JDBC in the app does not?

Do you keep the console running?
Do you start the application from within the same computer, and using
the same version of H2?

> /**/Connection conn2 = DriverManager.getConnection("jdbc:h2:tcp://
> localhost/
> transformer

There is no newline between // and localhost, and between / and
transformer in the log file?

Could you search on your machine for files named transformer.data.db?
I there there are multiple. Could you delete the ones that you don't
need?

In any case, if the problem is two different databases, I suggest to
use a absolute path or saving the database in the home directory
(~/transformer).

Regards,
Thomas

olddave

unread,
Mar 21, 2008, 1:27:59 PM3/21/08
to H2 Database
Hi,

Bingo! I did not want to use the Home directory because the database
and all it's files will be packed into the war file for my webapp.
What I had not realised was that I created the database using the file
URL and that the tcp did not connect to that existing database but
created a new empty one, in fact I found 3 altogether. I removed the
extra ones, and given I only have the URL method to use ( unless I
hack the Torque component I cannot use the Java methods to start the
database with the -baseDir argument) I tried again using the URLs you
suggested. I tried with the Console running and not running. I only
have one version of H2 running and only one computer

For the Torque component I use
jdbc:h2:file://C:/Work/Tomcat_5.5/webapps/transformer/db/
transformer;IFEXISTS=TRUE;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3
And then use the tcp one that points to the same database file for
Quartz
jdbc:h2:tcp://localhost:9092/file://C:/Work/Tomcat_5.5/webapps/
transformer/db/tranformer
there are no CR LF, all on a single line

I can see it opens the database first time, but when it runs the
connection test query that Torque uses it fails. I notice the last
empty arg in the getConnection, is that supposed to be the password?

03-21 17:07:44 fileLock: load {method=file,
id=118d24f6eb1f7a8e738c2947c82f527df403e5d1939}
03-21 17:07:44 database: closed
03-21 17:07:44 session: disconnected #2
03-21 17:07:44 fileLock: watchdog end
03-21 17:07:46 database: opening C:\Work\Tomcat_5.5\webapps\transformer
\db\transformer (build 66)
03-21 17:07:46 fileLock: save {method=file,
id=118d24f7a5a499d3bcc25b5b5ead2e9d2b33ca04519}
03-21 17:07:46 fileLock: load {method=file,
id=118d24f7a5a499d3bcc25b5b5ead2e9d2b33ca04519}
03-21 17:07:47 index: open existing SYS rows: 384
...
...
03-21 17:07:48 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-21 17:07:48 database: opened C:\Work\Tomcat_5.5\webapps\transformer
\db\transformer
03-21 17:07:48 session: connecting #2 to C:\Work\Tomcat_5.5\webapps
\transformer\db\transformer
03-21 17:07:48 jdbc[2]:
/*SQL*/SET TRACE_LEVEL_SYSTEM_OUT 3;
03-21 17:07:48 jdbc[2]:
/*SQL*/SET TRACE_LEVEL_FILE 3;
03-21 17:07:48 session: connected #2
03-21 17:07:48 jdbc[2]:
/**/Connection conn5 = DriverManager.getConnection("jdbc:h2:file://C:/
Work/Tomcat_5.5/webapps/transformer/db/
transformer;IFEXISTS=TRUE;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3",
"TLOADER", "")
03-21 17:07:48 jdbc[2]:
/**/Statement stat3 = conn5.createStatement();
03-21 17:07:48 jdbc[2]:
/**/ResultSet rs3 = stat3.executeQuery("SELECT 1 FROM TURBINE_USER");
03-21 17:07:48 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table TURBINE_USER not found; SQL
statement:
SELECT 1 FROM TURBINE_USER [42102-66]
at org.h2.message.Message.getSQLException(Message.java:89)
at org.h2.message.Message.getSQLException(Message.java:93)

David

On Mar 21, 4:43 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:

olddave

unread,
Mar 21, 2008, 1:35:34 PM3/21/08
to H2 Database
Hi,

One computer, one version of H2 1.0.67. There where multiple versions
of the database. So I deleted all but the one with my tables in it. I
want the database to be in the webapp sub directories so it will get
packed in the war file and run from the unpacked war file. The console
is not running when I start the webapp and now I get

....
03-21 17:25:03 lock: 1 exclusive write lock added for TURBINE_USER
03-21 17:25:03 lock: 1 exclusive write lock unlock TURBINE_USER
03-21 17:25:03 lock: 1 exclusive write lock added for TURBINE_USER
03-21 17:25:03 lock: 1 exclusive write lock unlock TURBINE_USER
....
03-21 17:25:03 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-21 17:25:03 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-21 17:25:03 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-21 17:25:03 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-21 17:25:03 database: opened C:\Work\Tomcat_5.5\webapps\transformer
\db\transformer
03-21 17:25:03 session: connecting #2 to C:\Work\Tomcat_5.5\webapps
\transformer\db\transformer
03-21 17:25:03 jdbc[2]:
/*SQL*/SET TRACE_LEVEL_SYSTEM_OUT 3;
03-21 17:25:03 jdbc[2]:
/*SQL*/SET TRACE_LEVEL_FILE 3;
03-21 17:25:03 session: connected #2
03-21 17:25:03 jdbc[2]:
/**/Connection conn4 = DriverManager.getConnection("jdbc:h2:file://C:/
Work/Tomcat_5.5/webapps/transformer/db/
transformer;IFEXISTS=TRUE;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3",
"TLOADER", "")
03-21 17:25:03 jdbc[2]:
/**/Statement stat2 = conn4.createStatement();
03-21 17:25:03 jdbc[2]:
/**/ResultSet rs2 = stat2.executeQuery("SELECT 1 FROM TURBINE_USER");
03-21 17:25:03 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table TURBINE_USER not found; SQL
statement:
SELECT 1 FROM TURBINE_USER [42102-66]
at org.h2.message.Message.getSQLException(Message.java:89)
at org.h2.message.Message.getSQLException(Message.java:93)
at org.h2.message.Message.getSQLException(Message.java:71)
at org.h2.command.Parser.readTableOrView(Parser.java:3985)

As you can see it does the lock thing with TURBINE_USER table ,so I
assume it knows it exists, but then promptly ignores its existance and
throws? Two things, in console the database is shown as TRANSFORMER,
is case important? 2nd thing is the last arg in the addConnection call
is empty, is that significant?

David

On Mar 21, 4:43 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:

olddave

unread,
Mar 21, 2008, 1:39:00 PM3/21/08
to H2 Database
Sorry about the twice posting with the same info, there seems to be a
delay in showing the post and I did not realise, thought I'd lost the
first one of the 2 most recent posts.

David

Thomas Mueller

unread,
Mar 23, 2008, 3:05:05 PM3/23/08
to h2-da...@googlegroups.com
Hi,

Maybe the table TURBINE_USER is in another schema? I don't know how
your application works. But you could connect to the database yourself
and find out if the table exists or not.

Regards,
Thomas

olddave

unread,
Mar 24, 2008, 8:11:25 AM3/24/08
to H2 Database

Hi,

I deliberately left in the last trace above the fact that it did the
exclusive write lock thing on that TURBINE_USER table. Thus proving
ithat table does exist. I thought that maybe it was something in
Torque that dynamically changed the URL, so traced swn to the
DriverManager.getConnection call. The finalizer call, is that because
the DriverManager is calling a database that has been closed? I have
switched to starting using the Tomcat listener and using tcp against a
database called transformer placed in my home directory, to try to
emulate as closely as possible the documentation. URL is
"jdbc:h2:tcp://localhost/~/
transformer;IFEXISTS=TRUE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3"

Finalizer.register(Object) line: 72
DriverAdapterCPDS.getPooledConnection(String, String) line: 160
DriverAdapterCPDS.getPooledConnection() line: 130
SharedPoolDataSource(InstanceKeyDataSource).testCPDS(String, String)
line: 711
SharedPoolDataSource.registerPool(String, String) line: 188
SharedPoolDataSource.getPooledConnectionAndInfo(String, String) line:
157
SharedPoolDataSource(InstanceKeyDataSource).getConnection(String,
String) line: 631
SharedPoolDataSource(InstanceKeyDataSource).getConnection() line: 615
TorqueInstance.getConnection(String) line: 705


Thx.

David

Mar 21, 5:35 pm
On Mar 23, 7:05 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:
> Hi,
>
> Maybe the table TURBINE_USER is in another schema? I don't know how
> your application works. But you could connect to the database yourself
> and find out if the table exists or not.
>
> Regards,
> Thomas
>

Thomas Mueller

unread,
Mar 25, 2008, 4:08:32 PM3/25/08
to h2-da...@googlegroups.com
Hi,

> I deliberately left in the last trace above the fact that it did the
> exclusive write lock thing on that TURBINE_USER table.

> Thus proving that table does exist.

Yes, but maybe this table is in another schema. H2 supports multiple
schemas, and tables in another schema may not be visible.

> The finalizer call, is that because
> the DriverManager is calling a database that has been closed?

You probably mean "Finalizer.register(Object) line: 72". I don't think
this is related to the Java garbage collection. Probably 'Finalizer'
is a class of DBCP.

What about if you delete all databases (all .db files), and then start
from scratch, and then always use ;TRACE_LEVEL_FILE=3 in the database
URL. Then please reproduce the 'table not found' problem, and post or
send me the .trace.db file that is in the same directory as the
database file. This file contains all JDBC API calls to this database.
Please compress the .trace.db file before sending.

Regards,
Thomas

olddave

unread,
Mar 25, 2008, 5:55:32 PM3/25/08
to H2 Database
Hi,

Just to clarify again where we are, as above. since I have spent 8
hours on this and tried a lots of different URLs it is worth
specifying the current one using the home directory.
1st connection to be made is using this URL -jdbc:h2:~/
transformer;IFEXISTS=TRUE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3
The 2nd is Quartz using this URL - jdbc:h2:tcp://localhost:9092/file://
~/transformer;IFEXISTS=TRUE

Here are the relevant excerpts from the trace.db log from the start of
Torques use of the database.

03-25 13:39:29 database: opening C:\Documents and Settings\David
Wynter.STPENABL-CE9725\transformer (build 66)
03-25 13:39:29 fileLock: save {method=file,
id=118e62a39e222d900b47cbc85df25d8d1181d8fcadf}
03-25 13:39:29 fileLock: load {method=file,
id=118e62a39e222d900b47cbc85df25d8d1181d8fcadf}
03-25 13:39:30 index: open existing SYS rows: 384
03-25 13:39:36 index: open existing STP_DATABASE rows: 0
...
03-25 13:39:44 lock: 1 exclusive write lock unlock TURBINE_USER
03-25 13:39:44 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-25 13:39:44 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-25 13:39:44 lock: 1 exclusive write lock added for
TURBINE_ROLE_PERMISSION
03-25 13:39:44 lock: 1 exclusive write lock unlock
TURBINE_ROLE_PERMISSION
03-25 13:39:44 lock: 1 exclusive write lock added for
TURBINE_ROLE_PERMISSION
03-25 13:39:44 lock: 1 exclusive write lock unlock
TURBINE_ROLE_PERMISSION
03-25 13:39:44 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-25 13:39:44 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-25 13:39:44 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-25 13:39:44 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-25 13:39:44 lock: 1 exclusive write lock added for
TURBINE_USER_GROUP_ROLE
03-25 13:39:44 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-25 13:39:44 database: opened C:\Documents and Settings\David
Wynter.STPENABL-CE9725\transformer
03-25 13:39:44 session: connecting #2 to C:\Documents and Settings
\David Wynter.STPENABL-CE9725\transformer
03-25 13:39:44 jdbc[2]:
/*SQL*/SET TRACE_LEVEL_SYSTEM_OUT 3;
03-25 13:39:44 jdbc[2]:
/*SQL*/SET TRACE_LEVEL_FILE 3;
03-25 13:39:44 session: connected #2
03-25 13:39:44 jdbc[2]:
/**/Connection conn0 = DriverManager.getConnection("jdbc:h2:~/
transformer;IFEXISTS=TRUE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3",
"TLOADER", "")
03-25 13:39:44 jdbc[2]:
/**/conn0.close();
03-25 13:39:44 jdbc[2]:
/*SQL*/ROLLBACK;
03-25 13:39:44 session: disconnecting #2
03-25 13:39:44 database: closing C:\Documents and Settings\David
Wynter.STPENABL-CE9725\transformer
03-25 13:39:44 index: Index TRANSFORMER.PRIMARY_KEY_4F head
consistent=true
...
03-25 13:39:49 lock: 1 exclusive write lock unlock SYS
03-25 13:39:51 fileLock: load {method=file,
id=118e62a39e222d900b47cbc85df25d8d1181d8fcadf}
03-25 13:39:51 database: closed
03-25 13:39:51 session: disconnected #2
03-25 13:39:51 database: opening C:\Documents and Settings\David
Wynter.STPENABL-CE9725\transformer (build 66)
03-25 13:39:51 fileLock: save {method=file,
id=118e62a8dde62bcdc8e59a2a5c73901444faf0f8907}
03-25 13:39:51 fileLock: load {method=file,
id=118e62a8dde62bcdc8e59a2a5c73901444faf0f8907}
03-25 13:39:51 index: open existing SYS rows: 384
03-25 13:39:51 fileLock: watchdog end
03-25 13:39:53 index: open existing STP_DATABASE rows: 0
...
03-25 13:40:01 lock: 1 exclusive write lock added for TURBINE_USER
03-25 13:40:01 lock: 1 exclusive write lock unlock TURBINE_USER
03-25 13:40:01 lock: 1 exclusive write lock added for TURBINE_USER
03-25 13:40:01 lock: 1 exclusive write lock unlock TURBINE_USER
...
03-25 13:40:01 lock: 1 exclusive write lock unlock
TURBINE_USER_GROUP_ROLE
03-25 13:40:01 database: opened C:\Documents and Settings\David
Wynter.STPENABL-CE9725\transformer
03-25 13:40:01 session: connecting #2 to C:\Documents and Settings
\David Wynter.STPENABL-CE9725\transformer
03-25 13:40:01 jdbc[2]:
/*SQL*/SET TRACE_LEVEL_SYSTEM_OUT 3;
03-25 13:40:01 jdbc[2]:
/*SQL*/SET TRACE_LEVEL_FILE 3;
03-25 13:40:01 session: connected #2
03-25 13:40:01 jdbc[2]:
/**/Connection conn1 = DriverManager.getConnection("jdbc:h2:~/
transformer;IFEXISTS=TRUE;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3",
"TLOADER", "")
03-25 13:40:01 jdbc[2]:
/**/Statement stat0 = conn1.createStatement();
03-25 13:40:01 jdbc[2]:
/**/ResultSet rs0 = stat0.executeQuery("SELECT * FROM TURBINE_USER");
03-25 13:40:01 jdbc[2]: SQLException
org.h2.jdbc.JdbcSQLException: Table TURBINE_USER not found; SQL
statement:
SELECT * FROM TURBINE_USER [42102-66]
at org.h2.message.Message.getSQLException(Message.java:89)

At the same time I logged in my log file the first attempt at
connecting to H2 using Torque and the time does coincide to the above
trace, so I know this is the trace from the time my webapp using
Torque starts..

From this you can clearly see that the TURBINE_USER table does exist.
In fact had been accessed milliseconds before H2 reports that this
table is not known. It may be a different schema I supoose, but only
test is there in addition and the only URLs I see in the trace are
transformer related.

It may just simply be that H2 does not work with Torque (V3.1.1)?

Thx.

David

On Mar 25, 8:08 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:

Thomas Mueller

unread,
Mar 27, 2008, 2:17:12 PM3/27/08
to h2-da...@googlegroups.com
Hi,

> Here are the relevant excerpts from the trace.db log from the start of
> Torques use of the database.

> 03-25 13:39:44 lock: 1 exclusive write lock unlock TURBINE_USER

Well this doesn't say in what schema this table is. Also, maybe the
table was dropped or renamed afterwards. Or maybe the schema was
changed (SET SCHEMA). I don't know Turbine, and without the trace
files I don't know what the problem is.

Using Google, I did found other people having similar problems with
other databases (not many however).

> It may just simply be that H2 does not work with Torque (V3.1.1)?

I never used Torque, sorry.

Thomas Mueller

unread,
Mar 27, 2008, 4:39:30 PM3/27/08
to h2-da...@googlegroups.com
Hi,

Just a short update: it looks like the problem is that the tables are
in another schema (TRANSFORMER).
I think there is a workaround: using a different database URL:

jdbc:h2:~/transformer;IFEXISTS=TRUE;SCHEMA=TRANSFORMER
or, if this doesn't work, could you try:
jdbc:h2:~/transformer;IFEXISTS=TRUE;SCHEMA_SEARCH_PATH=PUBLIC,TRANSFORMER

Regards,
Thomas

olddave

unread,
Apr 8, 2008, 5:44:27 PM4/8/08
to H2 Database
Hi,

I have been working with the first connection made form the webpp in
process. Using this URL
jdbc:h2:file://C:/Work/Tomcat_5.5/webapps/transformer/db/
transformer;DB_CLOSE_ON_EXIT=FALSE;IFEXISTS=TRUE;SCHEMA=TRANSFORMER;TRACE_LEVEL_FILE=1

The trouble I have is that when I try to use the 2nd service that uses
a JDBC connection using this URL, from within the same process
jdbc:h2:tcp://localhost:9092/file://C:/Work/Tomcat_5.5/webapps/
transformer/db/
transformer;DB_CLOSE_ON_EXIT=FALSE;IFEXISTS=TRUE;SCHEMA=TRANSFORMER;TRACE_LEVEL_FILE=1

I get the std.
Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken
[90067-66]

I cannot use -baseDir as an alternative as far as I can see as both of
these are programatically made inside the code.
I have tried to copy your examples of the required URLs closely.

Any other suggestions?

Thx

David

On Mar 27, 9:39 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:

Thomas Mueller

unread,
Apr 9, 2008, 3:17:24 PM4/9/08
to h2-da...@googlegroups.com
> The trouble I have is that when I try to use the 2nd service that uses
> a JDBC connection using this URL, from within the same process
> jdbc:h2:tcp://localhost:9092/file://C:/Work/Tomcat_5.5/webapps/
> transformer/db/
> transformer;DB_CLOSE_ON_EXIT=FALSE;IFEXISTS=TRUE;SCHEMA=TRANSFORMER;TRACE_LEVEL_FILE=1
>
> I get the std.
>
> Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken
> [90067-66]

You need to actually start the server before you can use the
client-server mode. See also the docs.

> I cannot use -baseDir as an alternative as far as I can see as both of
> these are programatically made inside the code.
> I have tried to copy your examples of the required URLs closely.

Sorry I don't understand.

Regards,
Thomas

olddave

unread,
Apr 10, 2008, 6:42:14 AM4/10/08
to H2 Database
Hi,

I do start the server using
dbc:h2:file://C:/Work/Tomcat_5.5/webapps/transformer/db/
transformer;DB_CLOSE_ON_EXIT=FALSE;IFEXISTS=TRUE;SCHEMA=TRANSFORMER;TRACE_LEVEL_FILE=1

through the Torque layer, which uses DBCP

Then after that I try to connect to that started instance of the
database using the Quartz service JDBC

jdbc:h2:tcp://localhost:9092/file://C:/Work/Tomcat_5.5/webapps/
transformer/db/
transformer;DB_CLOSE_ON_EXIT=FALSE;IFEXISTS=TRUE;SCHEMA=TRANSFORMER;TRACE_LEVEL_FILE=1

Do I also need to start the server after I connect embedded using the
first URL above, separately outside my application using

java org.h2.tools.Server -tcp -tcpPort 9092 -baseDir C:/Work/
Tomcat_5.5/webapps/transformer/db/transformer

?

I thought the first connection using the URL starts the server, and
the second connection using the tcp URL would connect to that same
Server in the same Process ( the webapp).

Thx.

David



On Apr 9, 8:17 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:

Thomas Mueller

unread,
Apr 14, 2008, 1:46:58 PM4/14/08
to h2-da...@googlegroups.com
Hi,

> I thought the first connection using the URL starts the server

No, at the moment opening a connection never starts the server. Did
you read somewhere that opening a connection starts the server? If yes
where? If not, did you just imply opening a connection starts a
server?

I was thinking about starting a server automatically when opening a
connection using a special url (probably jdbc:h2:auto:c:/data/test or
so), but there are some disadvantages (like: connections are closed
when the process that first the connection stops).

Regards,
Thomas

olddave

unread,
Apr 16, 2008, 2:21:36 PM4/16/08
to H2 Database
Hi.

I think I get it now. If you open a database in embedded mode, then
that is it, no other thread can attach to that database. I solved the
problem by moving the tables in the second connection into a separate
database and connect to that as an embedded database too. Fortunately
I need no joins between the 2 databases.

Thx.

David

On Apr 14, 6:46 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:

Thomas Mueller

unread,
Apr 18, 2008, 12:21:49 PM4/18/08
to h2-da...@googlegroups.com
Hi,

> I think I get it now. If you open a database in embedded mode, then
> that is it, no other thread can attach to that database.

A database may be opened by one process at the same time. But another
thread in the same process can open it as well.
See http://www.h2database.com/html/features.html#multiple_connections

Regards,
Thomas

olddave

unread,
Apr 19, 2008, 12:06:50 PM4/19/08
to H2 Database
Hi,

Yes I have read that section on multiple connection. But it does not
clarify whether that database acting as server can be a database
started as an embedded database. Also the example URLs given in the
documentation does not specify the specific one that allows a TCP
client attach from the same process to a database started as an
embedded database. I tried the URL given above and it does not work to
attach to the database started as embedded.

I refer to
jdbc:h2:file://C:/Work/Tomcat/webapps/tranpan/db/tranpan
jdbc:h2:tcp://localhost:9092/file://C:/Work/Tomcat/webapps/tranpan/db/
tranpan

Which in my case with the changed locations are

jdbc:h2:file://C:/Work/Tomcat_5.5/webapps/transformer/db/
transformer;DB_CLOSE_ON_EXIT=FALSE;IFEXISTS=TRUE;SCHEMA=TRANSFORMER;TRACE_LEVEL_FILE=1
jdbc:h2:tcp://localhost:9092/file://C:/Work/Tomcat_5.5/webapps/
transformer/db/
transformer;DB_CLOSE_ON_EXIT=FALSE;IFEXISTS=TRUE;SCHEMA=TRANSFORMER;TRACE_LEVEL_FILE=1

With these I get the "Caused by: org.h2.jdbc.JdbcSQLException:
Connection is broken [90067-66] "

Do I need an additional step to start a TCP Server between submitting
the two URLs above? My peference is to start it from the URL, as with
lots of these services they are jar files that take database URL
Driver, username and password only.

I also noted something else. Because I embedd H2 is a webapp and often
these are deployed on standard install Tomcat which have a path of C:
\Programs Files\Apache Software Foundation\Tomcat 5.5. With all these
spaces in the pathname the URL does not work. I also tried C:/
Program~1/Apache~1/Tomcat~1/ in the file pathname and it did not work
either. Should it work with spaces?

Thx.

David

On Apr 18, 5:21 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:

Thomas Mueller

unread,
Apr 23, 2008, 3:31:31 PM4/23/08
to h2-da...@googlegroups.com
Hi,

> Yes I have read that section on multiple connection. But it does not
> clarify whether that database acting as server can be a database
> started as an embedded database. Also the example URLs given in the
> documentation does not specify the specific one that allows a TCP
> client attach from the same process to a database started as an
> embedded database. I tried the URL given above and it does not work to
> attach to the database started as embedded.

I have updated the documentation at
http://www.h2database.com/html/features.html#connection_modes
I hope it is clearer now.

> Do I need an additional step to start a TCP Server

The TCP server must be started, otherwise the TCP connections don't work.

> I also noted something else. Because I embedd H2 is a webapp and often
> these are deployed on standard install Tomcat which have a path of C:
> \Programs Files\Apache Software Foundation\Tomcat 5.5. With all these
> spaces in the pathname the URL does not work.

Spaces in directories work if you didn't make a mistake.

Regards,
Thomas

Reply all
Reply to author
Forward
0 new messages