For SP2:
1. Better garbage collection on the JVM interaction. Man, the memory
degrades in the JVM! I suspect that if I do a low priority thread and call
System.gc() it would work better... Maybe.
2. In oracle thru ODBC, if I issue and incorrect data value (i.e. a "TRUE"
when I created a NUMERIC data type, I should enter 1 or 0) cfinsert/cfupdate
go to sleep with the fish... 100% CPU usage, no response... Oracle 8.1.5,
Solaris.
3. cfinsert/cfupdate mechanics with upper/lowercase tables.
Say you have a table in SqlServer 7 called MyTable. Say you have your SQL
server case sensitive, so the table has to be entered in exactly that case.
Say you install the same table in oracle which turns it into MYTABLE (oracle
does that)
if you use
<cfupdate datasource="#session.datasource#" tablename="MyTable"> works in
SQL, not in oracle
<cfupdate datasource="#session.datasource#" tablename="MYTABLE"> works in
oracle, not SQL.
<cfquery datasource="#session.datasource#">update MyTable set x=y where
id=1</cfquery>works in both
It turns out that my single ODBC-compliant cfupdate/cfinsert require proper
case for SqlServer and UPPERCASE for Oracle! mmmm! If I do a CFQUERY with
the SQL update statement all works fine, but I loose some of the nice form
management, like adding quotes automatically, automatic detection of form
parameters, id recognition, update those form fields only, etc.
I had to create a metadata reader in Java that gets the proper table name
from the DB and converts the table name to the right case before I issue the
cfinsert/update. works, but sucks. I have a CFX tag with a cached hash
table, so I read the catalog only once, and again only if a new table is
requested.
------------------
Probably not SP2, but right after that:
JRun/Cold Fusion fully supported connectivity, specially in the
session/application space. Maybe a 5.0 with JRun 4.5?
<Jaime/>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
