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 Re: What's going on here? Jboss and derby
Date Wed, 10 Oct 2007 19:45:48 GMT
Nevermind, I figured it out. It turns out that hibernate will create the 
tables from its .hbm.xml mapping files if it can't find them. It 
couldn't find them because the schema name it was using was different 
from the one I used to create them in the first place.

Thanks,
Kevin

Kevin Corby wrote:

> 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