From: "Ray Kiddy" <webobjects-dev@wocommunity.org>
Received-SPF: pass
 receiver=post.selbstdenker.com; client-ip=173.201.192.109; envelope-from=ray@ganymede.org
Subject: Re: [WO-DEV] Athena JDBC
To: WebObjects & WOnder Development <webobjects-dev@wocommunity.org>
References: <list-25480672@post.selbstdenker.com>
Message-ID: <f09534a7-e14e-56c8-36b9-88e66a6e5575@ganymede.org>
Date: Sun, 28 Feb 2021 12:06:11 -0800
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0)
 Gecko/20100101 Thunderbird/78.8.0
MIME-Version: 1.0
In-Reply-To: <list-25480672@post.selbstdenker.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-GB

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