Phil/MM Product Team > All the drivers are from DataDirect/Merant > except for the mySQL driver.
Are you sure about the above? What Java Type IV driver is provided with CFMX for DB2 UDB? This? http://www.datadirect-technologies.com/products/jdbc/jdbcrelhighlights.asp The above driver supports DB2 UDB for AS400(iSeries) for V5R4 and V5R1 OS Versions. I havent been able to configure this connection with CFMX..(got a Native JTOpen connection working) and i dont think AS400 DB2 UDB is supported.... Can you give some documentation on exactly what drivers CMFX uses(Author/Versions)? It would be very helpful to see some documentation on implementation of "CFQUERY" and how connection pooling works in CFMX. Thanks Joe On Mon, 9 Dec 2002 08:43:38 -0500 Phil Costa <[EMAIL PROTECTED]> wrote: > Better late than never ;-) > > All the drivers are from DataDirect/Merant > except for the mySQL driver. > > I believe a third-party JDBC driver would be > managed just like one of the drivers included > with CFMX, but I have to verify that. > > Phil > > -----Original Message----- > From: Joe Eugene [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, December 07, 2002 11:01 PM > To: CF-Talk > Subject: RE: Java in CF (CFMX) - MM Drivers > > > >Anybody from MM Product Team can explain this? > on November 24, 2002 > >5:24 PM > > Product Teams reply 2 weeks later on the > Thread!. Talked to Sean and figured out this > already. Anyways since you mentioned it, Are > all CFMX Native Drivers "DataDirect" > Drivers(Oracle,DB2 UDB). If you configure a > Type IV Native Datasource in CMFX... Does CFMX > manage connection pooling? Single Connection.. > Multiple Statements? How does this work? > > Thanks > Joe > > > -----Original Message----- > From: Phil Costa [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 4:49 PM > To: CF-Talk > Subject: RE: Java in CF (CFMX) - MM Drivers > > > It's throwing that error because you're trying > to access the JDBC drivers in an unlicensed > fashion. The DataDirect drivers are licensed > for use with ColdFusion, which includes support > for JSP as well as CFML, not the scenario > you're describing. > > Phil Costa > Sr. Product Manager, ColdFusion > Macromedia > > > > -----Original Message----- > From: Joe Eugene [mailto:[EMAIL PROTECTED]] > Sent: Sunday, November 24, 2002 5:24 PM > To: CF-Talk > Subject: RE: Java in CF (CFMX) - MM Drivers > > > I got this partially resolved... Sean helped > out.. Thanks Sean. It was a classpath problem. > However after i load the > drivers(macromedia.jdbc.MacromediaDriver) which > is in the "lib" directory of your > installation(eg. > "G:\CFusionMX\lib\macromedia_drivers.jar") and > give it the connection url.. Connection con = > DriverManager.getConnection("jdbc:macromedia:sqlserver://SqlServerName:1433" > ,"userid","Pwd"); > > I get an Exception.. > "macromedia.jdbc.MacromediaDriver$InvalidLicenseException: > An Enterprise license is needed to use the > Macromedia JDBC Drivers on the DB2, Oracle, > Sybase and Info rmix servers." > > I am running CFMX Enterprise > version(6,0,0,48097). I have the same > connection working fine in JSP Pages under > CFMX. Are CFMX Enterprise drivers protected > from usage in Java Applications(Console/Swing)? > Anybody from MM Product Team can explain this? > > Joe > > > > -----Original Message----- > > From: Joe Eugene > [mailto:[EMAIL PROTECTED]] > > Sent: Friday, November 22, 2002 4:11 PM > > To: CF-Talk > > Subject: RE: Java in CF (CFMX) - MM Drivers > > > > > > I can use the CFMX MM DB drivers in a JSP > page..No problem. however.. > > i need to use it in a Java Application..tried > to load the Driver.. > > > Class.forName("macromedia.jdbc.MacromediaDriver") > > Keep getting ClassNotFound Error.. > > I put the macromedia_driver.jar in the class > path.. still not > > loading.. Do i need to import something? What > am i missing? > > > > Joe > > > > PS:Old Thread. > > I am just catching up on this Thread.. > > Isnt the idea to comply with J2EE > Architecture? Model-View-Controller > > model etc.. Why would some want to write > in-line Java..? Anyways... > > > > > > > > On Fri, 22 Nov 2002 09:09:16 -0500 Phil Costa > > > wrote: > > > > > The decision to disallow inline java code > was > > > definitely not a cut and dry one. One > reason > > > was definitely to enforce a cleaner > separation > > > of syntax; the other, which I hadn't > mentioned, > > > was to remove some additional complexity > from > > > the parsing/compiling process. Because of > the > > > differences between typing and syntax, > parsing > > > a page that had both Java and CFML/CFScript > > > would have been a bear. > > > > > > Phil > > > > > > -----Original Message----- > > > From: Jon Hall [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, November 22, 2002 2:37 AM > > > To: CF-Talk > > > Subject: Re: Java in CF (CFMX) > > > > > > > > > Thursday, November 21, 2002, 11:54:58 PM, > you > > > wrote: > > > > > > MT> Jon Hall wrote: > > > >> The case for allowing inline Java is > simple, > > > CF developers can use > > > >> Java without having to know everything > about > > > Java. Methods and > > > >> classes are easy to get. Compiling, > > > classpath's, and understanding > > > >> the lengths Java goes to, to abstract > > > everything, etc. is not. > > > > > > MT> Knowing just a little about a language > as > > > deep/complex as Java can > > > MT> be "dangerous" in a number of ways... > > > > > > MT> It's very easy to run into errors in > java > > > if you don't understand > > > MT> how it all works (ex. trying to > instantiate > > > an interface). One of > > > MT> the overriding strengths of CF is that > it > > > offers a great deal of > > > MT> power in an easy to use/learn style. > This > > > sort of thing, IMO, goes > > > MT> against that strength. > > > > > > MT> Mixing CFML and Java can very quickly > lead > > > to code that is horribly > > > MT> organized and difficult to > follow/maintain. > > > Obviously, anal coders > > > MT> will keep things nice and neat, but > others > > > will be mashing CFML, > > > MT> CFScript, Java, and SQL together > > > haphazardly. > > > > > > MT> Then there's the compatibility thing... > > > Java lists != CF lists. > > > MT> Java arrays != CF arrays. Etc. Again, > > > this can lead to confusion > > > MT> and cause all kinds of errors. > > > > > > I say let the coders (and the pm's who have > a > > > clue ) who write the applications make the > > > decision on what works in their > application. > > > I'm not trying to be facetious, but be > brutally > > > honest, I couldn't care less that anyone > else > > > thinks my hypothetical hybrid Java/CF code > is > > > unorganized or difficult to maintain, as > long > > > as those that it matters to, like my boss > and > > > clients don't care either. So I don't see > how > > > the fear of some overwhelming horde of > > > organized code existing somewhere out > there, > > > just over the horizon, really is a valid > > > argument against allowing inline Java > within CF > > > templates. > > > > > > >> CFQuery is the perfect example here. If > CF > > > gives developers the power > > > >> to do whatever they want within cfquery > > > tags, then why not java > > > >> within cfjava tags? Seems's inconsistent > to > > > me. Especially since > > > >> cfquery probably the biggest strength of > the > > > CF language. > > > > > > MT> SQL and CFML serve 2 different > purposes, > > > database manipulation and > > > MT> application logic. Java and CFML serve > the > > > same purpose, > > > MT> application logic. > > > > > > That's not entirely true. TSQL and probably > > > PLSQL work fine within cfquery tags. > Terrible > > > as it may sound, if I want to loop over a > > > cfquery that manipulates a cursor I can. > > > > > > I'm not saying there are not valid reasons > for > > > disallowing inline Java, I'm just saying > that > > > limiting the flexibility of CF just because > of > > > the possibility that nasty code may come > into > > > existence is not a good enough reason in my > > > opinion, but it's the only one that's been > put > > > forward by both you and Phil. I also don't > want > > > to start yet another debate about what's > good > > > and bad for CF, but as you said earlier, I > am > > > curious as well. Though I suspect it's > similar > > > reasoning behind not allowing cfscript to > call > > > tags in the past (not that I ever got the > > > reasoning behind that either). > > > > > > -- > > > jon > > > mailto:[EMAIL PROTECTED] > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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