private PGType createInternalType( Object x, int targetType ) throws PSQLException { if ( x instanceof Byte ) return PGByte.castToServerType((Byte)x, targetType ); if ( x instanceof Short ) return PGShort.castToServerType((Short)x, targetType ); if ( x instanceof Integer ) return PGInteger.castToServerType((Integer)x, targetType ); if ( x instanceof Long ) return PGLong.castToServerType((Long)x, targetType ); if ( x instanceof Double ) return PGDouble.castToServerType((Double)x, targetType ); if ( x instanceof Float ) return PGFloat.castToServerType((Float)x, targetType ); if ( x instanceof BigDecimal) return PGBigDecimal.castToServerType((BigDecimal)x, targetType ); // since all of the above are instances of Number make sure this is after them if ( x instanceof Number ) return PGNumber.castToServerType((Number)x, targetType ); if ( x instanceof Boolean) return PGBoolean.castToServerType((Boolean)x, targetType ); return new PGUnknown(x); } // Helper method for setting parameters to PGobject subclasses.
public static PGType castToServerType(Object val, int targetType) { return new PGUnknown( val ); } public String toString()
return new PGBoolean( val.intValue() == 0?Boolean.FALSE:Boolean.TRUE ); case Types.REAL: return new PGFloat( new Float( val.floatValue() ) ); case Types.DOUBLE: case Types.FLOAT: return new PGDouble(new Double( val.doubleValue() )); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString( val.toString() ); case Types.SMALLINT: case Types.TINYINT: return new PGShort( new Short( val.shortValue() )); case Types.INTEGER: return new PGInteger( val ); case Types.DECIMAL: case Types.NUMERIC: return new PGBigDecimal( new BigDecimal( val.toString())); default: return new PGUnknown(val);
return new PGBoolean( val.byteValue() == 0?Boolean.FALSE:Boolean.TRUE ); return new PGByte( val ); case Types.REAL: return new PGFloat( new Float( val.floatValue() ) ); case Types.DOUBLE: case Types.FLOAT: return new PGDouble( new Double( val.doubleValue() ) ); case Types.NUMERIC: case Types.DECIMAL: return new PGBigDecimal( new BigDecimal(val.toString()) ); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString ( val.toString() ); default: return new PGUnknown(val);
return new PGBoolean( val.doubleValue() == 0?Boolean.FALSE:Boolean.TRUE ); case Types.BIGINT: return new PGLong( new Long( val.longValue() ) ); case Types.INTEGER: return new PGInteger( new Integer( val.intValue() ) ) ; case Types.SMALLINT: case Types.TINYINT: return new PGShort( new Short( val.shortValue() ) ); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString( val.toString() ); case Types.DECIMAL: case Types.NUMERIC: case Types.FLOAT: case Types.REAL: return new PGBigDecimal( val ); default: return new PGUnknown(val);
return new PGBoolean( val.doubleValue() == 0?Boolean.FALSE:Boolean.TRUE ); return new PGLong(new Long( val.longValue() )); case Types.INTEGER: return new PGInteger(new Integer( val.intValue() ) ); case Types.TINYINT: case Types.SMALLINT: return new PGShort(new Short( val.shortValue() )); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString( val.toString() ); case Types.DOUBLE: case Types.FLOAT: return( new PGDouble( new Double( val.doubleValue()))); case Types.REAL: return (new PGFloat( new Float( val.floatValue()))); case Types.DECIMAL: case Types.NUMERIC: return new PGNumber( val ); default: return new PGUnknown(val);
private PGType createInternalType( Object x, int targetType ) throws PSQLException { if ( x instanceof Byte ) return PGByte.castToServerType((Byte)x, targetType ); if ( x instanceof Short ) return PGShort.castToServerType((Short)x, targetType ); if ( x instanceof Integer ) return PGInteger.castToServerType((Integer)x, targetType ); if ( x instanceof Long ) return PGLong.castToServerType((Long)x, targetType ); if ( x instanceof Double ) return PGDouble.castToServerType((Double)x, targetType ); if ( x instanceof Float ) return PGFloat.castToServerType((Float)x, targetType ); if ( x instanceof BigDecimal) return PGBigDecimal.castToServerType((BigDecimal)x, targetType ); // since all of the above are instances of Number make sure this is after them if ( x instanceof Number ) return PGNumber.castToServerType((Number)x, targetType ); if ( x instanceof Boolean) return PGBoolean.castToServerType((Boolean)x, targetType ); return new PGUnknown(x); } // Helper method for setting parameters to PGobject subclasses.
return new PGBoolean( val.byteValue() == 0?Boolean.FALSE:Boolean.TRUE ); return new PGByte( val ); case Types.REAL: return new PGFloat( new Float( val.floatValue() ) ); case Types.DOUBLE: case Types.FLOAT: return new PGDouble( new Double( val.doubleValue() ) ); case Types.NUMERIC: case Types.DECIMAL: return new PGBigDecimal( new BigDecimal(val.toString()) ); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString ( val.toString() ); default: return new PGUnknown(val);
return new PGBoolean( val.doubleValue() == 0?Boolean.FALSE:Boolean.TRUE ); case Types.BIGINT: return new PGLong( new Long( val.longValue() ) ); case Types.INTEGER: return new PGInteger( new Integer( val.intValue() ) ) ; case Types.SMALLINT: case Types.TINYINT: return new PGShort( new Short( val.shortValue() ) ); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString( val.toString() ); case Types.DECIMAL: case Types.NUMERIC: case Types.FLOAT: case Types.REAL: return new PGBigDecimal( val ); default: return new PGUnknown(val);
public static PGType castToServerType(Object val, int targetType) { return new PGUnknown( val ); } public String toString()
return new PGLong(new Long( val.booleanValue()==true?1:0 )); case Types.INTEGER: return new PGInteger( new Integer( val.booleanValue()==true?1:0 ) ); case Types.SMALLINT: case Types.TINYINT: return new PGShort( new Short( val.booleanValue()==true?(short)1:(short)0 ) ); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString( val.booleanValue()==true?"true":"false" ); case Types.DOUBLE: case Types.FLOAT: return new PGDouble( new Double(val.booleanValue()==true?1:0)); case Types.REAL: return new PGFloat( new Float(val.booleanValue()==true?1:0)); case Types.NUMERIC: case Types.DECIMAL: return new PGBigDecimal( new java.math.BigDecimal(val.booleanValue()==true?1:0)); return new PGBoolean( val ); default: return new PGUnknown( val );
private PGType createInternalType( Object x, int targetType ) throws PSQLException { if ( x instanceof Byte ) return PGByte.castToServerType((Byte)x, targetType ); if ( x instanceof Short ) return PGShort.castToServerType((Short)x, targetType ); if ( x instanceof Integer ) return PGInteger.castToServerType((Integer)x, targetType ); if ( x instanceof Long ) return PGLong.castToServerType((Long)x, targetType ); if ( x instanceof Double ) return PGDouble.castToServerType((Double)x, targetType ); if ( x instanceof Float ) return PGFloat.castToServerType((Float)x, targetType ); if ( x instanceof BigDecimal) return PGBigDecimal.castToServerType((BigDecimal)x, targetType ); // since all of the above are instances of Number make sure this is after them if ( x instanceof Number ) return PGNumber.castToServerType((Number)x, targetType ); if ( x instanceof Boolean) return PGBoolean.castToServerType((Boolean)x, targetType ); return new PGUnknown(x); } // Helper method for setting parameters to PGobject subclasses.
public static PGType castToServerType(Object val, int targetType) { return new PGUnknown( val ); } public String toString()
return new PGBoolean( val.floatValue() == 0?Boolean.FALSE:Boolean.TRUE ); return new PGLong(new Long( val.longValue() )); case Types.INTEGER: return new PGInteger(new Integer( val.intValue() ) ); case Types.SMALLINT: case Types.TINYINT: return new PGShort(new Short( val.shortValue() )); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString( val.toString() ); case Types.DOUBLE: case Types.FLOAT: return( new PGDouble( new Double( val.doubleValue()))); case Types.REAL: return new PGFloat( val ); case Types.DECIMAL: case Types.NUMERIC: return new PGBigDecimal( new BigDecimal( val.toString())); default: return new PGUnknown(val);
return new PGBoolean( val.shortValue() == 0?Boolean.FALSE:Boolean.TRUE ); return new PGShort(val); case Types.REAL: return new PGFloat( new Float( val.floatValue() ) ); case Types.DOUBLE: case Types.FLOAT: return new PGDouble( new Double( val.doubleValue() ) ); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString ( val.toString() ); case Types.DECIMAL: case Types.NUMERIC: return new PGBigDecimal( new BigDecimal( val.toString())); default: return new PGUnknown(val);
return new PGBoolean( val.doubleValue() == 0?Boolean.FALSE:Boolean.TRUE ); return new PGLong( new Long( val.longValue() ) ); case Types.INTEGER: return new PGInteger( new Integer( val.intValue() ) ) ; case Types.SMALLINT: case Types.TINYINT: return new PGShort( new Short( val.shortValue() ) ); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString( val.toString() ); case Types.DOUBLE: case Types.FLOAT: return new PGDouble( val ); case Types.REAL: return new PGFloat( new Float( val.floatValue())); case Types.DECIMAL: case Types.NUMERIC: return new PGBigDecimal( new BigDecimal( val.toString())); default: return new PGUnknown(val);
return new PGBoolean( Boolean.TRUE ); if ( val.equalsIgnoreCase("false") || val.equalsIgnoreCase("0") || val.equalsIgnoreCase("f")) return new PGBoolean( Boolean.FALSE); return new PGBoolean( Boolean.FALSE); return new PGString(val); case Types.BIGINT: return new PGLong( new Long(Long.parseLong( val ))); case Types.INTEGER: return new PGInteger( new Integer(Integer.parseInt( val ))); case Types.TINYINT: return new PGShort( new Short( Short.parseShort( val ))); case Types.FLOAT: case Types.DOUBLE: return new PGDouble( new Double(Double.parseDouble( val ))); case Types.REAL: return new PGFloat( new Float( Float.parseFloat( val ))); case Types.NUMERIC: case Types.DECIMAL: return new PGBigDecimal( new BigDecimal( val)); default: return new PGUnknown( val );
return new PGBoolean(val.longValue()==0?Boolean.FALSE:Boolean.TRUE); case Types.REAL: return new PGFloat( new Float(val.floatValue()) ); case Types.FLOAT: case Types.DOUBLE: return new PGDouble( new Double(val.doubleValue()) ); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString(val.toString()); case Types.BIGINT: return new PGLong( val ); case Types.INTEGER: return new PGInteger( new Integer( val.intValue())); case Types.SMALLINT: case Types.TINYINT: return new PGShort( new Short( val.shortValue() )); case Types.DECIMAL: case Types.NUMERIC: return new PGBigDecimal( new BigDecimal( val.toString())); default: return new PGUnknown(val);
return new PGBoolean( val.doubleValue() == 0?Boolean.FALSE:Boolean.TRUE ); return new PGLong(new Long( val.longValue() )); case Types.INTEGER: return new PGInteger(new Integer( val.intValue() ) ); case Types.TINYINT: case Types.SMALLINT: return new PGShort(new Short( val.shortValue() )); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString( val.toString() ); case Types.DOUBLE: case Types.FLOAT: return( new PGDouble( new Double( val.doubleValue()))); case Types.REAL: return (new PGFloat( new Float( val.floatValue()))); case Types.DECIMAL: case Types.NUMERIC: return new PGNumber( val ); default: return new PGUnknown(val);
return new PGBoolean( val.shortValue() == 0?Boolean.FALSE:Boolean.TRUE ); return new PGShort(val); case Types.REAL: return new PGFloat( new Float( val.floatValue() ) ); case Types.DOUBLE: case Types.FLOAT: return new PGDouble( new Double( val.doubleValue() ) ); case Types.VARCHAR: case Types.LONGVARCHAR: return new PGString ( val.toString() ); case Types.DECIMAL: case Types.NUMERIC: return new PGBigDecimal( new BigDecimal( val.toString())); default: return new PGUnknown(val);