? 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
<             <jdbc-type>BLOB</jdbc-type>
<             <sql-type>BLOB</sql-type>
---
>             <jdbc-type>LONGVARBINARY</jdbc-type>
>             <sql-type>BYTE</sql-type>
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());