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 ...

It is confirmed that I will present the topic 'Head First i18N (Internationalization)' topic at the next IECFUG meeting.

Here are the notes about the presentation:

"This presentation will explain the first steps of creating multi-language applications and methods in ColdFusion with best practices. The main goals will be explaining the structure of multi-language 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."

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...