> -----Original Message-----
> From: Sean A Corfield [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 9 March 2004 11:02 AM
> To: CFAussie Mailing List
> Subject: [cfaussie] Re: JRUN For COldfusion
>
> I'm surprised it would be a "huge programming [...] task" to
> switch to
> JDBC... surely all you need to do is install the Informix
> JDBC drivers
> and redefine the data sources? Or am I missing some critical piece of
> the puzzle? Yes, it would mean retesting everything.
This is all I thought we'd need to do as well, but I've so far found 68 queries that
need to be rewritten because the syntax is just not supported when you go through JDBC
instead of ODBC. I'm in no way finished looking yet either, so I'm sure this list will
grow.
Other differences we've found are to do with putting dates into and getting dates out
of the database. There are subtle differences that are causing syntax errors only on a
JDBC connection.
An example of the SQL differences is this:
Existing code (I didn't write it. Don't complain, but it does/did work fine.)
SELECT DISTINCT t1.fieldx, t2.fieldy
FROM {oj table1 t1 LEFT OUTER JOIN table2 t2
ON t1.field1 = t2.field1
AND t1.field2 = t2.field2}
WHERE t1.field1= 'XX'
AND t1.field3='YY'
ORDER BY t1.field2
now throws a syntax error and needs to be changed to something like this:
SELECT DISTINCT t1.fieldx, t2.fieldy
FROM table1 t1, OUTER table2 t2
WHERE t1.field1 = t2.field1
AND t1.field2 = t2.field2}
AND t1.field1= 'XX'
AND t1.field3='YY'
ORDER BY t1.field2
Its not a major change, but this form of join occurrs, as I said, in 68 places in just
one of our apps.
I can't see any safe way to script this change, so every one of these changes is going
to have to be looked at individually, changed suitably and then individually tested.
The example is an abnormally simple join and does not reflect the complexity of the
majority of the queries effected.
I believe that this particular form of join was generated by the query builder in CF
Studio.
There may well be other coding changes required that I haven't found yet.
So I stand by my "huge programming" statement. (I was as surprised as you no doubt are
now)
Regards
Darren Tracey
JDBC victim
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
