Re: Error when using the jdbcType NVARCHAR with H2


mwhesse@...
 

Thanks for your support, below works for us.

SQLTypeInfo sqlType = new H2TypeInfo(
        "NVARCHAR", // String typeName
        (short)Types.NVARCHAR, // short dataType
        2147483647, // int precision
        "'", // String literalPrefix
        "'", // String literalSuffix
        "LENGTH", // String createParams
        1, // int nullable
        true, // boolean caseSensitive
        (short)3, // short searchable 
        false, // boolean unsignedAttribute
        false, // boolean fixedPrecScale
        false, // boolean autoIncrement
        "NVARCHAR", // String localTypeName
        (short)0, // short minimumScale
        (short)0, // short maximumScale
        0 // int numPrecRadix
);
addSQLTypeForJDBCType(handler, mconn, (short)Types.NVARCHAR, sqlType, true);    

Join {main@datanucleus.groups.io to automatically receive all group messages.