If it's working (you can make a query and return results), then probably
it's installed correctly. You may check the version with the following code:
<cfset obj = createObject("java", "macromedia.jdbc.oracle.OracleDriver")>
<cfoutput>#obj.getMajorVersion()#.#obj.getMinorVersion()#</cfoutput>
--
Fabio Terracini
Dustin Tinney wrote:
Is there a way to verify that the driver is installed correctly?
On 4/13/05, Fabio Terracini <[EMAIL PROTECTED]> wrote:
Do you updated the JDBC drivers?
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18807
--
Fabio Terracini
Dustin Tinney wrote:
We're running coldfusion 6.1 We have a table with in our Oracle 8i
database that has 2 fields. The first is an ID. It's the PK of the
table. The second is a Clob, data. When I write a cfQuery for
pulling items from this table it is as simple as this:
SELECT
data
FROM
tableName
WHERE
id = 'someID'
Now the problem is that depending on how big data is my query takes
from a couple of Miliseconds up to 16 seconds to run. All results
right up to about 1800 chars with in the data field take 10ms. Once I
hit around 1800 it takes around 16 seconds to run. Then after about
1850 it goes back down to 10ms. I can recreate the error again and
again. However I cannot figure out what is going on.
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
