db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Corby <kco...@pf-cvl.net>
Subject What's going on here? Jboss and derby
Date Wed, 10 Oct 2007 19:04:27 GMT
I am deploying a war file to Jboss that contains a derby database. The 
derby database already has some tables created and data inserted when it 
gets deployed. One of the columns is a CLOB which is set to have a 1GB 
max. Here is the table definition:

CREATE TABLE Script (
    id INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    name VARCHAR(64),
    messageType VARCHAR(32),
    messageSubtype VARCHAR(32),
    entityType VARCHAR(32),
    scriptType VARCHAR(32),
    inputType VARCHAR(32),
    contents CLOB(1 G),
    revisionId INT,
    reviser VARCHAR(64),
    reason VARCHAR(10000),
    revisionDate TIMESTAMP
);

When I do something with my webapp that inserts into the database, I am 
getting a failure when the CLOB value exceeds 255 bytes. Also all my 
preinserted data is missing from the table. If I check the derby.log, I 
see what is pasted below. It appears that the table is being recreated 
automatically right after deployment with a CLOB size of 255. Because 
the db is being recreated the original data is also getting cleared out.

How and why is this happening? I don't have anything running that is 
doing these creates and I don't know where they're coming from.

Here is the derby log output:


----------------------------------------------------------------
2007-10-10 18:22:34.882 GMT:
 Booting Derby version The Apache Software Foundation - Apache Derby - 
10.2.2.0 - (485682): instance c013800d-0115-8b27-6106-00001467eb98
on database directory 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts
 


Database Class Loader started - derby.database.classpath=''
2007-10-10 18:22:35.201 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
213), (SESSIONID = 0), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:35.206 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
213), (SESSIONID = 0), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Rolling back
2007-10-10 18:22:35.210 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
214), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:36.139 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
215), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Begin compiling prepared statement: SELECT CAST ('' AS 
VARCHAR(128)) AS TABLE_CAT, SCHEMANAME AS TABLE_SCHEM,  TABLENAME AS 
TABLE_NAME, (CAST (RTRIM(TABLE_TYPE) AS VARCHAR(12))) AS TABLE_TYPE, 
CAST ('' AS VARCHAR(128)) AS REMARKS, CAST (NULL AS VARCHAR(128)) AS 
TYPE_CAT, CAST (NULL AS VARCHAR(128)) AS TYPE_SCHEM, CAST (NULL AS 
VARCHAR(128)) AS TYPE_NAME, CAST (NULL AS VARCHAR(128)) AS 
SELF_REFERENCING_COL_NAME, CAST (NULL AS VARCHAR(128)) AS REF_GENERATION 
FROM SYS.SYSTABLES, SYS.SYSSCHEMAS, (VALUES ('T','TABLE'), ('S','SYSTEM 
TABLE'), ('V', 'VIEW'), ('A', 'SYNONYM')) T(TTABBREV,TABLE_TYPE) WHERE 
(TTABBREV=TABLETYPE     AND (SYS.SYSTABLES.SCHEMAID = 
SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT NULL) AND 
(SYS.SYSSCHEMAS.SCHEMANAME LIKE ?) AND (TABLENAME LIKE ?)) AND TABLETYPE 
IN ('T') ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME :End prepared 
statement
2007-10-10 18:22:36.872 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
215), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), End compiling prepared statement: SELECT CAST ('' AS 
VARCHAR(128)) AS TABLE_CAT, SCHEMANAME AS TABLE_SCHEM,  TABLENAME AS 
TABLE_NAME, (CAST (RTRIM(TABLE_TYPE) AS VARCHAR(12))) AS TABLE_TYPE, 
CAST ('' AS VARCHAR(128)) AS REMARKS, CAST (NULL AS VARCHAR(128)) AS 
TYPE_CAT, CAST (NULL AS VARCHAR(128)) AS TYPE_SCHEM, CAST (NULL AS 
VARCHAR(128)) AS TYPE_NAME, CAST (NULL AS VARCHAR(128)) AS 
SELF_REFERENCING_COL_NAME, CAST (NULL AS VARCHAR(128)) AS REF_GENERATION 
FROM SYS.SYSTABLES, SYS.SYSSCHEMAS, (VALUES ('T','TABLE'), ('S','SYSTEM 
TABLE'), ('V', 'VIEW'), ('A', 'SYNONYM')) T(TTABBREV,TABLE_TYPE) WHERE 
(TTABBREV=TABLETYPE     AND (SYS.SYSTABLES.SCHEMAID = 
SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT NULL) AND 
(SYS.SYSSCHEMAS.SCHEMANAME LIKE ?) AND (TABLENAME LIKE ?)) AND TABLETYPE 
IN ('T') ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME :End prepared 
statement
2007-10-10 18:22:36.979 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
215), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Executing prepared statement: SELECT CAST ('' AS 
VARCHAR(128)) AS TABLE_CAT, SCHEMANAME AS TABLE_SCHEM,  TABLENAME AS 
TABLE_NAME, (CAST (RTRIM(TABLE_TYPE) AS VARCHAR(12))) AS TABLE_TYPE, 
CAST ('' AS VARCHAR(128)) AS REMARKS, CAST (NULL AS VARCHAR(128)) AS 
TYPE_CAT, CAST (NULL AS VARCHAR(128)) AS TYPE_SCHEM, CAST (NULL AS 
VARCHAR(128)) AS TYPE_NAME, CAST (NULL AS VARCHAR(128)) AS 
SELF_REFERENCING_COL_NAME, CAST (NULL AS VARCHAR(128)) AS REF_GENERATION 
FROM SYS.SYSTABLES, SYS.SYSSCHEMAS, (VALUES ('T','TABLE'), ('S','SYSTEM 
TABLE'), ('V', 'VIEW'), ('A', 'SYNONYM')) T(TTABBREV,TABLE_TYPE) WHERE 
(TTABBREV=TABLETYPE     AND (SYS.SYSTABLES.SCHEMAID = 
SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT NULL) AND 
(SYS.SYSSCHEMAS.SCHEMANAME LIKE ?) AND (TABLENAME LIKE ?)) AND TABLETYPE 
IN ('T') ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME :End prepared 
statement with 3 parameters begin parameter #1: % :end parameter begin 
parameter #2: ME :end parameter begin parameter #3: 
PREVIOUSSCRIPTREVISION :end parameter
2007-10-10 18:22:37.061 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
215), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.062 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
215), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.062 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
217), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Executing prepared statement: SELECT CAST ('' AS 
VARCHAR(128)) AS TABLE_CAT, SCHEMANAME AS TABLE_SCHEM,  TABLENAME AS 
TABLE_NAME, (CAST (RTRIM(TABLE_TYPE) AS VARCHAR(12))) AS TABLE_TYPE, 
CAST ('' AS VARCHAR(128)) AS REMARKS, CAST (NULL AS VARCHAR(128)) AS 
TYPE_CAT, CAST (NULL AS VARCHAR(128)) AS TYPE_SCHEM, CAST (NULL AS 
VARCHAR(128)) AS TYPE_NAME, CAST (NULL AS VARCHAR(128)) AS 
SELF_REFERENCING_COL_NAME, CAST (NULL AS VARCHAR(128)) AS REF_GENERATION 
FROM SYS.SYSTABLES, SYS.SYSSCHEMAS, (VALUES ('T','TABLE'), ('S','SYSTEM 
TABLE'), ('V', 'VIEW'), ('A', 'SYNONYM')) T(TTABBREV,TABLE_TYPE) WHERE 
(TTABBREV=TABLETYPE     AND (SYS.SYSTABLES.SCHEMAID = 
SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT NULL) AND 
(SYS.SYSSCHEMAS.SCHEMANAME LIKE ?) AND (TABLENAME LIKE ?)) AND TABLETYPE 
IN ('T') ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME :End prepared 
statement with 3 parameters begin parameter #1: % :end parameter begin 
parameter #2: ME :end parameter begin parameter #3: SCRIPT :end parameter
2007-10-10 18:22:37.065 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
217), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.065 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
217), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.065 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
218), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Executing prepared statement: SELECT CAST ('' AS 
VARCHAR(128)) AS TABLE_CAT, SCHEMANAME AS TABLE_SCHEM,  TABLENAME AS 
TABLE_NAME, (CAST (RTRIM(TABLE_TYPE) AS VARCHAR(12))) AS TABLE_TYPE, 
CAST ('' AS VARCHAR(128)) AS REMARKS, CAST (NULL AS VARCHAR(128)) AS 
TYPE_CAT, CAST (NULL AS VARCHAR(128)) AS TYPE_SCHEM, CAST (NULL AS 
VARCHAR(128)) AS TYPE_NAME, CAST (NULL AS VARCHAR(128)) AS 
SELF_REFERENCING_COL_NAME, CAST (NULL AS VARCHAR(128)) AS REF_GENERATION 
FROM SYS.SYSTABLES, SYS.SYSSCHEMAS, (VALUES ('T','TABLE'), ('S','SYSTEM 
TABLE'), ('V', 'VIEW'), ('A', 'SYNONYM')) T(TTABBREV,TABLE_TYPE) WHERE 
(TTABBREV=TABLETYPE     AND (SYS.SYSTABLES.SCHEMAID = 
SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT NULL) AND 
(SYS.SYSSCHEMAS.SCHEMANAME LIKE ?) AND (TABLENAME LIKE ?)) AND TABLETYPE 
IN ('T') ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME :End prepared 
statement with 3 parameters begin parameter #1: % :end parameter begin 
parameter #2: ME :end parameter begin parameter #3: 
PREVIOUSSCRIPTREVISION :end parameter
2007-10-10 18:22:37.068 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
218), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.068 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
218), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.068 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
219), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Executing prepared statement: SELECT CAST ('' AS 
VARCHAR(128)) AS TABLE_CAT, SCHEMANAME AS TABLE_SCHEM,  TABLENAME AS 
TABLE_NAME, (CAST (RTRIM(TABLE_TYPE) AS VARCHAR(12))) AS TABLE_TYPE, 
CAST ('' AS VARCHAR(128)) AS REMARKS, CAST (NULL AS VARCHAR(128)) AS 
TYPE_CAT, CAST (NULL AS VARCHAR(128)) AS TYPE_SCHEM, CAST (NULL AS 
VARCHAR(128)) AS TYPE_NAME, CAST (NULL AS VARCHAR(128)) AS 
SELF_REFERENCING_COL_NAME, CAST (NULL AS VARCHAR(128)) AS REF_GENERATION 
FROM SYS.SYSTABLES, SYS.SYSSCHEMAS, (VALUES ('T','TABLE'), ('S','SYSTEM 
TABLE'), ('V', 'VIEW'), ('A', 'SYNONYM')) T(TTABBREV,TABLE_TYPE) WHERE 
(TTABBREV=TABLETYPE     AND (SYS.SYSTABLES.SCHEMAID = 
SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT NULL) AND 
(SYS.SYSSCHEMAS.SCHEMANAME LIKE ?) AND (TABLENAME LIKE ?)) AND TABLETYPE 
IN ('T') ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME :End prepared 
statement with 3 parameters begin parameter #1: % :end parameter begin 
parameter #2: ME :end parameter begin parameter #3: SCRIPT :end parameter
2007-10-10 18:22:37.070 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
219), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.070 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
219), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.071 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
220), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Executing prepared statement: SELECT CAST ('' AS 
VARCHAR(128)) AS TABLE_CAT, SCHEMANAME AS TABLE_SCHEM,  TABLENAME AS 
TABLE_NAME, (CAST (RTRIM(TABLE_TYPE) AS VARCHAR(12))) AS TABLE_TYPE, 
CAST ('' AS VARCHAR(128)) AS REMARKS, CAST (NULL AS VARCHAR(128)) AS 
TYPE_CAT, CAST (NULL AS VARCHAR(128)) AS TYPE_SCHEM, CAST (NULL AS 
VARCHAR(128)) AS TYPE_NAME, CAST (NULL AS VARCHAR(128)) AS 
SELF_REFERENCING_COL_NAME, CAST (NULL AS VARCHAR(128)) AS REF_GENERATION 
FROM SYS.SYSTABLES, SYS.SYSSCHEMAS, (VALUES ('T','TABLE'), ('S','SYSTEM 
TABLE'), ('V', 'VIEW'), ('A', 'SYNONYM')) T(TTABBREV,TABLE_TYPE) WHERE 
(TTABBREV=TABLETYPE     AND (SYS.SYSTABLES.SCHEMAID = 
SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT NULL) AND 
(SYS.SYSSCHEMAS.SCHEMANAME LIKE ?) AND (TABLENAME LIKE ?)) AND TABLETYPE 
IN ('T') ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME :End prepared 
statement with 3 parameters begin parameter #1: % :end parameter begin 
parameter #2: % :end parameter begin parameter #3: HIBERNATE_UNIQUE_KEY 
:end parameter
2007-10-10 18:22:37.073 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
220), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.073 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
220), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.074 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
221), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Begin compiling prepared statement: create table 
ME.PREVIOUSSCRIPTREVISION (ID integer not null, SCRIPTID integer not 
null, NAME varchar(64), MESSAGETYPE varchar(32), MESSAGESUBTYPE 
varchar(32), ENTITYTYPE varchar(32), SCRIPTTYPE varchar(32), INPUTTYPE 
varchar(32), CONTENTS clob(255), REVISIONID integer, REVISER 
varchar(64), REASON varchar(10000), REVISIONDATE timestamp, primary key 
(ID)) :End prepared statement
2007-10-10 18:22:37.095 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
221), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), End compiling prepared statement: create table 
ME.PREVIOUSSCRIPTREVISION (ID integer not null, SCRIPTID integer not 
null, NAME varchar(64), MESSAGETYPE varchar(32), MESSAGESUBTYPE 
varchar(32), ENTITYTYPE varchar(32), SCRIPTTYPE varchar(32), INPUTTYPE 
varchar(32), CONTENTS clob(255), REVISIONID integer, REVISER 
varchar(64), REASON varchar(10000), REVISIONDATE timestamp, primary key 
(ID)) :End prepared statement
2007-10-10 18:22:37.112 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
221), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Executing prepared statement: create table 
ME.PREVIOUSSCRIPTREVISION (ID integer not null, SCRIPTID integer not 
null, NAME varchar(64), MESSAGETYPE varchar(32), MESSAGESUBTYPE 
varchar(32), ENTITYTYPE varchar(32), SCRIPTTYPE varchar(32), INPUTTYPE 
varchar(32), CONTENTS clob(255), REVISIONID integer, REVISER 
varchar(64), REASON varchar(10000), REVISIONDATE timestamp, primary key 
(ID)) :End prepared statement
2007-10-10 18:22:37.222 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
221), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.223 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
227), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Begin compiling prepared statement: create table 
ME.SCRIPT (ID integer not null, NAME varchar(64), MESSAGETYPE 
varchar(32), MESSAGESUBTYPE varchar(32), ENTITYTYPE varchar(32), 
SCRIPTTYPE varchar(32), INPUTTYPE varchar(32), CONTENTS clob(255), 
REVISIONID integer, REVISER varchar(64), REASON varchar(10000), 
REVISIONDATE timestamp, primary key (ID)) :End prepared statement
2007-10-10 18:22:37.226 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
227), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), End compiling prepared statement: create table 
ME.SCRIPT (ID integer not null, NAME varchar(64), MESSAGETYPE 
varchar(32), MESSAGESUBTYPE varchar(32), ENTITYTYPE varchar(32), 
SCRIPTTYPE varchar(32), INPUTTYPE varchar(32), CONTENTS clob(255), 
REVISIONID integer, REVISER varchar(64), REASON varchar(10000), 
REVISIONDATE timestamp, primary key (ID)) :End prepared statement
2007-10-10 18:22:37.227 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
227), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Executing prepared statement: create table ME.SCRIPT 
(ID integer not null, NAME varchar(64), MESSAGETYPE varchar(32), 
MESSAGESUBTYPE varchar(32), ENTITYTYPE varchar(32), SCRIPTTYPE 
varchar(32), INPUTTYPE varchar(32), CONTENTS clob(255), REVISIONID 
integer, REVISER varchar(64), REASON varchar(10000), REVISIONDATE 
timestamp, primary key (ID)) :End prepared statement
2007-10-10 18:22:37.265 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
227), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.266 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
234), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Begin compiling prepared statement: create table 
hibernate_unique_key ( next_hi integer ) :End prepared statement
2007-10-10 18:22:37.267 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
234), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), End compiling prepared statement: create table 
hibernate_unique_key ( next_hi integer ) :End prepared statement
2007-10-10 18:22:37.268 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
234), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Executing prepared statement: create table 
hibernate_unique_key ( next_hi integer ) :End prepared statement
2007-10-10 18:22:37.278 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
234), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing
2007-10-10 18:22:37.279 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
237), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Begin compiling prepared statement: insert into 
hibernate_unique_key values ( 0 ) :End prepared statement
2007-10-10 18:22:37.318 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
237), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), End compiling prepared statement: insert into 
hibernate_unique_key values ( 0 ) :End prepared statement
2007-10-10 18:22:37.323 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
237), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Executing prepared statement: insert into 
hibernate_unique_key values ( 0 ) :End prepared statement
2007-10-10 18:22:37.334 GMT Thread[http-0.0.0.0-18573-2,5,jboss] (XID = 
237), (SESSIONID = 1), (DATABASE = 
/opt/webdevel/pfweb/jboss/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp3338mapToEntitiesService-exp.war/WEB-INF/classes/scripts),

(DRDAID = null), Committing


Mime
View raw message