RE: Java in CF (CFMX) - MM Drivers
If you have a question that is directed directly to Macromedia then you need to contact Macromedia directly. That means either contacting support, or sending your question to me. At the least CC us on your post. Otherwise, there is a chance we might not see your original question, or a follow up. We spend a lot of time helping people out on this list. Most of the people from Macromedia who are on the list and help people out are not here because they have to be, but because they love and are dedicated to the product and community. However, again, if you need direct support from Macromedia, then you need to contact us directly. We have processes and channels setup to provide the type of 1 on 1 support /communication that you appear to be looking for. Again, please feel to email me directly with any questions that you have that are addressed to the macromedia in general, or the CF Team in particular. btw, this should not be taken to mean that we will not continue to be active on the list helping people out. It just means that with the high volume of messages on the list, we miss questions / topics sometimes. mike chambers [EMAIL PROTECTED] > -Original Message- > From: Joe Eugene [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 13, 2002 12:49 PM > To: CF-Talk > Subject: RE: Java in CF (CFMX) - MM Drivers > > > MM-Product Team... > When Vernon Viehe(MM Community manager) exited.. there were > promises from > MM..that MM would provide better support through other MM Folks... > *Is this a JOKE?* > Vernon did a much better job..than whoever is in that place now. > > This Thread Question was directed to MM..since there is no > DOCUMENTATION on > details of drivers and such.. NEVER Got an Answer.! > > CFMX Updater 2 Release Notes... > DB2-Specific Issues > An exception could be generated when connecting to DB2 AS/400 v4R5. > 15002962(ID). > > ***STILL DOING THE SAME THING with V4R5 and V5R1*** > > Is MM(Product-Team) going to provide the documentation > details.. or do we have > to wait another year.. for a reponse...? > > BTW.. This Thread is dating back early last Month. > > Joe > > > On Mon, 09 Dec 2002 07:20:57 -0800 Joe Eugene > <[EMAIL PROTECTED]> wrote: > > > 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/jdbcrelhi > ghlights.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 > > 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- >
RE: Java in CF (CFMX) - MM Drivers
MM-Product Team... When Vernon Viehe(MM Community manager) exited.. there were promises from MM..that MM would provide better support through other MM Folks... *Is this a JOKE?* Vernon did a much better job..than whoever is in that place now. This Thread Question was directed to MM..since there is no DOCUMENTATION on details of drivers and such.. NEVER Got an Answer.! CFMX Updater 2 Release Notes... DB2-Specific Issues An exception could be generated when connecting to DB2 AS/400 v4R5. 15002962(ID). ***STILL DOING THE SAME THING with V4R5 and V5R1*** Is MM(Product-Team) going to provide the documentation details.. or do we have to wait another year.. for a reponse...? BTW.. This Thread is dating back early last Month. Joe On Mon, 09 Dec 2002 07:20:57 -0800 Joe Eugene <[EMAIL PROTECTED]> wrote: > 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 > 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 >
RE: Java in CF (CFMX) - MM Drivers
> > believe a third-party JDBC driver would be managed just like one of the > drivers included with CFMX, > is true. Have you done any tests on how the driver connection pooling works with native JDBC type IV other connections? Yea.. i have configured Oracle 8.0.5 and AS400 DB2 V5R1 Native Drivers and they are working... but am clueless.. on the how this works... without seeing some documentation of CFQUERY implementation. It works... How is the QUESTION? Thanks Joe > -Original Message- > From: Rob Rohan [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 1:18 PM > To: CF-Talk > Subject: RE: Java in CF (CFMX) - MM Drivers > > > We recently moved from SQL7.0 with the included MX > (DataDirect/Merant) JDBC > drivers, to SQL2000 with MS provided JDBC drivers and it was (aside from > microsofts non-standard jdbc uri) simple. In other words > > > believe a third-party JDBC driver would be managed just like one of the > drivers included with CFMX, > > is true. > > Rob > > http://treebeard.sourceforge.net > http://ruinworld.sourceforge.net > Scientia Est Potentia > > -Original Message- > From: Phil Costa [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 5:44 AM > To: CF-Talk > Subject: RE: Java in CF (CFMX) - MM Drivers > > > 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://SqlServer > Name: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 ide
RE: Java in CF (CFMX) - MM Drivers
We recently moved from SQL7.0 with the included MX (DataDirect/Merant) JDBC drivers, to SQL2000 with MS provided JDBC drivers and it was (aside from microsofts non-standard jdbc uri) simple. In other words > believe a third-party JDBC driver would be managed just like one of the drivers included with CFMX, is true. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:44 AM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers 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 <[EMAIL PROTECTED]> > 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. Meth
RE: Java in CF (CFMX) - MM Drivers
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 &
RE: Java in CF (CFMX) - MM Drivers
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 <[EMAIL PROTECTED]> > 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).
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 <[EMAIL PROTECTED]> > 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. > > Obviousl
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 <[EMAIL PROTECTED]> > 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 applicatio
Re: Java in CF (CFMX) - MM Drivers
On Sunday, Nov 24, 2002, at 20:05 US/Pacific, Joe Eugene wrote: > Thanks Sean once again for pointing out the license thing, anyways i > got > it working with SQL Server Drivers. Yes, those would not be protected by the Macromedia license I guess. > On windows, this is what worked for me. > "java -cp .;G:\CFusionMX\lib\macromedia_drivers.jar JavaFileName" > The semi colon was whats missing...Picky! Even the ClassPath setting > had > to include ".;" at the begining. Ah, that's makes sense... On Windows, ':' is a valid part of a file path. On Unix it isn't so it can be used as a separator (which is also how it works on the Mac since that uses a Unix shell underneath). Windows requires ';' instead. The '.;' is '.' (current directory) ';' (separator) to tell Java to search the current directory (for your SpoDiscParts class file)... > Thanks for your help and sorry for taking a lot of your time on IM, the > other day. Not a problem... Sorry I didn't pick up on the difference in path separators on Windows... Not much of a Windows user, I'm afraid... Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Java in CF (CFMX) - MM Drivers
Thanks Sean once again for pointing out the license thing, anyways i got it working with SQL Server Drivers. > really puzzled since I got it to work on my Mac and we seemed to be > typing the same commands (modulo you using Windows). Yes.. it was really frustrating.. i couldnt get it to work with the same commands.. On windows, this is what worked for me. "java -cp .;G:\CFusionMX\lib\macromedia_drivers.jar JavaFileName" The semi colon was whats missing...Picky! Even the ClassPath setting had to include ".;" at the begining. Thanks for your help and sorry for taking a lot of your time on IM, the other day. Joe > -Original Message- > From: Sean A Corfield [mailto:[EMAIL PROTECTED]] > Sent: Sunday, November 24, 2002 8:45 PM > To: CF-Talk > Subject: Re: Java in CF (CFMX) - MM Drivers > > > On Sunday, Nov 24, 2002, at 14:23 US/Pacific, Joe Eugene wrote: > > I got this partially resolved... Sean helped out.. Thanks Sean. > > Glad to hear you got it working after we'd been chatting on IM. I was > really puzzled since I got it to work on my Mac and we seemed to be > typing the same commands (modulo you using Windows). > > > 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." > > Yes, I was a little surprised that this was not the error you were > getting when you originally posted and I expected you'd run into this > once you'd got the drivers loaded... sorry! :) > > > 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)? > > Yes, basically. When you attempt to run the Macromedia driver classes, > they check that a valid CFMX Enterprise license is present in the > runtime environment. That means you can invoke them from CF, you can > invoke them from JSP running on CFMX but you cannot invoke them outside > the CFMX environment (unless you can figure out how to persuade a > standalone Java application to 'find' the CFMX license of course... > which would probably involve violating your CFMX license agreement!). > > Sean A Corfield -- Director, Architecture > Web Technology Group -- Macromedia, Inc. > tel: (415) 252-2287 -- cell: (415) 717-8473 > aim: seancorfield -- http://www.macromedia.com > An Architect's View -- http://www.corfield.org/blog/ > > Introducing Macromedia Contribute. Web publishing for everyone. > Learn more at http://www.macromedia.com/contribute > > ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Java in CF (CFMX) - MM Drivers
On Sunday, Nov 24, 2002, at 14:23 US/Pacific, Joe Eugene wrote: > I got this partially resolved... Sean helped out.. Thanks Sean. Glad to hear you got it working after we'd been chatting on IM. I was really puzzled since I got it to work on my Mac and we seemed to be typing the same commands (modulo you using Windows). > 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." Yes, I was a little surprised that this was not the error you were getting when you originally posted and I expected you'd run into this once you'd got the drivers loaded... sorry! :) > 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)? Yes, basically. When you attempt to run the Macromedia driver classes, they check that a valid CFMX Enterprise license is present in the runtime environment. That means you can invoke them from CF, you can invoke them from JSP running on CFMX but you cannot invoke them outside the CFMX environment (unless you can figure out how to persuade a standalone Java application to 'find' the CFMX license of course... which would probably involve violating your CFMX license agreement!). Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| 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
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 > <[EMAIL PROTECTED]> 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 horiz
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 <[EMAIL PROTECTED]> 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 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