Examples of SqlTypeInfo

org.datanucleus.store.rdbms.schema.SQLTypeInfo
Representation of SQL type information in the datastore.
org.jboss.dna.common.jdbc.model.api.SqlTypeInfo
Provides RDBMS supported standatd SQL types info. @author Sergiy Litsenko

Examples of org.datanucleus.store.rdbms.schema.SQLTypeInfo

    public void initialiseTypes(StoreSchemaHandler handler, ManagedConnection mconn)
    {
        super.initialiseTypes(handler, mconn);


        // Add on any missing JDBC types
        SQLTypeInfo sqlType = new org.datanucleus.store.rdbms.schema.MSSQLTypeInfo(
            "UNIQUEIDENTIFIER", (short)Types.CHAR, 36, "'", "'", "", 1, false, (short)2,
            false, false, false, "UNIQUEIDENTIFIER", (short)0, (short)0, 10);
        sqlType.setAllowsPrecisionSpec(false);
        addSQLTypeForJDBCType(handler, mconn, (short)MSSQLTypeInfo.UNIQUEIDENTIFIER, sqlType, true);


        sqlType = new org.datanucleus.store.rdbms.schema.MSSQLTypeInfo(
            "IMAGE", (short)Types.BLOB, 2147483647, null, null, null, 1, false, (short)1,
            false, false, false, "BLOB", (short)0, (short)0, 0);

View Full Code Here

Examples of org.datanucleus.store.rdbms.schema.SQLTypeInfo

        return info;
    }


    public SQLTypeInfo newSQLTypeInfo(ResultSet rs)
    {
        SQLTypeInfo ti = new org.datanucleus.store.rdbms.schema.MSSQLTypeInfo(rs);


        // Discard TINYINT type because it doesn't support negative values.
        String typeName = ti.getTypeName();
        if (typeName.toLowerCase().startsWith("tinyint"))
        {
            return null;
        }

View Full Code Here

Examples of org.datanucleus.store.rdbms.schema.SQLTypeInfo

    {
        super.initialiseTypes(handler, mconn);


        // Add on any missing JDBC types
        // CLOB - not present before v2.0
        SQLTypeInfo sqlType = new org.datanucleus.store.rdbms.schema.HSQLTypeInfo(
            "LONGVARCHAR", (short)Types.CLOB, 2147483647, "'", "'", null, 1, true, (short)3,
            false, false, false, "LONGVARCHAR", (short)0, (short)0, 0);
        addSQLTypeForJDBCType(handler, mconn, (short)Types.CLOB, sqlType, true);


        // BLOB - not present before v2.0
        sqlType = new org.datanucleus.store.rdbms.schema.HSQLTypeInfo(
            "LONGVARBINARY", (short)Types.BLOB, 2147483647, "'", "'", null, 1, false, (short)3,
            false, false, false, "LONGVARBINARY", (short)0, (short)0, 0);
        addSQLTypeForJDBCType(handler, mconn, (short)Types.BLOB, sqlType, true);


        // LONGVARCHAR - not present in 2.0+
        sqlType = new org.datanucleus.store.rdbms.schema.HSQLTypeInfo(
            "LONGVARCHAR", (short)Types.LONGVARCHAR, 2147483647, "'", "'", null, 1, true, (short)3,
            false, false, false, "LONGVARCHAR", (short)0, (short)0, 0);
        addSQLTypeForJDBCType(handler, mconn, (short)Types.LONGVARCHAR, sqlType, true);


        // Update any types that need extra info relative to the JDBC info
        Collection<SQLTypeInfo> sqlTypes = getSQLTypeInfoForJdbcType(handler, mconn, (short)Types.BLOB);
        if (sqlTypes != null)
        {
            Iterator<SQLTypeInfo> iter = sqlTypes.iterator();
            while (iter.hasNext())
            {
                sqlType = iter.next();
                sqlType.setAllowsPrecisionSpec(false); // Can't add precision on a BLOB
            }
        }
        sqlTypes = getSQLTypeInfoForJdbcType(handler, mconn, (short)Types.CLOB);
        if (sqlType != null)
        {
            Iterator<SQLTypeInfo> iter = sqlTypes.iterator();
            while (iter.hasNext())
            {
                sqlType = iter.next();
                sqlType.setAllowsPrecisionSpec(false); // Can't add precision on a CLOB
            }
        }
        sqlTypes = getSQLTypeInfoForJdbcType(handler, mconn, (short)Types.LONGVARBINARY);
        if (sqlTypes != null)
        {
            Iterator<SQLTypeInfo> iter = sqlTypes.iterator();
            while (iter.hasNext())
            {
                sqlType = iter.next();
                sqlType.setAllowsPrecisionSpec(false); // Can't add precision on a LONGVARBINARY
            }
        }
        sqlTypes = getSQLTypeInfoForJdbcType(handler, mconn, (short)Types.LONGVARCHAR);
        if (sqlTypes != null)
        {
            Iterator<SQLTypeInfo> iter = sqlTypes.iterator();
            while (iter.hasNext())
            {
                sqlType = iter.next();
                sqlType.setAllowsPrecisionSpec(false); // Can't add precision on a LONGVARCHAR
            }
        }
    }

View Full Code Here

Examples of org.datanucleus.store.rdbms.schema.SQLTypeInfo

    return "DROP TABLE " + table.toString();
  }


    public SQLTypeInfo newSQLTypeInfo(ResultSet rs)
    {
        SQLTypeInfo info = new SQLTypeInfo(rs);


        // Discard the tinyint type because it doesn't support negative values.
        if (info.getTypeName().toLowerCase().startsWith("tinyint"))
        {
            return null;
        }
        // Discard the longsysname type because it doesn't allow specification of length
        if (info.getTypeName().toLowerCase().startsWith("longsysname"))
        {
            return null;
        }
        return info;
    }

View Full Code Here

Examples of org.datanucleus.store.rdbms.schema.SQLTypeInfo

    public void initialiseTypes(StoreSchemaHandler handler, ManagedConnection mconn)
    {
        super.initialiseTypes(handler, mconn);


        // Add on any missing JDBC types
        SQLTypeInfo sqlType = new org.datanucleus.store.rdbms.schema.DB2TypeInfo(
            "FLOAT", (short)Types.FLOAT, 53, null, null, null, 1, false, (short)2,
            false, false, false, null, (short)0, (short)0, 0);
        addSQLTypeForJDBCType(handler, mconn, (short)Types.FLOAT, sqlType, true);


        sqlType = new org.datanucleus.store.rdbms.schema.DB2TypeInfo(

View Full Code Here

Examples of org.datanucleus.store.rdbms.schema.SQLTypeInfo


        JDBCTypeInfo jdbcType = (JDBCTypeInfo)typesInfo.getChild("9");
        if (jdbcType != null && jdbcType.getNumberOfChildren() > 0)
        {
            // somehow BIGINT is set to 9 in the JDBC driver so add it at its correct value
            SQLTypeInfo dfltTypeInfo = (SQLTypeInfo)jdbcType.getChild("DEFAULT");
            SQLTypeInfo sqlType = new SQLTypeInfo(dfltTypeInfo.getTypeName(),
                (short)Types.BIGINT, dfltTypeInfo.getPrecision(), dfltTypeInfo.getLiteralPrefix(),
                dfltTypeInfo.getLiteralSuffix(), dfltTypeInfo.getCreateParams(), dfltTypeInfo.getNullable(),
                dfltTypeInfo.isCaseSensitive(), dfltTypeInfo.getSearchable(), dfltTypeInfo.isUnsignedAttribute(),
                dfltTypeInfo.isFixedPrecScale(), dfltTypeInfo.isAutoIncrement(), dfltTypeInfo.getLocalTypeName(),
                dfltTypeInfo.getMinimumScale(), dfltTypeInfo.getMaximumScale(), dfltTypeInfo.getNumPrecRadix());
            addSQLTypeForJDBCType(handler, mconn, (short)Types.BIGINT, sqlType, true);
        }


        jdbcType = (JDBCTypeInfo)typesInfo.getChild("16");
        if (jdbcType != null)
        {
            // somehow BOOLEAN is set to 16 in the JDBC driver so add it at its correct location
            SQLTypeInfo dfltTypeInfo = (SQLTypeInfo)jdbcType.getChild("DEFAULT");
            SQLTypeInfo sqlType = new SQLTypeInfo(dfltTypeInfo.getTypeName(),
                (short)Types.BOOLEAN, dfltTypeInfo.getPrecision(), dfltTypeInfo.getLiteralPrefix(),
                dfltTypeInfo.getLiteralSuffix(), dfltTypeInfo.getCreateParams(), dfltTypeInfo.getNullable(),
                dfltTypeInfo.isCaseSensitive(), dfltTypeInfo.getSearchable(), dfltTypeInfo.isUnsignedAttribute(),
                dfltTypeInfo.isFixedPrecScale(), dfltTypeInfo.isAutoIncrement(), dfltTypeInfo.getLocalTypeName(),
                dfltTypeInfo.getMinimumScale(), dfltTypeInfo.getMaximumScale(), dfltTypeInfo.getNumPrecRadix());

View Full Code Here

Examples of org.jboss.dna.common.jdbc.model.api.SqlTypeInfo

    }


    public void testAddSqlTypeInfo() {
        String NAME = "My Name";
        // create
        SqlTypeInfo object = new DefaultModelFactory().createSqlTypeInfo();
        // set
        object.setName(NAME);
        // add
        bean.addSqlTypeInfo(object);
        // check
        assertFalse(bean.getSqlTypeInfos().isEmpty());
    }

View Full Code Here

Examples of org.jboss.dna.common.jdbc.model.api.SqlTypeInfo

    }


    public void testDeleteSqlTypeInfo() {
        String NAME = "My Name";
        // create
        SqlTypeInfo object = new DefaultModelFactory().createSqlTypeInfo();
        // set
        object.setName(NAME);
        // add
        bean.addSqlTypeInfo(object);
        // check
        assertFalse(bean.getSqlTypeInfos().isEmpty());
        // delete

View Full Code Here

Examples of org.jboss.dna.common.jdbc.model.api.SqlTypeInfo

    }


    public void testFindSqlTypeInfoByTypeName() {
        String NAME = "My Name";
        // create
        SqlTypeInfo object = new DefaultModelFactory().createSqlTypeInfo();
        // set
        object.setName(NAME);
        // add
        bean.addSqlTypeInfo(object);
        // check
        assertSame(object, bean.findSqlTypeInfoByTypeName(object.getName()));
    }

View Full Code Here

Examples of org.jboss.dna.common.jdbc.model.api.SqlTypeInfo

        Integer maxScale = getInteger(resultSet, "MAXIMUM_SCALE", false);
        // radix
        Integer radix = getInteger(resultSet, "NUM_PREC_RADIX", false);


        // create SQL type info object
        SqlTypeInfo typeInfo = factory.createSqlTypeInfo();


        // ***************************
        // *** DatabaseNamedObject ***
        // ***************************


        // set name
        typeInfo.setName(typeName);
        // set remarks
        // typeInfo.setRemarks (remarks); // N/A
        // TODO set extra properties
        // typeInfo.addExtraProperty (String key, Object value);


        // *******************
        // *** SqlTypeInfo ***
        // *******************


        // Localized type name
        typeInfo.setLocalizedTypeName(localTypeName);
        // SQL type nullability
        typeInfo.setNullabilityType(getNullabilityType(nullableType));
        // SQL type from java.sql.Types
        typeInfo.setSqlType(getSqlType(dataType));
        // precision
        typeInfo.setPrecision(precision);
        // fixed precision scale
        typeInfo.setFixedPrecisionScale(fixedPrecisionScale);
        // number precision radix
        typeInfo.setNumberPrecisionRadix(radix);
        // minimum scale supported
        typeInfo.setMinScale(minScale);
        // maximum scale supported
        typeInfo.setMaxScale(maxScale);
        // literal prefix
        typeInfo.setLiteralPrefix(literalPrefix);
        // literal suffix
        typeInfo.setLiteralSuffix(literalSuffix);
        // parameters used in creating the type (may be null)
        typeInfo.setCreateParams(createParams);
        // Case Sensitive
        typeInfo.setCaseSensitive(caseSensitive);
        // searchability type
        typeInfo.setSearchabilityType(getSearchabilityType(searchableType));
        // Unsigned
        typeInfo.setUnsigned(unsignedAttribute);
        // Auto Increment
        typeInfo.setAutoIncrement(autoIncrement);


        // add SQL type info to the list
        database.addSqlTypeInfo(typeInfo);


        // log

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.