2008 13:44
To: CF-Talk
Subject: RE: closing JDBC recordsets
You're right, a standard datasource would be much better, my direct
access code which works (CF 8.1) is:
cfobject type=JAVA action=Create name=Class
class=java.lang.Class cfset
Class.forName
-Original Message-
From: denstar [mailto:[EMAIL PROTECTED]
Sent: 02 May 2008 07:40
To: CF-Talk
Subject: Re: closing JDBC recordsets
Is there any possibility that the database file format is DBASE?
That's the jdbc driver I was using for clipper, I think.
Maybe it's foxpro
[mailto:[EMAIL PROTECTED]
Sent: 01 May 2008 06:48
To: CF-Talk
Subject: Re: closing JDBC recordsets
On Wed, Apr 30, 2008 at 11:36 PM, Richard Meredith-Hardy
[EMAIL PROTECTED] wrote:
I did try, but without success.
I suppose you're right though. I'll have another go at it.
You can
You're right, a standard datasource would be much better, my
direct access code which works (CF 8.1) is:
cfobject type=JAVA action=Create name=Class
class=java.lang.Class cfset
Class.forName(sun.jdbc.odbc.JdbcOdbcDriver)
cfobject type=JAVA action=Create name=DriverManager
communicated with the DB in CF8 is by a direct
JDBC connection (code below) but I'd prefer to do it in a more standard way
if I could
Richard
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 01 May 2008 09:13
To: CF-Talk
Subject: RE: closing JDBC recordsets
You're
On Thu, May 1, 2008 at 2:12 AM, Dave Watts [EMAIL PROTECTED] wrote:
If you're using an ODBC datasource, why not just use the ODBC Socket
datasource option in CF?
Well, what he said, and as an addendum: sometimes you'll need to look
up the specifics of the driver-- pass custom options and
You're right, a standard datasource would be much better, my
direct access code which works (CF 8.1) is:
cfobject type=JAVA action=Create name=Class
class=java.lang.Class cfset
Class.forName(sun.jdbc.odbc.JdbcOdbcDriver)
cfobject type=JAVA action=Create name=DriverManager
at jdbcodbc.cfm which is in CFIDE\administrator\datasources\
I thought this might contain some interesting clues, but this cfm file is
encrypted...
Richard
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 01 May 2008 13:44
To: CF-Talk
Subject: RE: closing JDBC recordsets
Let me say first off that I'm not very experienced with cfc's.
Code below is a cfc to query a sage line 100 accounting db from cf8.1
This works, a normal query via a regular datasource type ODBC socket
doesn't (though it does in CF5).
My question: I understand that when using JDBC it is
]
Sent: 30 April 2008 09:55
To: CF-Talk
Subject: closing JDBC recordsets
Let me say first off that I'm not very experienced with cfc's.
Code below is a cfc to query a sage line 100 accounting db
from cf8.1 This works, a normal query via a regular
datasource type ODBC socket doesn't (though
Actually, to answer my own question, I think that if I call the close()
method for the passed JDBC recordset after I've done with using it in other
methods then this should do the trick. Am I right?
Actually, to answer my own question, I think that if I call the close()
method for the passed
is an ancient beast and I would use a normal cf datasource if
I could, but it doesn't work in cf8 hence the reason for doing it manually,
which does.
Regards
Richard
-Original Message-
From: C S [mailto:[EMAIL PROTECTED]
Sent: 30 April 2008 14:08
To: CF-Talk
Subject: Re: closing JDBC
Yes, I can convert it into a cfquery object, and a lot of the time I will,
but I also want to be able to insert the data into another table in another
db which I can do directly rather than converting it to a query first.
Hence the reason to split it into separate methods.
Personally I would
On Wed, Apr 30, 2008 at 8:02 AM, Richard Meredith-Hardy
[EMAIL PROTECTED] wrote:
Sage line 100 is an ancient beast and I would use a normal cf datasource if
I could, but it doesn't work in cf8 hence the reason for doing it manually,
which does.
If you can do it in a CFC, you can create
I did try, but without success.
I suppose you're right though. I'll have another go at it.
Richard
-Original Message-
From: denstar [mailto:[EMAIL PROTECTED]
Sent: 30 April 2008 23:05
To: CF-Talk
Subject: Re: closing JDBC recordsets
On Wed, Apr 30, 2008 at 8:02 AM
On Wed, Apr 30, 2008 at 11:36 PM, Richard Meredith-Hardy
[EMAIL PROTECTED] wrote:
I did try, but without success.
I suppose you're right though. I'll have another go at it.
You can always implement your own pooling, if you want. Just more typing. :-)
16 matches
Mail list logo