Mercurial > hg > monetdb-java

comparison src/main/java/org/monetdb/jdbc/MonetDatabaseMetaData.java @ 943:ff075ed5ce81

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Spell check.
author Sjoerd Mullender <sjoerd@acm.org>
date Thu, 09 Jan 2025 10:56:14 +0100 (3 months ago)
parents d416e9b6b3d0
children 39b74cc688d2
comparison
equal deleted inserted replaced
942:45c26b1a0677 943:ff075ed5ce81
1288 return true; 1288 return true;
1289 } 1289 }
1290 1290
1291 /** 1291 /**
1292 * Can statements remain open across commits? They may, but 1292 * Can statements remain open across commits? They may, but
1293 * this driver cannot guarentee that. In further reflection. 1293 * this driver cannot guarantee that. In further reflection.
1294 * we are taking a Statement object here, so the answer is 1294 * we are taking a Statement object here, so the answer is
1295 * yes, since the Statement is only a vehicle to execute some SQL 1295 * yes, since the Statement is only a vehicle to execute some SQL
1296 * 1296 *
1297 * @return true if they always remain open; false otherwise 1297 * @return true if they always remain open; false otherwise
1298 */ 1298 */
1301 return true; 1301 return true;
1302 } 1302 }
1303 1303
1304 /** 1304 /**
1305 * Can statements remain open across rollbacks? They may, but 1305 * Can statements remain open across rollbacks? They may, but
1306 * this driver cannot guarentee that. In further contemplation, 1306 * this driver cannot guarantee that. In further contemplation,
1307 * we are taking a Statement object here, so the answer is yes again. 1307 * we are taking a Statement object here, so the answer is yes again.
1308 * 1308 *
1309 * @return true if they always remain open; false otherwise 1309 * @return true if they always remain open; false otherwise
1310 */ 1310 */
1311 @Override 1311 @Override
1332 public int getMaxCharLiteralLength() { 1332 public int getMaxCharLiteralLength() {
1333 return 0x7ffffffe; // MonetDB supports null terminated strings of max 2GB, see function: int UTF8_strlen() 1333 return 0x7ffffffe; // MonetDB supports null terminated strings of max 2GB, see function: int UTF8_strlen()
1334 } 1334 }
1335 1335
1336 /** 1336 /**
1337 * Whats the limit on column name length. 1337 * What's the limit on column name length.
1338 * I take some safety here, but it's just a varchar in MonetDB 1338 * I take some safety here, but it's just a varchar in MonetDB
1339 * 1339 *
1340 * @return the maximum column name length 1340 * @return the maximum column name length
1341 */ 1341 */
1342 @Override 1342 @Override
1541 return 1024; // In MonetDB the max length of column sys.db_user_info.name is defined as 1024 1541 return 1024; // In MonetDB the max length of column sys.db_user_info.name is defined as 1024
1542 } 1542 }
1543 1543
1544 /** 1544 /**
1545 * What is the database's default transaction isolation level? 1545 * What is the database's default transaction isolation level?
1546 * We only see commited data, nonrepeatable reads and phantom 1546 * We only see committed data, nonrepeatable reads and phantom
1547 * reads can occur. 1547 * reads can occur.
1548 * 1548 *
1549 * @return the default isolation level 1549 * @return the default isolation level
1550 * @see Connection 1550 * @see Connection
1551 */ 1551 */
2206 * MonetDB doesn't have this level of access rights. 2206 * MonetDB doesn't have this level of access rights.
2207 * 2207 *
2208 * <P>Only privileges matching the column name criteria are 2208 * <P>Only privileges matching the column name criteria are
2209 * returned. They are ordered by COLUMN_NAME and PRIVILEGE. 2209 * returned. They are ordered by COLUMN_NAME and PRIVILEGE.
2210 * 2210 *
2211 * <P>Each privilige description has the following columns: 2211 * <P>Each privilege description has the following columns:
2212 * <OL> 2212 * <OL>
2213 * <LI><B>TABLE_CAT</B> String =&gt; table catalog (may be null) 2213 * <LI><B>TABLE_CAT</B> String =&gt; table catalog (may be null)
2214 * <LI><B>TABLE_SCHEM</B> String =&gt; table schema (may be null) 2214 * <LI><B>TABLE_SCHEM</B> String =&gt; table schema (may be null)
2215 * <LI><B>TABLE_NAME</B> String =&gt; table name 2215 * <LI><B>TABLE_NAME</B> String =&gt; table name
2216 * <LI><B>COLUMN_NAME</B> String =&gt; column name 2216 * <LI><B>COLUMN_NAME</B> String =&gt; column name
2217 * <LI><B>GRANTOR</B> =&gt; grantor of access (may be null) 2217 * <LI><B>GRANTOR</B> =&gt; grantor of access (may be null)
2218 * <LI><B>GRANTEE</B> String =&gt; grantee of access 2218 * <LI><B>GRANTEE</B> String =&gt; grantee of access
2219 * <LI><B>PRIVILEGE</B> String =&gt; name of access (SELECT, 2219 * <LI><B>PRIVILEGE</B> String =&gt; name of access (SELECT,
2220 * INSERT, UPDATE, REFRENCES, ...) 2220 * INSERT, UPDATE, REFERENCES, ...)
2221 * <LI><B>IS_GRANTABLE</B> String =&gt; "YES" if grantee is permitted 2221 * <LI><B>IS_GRANTABLE</B> String =&gt; "YES" if grantee is permitted
2222 * to grant to others; "NO" if not; null if unknown 2222 * to grant to others; "NO" if not; null if unknown
2223 * </OL> 2223 * </OL>
2224 * 2224 *
2225 * @param catalog a catalog name; "" retrieves those without a catalog 2225 * @param catalog a catalog name; "" retrieves those without a catalog
2313 * <LI><B>TABLE_SCHEM</B> String =&gt; table schema (may be null) 2313 * <LI><B>TABLE_SCHEM</B> String =&gt; table schema (may be null)
2314 * <LI><B>TABLE_NAME</B> String =&gt; table name 2314 * <LI><B>TABLE_NAME</B> String =&gt; table name
2315 * <LI><B>GRANTOR</B> =&gt; grantor of access (may be null) 2315 * <LI><B>GRANTOR</B> =&gt; grantor of access (may be null)
2316 * <LI><B>GRANTEE</B> String =&gt; grantee of access 2316 * <LI><B>GRANTEE</B> String =&gt; grantee of access
2317 * <LI><B>PRIVILEGE</B> String =&gt; name of access (SELECT, 2317 * <LI><B>PRIVILEGE</B> String =&gt; name of access (SELECT,
2318 * INSERT, UPDATE, REFRENCES, ...) 2318 * INSERT, UPDATE, REFERENCES, ...)
2319 * <LI><B>IS_GRANTABLE</B> String =&gt; "YES" if grantee is permitted 2319 * <LI><B>IS_GRANTABLE</B> String =&gt; "YES" if grantee is permitted
2320 * to grant to others; "NO" if not; null if unknown 2320 * to grant to others; "NO" if not; null if unknown
2321 * </OL> 2321 * </OL>
2322 * 2322 *
2323 * @param catalog a catalog name; "" retrieves those without a catalog 2323 * @param catalog a catalog name; "" retrieves those without a catalog
3143 * <LI><B>INDEX_NAME</B> String =&gt; index name; null when TYPE is 3143 * <LI><B>INDEX_NAME</B> String =&gt; index name; null when TYPE is
3144 * tableIndexStatistic 3144 * tableIndexStatistic
3145 * <LI><B>TYPE</B> short =&gt; index type: 3145 * <LI><B>TYPE</B> short =&gt; index type:
3146 * <UL> 3146 * <UL>
3147 * <LI> tableIndexStatistic - this identifies table statistics that are 3147 * <LI> tableIndexStatistic - this identifies table statistics that are
3148 * returned in conjuction with a table's index descriptions 3148 * returned in conjunction with a table's index descriptions
3149 * <LI> tableIndexClustered - this is a clustered index 3149 * <LI> tableIndexClustered - this is a clustered index
3150 * <LI> tableIndexHashed - this is a hashed index 3150 * <LI> tableIndexHashed - this is a hashed index
3151 * <LI> tableIndexOther - this is some other style of index 3151 * <LI> tableIndexOther - this is some other style of index
3152 * </UL> 3152 * </UL>
3153 * <LI><B>ORDINAL_POSITION</B> short =&gt; column sequence number 3153 * <LI><B>ORDINAL_POSITION</B> short =&gt; column sequence number
3881 return con.supportsEscapeSequenceSyntax(); 3881 return con.supportsEscapeSequenceSyntax();
3882 } 3882 }
3883 3883
3884 /** 3884 /**
3885 * Retrieves whether a SQLException while autoCommit is true 3885 * Retrieves whether a SQLException while autoCommit is true
3886 * inidcates that all open ResultSets are closed, even ones that are 3886 * indicates that all open ResultSets are closed, even ones that are
3887 * holdable. When a SQLException occurs while autocommit is true, it 3887 * holdable. When a SQLException occurs while autocommit is true, it
3888 * is vendor specific whether the JDBC driver responds with a commit 3888 * is vendor specific whether the JDBC driver responds with a commit
3889 * operation, a rollback operation, or by doing neither a commit nor 3889 * operation, a rollback operation, or by doing neither a commit nor
3890 * a rollback. A potential result of this difference is in whether 3890 * a rollback. A potential result of this difference is in whether
3891 * or not holdable ResultSets are closed. 3891 * or not holdable ResultSets are closed.