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.

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

Add Field to Specify DB2 Schema Name #5

Open
Truman-Brown opened this issue Oct 5, 2021 · 1 comment
Open

Add Field to Specify DB2 Schema Name #5

Truman-Brown opened this issue Oct 5, 2021 · 1 comment

Comments

@Truman-Brown
Copy link

As of right now, you have to specify the Schema Name when running the SQL Statements to create the tables for Stocktrader Portfolios. For example, the SQL Statement for the Portfolio Table needs to look like
CREATE TABLE "<SCHEMA NAME>".Portfolio(owner VARCHAR(32) NOT NULL, total DOUBLE, accountID VARCHAR(64), PRIMARY KEY(owner));

This could be configurable somehow.

@jwalcorn
Copy link
Member

Yes, right now it assumes the schema name is the ID with which you logged in to the database. Like if you logged in as db2admin, then it assumes the table will be db2admin.Portfolio. I agree making this configurable, so that the schema name doesn't have to be login name, would be a good enhancement. Need to think about how best to implement that (I assume that would need to get specified in the JPA annotations in the POJO for each table).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants