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 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
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- 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
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). 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
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 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
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. 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
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 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
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. 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
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 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
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 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
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=subscribeforumid=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
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=subscribeforumid=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 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=subscribeforumid=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
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=subscribeforumid=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
