Oğuz Demirkapı

I will present the topic 'Designing & Architecturing Multilingual (i18N) Applications' at upcoming cf.Objective() 2009 conference at Minneapolis, MN between May 14-16, 2009.

Here is the excerpt about my presentation:

This presentation will explain the steps of designing and architecturing multilingual applications and methods in ColdFusion with best practices. The main goals will be explaining the structure of multilingual applications, defining requirements and solutions, and providing best practices with code samples.

Explaining the theory for i18N (internationalization), L10N (localization), g11N (globalization) and other known approaches, defining opportunities to create effective solutions such as Java platform tools usage or designing better database or setting up your environment to make multilingual applications easier to write are some of the topics.

If you have interest to learn more about multilingual approaches on software development with some sample code in ColdFusion, you are always welcomed to attend my presentation.

See you there ...

 

We are using MS SQL Server for our main application and we have some issues with the Unicode support on default delivered driver etc. After testing some resources we have decided to change our main SQL JDBC driver which we use to connect to the SQL Server. We have selected jTDS one which is known as a robust solution and having it as free was nice. :)

Here are the steps to install jTDS JDBC driver on a ColdFusion 8 server:

• Download the new driver from http://jtds.sourceforge.net In my case the file name was "jtds-1.2.2-dist.zip"
• Extract the file and find the jar file such as "jtds-1.2.2.jar".
• Copy the jar file (jtds-1.2.2.jar) into ColdFusion lib directory ("...\ColdFusion8\lib" or "...\WEB-INF\cfusion\lib")
• Restart ColdFusion.
• Create a new DSN in ColdFusion administrator as selecting "other" and put following information
  • CF Data Source Name: your data source name
  • JDBC URL: jdbc:jtds:sqlserver://yourServerName:1433/yourDatabaseName;
  • Driver Class: net.sourceforge.jtds.jdbc.Driver
  • Driver Name: Any name that you prefer (I said jTDS)
  • And the rest is as always your username, password etc.

After having these settings, you should be able to connect your SQL Server with your new jTDS JDBC driver.

Have fun!

Read more...

Here is my presentation slides from todays session.

"The Power of MySQL"

I think it was pretty informative presentation about the basics of MySQL. I also feel that MySQL is a widely used platform in development but not in production. This is something that I expected from ColdFusion community when I think about MS SQL Server usage. But I think this will change by the time especially because of the power of the MySQL server and the open source community projects which mostly prefer MySQL as main database platform.

Luckily we have a native support in ColdFusion 8 and this is something that would be a good reason completing ease of MySQL usage especially when I remember the dilemma on embedded drivers in ColdFusion and old JDBC driver installation requirements etc.

I am also excited about the new MySQL storage engine Falcon. I feel that this will be something important in the new future for the database world preferences.

Please feel free to share your comments and ask any question that you may have.

Read more...

If you are using Microsoft Access with Unicode drivers which is defined in ColdFusion administrator, you may have problems with boolean parameters.

Following query is a simple filter for active records but because of problems on the default drivers for MS Access it will return null.

Read more...