You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Rick Shaw (JIRA)" <ji...@apache.org> on 2011/07/20 00:06:57 UTC
[jira] [Created] (CASSANDRA-2926) The JDBC Suite should provide a
simple DatabaseMetaData implementation
The JDBC Suite should provide a simple DatabaseMetaData implementation
----------------------------------------------------------------------
Key: CASSANDRA-2926
URL: https://issues.apache.org/jira/browse/CASSANDRA-2926
Project: Cassandra
Issue Type: New Feature
Components: Drivers
Affects Versions: 0.8.1
Reporter: Rick Shaw
Assignee: Rick Shaw
Priority: Minor
Fix For: 0.8.2
The {{DatabaseMetaData}} interface provides access to meta-data information about the JDBC Driver implementation and the DB that it supports. This class would usually be used by tooling to discover the extended capabilities of the Driver Suite.
A very basic implementation is planned initially. Non-static metadata about Keyspaces and Column Families can be provided in enhanced versions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2926) The JDBC Suite should provide a
simple DatabaseMetaData implementation
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13089218#comment-13089218 ]
Jonathan Ellis commented on CASSANDRA-2926:
-------------------------------------------
bq. We return an empty ResultSet. Since we did not return any tables in the result from that method call I went with false.
true is also valid then :) Going to go with that so we don't have to remember to change it, when we do actually ask for tables/CFs.
bq. Zero (0) implies no limit
Added the few limits we have.
bq. no good excuse for them being false
I thought at first this was talking about statement isolation but actually it is talking about the resultset manipulation api. So false is correct.
bq. There is no UNION operator in CQL?
You're right, but for some reason I keep thinking there is. Sorry. (This would be the right way to do "multiget." Guess I should create a ticket.)
> The JDBC Suite should provide a simple DatabaseMetaData implementation
> ----------------------------------------------------------------------
>
> Key: CASSANDRA-2926
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2926
> Project: Cassandra
> Issue Type: Sub-task
> Components: Drivers
> Affects Versions: 0.8.1, 0.8.4
> Reporter: Rick Shaw
> Assignee: Rick Shaw
> Priority: Minor
> Labels: CQL, JDBC
> Fix For: 0.8.5
>
> Attachments: add-database-metadata-v1.txt
>
>
> The {{DatabaseMetaData}} interface provides access to meta-data information about the JDBC Driver implementation and the DB that it supports. This class would usually be used by tooling to discover the extended capabilities of the Driver Suite.
> A very basic implementation is planned initially. Non-static metadata about Keyspaces and Column Families can be provided in enhanced versions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-2926) The JDBC Suite should provide a
simple DatabaseMetaData implementation
Posted by "Rick Shaw (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Shaw updated CASSANDRA-2926:
---------------------------------
Attachment: (was: jdbc-add-simple-datasource-v1.txt)
> The JDBC Suite should provide a simple DatabaseMetaData implementation
> ----------------------------------------------------------------------
>
> Key: CASSANDRA-2926
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2926
> Project: Cassandra
> Issue Type: Sub-task
> Components: Drivers
> Affects Versions: 0.8.1
> Reporter: Rick Shaw
> Assignee: Rick Shaw
> Priority: Minor
> Labels: CQL, JDBC
> Fix For: 0.8.3
>
>
> The {{DatabaseMetaData}} interface provides access to meta-data information about the JDBC Driver implementation and the DB that it supports. This class would usually be used by tooling to discover the extended capabilities of the Driver Suite.
> A very basic implementation is planned initially. Non-static metadata about Keyspaces and Column Families can be provided in enhanced versions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-2926) The JDBC Suite should provide a
simple DatabaseMetaData implementation
Posted by "Rick Shaw (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Shaw updated CASSANDRA-2926:
---------------------------------
Issue Type: Sub-task (was: New Feature)
Parent: CASSANDRA-2876
> The JDBC Suite should provide a simple DatabaseMetaData implementation
> ----------------------------------------------------------------------
>
> Key: CASSANDRA-2926
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2926
> Project: Cassandra
> Issue Type: Sub-task
> Components: Drivers
> Affects Versions: 0.8.1
> Reporter: Rick Shaw
> Assignee: Rick Shaw
> Priority: Minor
> Labels: CQL, JDBC
> Fix For: 0.8.2
>
>
> The {{DatabaseMetaData}} interface provides access to meta-data information about the JDBC Driver implementation and the DB that it supports. This class would usually be used by tooling to discover the extended capabilities of the Driver Suite.
> A very basic implementation is planned initially. Non-static metadata about Keyspaces and Column Families can be provided in enhanced versions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (CASSANDRA-2926) The JDBC Suite should provide a
simple DatabaseMetaData implementation
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis resolved CASSANDRA-2926.
---------------------------------------
Resolution: Fixed
Reviewer: jbellis
committed w/ above minor changes
> The JDBC Suite should provide a simple DatabaseMetaData implementation
> ----------------------------------------------------------------------
>
> Key: CASSANDRA-2926
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2926
> Project: Cassandra
> Issue Type: Sub-task
> Components: Drivers
> Affects Versions: 0.8.1, 0.8.4
> Reporter: Rick Shaw
> Assignee: Rick Shaw
> Priority: Minor
> Labels: CQL, JDBC
> Fix For: 0.8.5
>
> Attachments: add-database-metadata-v1.txt
>
>
> The {{DatabaseMetaData}} interface provides access to meta-data information about the JDBC Driver implementation and the DB that it supports. This class would usually be used by tooling to discover the extended capabilities of the Driver Suite.
> A very basic implementation is planned initially. Non-static metadata about Keyspaces and Column Families can be provided in enhanced versions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Issue Comment Edited] (CASSANDRA-2926) The JDBC Suite
should provide a simple DatabaseMetaData implementation
Posted by "Rick Shaw (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13089114#comment-13089114 ]
Rick Shaw edited comment on CASSANDRA-2926 at 8/22/11 10:57 PM:
----------------------------------------------------------------
With 176 methods, what are the odds I guess right on all :) So let me say first off, I be glad to change any values. But here are my excuses...
- allTablesAreSelectable -- references whether the user can use all the tables returned by {{getTables()}}, which is not currently supported. We return an empty {{ResultSet}}. Since we did not return any tables in the result from that method call I went with {{false}}.
- getMaxBinaryLiteralLength
- getMaxCharLiteralLength
Zero (0) implies no limit or the limit was unknown, and as I did not know of any such limit except practicality I went with zero. I could not find any documented limits but if I missed them somewhere I will gladly put them in.
- [own|others][Deletes|Inserts|Updates]AreVisible -- no good excuse for them being {{false}}. I must have been confused by all the questions running together. I will make them {{true}} in the subsequent patch.
- supportsUnion -- There is no {{UNION}} operator in CQL? I answered {{false}}?
was (Author: ardot):
With 176 methods, what are the odds I guess right on all :) So let me say first off, I be glad to change any values. But here are my excuses...
- allTablesAreSelectable -- references whether the user can use all the tables returned by {{getTables()}}, which is not currently supported. We return an empty {{ResultSet}}. Since we did not return any tables in the result from that method call I went with {{false}}.
- getMaxBinaryLiteralLength
- getMaxCharLiteralLength
Zero (0) implies no limit or the limit was unknown, and as I did not know of any such limit except practicality I went with zero. I could not find any documented limits but if I missed them somewhere I will gladly put them in.
- [own|others][Deletes|Inserts|Updates]AreVisible -- no good excuse for them being {{false}}. I must have been confused by all the questions running together. I will make them {{true}} in the subsequent patch.
- supportsUnion -- There is no {{UNION}} statement type in CQL? I answered {{false}}?
> The JDBC Suite should provide a simple DatabaseMetaData implementation
> ----------------------------------------------------------------------
>
> Key: CASSANDRA-2926
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2926
> Project: Cassandra
> Issue Type: Sub-task
> Components: Drivers
> Affects Versions: 0.8.1, 0.8.4
> Reporter: Rick Shaw
> Assignee: Rick Shaw
> Priority: Minor
> Labels: CQL, JDBC
> Fix For: 0.8.5
>
> Attachments: add-database-metadata-v1.txt
>
>
> The {{DatabaseMetaData}} interface provides access to meta-data information about the JDBC Driver implementation and the DB that it supports. This class would usually be used by tooling to discover the extended capabilities of the Driver Suite.
> A very basic implementation is planned initially. Non-static metadata about Keyspaces and Column Families can be provided in enhanced versions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2926) The JDBC Suite should provide a
simple DatabaseMetaData implementation
Posted by "Rick Shaw (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13089114#comment-13089114 ]
Rick Shaw commented on CASSANDRA-2926:
--------------------------------------
With 176 methods, what are the odds I guess right on all :) So let me say first off, I be glad to change any values. But here are my excuses...
- allTablesAreSelectable -- references whether the user can use all the tables returned by {{getTables()}}, which is not currently supported. We return an empty {{ResultSet}}. Since we did not return any tables in the result from that method call I went with {{false}}.
- getMaxBinaryLiteralLength
- getMaxCharLiteralLength
Zero (0) implies no limit or the limit was unknown, and as I did not know of any such limit except practicality I went with zero. I could not find any documented limits but if I missed them somewhere I will gladly put them in.
- [own|others][Deletes|Inserts|Updates]AreVisible -- no good excuse for them being {{false}}. I must have been confused by all the questions running together. I will make them {{true}} in the subsequent patch.
- supportsUnion -- There is no {{UNION}} statement type in CQL? I answered {{false}}?
> The JDBC Suite should provide a simple DatabaseMetaData implementation
> ----------------------------------------------------------------------
>
> Key: CASSANDRA-2926
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2926
> Project: Cassandra
> Issue Type: Sub-task
> Components: Drivers
> Affects Versions: 0.8.1, 0.8.4
> Reporter: Rick Shaw
> Assignee: Rick Shaw
> Priority: Minor
> Labels: CQL, JDBC
> Fix For: 0.8.5
>
> Attachments: add-database-metadata-v1.txt
>
>
> The {{DatabaseMetaData}} interface provides access to meta-data information about the JDBC Driver implementation and the DB that it supports. This class would usually be used by tooling to discover the extended capabilities of the Driver Suite.
> A very basic implementation is planned initially. Non-static metadata about Keyspaces and Column Families can be provided in enhanced versions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-2926) The JDBC Suite should provide a
simple DatabaseMetaData implementation
Posted by "Rick Shaw (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Shaw updated CASSANDRA-2926:
---------------------------------
Attachment: add-database-metadata-v1.txt
Minimal support for JDBC Tooling.
This Class will eventually provide the JDBC support for describing Column Families and Keyspaces.
> The JDBC Suite should provide a simple DatabaseMetaData implementation
> ----------------------------------------------------------------------
>
> Key: CASSANDRA-2926
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2926
> Project: Cassandra
> Issue Type: Sub-task
> Components: Drivers
> Affects Versions: 0.8.1
> Reporter: Rick Shaw
> Assignee: Rick Shaw
> Priority: Minor
> Labels: CQL, JDBC
> Fix For: 0.8.5
>
> Attachments: add-database-metadata-v1.txt
>
>
> The {{DatabaseMetaData}} interface provides access to meta-data information about the JDBC Driver implementation and the DB that it supports. This class would usually be used by tooling to discover the extended capabilities of the Driver Suite.
> A very basic implementation is planned initially. Non-static metadata about Keyspaces and Column Families can be provided in enhanced versions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2926) The JDBC Suite should provide a
simple DatabaseMetaData implementation
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13088813#comment-13088813 ]
Jonathan Ellis commented on CASSANDRA-2926:
-------------------------------------------
Shouldn't these be changed to match Cassandra better?
- allTablesAreSelectable
- getMaxBinaryLiteralLength
- getMaxCharLiteralLength
- [own|others][Deletes|Inserts|Updates]AreVisible
- supportsUnion
> The JDBC Suite should provide a simple DatabaseMetaData implementation
> ----------------------------------------------------------------------
>
> Key: CASSANDRA-2926
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2926
> Project: Cassandra
> Issue Type: Sub-task
> Components: Drivers
> Affects Versions: 0.8.1, 0.8.4
> Reporter: Rick Shaw
> Assignee: Rick Shaw
> Priority: Minor
> Labels: CQL, JDBC
> Fix For: 0.8.5
>
> Attachments: add-database-metadata-v1.txt
>
>
> The {{DatabaseMetaData}} interface provides access to meta-data information about the JDBC Driver implementation and the DB that it supports. This class would usually be used by tooling to discover the extended capabilities of the Driver Suite.
> A very basic implementation is planned initially. Non-static metadata about Keyspaces and Column Families can be provided in enhanced versions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-2926) The JDBC Suite should provide a
simple DatabaseMetaData implementation
Posted by "Rick Shaw (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Shaw updated CASSANDRA-2926:
---------------------------------
Attachment: jdbc-add-simple-datasource-v1.txt
> The JDBC Suite should provide a simple DatabaseMetaData implementation
> ----------------------------------------------------------------------
>
> Key: CASSANDRA-2926
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2926
> Project: Cassandra
> Issue Type: Sub-task
> Components: Drivers
> Affects Versions: 0.8.1
> Reporter: Rick Shaw
> Assignee: Rick Shaw
> Priority: Minor
> Labels: CQL, JDBC
> Fix For: 0.8.3
>
> Attachments: jdbc-add-simple-datasource-v1.txt
>
>
> The {{DatabaseMetaData}} interface provides access to meta-data information about the JDBC Driver implementation and the DB that it supports. This class would usually be used by tooling to discover the extended capabilities of the Driver Suite.
> A very basic implementation is planned initially. Non-static metadata about Keyspaces and Column Families can be provided in enhanced versions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira