Mailing List webobjects-dev@wocommunity.org Message #87
From: Ray Kiddy <webobjects-dev@wocommunity.org>
Subject: Re: [WO-DEV] Athena JDBC
Date: Sun, 28 Feb 2021 12:06:11 -0800
To: WebObjects & WOnder Development <webobjects-dev@wocommunity.org>
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
Subscribe (FEED) Subscribe (DIGEST) Subscribe (INDEX) Unsubscribe Mail to Listmaster