Displaying 14 results from an estimated 14 matches for "oci_adapt".
Did you mean:
oci_adapte
2006 Feb 07
5
OCI adapter slowdown on dictionary access
...ppropriate statement ran about 1 min which led to a
timeout.
Our Oracle guru told me to analyze the SYSTEM schema. After that hadn''t
helped, he said the only remaining chance is to use a hint in the
statement. Other tools like TOAD would do it by themself anyway...
I made the change in oci_adapter.rb and Rails was responsive again. If
anybody else has this problem or if anybody wants to include the change
into the next ActiveRecord version, here is what I''ve changed:
in activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb
at line 341 (in the #columns method...
2006 Jan 10
5
Oracle 10g Express - generate scaffold gives error
...ROOT: ./script/../config/..
Application Trace | Framework Trace | Full Trace
e:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:155:in `attrSet''
e:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:155:in `initialize''
e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:515:in
`new''
e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:515:in
`new_connection''
e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:545:in
`initialize''...
2006 Jan 18
1
Problem with OCI in Apache
...rror when run from apache. this is the copy of the FULL TRACE i get
/usr/local/lib/ruby/site_ruby/1.8/oci8.rb:131:in `create''
/usr/local/lib/ruby/site_ruby/1.8/oci8.rb:131:in `initialize''
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:515:in `new_connection''
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:545:in `initialize''
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:35:in `oci_connect...
2005 Oct 14
10
Active Record: Prepared Statements?
Hello all,
my first project is on it''s way, and I am loving it!
But, and that''s a big BUT:
Active Record does not use prepared statements! How is that? Everybody is
bragging about performance and the most obvious tuning measure is missing.
Ok, I don''t know, if MySQL can even do them as I am using Postgres, but
still.
I started looking at the code and it is not
2008 Feb 22
2
Connecting to Oracle from Rails 2.0.2
...t you have previously installed rails 1.x, copy the oracle
adapters manually from:
C:\ruby\lib\ruby\gems\1.8\gems\activerecord-2.0.2\lib\active_record\connection_adapters\oracle_adapter.rb
to:
C:\ruby\lib\ruby\gems\1.8\gems\activerecord-1.15.6\lib\active_record\connection_adapters
and rename it to oci_adapter.rb
Copy the ora.dll & oraociei11.dll from C:\oracle\instantclient_11_1 to
c:\ruby\bin
Edit your database.yml to read:
development:
adapter: oci
host: <your db host>:<your db port>/<your db sid>
username: <uid>
password: <pwd>
go to http://localhost:30...
2005 Jul 27
1
Problem connection to oracle
...1:in
`initialize''
from
/usr/local/lib/ruby/site_ruby/1.8/oci8.rb:161:in
`do_ocicall''
from
/usr/local/lib/ruby/site_ruby/1.8/oci8.rb:161:in
`initialize''
from
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.11.1/lib/active_record/connection_adapters/oci_adapter.rb:211:in
`new''
from
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.11.1/lib/active_record/connection_adapters/oci_adapter.rb:211:in
`oci_connection''
from
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.11.1/lib/active_record/query_cache.rb:52:in
`send'...
2006 Jan 12
7
Is anyone using oracle with RoR successfully?
Hi,
Is anyone using Oracle with RoR successfully?
Is everything running smoothly?
What are the main issues?
any response is appreciated
thanks,
Chris
--
Posted via http://www.ruby-forum.com/.
2008 Feb 06
3
slogging my way thru oracle, not adapter? gem install fails?
...activerecord-oci-adapter (> 0) in any repository
<ubuntu_gutsy> me@ubuntu:~/workspace/oracle/ro$ rake db:migrate
(in /home/me/workspace/oracle/ro)
rake aborted!
Please install the oci adapter: `gem install activerecord-oci-adapter`
(no such file to load -- active_record/connection_adapters/oci_adapte
r)
(See full trace by running task with --trace)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@publ...
2006 Mar 10
14
Oracle Date type errors rails on edit
I have a table with "expires_on" a DATE field.
"Show" and "Destroy" work, but "Edit" errors:
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:150:in
`select_hour''
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:149:in
`select_hour''
It only happens when
2005 May 22
1
ActiveRecord: can not connect to mysql
...method redefined; discarding old default
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/connection_adapters/sqlserver_adapter.rb:95:
warning: (...) interpreted as grouped expression
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/connection_adapters/oci_adapter.rb:58:
warning: (...) interpreted asgrouped expression
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active_record/connection_adapters/oci_adapter.rb:103:
warning: ambiguous first argument; put parentheses or
even spaces
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.10.1/lib/active...
2005 May 19
0
Re: Problem with Rails and OCI8
...2005
Using Rails 0.10.1 , following error when I have OCI8 (ver 1.9)
installed .. Older rails (0.9) did not have this problem, AFAIK.
Uninstalling OCI8 from site_ruby makes the problem go away.
Ideas? Thanks.
/usr/lib/ruby/gems/1.8/gems/activerecord-1.8.0/lib/active_record/connection_
adapters/oci_adapter.rb:253:
undefined method `define_a_column'' for class `OCI8::Cursor''
(NameError)
from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require__''
from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require''
fro...
2009 May 06
0
OCI Library Initialization Error
.../kernel/reporting.rb:11:in
`silence_warnings''
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/core_ext/kernel/requires.rb:5:in
`require_library_or_gem''
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-oracle-adapter-1.0.0.9250/lib/active_record/connection_adapters/oci_adapter.rb:29
C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:36:in
`gem_original_require''
C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:36:in
`require''
C:/Ruby/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require''...
2006 Mar 23
11
ActiveRecord: Oracle metadata loading slow on large database
All,
While attempting to use ActiveRecord against a large database, approx.
1700 tables and 4 million rows, I discovered an inefficiency in
oci_adapter.rb. The problem seems to be the SQL being generated to
lazy-load the columns metadata. "def columns(table_name, name = nil)"
method generates the following SQL:
select column_name, data_type, data_default, nullable,
decode(data_type, ''NUMBER'', data_precision,
...
2006 Jan 13
19
Problems with scaffold''s parameter on Oracle
Hi
I run Ruby on Rails on Oracle XE.
I have a simple table:
create table customer(id number primary key, name varchar2(100));
And
ruby script\generate model Customer
ruby script\generate controller Customer
http://localhost:3000/customer/
- show a fine list, but when I click show/edit/destroy, I get an
ORA-01722:
OCIError: ORA-01722: invalid number: select * from (select raw_sql_.*,