装上oracle驱动

前两天看了下ror的东西，觉得很有趣，我也动手来搞一下。

ruby，rails顺手抓下来，netbeans也挺有意思。不过默认ms是mysql，这个可挺没意思，我可是要用oracle

动手吧。

http://www.oracle.com/technology/global/cn/pub/articles/haefel-oracle-ruby.html

 

http://ruby-oci8.rubyforge.org/en/InstallForInstantClient.html

http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html

sudo vi /etc/profile

export DYLD_LIBRARY_PATH=/opt/oracle/instantclient10_1

http://rubyforge.org/frs/?group_id=256

 

RC_ARCHS=i386
export RC_ARCHS

/oracle/ruby-oci8-2.0.3

make

make install

 

ruby setup.rb config

ruby setup.rb setup

ruby setup.rb install

MD，失败了。。。。

最后发现还是这个靠谱

http://blog.rayapps.com/2008/04/24/how-to-setup-ruby-and-new-oracle-instant-client-on-leopard/

sudo vi /etc/profile

export DYLD_LIBRARY_PATH="/opt/oracle/instantclient10_1"
export SQLPATH="/opt/oracle/instantclient10_1"
export NLS_LANG="AMERICAN_AMERICA.UTF8"
export PATH=$PATH:$DYLD_LIBRARY_PATH

 

 

 

ORACLE_PATH=/opt/oracle/instantclient10_1
export DYLD_LIBRARY_PATH="${ORACLE_PATH}"
export SQLPATH="${ORACLE_PATH}"
export TNS_ADMIN="${ORACLE_PATH}"
export NLS_LANG="AMERICAN_AMERICA.UTF8"
export PATH=$PATH:$DYLD_LIBRARY_PATH

/oracle/ruby-oci8-2.0.3

 

ruby setup.rb config
make
sudo make install

 

 

 

控制台可以了。。。但是ide里还是不可以，

=> Booting WEBrick
=> Rails 2.3.5 application starting on http://0.0.0.0:52820
oci8lib.c:164:in oci8lib.bundle: OCI Library Initialization Error (OCIError)
    from /Library/Ruby/Site/1.8/rubygems/custom_require.rb:31:in `require'
    from /Users/huangbin/.gem/ruby/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:156:in `require'
    from /Users/huangbin/.gem/ruby/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:521:in `new_constants_in'
    from /Users/huangbin/.gem/ruby/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:156:in `require'
    from /Library/Ruby/Site/1.8/oci8.rb:25
    from /Library/Ruby/Site/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
    from /Library/Ruby/Site/1.8/rubygems/custom_require.rb:31:in `require'
    from /Users/huangbin/.gem/ruby/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:156:in `require'
     ... 35 levels...
    from /Library/Ruby/Site/1.8/rubygems/custom_require.rb:31:in `require'
    from /Users/huangbin/Desktop/ror/rorMiniBiz/script/server:3
    from -e:1:in `load'
    from -e:1

Process finished with exit code 1

 

===

追加一行

export ORACLE_HOME=/opt/oracle/instantclient10_1

无效：（

 

唉。。。

原来把昨天加的系统变量在ide里搞一下就可以了。

 

以后生产系统看来还真得需要很多时间阿。

 

 

http://www.iteye.com/topic/191071

 

NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"

 

上边的解决方法无效。。。

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

 

回家了，搞的时候发现竟然有乱码问题，nnd，google

http://even.wordpress.com.cn/tag/rails-mysql-utf8/

费了九牛二虎之力，终于搞定了。
Rails下面database.yml，增加配置encoding:utf8
Mysql配置文件：
[mysqld]
default-character-set=utf8
defalut-collation=utf8_general_ci
character-set-server=utf8
collation-server=utf8_general_ci

create database [name] default character set utf8 default collate utf8_general_ci

 

仔细一看原来是创建database的时候不是utf8.。。

好了，天下太平，我要继续了

 

 

 

^^^^^^^^^^^^^^^^^^^^^

 

 

我靠。。。

爽阿

上传文件处理

字符转换           

require'iconv'

usernameutf8 =   Iconv.iconv("UTF-8", "GBK", csvs[4]).to_s

 

 

 

分页will_paginate

model加一句

require 'will_paginate'

 

Controller加一句

@als = Al.paginate :page => params[:page]||1, :per_page => 50

 

页面一句

           <%= will_paginate @alis, :prev_label=> '上一页',:next_label   => '下一页' %>