Re: RawRow cross DB compatibility
Re: RawRow cross DB compatibility
- Subject: Re: RawRow cross DB compatibility
- From: Chuck Hill <email@hidden>
- Date: Tue, 25 Mar 2014 03:28:32 +0000
- Thread-topic: RawRow cross DB compatibility
|
Hi Oscar,
On 2014-03-24, 5:54 PM, "Oscar González" wrote:
Hi all,
I'm migrating a few projects from Oracle to Postgresql, there are a lot straight RawRow for performance.
Raw rows or raw SQL? Most raw row stuff can take a qualifier which removes the need for raw (custom) SQL. You are using Wonder, right?
Now I'm facing the problem of changing every incompatibility like nvl for coalesce for example.
1. I will like to know the right way of doing a RawRow to use the JdbcPlugin for better cross databases
There might be some stuff in JDBCPlugin or in the SQLHelper family to make this easier, but it might be more trouble than it is worth unless you plan on migrating the projects again.
2. For my own problem is there any workaround instead of doing it by the long way.
I think you might be stuck with it. Oracle is known for doing things its own way.
Chuck
Appreciate any help
Saludos,
Óscar González Pérez
TECH un AGRO S.A
|
_______________________________________________
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