Isaac Dealey wrote up an article on leveraging JDBC and CFMX, there some code samples and other interesting bits and bobs:
http://www.sys-con.com/story/?storyid=45569&DE=1 Cheers G On Thu, 12 Aug 2004 14:18:40 +1000, Elliot Russo <[EMAIL PROTECTED]> wrote: > in a past life I have prgrammed asp (asp.net), vb, and done a bit of java - > they all have a a little more features than cfquery :) > > "Barry Beattie" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > > sheesh! it's starting to look like Microsoft's ADO > > you're not a former ASP programmer, by chance, Elloit? > > cheers > barry.b > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Elliot > Russo > Sent: Thursday, 12 August 2004 12:12 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Using jdbc from Coldfusion > > I'd like access to the prepared statement methods. I am building my own > in > cf but it is a nuisance > > conn = createObject(); > > statement = conn.prepareStatement("select x from y where z = ?"); > > statement.setParameter(1, "test"); > statement.setMaxRows(30); > > qResults = statement.execute(); > > then i want to add stuff like this where there are known named queries > with > known typed parameters > > statement = conn.getNamedStatement("getUsersByType"); > statement.setParameter("type", "admin"); > > qResults = statement.execute(); > > Elliot > > "Mark Mandel" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > Elliot, > > > > I've never (needed?) to use Java to write my own connection to my DB, > > I've always been able to go through a CF datasource - even if it is > > set up to go through a 3rd party jdbc driver. > > > > > I am creating some cfc to wrap my own database interactions but > cfquery > is a > > > pain if you want to use cfqueryparam. and build dynamic sql > statements > > > > I'm not sure what you mean by this? are you trying to extend cfquery > > or something? > > > > I'm a tad confused :oP > > > > Mark > > > > On Thu, 12 Aug 2004 10:22:25 +1000, Elliot Russo > > <[EMAIL PROTECTED]> wrote: > > > Thanks Mark, seems the vendor driver is the way to go, found them > with > the > > > client install. > > > > > > Have you/can you interact with the java objects from cf or do I > need to > do > > > the whole shebang from in java. > > > > > > What i mean is should/can I create a class, to create and return a > > > connection object and use that in cf to excute prepared statements > etc > or am > > > i going to be casting all the time and be unable to access some > method > > > properly. > > > > > > > > > > > Elliot > > > > > > -- > > E: [EMAIL PROTECTED] > > W: www.compoundtheory.com > > ICQ: 3094740 > > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > -- e: greg.stewart(a)gmail.com w: http://gregs.tcias.co.uk/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
