1. I have data in an Athena instance in AWS.
2. I am able to connect to the database but not retrieve any Database Metadata of any kind in a webobjects application and EOModeler.
3. I have tried with Intellij DataGrip, which is a JDBC query IDE, and that application is able to get all metadata (databases, schemas, tables and views).
Based on the above bullets, I am describing that no metadata is returned in EOModeler , or for that matter calling JDBC connection getMetaData method.
Conclusion:
Whatever queries the JDBC connector is using to pull metadata from the connection are not working for the Athena AWS JDBC driver.
What I have looked at to resolve the issue:
The query that is used with the Athena JDBC driver is “SHOW TABLES IN <DATABASE>” to retrieve table names from the JDBC connection.
My thought process:
Maybe a plugin can change the queries that are used to discover tables for EOF.
My Action:
- Go into project wonder and look at some code there to see if anything like this has been done in the Wonder project
- Code that was found in Wonder that made the most sense to look at was plugins
- Opened the MySql plugin to see if there was any indication in there where I could change the schema and table discovery methods for EOF so it discovers the metadata.
Result:
I have not found a way, or any code in Wonder that already does it, to modify the metadata discovery for the Athena JDBC driver. My question to the list is:
1. Is there a way to modify the way EOF discovers metadata for a specific type of database
2. If there is what class and methods would I need to implement, extend, override to be able to get the metadata into EOF for the Athena AWS database.
Don
I went into project wonder and looked at the MySQL plugin to see if there is a way to change the queries that are used to get database metadata in a plugin for EOF.
Is anyone else using Athena JDBC driver? What was your experience if you are.
Any pointers on how to modify how the JDBC EOF framework discovers metadata.
For Athena the query is Show TABLES IN <DATABASE>
Any help that anyone can provide would be great.
I am not sure that I understand your question.
If you want to connect to another kind of database and the MySQL plugin is not doing it, the obvious answer would be to write another plugin, one specifically for Athena. Does anyone have a plugin for Athena?
Is Athena supposed to be API compatible with MySQL? Glancing at some documentation, I am not seeing that it is or is supposed to be. Does the MySQL plugin "almost" work? If so, perhaps the MySQL plugin could be re-used and extended for Athena.
As to "how to modify how the JDBC EOF framework discovers metadata", the answer would be to use the methods available when writing a new plugin to get the information and return the information EOF needs.
Given this, are you asking how to write a plugin for Athena, or are you asking if one already exists, or if someone else would write it?
cheers - ray
On 2/27/21 7:20 PM, Don Lindsay wrote:
Hello;
I have data in an Athena instance in AWS. I am able to connect to the database but not retrieve any Database Metadata of any kind. I have tried with IntellijDataGrip and that application is able to get all metadata (databases, schemas, tables and views. I went into project wonder and looked at the MySQL plugin to see if there is a way to change the queries that are used to get database metadata in a plugin for EOF.
Is anyone else using Athena JDBC driver? What was your experience if you are.
Any pointers on how to modify how the JDBC EOF framework discovers metadata.
For Athena the query is Show TABLES IN <DATABASE>
Any help that anyone can provide would be great.
Thanks
Don
#############################################################
This message is sent to you because you are subscribed to
the mailing list <
webobjects-dev@wocommunity.org>.
To unsubscribe, E-mail to: <
webobjects-dev-off@wocommunity.org>
To switch to the DIGEST mode, E-mail to <
webobjects-dev-digest@wocommunity.org>
To switch to the INDEX mode, E-mail to <
webobjects-dev-index@wocommunity.org>
Send administrative queries to <
webobjects-dev-request@wocommunity.org>