Win 7 64Bit with SQL 2008 DSN Railo 3.2 Connection Problem?

I Just found: http://groups.google.com/group/railo/browse_thread/thread/b7c9614cf39090b5

Not for lack of trying, I couldn't get Railo 3.2 to connect to my local sql2008 datasource on my new 64bit windows pc. Turns out, microsoft changed something for datasources in windows 7..

The solution as it turns out is to create a datasource under "MSSQL - Microsoft SQL Server (Vendor jTDS)"  ... Apparently the regular Microsoft Vendor driver doesn't work for Microsoft anymore.

Customizing Error Messages in Railo 3.2 with IIS 7

I was having difficulty troubleshooting a new app on my server, and couldn't get past IIS'7 Error 500 screen. The default setting is to only show error messages when you're running the site on the server itself. I followed a helpful blog post to enable errors.

Many thanks to http://www.cfmldeveloper.com/post.cfm/enabling-railo-errors-on-iis7

Railo 3.2 Site on IIS7

Railo 3.2 Apache, with IIS7 on Windows server 2008 R2.

I had the Apache server.xml set up correctly, as I've done countless times... but the default document wasn't working... and all non .cfm files were pointing to IIS's default site.

Turns out, I hadn't made a website entry in IIS, to parallel the configuration in Apache's server.xml entry.... Its all making sense now. Requests routed to apache knew where they were because of server.xml, but IIS had to have a configuration to set the webroot for all the other file types (such as .html, .css, and .jpeg)

I still can't figure out how to make a site in IIS that isn't inside C:\inetpub\wwwroot\ as the permissions get all screwy... I'll leave that for another day.

Railo DSN with MSSQL2008r2

So today I had a frustrating hour or so trying to add a new SQL Server Authentication Mode login to my SQLExpress 2008R2 instance using management console (for the purpose of connecting with Railo 3.2 ).. which is supposed to be trivial... turns out it is... when you don't have SQL Server Authentication mode shut off, as it was in my installation.

For me, it was Steps 11 and 12 that were key.

http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

Railo 3.2 on IIS 6.0

For clarity: These notes are for Resin 3.1 and Railo 3.2.0.001 rc to be used with IIS 6.0 as the primary webserver.

1) The installation package contains a setup.exe which configures Caucho-Resin.

1) In the example, resin.conf has an entry added for foo.com in which the root-directory attribute is set to "foo.com", when it should be set to simply "." in the case of Railo 3.x

2) Also, during my multiple attempts at the installation process, I came across other documents saying that an ISAPI filter was required on the "Web Sites" node of IIS... in my case.. it only worked without doing adding an ISAPI filter.

3) adding a /scripts directory? I added a scripts directory, with a copy of isapi_srun.dll into /InetPub/vhosts/

4) The default cflocation in index.cfm to the railo-context admin was driving me crazy... I had no idea where I actually was~!! Without adding an entry to resin.conf, my site was root-pointing to C:\railo\webapps\ROOT and launching index.cfm ... which I discovered later was redirecting via cflocation to the railo-context admin... so it was working... but I didn't know it! So, to save my sanity until I got everything going, I temporarily edited C:\railo\webapps\ROOT\index.cfm to require a manual click (a href=) instead of cflocation to show me where I was, and where I was going.

5) I also now have a new services entry called "Railo 3.1 Server" set as Automatic, which launches:

"C:\railo\httpd.exe" -service -Xms256M -Xmx512M -conf conf/resin.conf -java_home jre/ -java_exe jre/bin/java

Guide for adding Caucho Resin as a windows service if you don't have it already configured for you: http://wiki.caucho.com/Windows_service

Railo does Array's By Reference

I'm working away developing an app in Railo, and I just read Ben Nadel's post about how Coldfusion passes Arrays by Value (which is nuts btw, when you think about it) ... and how to pass an array By Reference using java.util.ArrayList directly.

Thankfully, Railo passes Arrays by Reference! ... and since I'm working on a new project there's no reverse compatibility issue moving from Coldfusion.

arrA = ArrayNew();

ArrayAppend(arrA,"Hello World");

arrB = arrA;

ArrayAppend(arrB,"Hello Jello");

writeDump(arrA);

writeDump(arrB);

Array
1	string Hello World
2	string Hello Jello

Array
1	string Hello World
2	string Hello Jello