? jboss-4.0/thirdparty
Index: jboss-4.0/server/src/etc/conf/default/standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.84.2.6
diff -r1.84.2.6 standardjbosscmp-jdbc.xml
2759,2760c2759,2760
< BLOB
< BLOB
---
> LONGVARBINARY
> BYTE
Index: jboss-4.0/server/src/main/org/jboss/ejb/txtimer/GeneralPurposeDatabasePersistencePlugin.java
===================================================================
RCS file: /cvsroot/jboss/jboss/src/main/org/jboss/ejb/txtimer/GeneralPurposeDatabasePersistencePlugin.java,v
retrieving revision 1.1.2.3
diff -r1.1.2.3 GeneralPurposeDatabasePersistencePlugin.java
12a13
> import org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCFunctionMappingMetaData;
103,111c104,119
< String createTableDDL = "create table " + getTableName() + " (" +
< " " + getColumnTimerID() + " varchar(80) not null," +
< " " + getColumnTargetID() + " varchar(80) not null," +
< " " + getColumnInitialDate() + " " + dateType + " not null," +
< " " + getColumnTimerInterval() + " " + longType + "," +
< " " + getColumnInstancePK() + " " + objectType + "," +
< " " + getColumnInfo() + " " + objectType + "," +
< " constraint " + getTableName() + "_PK primary key (" + getColumnTimerID() + "," + getColumnTargetID() + ")" +
< ")";
---
> StringBuffer createTableDDL = new StringBuffer( "create table " + getTableName() + " (" +
> " " + getColumnTimerID() + " varchar(80) not null," +
> " " + getColumnTargetID() + " varchar(80) not null," +
> " " + getColumnInitialDate() + " " + dateType + " not null," +
> " " + getColumnTimerInterval() + " " + longType + "," +
> " " + getColumnInstancePK() + " " + objectType + "," +
> " " + getColumnInfo() + " " + " " + objectType + "," );
>
> JDBCFunctionMappingMetaData pkConstraint = typeMapping.getPkConstraintTemplate();
> String pkName = "pk_" + getTableName();
> String[] args = new String[]{
> pkName,
> getColumnTimerID() + "," + getColumnTargetID()
> };
> pkConstraint.getFunctionSql(args, createTableDDL );
> createTableDDL.append( ')' );
113c121
< log.debug("Executing DDL: " + createTableDDL);
---
> log.debug("Executing DDL: " + createTableDDL.toString());
116c124
< st.executeUpdate(createTableDDL);
---
> st.executeUpdate(createTableDDL.toString());