You have to close them yourself... that's what CF does behind the
scenes. They will eventually close when the object is no longer in
scope and is garbage collected, but in Java you don't know when that
will happen. You'll want to make sure its done in any exception
handlers as well.
-dh
From what I've seen, I think that datasource manager handles that as
part of the connection pool, but i'm not 100% sure yet.
ap
On Jul 17, 2007, at 11:33 AM, Douglas Knudsen wrote:
interesting. Curious, you have to manually close the connections
in your JavaObj or does the CF datasource ma
interesting. Curious, you have to manually close the connections in your
JavaObj or does the CF datasource manager thingy handle it?
DK
On 7/17/07, Andrew Powell <[EMAIL PROTECTED]> wrote:
OK, I figured out a way to get the Java connection object without having
the Datasource password:
var m
Thanks.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, July 17, 2007 10:27 AM
To: discussion@acfug.org
Cc: [EMAIL PROTECTED]; discussion@acfug.org
Subject: Re: [ACFUG Discuss] moving tables across data sources
OK, I figured out a way to get the Java connection object without
having the Datasource password:
var myConnection = createObject
('java','coldfusion.server.ServiceFactory');
myConnection.getDataSourceService().getDatasource
('myDSNName').getConnection();
var javaObj = createObject('java','
Seth:
Let me preface my remarks by stating that I am using MS SQL. Here is what
I would do:
INSERT INTO server.database.owner.tablename (column1, column2, ...)
SELECT column1, column2, ...
FROM server.database2.owner.tablename
The trick is to set up a single user id on the server that can acce