<[EMAIL PROTECTED]> wrote:
> Are there differences in SQL/functions when moving from an ODBC datasource
> to a JDBC datasource?
>
> We're hosting an application for another contractor and their app is the
> only one using ODBC (all apps use Oracle). We'd like to remove the ODBC
> services (well, we're setting up a brand new box and would like to do so
> without ODBC) but they claim that it's a big hassle for them to change their
> app to use JDBC instead of ODBC. When we've migrated apps in the past (many
> of which are considerably larger) we never had to change any SQL as long as
> the back-end database was the same.
>
There are a couple of differences that come to mind based on some code
I inherited back when we were migrating an app from CF 4.5 to CFMX.
The drivers on CF 4.5 were using the ODBC drivers, and it may or may
not apply to CFMX's ODBC implementation. Nonetheless, I figured I'd
throw it out there:
1) You cannot end your queries with a semi-colon, i.e.
SELECT sysdate
FROM dual;
There were a bunch of querie like that in the code, and I'm assuming
that it was because the previous developer copied and pasted from SQL
Plus directly into the cfquery tag.
2) You can't have multiple SQL statements (that I'm aware of) in the
same cfquery tag (mainly because of #1 above), i.e.,
UPDATE myTable
SET myColumn = myValue
WHERE myKey = myKeyID;
SELECT COUNT(*)
FROM myTable
WHERE myKey = myKeyID
Again, I'm not suggesting that the above is good coding practices, but
you can't help what you inherit and I noticed you said it was a
contractor's app.
And Isaac, I won't damn you. ;)
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
