Configuring Oracle Thin Client in CFMX

For CFMX Enterprise and Professional

  1. Save the classes12.zip file to {CFMX_HOME}WEB-INFlib
  2. Edit the JVM Java page in CFAdmin,
  3. Add {CFMX_HOME}WEB-INFlibclasses12.zip to the class path
  4. Restart the CFMX App server
  5. Add datasource using the "other" driver
  6. JDBC URL: jdbc:oracle:thin:@[dbservername]:1521:[SID]
  7. Driver Class: oracle.jdbc.driver.OracleDriver
  8. Configure username, password, submit

For CFMX J2EE (WebSphere in this case)

  1. save the classes12.zip file to {WAS_HOME}AppServerlib
  2. open the WAS admin console
  3. add {WAS_HOME}AppServerlibclasses12.zip to the class path in WAS Console, submit, then save changes.
  4. restart the WAS server
  5. Add datasource in CFAdmin using the "other" driver
  6. JDBC URL: jdbc:oracle:thin:@[dbservername]:1521:[SID]
  7. Driver Class: oracle.jdbc.driver.OracleDriver
  8. Configure username, password, submit

Configuring Sun JDBC-ODBC Bridge in CFMX

I've seen some rare cases where ColdFusion MX's JDBC Type III driver is not able to connect to ODBC datasources under certain conditions.
The JDBC Type III drivers in CFMX are the drivers that use the ODBC Server and ODBC Agent Services as the middleware component in the translation, such as the driver marked as "ODBC Socket" and the one marked as "Microsoft Access". The latter happens to be the same as the former but given an obvious name just to be clear about which to chose if you are using MS Access.

The workaround in those cases was given by using the Sun JDBC:ODBC Bridge which is already built into the JVM ColdFusion is running on. The disadvantage of this driver is that it is single threaded, and thus very slow. Here's how you can configure your ColdFusion MX server to use the Sun JDBC:ODBC Bridge.





  1. CFAdmin > Datasources > Create new datasource with driver labeled "Other"


  2. Driver Class: sun.jdbc.odbc.JdbcOdbcDriver


  3. JDBC URL: jdbc:odbc:[datasource];


  4. Replace "[datasource]" with the ODBC datasource name from the Control Panel ODBC Administrator


  5. Driver Name is an optional field where you can type a label for how you like to call the driver, can leave empty


  6. Complete the username and password


  7. Submit



Apache Security Secrets Revealed

WHITEPAPER




RedHat just posted a new link for a whitepaper on Apache Security, however the date on the paper is October of last year. Nevertheless, looks worth reading...

JLCA 2.0: Convert JSP and Servlets to ASP.NET

Interesting article on Internet Week yesterday.




""The key new feature of JLCA 2.0, which runs within Visual Studio .Net, is the ability to convert Java Server Pages (JSPs) and servlet applications to ASP.Net, according to Microsoft. The product is available for "http://msdn.microsoft.com/vstudio/downloads/tools/jlca" target="_blank">download.






To support the use of JLCA 2.0, Microsoft also published a JSP-to-ASP.Net Migration Guide, which provides resources to help developers migrate to ASP.Net. The guide supports the documented migration with videos, white papers, sample code and additional resources.""