Seems I frequently need to kill some session due to the network issue or other client issue to submit data to oracle, but each time I google the answner, it takes me at least 5 minutes, so I decide to write done SQL and command here:

SELECT a.sid,a.serial#, a.username,c.os_user_name,a.terminal,
b.object_id,substr(b.object_name,1,40) object_name
from v$session a, dba_objects b, v$locked_object c
where a.sid = c.session_id
and b.object_id = c.object_id

alter system kill session '14,397';

The Unobtrusive JavaScript feature introduce from Rails 3.1 and the Rails Guide have a whole chapter to say about how to use, but the jquery-ujs much more feature not talked in official Rails Guide.

Except the AJAX forms and some link_to feature, one of my favorite features is AJAX HTTP request back to server when one of the forms input control content changed by user and lost focus. Such feature is very similar to ASP.NET AutoPostBack, which is very handy when you need user fill some content first before you can help them auto fill the rest.

I used to write post about install ruby 2.0.0-p195 in windows one years ago, the ruby language improved a lot this year and it's gems. But windows platform is still not active compare with Mac OS X or Linux in rubyist.

There are two thick I believe worth to write down for the windows rubyist:

Install debugger

1. clone the debugger-ruby_core_source to local folder, e.g. C:\git\debugger-ruby_core_source
2. copy C:\git\debugger-ruby_core_source\lib to C:\Ruby200\lib\ruby\gems\2.0.0\gems\debugger-ruby_core_source-1.3.2
3. gem install debugger.

Install bson

Modify the win32.h file (@C:\Ruby200\include\ruby-2.0.0\ruby) before install gems bson

static inline double
rb_w32_pow(double x, double y)
{
    return powl(x, y);
}
#elif defined(__MINGW64_VERSION_MAJOR)
 
#ifndef _PC_64
#define _PC_64 0x00000000
#endif
 
#ifndef _MCW_PC
#define _MCW_PC 0x00030000
#endif
 
/*
 * Set floating point precision for pow() of mingw-w64 x86.
 * With default precision the result is not proper on WinXP.
 */

Genymotion is very fast compare to original android simulator, but make it work in Intranet takes me quite a lot of time.

In fact, it's simple: Open the Oracle VM VirtualBox manager, Settings->Network, Select the Adapter 2 (Adapter 1 is used primary by Genymotion and cannot change), using Bridged Adapter and select the working network card in Intranet (not wireless usually).

Ubuntu 12.04 LTS already have the freetds package, so just running below command will install SQL Server support for Rails.

apt-get install freetds-dev tdsodbc
gem install tiny_tds
gem install activerecord-sqlserver-adapter

#/etc/odbcinst.ini
[FreeTDS]
Description = ODBC for Microsoft SQL
#choose one of line based on your version
Driver      = /usr/lib/i386-linux-gnu/odbc/libtdsodbc.so
Driver      = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
UsageCount  = 1
Threading   = 2

About the driver location, you may need to find the libtdsodbc first at via find /usr/lib -name libtdsodbc.so.

#/etc/odbc.ini
[FreeTDS-TECN]
Description     = MS SQL connection to 'SDSS' database
Driver          = FreeTDS
Database        = TECN
ServerName      = CVPALPIP01
Trace           = No

#/etc/freetds/freetds.conf
[CVPALPIP01]
        host = 10.70.2.77
        port = 1433
        tds version = 7.0 # or 8.0

tecn:
  adapter: sqlserver
  dataserver: '10.70.2.77\SDSS'
  database: TECN
  username: only_read
  password: only_read

# app/models/tecn.rb
class Tecn < ActiveRecord::Base
  # No corresponding table in the DB.
  self.abstract_class = true
  establish_connection("tecn")
  def readonly?
  	true
  end
end

Just attend company training and below is quick notes/tips coming from trainer.

• Always using mm as basic unit in drawing, no matteer your are drawing archtecture/mechanical.
• Workspace setting is to classic, Options->User Preferences for Right-click Customization is set to 1/2/1 (repeat last cmd/shortcut menu/ENTER) mode is recommand.
• Notice the Trim is only trim and can not delete whole object.
• Menu undo is based on action, but Ctrl+Z can undo step in an action.
• Polar Array can product beautiful result if set very high repeat rate.
• Layer must be use in practical drawing, if output to A4, line weight should be larger than 0.53mm to see a noticable result.
• Multiline must explode before trim
• Overkill can be used to clean duplicate line and it's original express tools can be load by MENULOAD and select acetmain.cuix.
• The Block should draw in layer 0.
• The Block insert allow add negative value to get a mirror effect.
• Delete Block should use PURGE command
• Multi Text Text Height is based on the draw dimenstion
• Multi Text upper side text and down side text should using stack
• x/400 x is longest line in demension, 14000/400=40
• Change line type, show detail to adjust the line Global scale factor if the dash style is too small to display completely.
• You can turn off InfoCenter by change Windows Registry:

[HKEY_CURRENT_USER\Software\Autodesk\AutoCAD\R19.1\ACAD-D005:409\InfoCenter]
"InfoCenterOn"=dword:00000000

Step 1, setting the autoindex on in conf

server {
  listen       80;
  server_name  cvpforms; #replace your DNS name
  server_name  cvpforms.sandisk.com;
  rails_env    development; #development/production
  root         /var/rails_apps/pl-form/public;
  passenger_enabled on;
  client_max_body_size 5m;
  location /rf_image {
    autoindex on;
    autoindex_exact_size off;
  }
}

Step 2, resolve the 403 forbidden error using below command if you meet such error.

chmod 755 * -R # in /home/pl-form/pl-form/public/rf_image

Microsoft now is become quit outdated technology after they release so many outdated technology, but WebMatrix is in my opinion, the best tools to right node.js tools in Windows.

But I'm used to using port 3000 as default debug port since I'm switch to Ruby & Rails, so really not want to change port time to time, so here is how to change binding port.

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.applicationHost>
        <sites>
            <site name="firstNode" id="1">
                <application path="/" applicationPool="UnmanagedClassicAppPool">
                    <virtualDirectory path="/" physicalPath="D:\EricDocuments\My Web Sites\firstNode" />
                </application>
                <bindings>
                    <binding protocol="http" bindingInformation="*:3000:localhost" />
                </bindings>
            </site>
        </sites>
    </system.applicationHost>
</configuration>

Just find the your node.js project entry in applicationhost.config and change port.

Confirm works at Ubuntu 14.04 / 12.04.

• knitr - A general-purpose package for dynamic report generation in R
• rmarkdown - Dynamic Documents for R
• SixSigma - Six Sigma Tools for Quality and Process Improvement
• sqldf - Perform SQL Selects on R Data Frames
• tseries - Time series analysis and computational finance
• quantmod - Quantitative Financial Modeling Framework
• doBy - Groupwise summary statistics, general linear contrasts, population means (least-squares-means), and other utilities
• rJava - Low-Level R to Java Interface to support RWeka and xlsx

R CMD javareconf

• xlsx - Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files
• RCurl - General network (HTTP/FTP/...) client interface for R

apt-get install libcurl-dev

• devtools - Tools to make developing R code easier
• gplots - Various R programming tools for plotting data
• ggmap - A package for spatial visualization with Google Maps and OpenStreetMap
• googleVis - Interface between R and the Google Chart Tools
• rworldmap - Mapping global data, vector and raster.
• rgdal - Bindings for the Geospatial Data Abstraction Library

apt-get install libgdal1-dev
apt-get install libproj-dev # or libproj if not found

• ROracle - Oracle database interface (DBI) driver for R.

  ROracle need Oracle Client install, and further additional setup procedure

• pls - Multivariate regression methods Partial Least Squares Regression (PLSR), Principal Component Regression (PCR) and Canonical Powered Partial Least Squares (CPPLS).

• assertthat - assertthat is an extension to stopifnot() that makes it easy to declare the pre and post conditions that you code should satisfy.

• dplyr - A fast, consistent tool for working with data frame like objects, both in memory and out of memory.

• data.table - Fast aggregation of large data (e.g. 100GB in RAM), fast ordered joins, fast add/modify/delete of columns by group using no copies at all, list columns and a fast file reader (fread). Offers a natural and flexible syntax, for faster development.

• earth - Build regression models using the techniques in Friedman's papers "Fast MARS" and "Multivariate Adaptive Regression Splines".

• kernlab - Kernel-based machine learning methods for classification, regression, clustering, novelty detection, quantile regression and dimensionality reduction. Among other methods kernlab includes Support Vector Machines, Spectral Clustering, Kernel PCA, Gaussian Processes and a QP solver.

• caret - Classification and Regression Training, Misc functions for training and plotting classification and regression models.

• rpart - Recursive Partitioning and Regression Trees

• party - A Laboratory for Recursive Partytioning

• RWeka - An R interface to Weka (Version 3.7.12). Weka is a collection of machine learning algorithms for data mining tasks written in Java, containing tools for data pre-processing, classification, regression, clustering, association rules, and visualization.

• ipred - Improved predictive models by indirect classification and bagging for classification, regression and survival problems as well as resampling based estimators of prediction error.

• randomForest - Breiman and Cutler's random forests for classification and regression

• gbm - Generalized Boosted Regression Models

• Cubist - Regression modeling using rules with added instance-based corrections

• VGAM - Vector Generalized Linear and Additive Models, An implementation of about 6 major classes of statistical regression models. At the heart of it are the vector generalized linear and additive model (VGLM/VGAM) classes. Currently only fixed-effects models are implemented, i.e., no random-effects models. Many (150+) models and distributions are estimated by maximum likelihood estimation (MLE) or penalized MLE, using Fisher scoring.

• mda - Mixture and flexible discriminant analysis, multivariate adaptive regression splines (MARS), BRUTO...

• klaR - Miscellaneous functions for classification and visualization developed at the Fakultaet Statistik, Technische Universitaet Dortmund

• e1071 - Misc Functions of the Department of Statistics, Probability Theory Group (Formerly: E1071), TU Wien

• C50 - C5.0 decision trees and rule-based models for pattern recognition.

• ROCR - Visualizing the Performance of Scoring Classifiers

• ISLR - Data for An Introduction to Statistical Learning with Applications in R