Package org.postgresql.core

Examples of org.postgresql.core.TypeInfo

27
28
29
30
31
32
33
34
35
36
    Properties _clientInfo;

    public AbstractJdbc4Connection(String host, int port, String user, String database, Properties info, String url) throws SQLException {
        super(host, port, user, database, info, url);

        TypeInfo types = getTypeInfo();
        if (haveMinimumServerVersion("8.3")) {
            types.addCoreType("xml", Oid.XML, java.sql.Types.SQLXML, "java.sql.SQLXML", Oid.XML_ARRAY);
        }
    }
View Full Code Here
19
20
21
22
23
24
25
26
27
28
{

    public AbstractJdbc3gConnection(String host, int port, String user, String database, Properties info, String url) throws SQLException {
        super(host, port, user, database, info, url);

        TypeInfo types = getTypeInfo();
        if (haveMinimumServerVersion("8.3")) {
            types.addCoreType("uuid", Oid.UUID, java.sql.Types.OTHER, "java.util.UUID", Oid.UUID_ARRAY);
        }
    }
View Full Code Here
27
28
29
30
31
32
33
34
35
36
    Properties _clientInfo;

    public AbstractJdbc4Connection(String host, int port, String user, String database, Properties info, String url) throws SQLException {
        super(host, port, user, database, info, url);

        TypeInfo types = getTypeInfo();
        if (haveMinimumServerVersion("8.3")) {
            types.addCoreType("xml", Oid.XML, java.sql.Types.SQLXML, "java.sql.SQLXML", Oid.XML_ARRAY);
        }
    }
View Full Code Here
18
19
20
21
22
23
24
25
26
27
{

    public AbstractJdbc3gConnection(HostSpec[] hostSpecs, String user, String database, Properties info, String url) throws SQLException {
        super(hostSpecs, user, database, info, url);

        TypeInfo types = getTypeInfo();
        if (haveMinimumServerVersion("8.3")) {
            types.addCoreType("uuid", Oid.UUID, java.sql.Types.OTHER, "java.util.UUID", Oid.UUID_ARRAY);
        }
    }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
42
    private final Properties _clientInfo;

    public AbstractJdbc4Connection(HostSpec[] hostSpecs, String user, String database, Properties info, String url) throws SQLException {
        super(hostSpecs, user, database, info, url);

        TypeInfo types = getTypeInfo();
        if (haveMinimumServerVersion("8.3")) {
            types.addCoreType("xml", Oid.XML, java.sql.Types.SQLXML, "java.sql.SQLXML", Oid.XML_ARRAY);
        }

        _clientInfo = new Properties();
        if (haveMinimumServerVersion("9.0")) {
            String appName = info.getProperty("ApplicationName");
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
60
            TestUtil.createSchema( con, "third_schema" );
            TestUtil.createTable( con, "third_schema.x", "third_schema_field_n float");
            TestUtil.createSchema( con, "last_schema" );
            TestUtil.createTable( con, "last_schema.x", "last_schema_field_n text");
            stmt.execute("SET search_path TO third_schema;");
            TypeInfo typeInfo = con.getTypeInfo();
            int OID = typeInfo.getPGType("x");
            ResultSet rs = stmt.executeQuery("SELECT 'third_schema.x'::regtype::oid");
            assertTrue(rs.next());
            assertEquals(OID, rs.getInt(1));
            assertTrue(!rs.next());
            TestUtil.dropSchema( con, "first_schema" );
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
            TestUtil.createSchema( con, "third_schema" );
            TestUtil.createTable( con, "third_schema.x", "third_schema_field_n float");
            TestUtil.createSchema( con, "last_schema" );
            TestUtil.createTable( con, "last_schema.y", "last_schema_field_n text");
            stmt.execute("SET search_path TO first_schema, second_schema, last_schema, public;");
            TypeInfo typeInfo = con.getTypeInfo();
            int OID = typeInfo.getPGType("y");
            ResultSet rs = stmt.executeQuery("SELECT 'second_schema.y'::regtype::oid");
            assertTrue(rs.next());
            assertEquals(OID, rs.getInt(1));
            assertTrue(!rs.next());
            TestUtil.dropSchema( con, "first_schema" );
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
        try {
            TestUtil.createSchema( con, "first_schema" );
            TestUtil.createTable( con, "first_schema.x", "first_schema_field int4");
            TestUtil.createSchema( con, "second_schema" );
            TestUtil.createTable( con, "second_schema.x", "second_schema_field text");
            TypeInfo typeInfo = con.getTypeInfo();
            int OID = typeInfo.getPGType("x");
            ResultSet rs = stmt.executeQuery("SELECT oid FROM pg_type WHERE typname = 'x' ORDER BY oid DESC LIMIT 1");
            assertTrue(rs.next());
            assertEquals(OID, rs.getInt(1));
            assertTrue(!rs.next());
            TestUtil.dropSchema( con, "first_schema" );
View Full Code Here
31
32
33
34
35
36
37
38
39
40
    Properties _clientInfo;

    public AbstractJdbc4Connection(String host, int port, String user, String database, Properties info, String url) throws SQLException {
        super(host, port, user, database, info, url);

        TypeInfo types = getTypeInfo();
        if (haveMinimumServerVersion("8.3")) {
            types.addCoreType("xml", Oid.XML, java.sql.Types.SQLXML, "java.sql.SQLXML", Oid.XML_ARRAY);
        }
    }
View Full Code Here
31
32
33
34
35
36
37
38
39
40
    Properties _clientInfo;

    public AbstractJdbc4Connection(String host, int port, String user, String database, Properties info, String url) throws SQLException {
        super(host, port, user, database, info, url);

        TypeInfo types = getTypeInfo();
        if (haveMinimumServerVersion("8.3")) {
            types.addCoreType("xml", Oid.XML, java.sql.Types.SQLXML, "java.sql.SQLXML", Oid.XML_ARRAY);
        }
    }
View Full Code Here
TOP

Related Classes of org.postgresql.core.TypeInfo

  • org.postgresql.jdbc3g.AbstractJdbc3gConnection
  • org.postgresql.jdbc4.AbstractJdbc4Connection
  • org.postgresql.test.jdbc2.SearchPathLookupTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.