Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

feat: Support CREATE DATABASE and ALTER DATABASE in JDBC #457

Open
olavloite opened this issue May 6, 2021 · 0 comments
Open

feat: Support CREATE DATABASE and ALTER DATABASE in JDBC #457

olavloite opened this issue May 6, 2021 · 0 comments
Assignees
@olavloite
Labels
api: spanner Issues related to the googleapis/java-spanner-jdbc API. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.

Comments

@olavloite
Copy link
Collaborator

The JDBC driver supports all DDL statements that affect an existing database, but currently does not support CREATE DATABASE. It also does not support the ALTER DATABASE statement for any other database than the one that the client is connected to at that moment. This makes it difficult to create and maintain databases using JDBC. The JDBC driver should therefore support:

  • Connecting to an instance without connecting to a specific database.
  • Executing CREATE DATABASE statements
  • Executing ALTER DATABASE statements for other databases than the one the client is connected to at that moment.
  • Executing DROP DATABASE statements
  • Listing existing databases on an instance (SHOW VARIABLE DATABASES)
@olavloite olavloite added type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design. api: spanner Issues related to the googleapis/java-spanner-jdbc API. labels May 6, 2021
@olavloite olavloite self-assigned this May 6, 2021
olavloite added a commit to googleapis/java-spanner that referenced this issue May 7, 2021
@olavloite
feat: support DATABASE statements
49b8321 
Adds support for the following DATABASE statements in the Connection API:
- CREATE DATABASE <database_id>
- ALTER DATABASE <database_id>
- DROP DATABASE <database_id>
- USE DATABASE <database_id>

Needed for googleapis/java-spanner-jdbc#457
@olavloite olavloite mentioned this issue May 7, 2021
Closed
@rajatbhatta rajatbhatta removed their assignment Aug 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@olavloite olavloite

Labels
api: spanner Issues related to the googleapis/java-spanner-jdbc API. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@olavloite @rajatbhatta