> I hope Oracle enhanced adapter can surpport it too. Thank you.
> Actually, supportion is simple.
> first in class OCI8EnhancedAutoRecover

>     def initialize(config, factory =
> OracleEnhancedConnectionFactory.new)
>       @active = true
>       @username, @password, @database, = config[:username].to_s, config
> [:password].to_s, config[:database].to_s
>       @async = config[:allow_concurrency]
>       @prefetch_rows = config[:prefetch_rows] || 100
>       @cursor_sharing = config[:cursor_sharing] || 'similar'
>       @factory = factory
>       @privilege = config[:privilege] # add
>       @connection  = @factory.new_connection @username, @password,
> @database, @async, @prefetch_rows,   @cursor_sharing, @privilege #
> add
>       super @connection
>     end

> second in class OracleEnhancedConnectionFactory
>     def new_connection(username, password, database, async,
> prefetch_rows, cursor_sharing, privilege) #add
>       conn = OCI8.new username, password, database, privilege #add
>       conn.exec %q{alter session set nls_date_format = 'YYYY-MM-DD
> HH24:MI:SS'}
>       conn.exec %q{alter session set nls_timestamp_format = 'YYYY-MM-
> DD HH24:MI:SS'} rescue nil
>       conn.autocommit = true
>       conn.non_blocking = true if async
>       conn.prefetch_rows = prefetch_rows
>       conn.exec "alter session set cursor_sharing = #{cursor_sharing}"
> rescue nil
>       conn
>     end

> last in class OCI8EnhancedAutoRecover
>     def reset!
>       logoff rescue nil
>       begin
>         @connection = @factory.new_connection @username, @password,
> @database, @async, @prefetch_rows, @cursor_sharing, @privilege #add
>         __setobj__ @connection
>         @active = true
>       rescue
>         @active = false
>         raise
>       end
>     end

> OK, I will add this to feature list and hopefully will include this in
> next version of adapter.

> Raimonds

> On Dec 20, 2:01 am, Colin Jack <jichen3...@gmail.com> wrote:
> > Yes, you right.
> > I'm not use in rails. I just ues ActiveRecord in my project.
> > If the Database at standby, do sql must need SYSDBA privilege.
> > Of course, I can just use oci8, but it's so inconvenient, when I used
> > to ActiveRecord.