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

WhiteRabbit Cannot connect to PosgreSQL datbase where schema has uppercase letters #416

Open
Intisma opened this issue Jul 29, 2024 · 1 comment
Assignees
Labels
bug WhiteRabbit Issue concerning the creation of scan report

Comments

@Intisma
Copy link

Intisma commented Jul 29, 2024

Issue Description:

When testing the connection to the database where the schema name contains uppercase letters, I encounter the following error:
Unable to retrieve table names for database Schema_name.
In this message, the schema name is displayed correctly with uppercase letters. However, upon inspecting the connection made to the database, I noticed that the query sent was:
SELECT table_name FROM information_schema.tables WHERE table_schema = 'schema_name' ORDER BY table_name
In this query, the schema name is converted to all lowercase letters. I attempted to use double quotes around the schema name, but it still transformed all letters to lowercase.

Question:

Is there any way to use WhiteRabbit with schema names that contain uppercase letters? I have read-only access to the database and cannot modify the schema names.

@Intisma Intisma added the bug label Jul 29, 2024
@janblom janblom added the WhiteRabbit Issue concerning the creation of scan report label Jul 29, 2024
@janblom janblom self-assigned this Jul 29, 2024
@Intisma
Copy link
Author

Intisma commented Jul 29, 2024

I modified the code and was able to use the program with uppercase schemas. I made minimal modifications to DBConnection.java, specifically by removing the forced lowercase transformation and adding double quotes to the section that sets the working path. This change was necessary because PostgreSQL automatically lowercases text that is not enclosed in double quotes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug WhiteRabbit Issue concerning the creation of scan report
Projects
None yet
Development

No branches or pull requests

2 participants