public ResultSet getClientInfoProperties() throws SQLException { Field f[] = new Field[4]; f[0] = new Field("NAME", Oid.VARCHAR); f[1] = new Field("MAX_LEN", Oid.INT4); f[2] = new Field("DEFAULT_VALUE", Oid.VARCHAR); f[3] = new Field("DESCRIPTION", Oid.VARCHAR); Vector v = new Vector(); if (connection.haveMinimumServerVersion("9.0")) { byte[][] tuple = new byte[4][]; tuple[0] = connection.encodeString("ApplicationName"); tuple[1] = connection.encodeString(Integer.toString(getMaxNameLength())); tuple[2] = connection.encodeString(""); tuple[3] = connection.encodeString("The name of the application currently utilizing the connection."); v.addElement(tuple); } return (ResultSet) ((BaseStatement)createMetaDataStatement()).createDriverResultSet(f, v); }
public java.sql.ResultSet getTableTypes() throws SQLException { String types[] = new String[tableTypeClauses.size()]; Enumeration e = tableTypeClauses.keys(); int i = 0; while (e.hasMoreElements()) { types[i++] = (String)e.nextElement(); } sortStringArray(types); Field f[] = new Field[1]; Vector v = new Vector(); f[0] = new Field("TABLE_TYPE", Oid.VARCHAR); for (i = 0; i < types.length; i++) { byte[][] tuple = new byte[1][]; tuple[0] = connection.encodeString(types[i]); v.addElement(tuple); } return (ResultSet) ((BaseStatement)createMetaDataStatement()).createDriverResultSet(f, v); }
public java.sql.ResultSet getCatalogs() throws SQLException { Field f[] = new Field[1]; Vector v = new Vector(); f[0] = new Field("TABLE_CAT", Oid.VARCHAR); byte[][] tuple = new byte[1][]; tuple[0] = connection.encodeString(connection.getCatalog()); v.addElement(tuple); return (ResultSet) ((BaseStatement)createMetaDataStatement()).createDriverResultSet(f, v); }
tuple[1] = connection.encodeString("ctid"); tuple[2] = connection.encodeString(Integer.toString(connection.getTypeInfo().getSQLType("tid"))); tuple[3] = connection.encodeString("tid"); tuple[4] = null; tuple[5] = null; tuple[6] = null; tuple[7] = connection.encodeString(Integer.toString(java.sql.DatabaseMetaData.versionColumnPseudo)); v.addElement(tuple);
for (i = 0; i < permNames.length; i++) byte[] privilege = connection.encodeString(permNames[i]); Vector grantees = (Vector)permissions.get(permNames[i]); for (int j = 0; j < grantees.size(); j++) tuple[1] = schema; tuple[2] = table; tuple[3] = connection.encodeString(owner); tuple[4] = connection.encodeString(grantee); tuple[5] = privilege; tuple[6] = connection.encodeString(grantable); v.addElement(tuple);
for (i = 0; i < permNames.length; i++) byte[] privilege = connection.encodeString(permNames[i]); Vector grantees = (Vector)permissions.get(permNames[i]); for (int j = 0; j < grantees.size(); j++) tuple[2] = tableName; tuple[3] = column; tuple[4] = connection.encodeString(owner); tuple[5] = connection.encodeString(grantee); tuple[6] = privilege; tuple[7] = connection.encodeString(grantable); v.addElement(tuple);
byte bZero[] = connection.encodeString("0"); byte b10[] = connection.encodeString("10"); byte bf[] = connection.encodeString("f"); byte bt[] = connection.encodeString("t"); byte bliteral[] = connection.encodeString("'"); byte bNullable[] = connection.encodeString(Integer.toString(java.sql.DatabaseMetaData.typeNullable)); byte bSearchable[] = connection.encodeString(Integer.toString(java.sql.DatabaseMetaData.typeSearchable)); int typeOid = (int)rs.getLong(2); tuple[0] = connection.encodeString(typname); tuple[1] = connection.encodeString(Integer.toString(connection.getTypeInfo().getSQLType(typname))); tuple[2] = connection.encodeString(Integer.toString(connection.getTypeInfo().getMaximumPrecision(typeOid))); tuple[13] = bZero; // min scale is zero tuple[14] = (typeOid == Oid.NUMERIC) ? connection.encodeString("1000") : bZero; tuple1[0] = connection.encodeString("serial"); tuple1[11] = bt; v.addElement(tuple1); tuple1[0] = connection.encodeString("bigserial"); tuple1[11] = bt; v.addElement(tuple1);
byte specificName[] = connection.encodeString(rs.getString("proname") + "_" + rs.getString("oid")); int returnType = (int)rs.getLong("prorettype"); String returnTypeType = rs.getString("typtype"); tuple[1] = schema; tuple[2] = procedureName; tuple[3] = connection.encodeString("returnValue"); tuple[4] = connection.encodeString(Integer.toString(java.sql.DatabaseMetaData.procedureColumnReturn)); tuple[5] = connection.encodeString(Integer.toString(connection.getTypeInfo().getSQLType(returnType))); tuple[6] = connection.encodeString(connection.getTypeInfo().getPGType(returnType)); tuple[7] = null; tuple[8] = null; tuple[9] = null; tuple[10] = null; tuple[11] = connection.encodeString(Integer.toString(java.sql.DatabaseMetaData.procedureNullableUnknown)); tuple[12] = null; if (jdbcVersion >= 4) { tuple[17] = connection.encodeString(Integer.toString(0)); tuple[18] = isnullableUnknown; tuple[19] = specificName; tuple[3] = connection.encodeString(argNames[i]); else tuple[3] = connection.encodeString("$" + (i + 1)); tuple[4] = connection.encodeString(Integer.toString(columnMode)); tuple[5] = connection.encodeString(Integer.toString(connection.getTypeInfo().getSQLType(argOid))); tuple[6] = connection.encodeString(connection.getTypeInfo().getPGType(argOid));
columnSize = connection.getTypeInfo().getDisplaySize(typeOid, typeMod); tuple[0] = connection.encodeString(Integer.toString(scope)); tuple[1] = rs.getBytes("attname"); tuple[2] = connection.encodeString(Integer.toString(connection.getTypeInfo().getSQLType(typeOid))); tuple[3] = connection.encodeString(connection.getTypeInfo().getPGType(typeOid)); tuple[4] = connection.encodeString(Integer.toString(columnSize)); tuple[5] = null; // unused tuple[6] = connection.encodeString(Integer.toString(decimalDigits)); tuple[7] = connection.encodeString(Integer.toString(java.sql.DatabaseMetaData.bestRowNotPseudo)); v.addElement(tuple);
action = java.sql.DatabaseMetaData.importedKeyRestrict; tuple[9] = connection.encodeString(Integer.toString(action)); else if ("restrict".equals(rule)) action = java.sql.DatabaseMetaData.importedKeyRestrict; tuple[10] = connection.encodeString(Integer.toString(action)); tuple[3] = connection.encodeString(pkeyColumn); //PKCOLUMN_NAME tuple[7] = connection.encodeString(fkeyColumn); //FKCOLUMN_NAME tuple[11] = connection.encodeString(fkName); //FK_NAME this will give us a unique name for the foreign key tuple[12] = rs.getBytes(7); //PK_NAME deferrability = java.sql.DatabaseMetaData.importedKeyInitiallyImmediate; tuple[13] = connection.encodeString(Integer.toString(deferrability));
tuple[4] = connection.encodeString(Integer.toString(sqlType)); String pgType = connection.getTypeInfo().getPGType(typeOid); tuple[5] = connection.encodeString(pgType); // Type name tuple[7] = null; // Buffer length tuple[5] = connection.encodeString("serial"); // Type name == serial tuple[5] = connection.encodeString("bigserial"); // Type name == bigserial tuple[6] = connection.encodeString(Integer.toString(columnSize)); tuple[8] = connection.encodeString(Integer.toString(decimalDigits)); tuple[9] = connection.encodeString("10"); tuple[9] = connection.encodeString("2"); tuple[10] = connection.encodeString(Integer.toString(rs.getBoolean("attnotnull") ? java.sql.DatabaseMetaData.columnNoNulls : java.sql.DatabaseMetaData.columnNullable)); // Nullable tuple[11] = rs.getBytes("description"); // Description (if any) tuple[12] = rs.getBytes("adsrc"); // Column default tuple[15] = tuple[6]; // char octet length tuple[16] = rs.getBytes("attnum"); // ordinal position tuple[17] = connection.encodeString(rs.getBoolean("attnotnull") ? "NO" : "YES"); // Is nullable tuple[19] = null; // SCOPE_SCHEMA tuple[20] = null; // SCOPE_TABLE tuple[21] = baseTypeOid == 0 ? null : connection.encodeString(Integer.toString(connection.getTypeInfo().getSQLType(baseTypeOid))); // SOURCE_DATA_TYPE tuple[22] = connection.encodeString(autoinc);
public ResultSet getClientInfoProperties() throws SQLException { Field f[] = new Field[4]; f[0] = new Field("NAME", Oid.VARCHAR); f[1] = new Field("MAX_LEN", Oid.INT4); f[2] = new Field("DEFAULT_VALUE", Oid.VARCHAR); f[3] = new Field("DESCRIPTION", Oid.VARCHAR); Vector v = new Vector(); if (connection.haveMinimumServerVersion("9.0")) { byte[][] tuple = new byte[4][]; tuple[0] = connection.encodeString("ApplicationName"); tuple[1] = connection.encodeString(Integer.toString(getMaxNameLength())); tuple[2] = connection.encodeString(""); tuple[3] = connection.encodeString("The name of the application currently utilizing the connection."); v.addElement(tuple); } return (ResultSet) ((BaseStatement)createMetaDataStatement()).createDriverResultSet(f, v); }
public java.sql.ResultSet getTableTypes() throws SQLException { String types[] = new String[tableTypeClauses.size()]; Enumeration e = tableTypeClauses.keys(); int i = 0; while (e.hasMoreElements()) { types[i++] = (String)e.nextElement(); } sortStringArray(types); Field f[] = new Field[1]; Vector v = new Vector(); f[0] = new Field("TABLE_TYPE", Oid.VARCHAR); for (i = 0; i < types.length; i++) { byte[][] tuple = new byte[1][]; tuple[0] = connection.encodeString(types[i]); v.addElement(tuple); } return (ResultSet) ((BaseStatement)createMetaDataStatement()).createDriverResultSet(f, v); }
public java.sql.ResultSet getCatalogs() throws SQLException { Field f[] = new Field[1]; Vector v = new Vector(); f[0] = new Field("TABLE_CAT", Oid.VARCHAR); byte[][] tuple = new byte[1][]; tuple[0] = connection.encodeString(connection.getCatalog()); v.addElement(tuple); return (ResultSet) ((BaseStatement)createMetaDataStatement()).createDriverResultSet(f, v); }
public java.sql.ResultSet getTableTypes() throws SQLException { String types[] = new String[tableTypeClauses.size()]; Enumeration e = tableTypeClauses.keys(); int i = 0; while (e.hasMoreElements()) { types[i++] = (String)e.nextElement(); } sortStringArray(types); Field f[] = new Field[1]; Vector v = new Vector(); f[0] = new Field("TABLE_TYPE", Oid.VARCHAR); for (i = 0; i < types.length; i++) { byte[][] tuple = new byte[1][]; tuple[0] = connection.encodeString(types[i]); v.addElement(tuple); } return (ResultSet) ((BaseStatement)createMetaDataStatement()).createDriverResultSet(f, v); }
public java.sql.ResultSet getCatalogs() throws SQLException { Field f[] = new Field[1]; Vector v = new Vector(); f[0] = new Field("TABLE_CAT", Oid.VARCHAR); byte[][] tuple = new byte[1][]; tuple[0] = connection.encodeString(connection.getCatalog()); v.addElement(tuple); return (ResultSet) ((BaseStatement)createMetaDataStatement()).createDriverResultSet(f, v); }
for (i = 0; i < permNames.length; i++) byte[] privilege = connection.encodeString(permNames[i]); Vector grantees = (Vector)permissions.get(permNames[i]); for (int j = 0; j < grantees.size(); j++) tuple[1] = schema; tuple[2] = table; tuple[3] = connection.encodeString(owner); tuple[4] = connection.encodeString(grantee); tuple[5] = privilege; tuple[6] = connection.encodeString(grantable); v.addElement(tuple);
tuple[1] = connection.encodeString("ctid"); tuple[2] = connection.encodeString(Integer.toString(connection.getTypeInfo().getSQLType("tid"))); tuple[3] = connection.encodeString("tid"); tuple[4] = null; tuple[5] = null; tuple[6] = null; tuple[7] = connection.encodeString(Integer.toString(java.sql.DatabaseMetaData.versionColumnPseudo)); v.addElement(tuple);
tuple[1] = connection.encodeString("ctid"); tuple[2] = connection.encodeString(Integer.toString(connection.getTypeInfo().getSQLType("tid"))); tuple[3] = connection.encodeString("tid"); tuple[4] = null; tuple[5] = null; tuple[6] = null; tuple[7] = connection.encodeString(Integer.toString(java.sql.DatabaseMetaData.versionColumnPseudo)); v.addElement(tuple);
columnSize = connection.getTypeInfo().getDisplaySize(typeOid, typeMod); tuple[0] = connection.encodeString(Integer.toString(scope)); tuple[1] = rs.getBytes("attname"); tuple[2] = connection.encodeString(Integer.toString(connection.getTypeInfo().getSQLType(typeOid))); tuple[3] = connection.encodeString(connection.getTypeInfo().getPGType(typeOid)); tuple[4] = connection.encodeString(Integer.toString(columnSize)); tuple[5] = null; // unused tuple[6] = connection.encodeString(Integer.toString(decimalDigits)); tuple[7] = connection.encodeString(Integer.toString(java.sql.DatabaseMetaData.bestRowNotPseudo)); v.addElement(tuple);