RE: CFObject in CFMX (Connection String)
> I saw the docs as well... is this a limitation of the > JDBC-ODBC bridge or the native driver in CFMX? I'm not an expert on JDBC; I recall hearing that it's a limitation with JDBC. > So the "ODBC Socket" or "SQL Server" drivers provided > with CFMX are pure Java Type IV native drivers? No ODBC > involved... can your confirm this?. The SQL Server driver in CF MX is a Type 4 driver. The ODBC Socket driver isn't - it can't be, because it's an connection to ODBC! The MS Access driver isn't a Type 4 driver, either. I'm not sure what type the ODBC Socket driver is, but I've been told by MM people that the Access driver is Type 3. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFObject in CFMX (Connection String)
I saw the docs as well... is this a limitation of the JDBC-ODBC bridge or the native driver in CFMX? So the "ODBC Socket" or "SQL Server" drivers provided with CFMX are pure Java Type IV native drivers? No ODBC involved... can your confirm this?. Joe - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 08, 2002 8:32 PM Subject: RE: CFObject in CFMX (Connection String) > > It looks like "connectstring" and some other params of > > query are deprecated in CFMX.. so how do you go about > > doing a DNS-less connection in CFMX? > > Dynamic connections aren't supported in CF MX. This is documented in the > release notes, I think, or in the regular documentation set itself. If I > recall correctly, this is a limitation of JDBC. > > > Where are Java JDBC driver info's stored in CFMX? I would > > like to use the TYPE IV Java drivers making direct calls > > to the DB.. Theoretically.. this would give the best > > performance..since u bypass the ODBC layer right? > > There's no ODBC layer used when you create a CF MX datasource anyway, if > you're using a Type 4 driver. So, I don't think you'd get any performance > increase even if you could build a dynamic connection. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFObject in CFMX (Connection String)
> It looks like "connectstring" and some other params of > query are deprecated in CFMX.. so how do you go about > doing a DNS-less connection in CFMX? Dynamic connections aren't supported in CF MX. This is documented in the release notes, I think, or in the regular documentation set itself. If I recall correctly, this is a limitation of JDBC. > Where are Java JDBC driver info's stored in CFMX? I would > like to use the TYPE IV Java drivers making direct calls > to the DB.. Theoretically.. this would give the best > performance..since u bypass the ODBC layer right? There's no ODBC layer used when you create a CF MX datasource anyway, if you're using a Type 4 driver. So, I don't think you'd get any performance increase even if you could build a dynamic connection. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFObject in CFMX (Connection String)
If you really need a DSN-less connection, you can try ADO. It's also useful
for grabbing info about columns and tables. I am using it for one project of
mine in MX.
http://cfhub.com/advanced/ado/adodb_query.cfm
- Original Message -
From: "Joe Eugene" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, September 09, 2002 7:15 AM
Subject: Re: CFObject in CFMX (Connection String)
> It looks like "connectstring" and some other params of query are
> deprecated in CFMX.. so how do you go about doing a DNS-less connection in
> CFMX?
>
> Where are Java JDBC driver info's stored in CFMX? I would like to use the
> TYPE IV
> Java drivers making direct calls to the DB.. Theoretically.. this would
give
> the
> best performance..since u bypass the ODBC layer right?
>
> Joe
>
> - Original Message -
> From: "Matt Liotta" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, September 08, 2002 2:35 PM
> Subject: RE: CFObject in CFMX
>
>
> > No idea really, I could speculate, but what fun is that.
> >
> > Matt Liotta
> > President & CEO
> > Montara Software, Inc.
> > http://www.montarasoftware.com/
> > 888-408-0900 x901
> >
> > > -Original Message-
> > > From: Joe Eugene [mailto:[EMAIL PROTECTED]]
> > > Sent: Sunday, September 08, 2002 10:56 AM
> > > To: CF-Talk
> > > Subject: Re: CFObject in CFMX
> > >
> > > Matt,
> > > Do you know why you have to be "explicit" on declaring the
> > class
> > > as
> > > public/private...CFMX doesnt
> > > take default.
> > > eg.. CFMX doesnt like
> > >class ChkStrings{}
> > > it should be
> > > public class ChkStrings{}
> > > The Java construct works fine without an explicit declaration
> > of
> > > "public" and u are able to
> > > instanciate the class object.. call methods and whatever..
> > but..
> > > CFMX doesnt like this. CFMX
> > > creates the object but doesnt realize any public methods in
> > the
> > > class.
> > > Joe
> > >
> > >
> > > - Original Message -
> > > From: "Matt Liotta" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Sunday, September 08, 2002 1:09 PM
> > > Subject: RE: CFObject in CFMX
> > >
> > >
> > > > CFMX can be configured to have a hot load directory that detects
> > changes
> > > > to Java classes and reloads them. You have to change an XML
> > > > configuration file for this, so check the documentation.
> > > >
> > > > Matt Liotta
> > > > President & CEO
> > > > Montara Software, Inc.
> > > > http://www.montarasoftware.com/
> > > > 888-408-0900 x901
> > > >
> > > > > -Original Message-
> > > > > From: Joe Eugene [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Sunday, September 08, 2002 9:14 AM
> > > > > To: CF-Talk
> > > > > Subject: RE: CFObject in CFMX
> > > > >
> > > > > Sean,
> > > > > If i am right ... obj.init() simply does an instanciation..ie
> > > > calls
> > > > > the
> > > > > constructor. I dont have a constructor.. so the default
> > > > constructor
> > > > > should be called right?.. so obj.init() is needed only when you
> > > > have
> > > > > to instanciate the object and set variables too. some like...
> > > > >
> > > > > Myclass mc = new Myclass(); // default
> > > > > Myclass mc = new Myclass(10,20); // same as obj.init(10,20)
> > > > >
> > > > > Anyways i finally found out that you had to "explicitly" declare
> > > > the
> > > > > class
> > > > > as "public" to get this working...
> > > > > so "class chkString{}" should be "puiblic class chkString{}"...
> > > > i
> > > > > know i
> > > > > tried this
> > > > > earlier.. but one BIG DEBUG PROBLEM.. after CFMX loads the class
> > > > the
> > > > > first
> > > > > time
> > > > > and you replace the class with a new class...CFMX keeps the OLD
> >
Re: CFObject in CFMX (Connection String)
Joe Eugene wrote: > It looks like "connectstring" and some other params of query are > deprecated in CFMX.. so how do you go about doing a DNS-less connection in > CFMX? Depends what you want. I'm not sure if you can get it as dynamic as with CF 5. But in many cases it is sufficient to just be able to create datasources on the fly. If that is the case, dig into the ServiceFactory. http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=12 should get you started. > Where are Java JDBC driver info's stored in CFMX? Not sure if they are :) The settings for the default drivers are probably stored in some XML file, but for anything else they are not stored as properties of the driver but of the datasource. > I would like to use the TYPE IV > Java drivers making direct calls to the DB.. Theoretically.. this would give > the best performance..since u bypass the ODBC layer right? Theoretically yes. In practice it depends on the quality of the JDBC drivers. But you can administer Type IV JDBC Drivers through the CF MX Administrator just like any other driver. No need to use cfobject for that. Jochem __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFObject in CFMX (Connection String)
It looks like "connectstring" and some other params of query are
deprecated in CFMX.. so how do you go about doing a DNS-less connection in
CFMX?
Where are Java JDBC driver info's stored in CFMX? I would like to use the
TYPE IV
Java drivers making direct calls to the DB.. Theoretically.. this would give
the
best performance..since u bypass the ODBC layer right?
Joe
- Original Message -
From: "Matt Liotta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, September 08, 2002 2:35 PM
Subject: RE: CFObject in CFMX
> No idea really, I could speculate, but what fun is that.
>
> Matt Liotta
> President & CEO
> Montara Software, Inc.
> http://www.montarasoftware.com/
> 888-408-0900 x901
>
> > -Original Message-
> > From: Joe Eugene [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, September 08, 2002 10:56 AM
> > To: CF-Talk
> > Subject: Re: CFObject in CFMX
> >
> > Matt,
> > Do you know why you have to be "explicit" on declaring the
> class
> > as
> > public/private...CFMX doesnt
> > take default.
> > eg.. CFMX doesnt like
> >class ChkStrings{}
> > it should be
> > public class ChkStrings{}
> > The Java construct works fine without an explicit declaration
> of
> > "public" and u are able to
> > instanciate the class object.. call methods and whatever..
> but..
> > CFMX doesnt like this. CFMX
> > creates the object but doesnt realize any public methods in
> the
> > class.
> > Joe
> >
> >
> > - Original Message -
> > From: "Matt Liotta" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Sunday, September 08, 2002 1:09 PM
> > Subject: RE: CFObject in CFMX
> >
> >
> > > CFMX can be configured to have a hot load directory that detects
> changes
> > > to Java classes and reloads them. You have to change an XML
> > > configuration file for this, so check the documentation.
> > >
> > > Matt Liotta
> > > President & CEO
> > > Montara Software, Inc.
> > > http://www.montarasoftware.com/
> > > 888-408-0900 x901
> > >
> > > > -Original Message-
> > > > From: Joe Eugene [mailto:[EMAIL PROTECTED]]
> > > > Sent: Sunday, September 08, 2002 9:14 AM
> > > > To: CF-Talk
> > > > Subject: RE: CFObject in CFMX
> > > >
> > > > Sean,
> > > > If i am right ... obj.init() simply does an instanciation..ie
> > > calls
> > > > the
> > > > constructor. I dont have a constructor.. so the default
> > > constructor
> > > > should be called right?.. so obj.init() is needed only when you
> > > have
> > > > to instanciate the object and set variables too. some like...
> > > >
> > > > Myclass mc = new Myclass(); // default
> > > > Myclass mc = new Myclass(10,20); // same as obj.init(10,20)
> > > >
> > > > Anyways i finally found out that you had to "explicitly" declare
> > > the
> > > > class
> > > > as "public" to get this working...
> > > > so "class chkString{}" should be "puiblic class chkString{}"...
> > > i
> > > > know i
> > > > tried this
> > > > earlier.. but one BIG DEBUG PROBLEM.. after CFMX loads the class
> > > the
> > > > first
> > > > time
> > > > and you replace the class with a new class...CFMX keeps the OLD
> > > > class in
> > > > memory.. so basically you have restart the CFAS...
> > > > Is there any work around this... i mean you can't restart the
> > > server
> > > > in the
> > > > middle of productionAppreciate your help.
> > > >
> > > > Thanks
> > > > Joe
> > > > Certified Advanced ColdFusion Developer
> > > > [EMAIL PROTECTED]
> > > >
> > > >
> > > > -Original Message-
> > > > From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
> > > > Sent: Sunday, September 08, 2002 10:18 AM
> > > > To: CF-Talk
> > > > Subject: Re: CFObject in CFMX
> > > >
> > > >
> > > > On Saturday, September 7, 2002, at 09:08 , Joe Eugene wrote:
> > > > > I am trying to invoke a java class with CFobject and CFMX
> doesnt
> > > > > like something...
> > > > >
> > > > > name="obj">
> > > > >
> > > > >
> > > > > it creates the object "obj" but says there is an error on
> > > > "obj.getString(
> > > > > )"
> > > >
> > > > Use to see exactly what you created - it will
> > > dump
> > > > out a Java object will all the methods.
> > > >
> > > > It doesn't look like you're calling init() either - CF requires
> that
> > > you
> > > > call init() after creating the object so that it is correctly
> > > constructed.
> > > > I think your code should read:
> > > >
> > > > name="obj">
> > > >
> > > >
> > > >
> > > > Sean A Corfield -- http://www.corfield.org/blog/
> > > >
> > > > "If you're not annoying somebody, you're not really alive."
> > > > -- Margaret Atwood
> > > >
> > > >
> > > >
> > >
> >
>
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsu
