Re: Entity join with different data sources?

Subject: Re: Entity join with different data sources?
From: Gintautas Sulskus <email@hidden>
Date: Tue, 03 Dec 2013 02:51:39 +0000

Thanks :)

By the way, we are thinking to use REST to communicate with HBase via Thrift.

The natural way was to use WOLips, create entities and set adaptor to rest.

Is this the best tutorial available?

http://wiki.wocommunity.org/display/WEB/Your+First+Rest+Project#YourFirstRestProject-CreatingRESTcontrollersandroutes

Basically I have hit the wall like this guy: http://lists.apple.com/archives/webobjects-dev/2013/Mar/msg00303.html

No template. Indigo + WOLips 3.7. Any clues? I'm using 3.7 latest release update site.

In the meantime, as alternative for the above, I have done some experiments with WebObjects + EOModel + Impala/Entity JDBC drivers.

EOModel CAN query Impala/Hive for a list of tables. However, there is no reverse engineering support so I have created an entity manually that maps to the table on Hive. However, whenever I try to fetch all records from that entity it gives me an exception:

Method not supported at org.apache.hive.jdbc.HiveDatabaseMetaData.supportsANSI92FullSQL(HiveDatabaseMetaData.java:805)

Well, that's true and correct. However, I will need only the most basic subset from ANSI92 that is supported by Impala. Is there any way to overcome this check?
Will I have to extend these classes?

Regards,

Gintas

On Mon, Nov 25, 2013 at 7:10 PM, Chuck Hill <email@hidden> wrote:

Hi,

On 2013-11-25 3:38 AM, "Gintautas Sulskus" wrote:

Thank you for a very quick response.

Each model is specific to one database, you will need to have two models. You can have as many models as you want in a project. You can create a model group in Eclipse to hold both models so that you can make relationships between them.

Can I use relationship to make "virtual" joins, that do not exist in the database? E.g. I would like to express table_1 and table_2 as a virtual_table_3 that exists only in EOModel. Then I would like to query and perform dml operations on that virtual table.

No, you can't do that. They get fetched as disjoint Java objects.

Or should I express only the relationships that are present in the database?

Yes. I will also note that this is not a commonly used feature of EOF, so you may run into bugs.

Chuck

ERRest. There are multiple presentations in the WOCommunity.

Found it! Thanks a lot :)

Cheers,

Gintas

On Mon, Nov 25, 2013 at 5:39 AM, Chuck Hill <email@hidden> wrote:

On 2013-11-24 7:40 PM, "Gintautas Sulskus" wrote:

Hello,

Just wanted to double check: I am trying to create an EOModel (in WOLips) that would use two entities from different databases. Is it possible to achieve this? I assume the answer is NO.

Each model is specific to one database, you will need to have two models. You can have as many models as you want in a project. You can create a model group in Eclipse to hold both models so that you can make relationships between them.

Chuck

Also, I was looking for any information on REST adaptor and could not find anything. Do you have any references to this?

Much appreciated!

Best Regards,
Gintautas

--
Best Regards,
Gintautas Sulskus

--
Best Regards,
Gintautas Sulskus

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

Follow-Ups:
- Re: Entity join with different data sources?
  - From: Chuck Hill <email@hidden>

Prev by Date: Inheritance ERRest
Next by Date: Re: Entity join with different data sources?
Previous by thread: Re: Inheritance ERRest
Next by thread: Re: Entity join with different data sources?
Index(es):
- Date
- Thread