Examples of org.postgresql.util.PGobject

org.postgresql.util.PGobject
PGobject is a class used to describe unknown types An unknown type is any type that is unknown by JDBC Standards

                // Handle the type (requires SQLInput & SQLOutput classes to be implemented)
                throw new PSQLException(GT.tr("Custom type maps are not supported."), PSQLState.NOT_IMPLEMENTED);
            }
        }


        PGobject obj = null;


        if (logger.logDebug())
            logger.debug("Constructing object from type=" + type + " value=<" + value + ">");


        try
        {
            Class klass = _typeCache.getPGobject(type);


            // If className is not null, then try to instantiate it,
            // It must be basetype PGobject


            // This is used to implement the org.postgresql unique types (like lseg,
            // point, etc).


            if (klass != null)
            {
                obj = (PGobject) (klass.newInstance());
                obj.setType(type);
                obj.setValue(value);
            }
            else
            {
                // If className is null, then the type is unknown.
                // so return a PGobject with the type set, and the value set
                obj = new PGobject();
                obj.setType( type );
                obj.setValue( value );
            }


            return obj;
        }
        catch (SQLException sx)

View Full Code Here

    @Override
    public Object nullSafeGet(ResultSet resultSet, String[] names, SessionImplementor sessionImplementor, Object o) throws HibernateException, SQLException {
        if (resultSet.getObject(names[0]) == null) {
            return null;
        }
        PGobject pGobject = (PGobject) resultSet.getObject(names[0]);
        Object jsonObject = null;
        try {
            jsonObject = objectMapper.readValue(pGobject.getValue(), this.returnedClass());
        } catch (IOException e) {
            e.printStackTrace();
        }
        return jsonObject;
    }

View Full Code Here

        try {
            jsonString = objectMapper.writeValueAsString(value);
        } catch (IOException e) {
            e.printStackTrace();
        }
        PGobject pGobject = new PGobject();
        pGobject.setType("json");
        pGobject.setValue(jsonString);
        preparedStatement.setObject(index, pGobject);
    }

View Full Code Here

    @Override
    public Object nullSafeGet(ResultSet resultSet, String[] names, SessionImplementor sessionImplementor, Object o) throws HibernateException, SQLException {
        if (resultSet.getObject(names[0]) == null) {
            return null;
        }
        PGobject pGobject = (PGobject) resultSet.getObject(names[0]);
        Object jsonObject = null;
        try {
            jsonObject = objectMapper.readValue(pGobject.getValue(), this.returnedClass());
        } catch (IOException e) {
            e.printStackTrace();
        }
        return jsonObject;
    }

View Full Code Here

        try {
            jsonString = objectMapper.writeValueAsString(value);
        } catch (IOException e) {
            e.printStackTrace();
        }
        PGobject pGobject = new PGobject();
        pGobject.setType("json");
        pGobject.setValue(jsonString);
        preparedStatement.setObject(index, pGobject);
    }

View Full Code Here

                // Handle the type (requires SQLInput & SQLOutput classes to be implemented)
                throw new PSQLException(GT.tr("Custom type maps are not supported."), PSQLState.NOT_IMPLEMENTED);
            }
        }


        PGobject obj = null;


        if (logger.logDebug())
            logger.debug("Constructing object from type=" + type + " value=<" + value + ">");


        try
        {
            Class klass = _typeCache.getPGobject(type);


            // If className is not null, then try to instantiate it,
            // It must be basetype PGobject


            // This is used to implement the org.postgresql unique types (like lseg,
            // point, etc).


            if (klass != null)
            {
                obj = (PGobject) (klass.newInstance());
                obj.setType(type);
                obj.setValue(value);
            }
            else
            {
                // If className is null, then the type is unknown.
                // so return a PGobject with the type set, and the value set
                obj = new PGobject();
                obj.setType( type );
                obj.setValue( value );
            }


            return obj;
        }
        catch (SQLException sx)

View Full Code Here

                // Handle the type (requires SQLInput & SQLOutput classes to be implemented)
                throw new PSQLException(GT.tr("Custom type maps are not supported."), PSQLState.NOT_IMPLEMENTED);
            }
        }


        PGobject obj = null;


        if (logger.logDebug())
            logger.debug("Constructing object from type=" + type + " value=<" + value + ">");


        try
        {
            Class klass = _typeCache.getPGobject(type);


            // If className is not null, then try to instantiate it,
            // It must be basetype PGobject


            // This is used to implement the org.postgresql unique types (like lseg,
            // point, etc).


            if (klass != null)
            {
                obj = (PGobject) (klass.newInstance());
                obj.setType(type);
                obj.setValue(value);
            }
            else
            {
                // If className is null, then the type is unknown.
                // so return a PGobject with the type set, and the value set
                obj = new PGobject();
                obj.setType( type );
                obj.setValue( value );
            }


            return obj;
        }
        catch (SQLException sx)

View Full Code Here

    @Override
    public PGobject convertToDatabaseColumn(UrlStatus attribute)
    {
        try
        {
            PGobject pGobject = new PGobject();


            pGobject.setType("url_status");
            pGobject.setValue(attribute.name());


            return pGobject;
        }
        catch (SQLException ex)
        {

View Full Code Here


        return null;
    }


    public static boolean save(Connection connection, String json) throws SQLException {
        PGobject jsonbObject = new PGobject();
        jsonbObject.setType("jsonb");
        jsonbObject.setValue(json);


        try (PreparedStatement insertStatement = connection.prepareStatement("INSERT INTO reports (created_at, json) VALUES(?, ?)")) {
            insertStatement.setTimestamp(1, new Timestamp(Calendar.getInstance().getTimeInMillis()));
            insertStatement.setObject(2, jsonbObject);
            return insertStatement.executeUpdate() == 1;

View Full Code Here


        Object result = value;
        if (clazz.isEnum()) {


            // HACK: should be implemented in PgTypeHelper
            final PGobject pgobj = new PGobject();
            pgobj.setType(typeName);
            try {
                pgobj.setValue(((Enum<?>) value).name());
            } catch (final SQLException ex) {
                if (sensitive) {
                    LOG.error("Failed to set PG object value (sensitive parameter, stacktrace hidden)");
                } else {
                    LOG.error("Failed to set PG object value", ex);

View Full Code Here

0 1

TOP

Related Classes of org.postgresql.util.PGobject

arjdbc.postgresql.PostgreSQLRubyJdbcConnection

com.bazarnazar.pgjson.PGJsonObject

cosc561.searchengine.entities.converter.UrlStatusEnumConverter

de.zalando.sprocwrapper.proxy.OtherStoredProcedureParameter

de.zalando.typemapper.core.TypeMapper

examples.TestAutoregister

examples.TestBoxes

fi.evident.dalesbred.dialects.PostgreSQLDialect

models.Report

org.postgresql.jdbc2.AbstractJdbc2Connection

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.