Displaying 20 results from an estimated 45 matches for "oracle_adapter".
2007 Oct 07
0
Rails AR/Oracle Unit Test: [7769] failed (getting worse)
...ror: out of range of Time (expect between 1970-01-01 00:00:00 UTC and 2037-12-31 23:59:59, but 1807-10-06 22:33:09 PST)
/usr/pkg/ruby184/lib/ruby/site_ruby/1.8/oci8.rb:983:in `to_time''
/usr/pkg/ruby184/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/active_record/connection_adapters/oracle_adapter.rb:503:in `select''
./test/../lib/active_record/base.rb:1360:in `each_with_index''
/usr/pkg/ruby184/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/active_record/connection_adapters/oracle_adapter.rb:496:in `select''
./test/../lib/active_record/connection_adapters...
2006 Apr 26
4
Re: Rails AR/Oracle Unit Test: [4280] failed
...-04-26 13:43:29 -0700 (Wed, 26 Apr 2006) | 1 line
>
> Add Oracle support for CLOB inserts. Closes #4748. [schoenm@earthlink.net sandra.metz@duke.edu]
> ------------------------------------------------------------------------
>
> U activerecord/lib/active_record/connection_adapters/oracle_adapter.rb
> U activerecord/CHANGELOG
> Updated to revision 4280.
>
2006 Mar 28
4
Problem with ActiveRecord, create, save, and Oracle adapter?
...2: render :action => ''new''
163: end
Here''s the error (which is the same as what''s in the dev log):
ArgumentError in Schedules#create
wrong number of arguments (1 for 0)
/opt/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/oracle_adapter.rb:53:in
`attributes_with_quotes_pre_oracle''
/opt/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/oracle_adapter.rb:53:in
`attributes_with_quotes''
/opt/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/base.rb:2031:in
`quoted_column_n...
2006 Mar 29
2
AR 1.14 oracle_adater.rb does not work
the error is :
wrong number of arguments (1 for 0)
where :
active_record/connection_adapters/oracle_adapter.rb:53:in
`attributes_with_quotes_pre_oracle''
this method is new, it was an alias in the previous version :
alias :attributes_with_quotes_pre_oci :attributes_with_quotes
#:nodoc:
I replaced the method by the alias of the previous version, and it is
working fine.
This is the code...
2010 Apr 27
3
"ORA-12154: TNS:..." error after successful oracle connection
...nt_record''
C:/web/IPSO/app/controllers/attending_ips_controller.rb:26:in
`new_edit''
-e:4:in `load''
-e:4
C:/ruby_prod/lib/ruby/site_ruby/1.8/oci8.rb:229:in `initialize''
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:585:in `new''
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:585:in
`new_connection''
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:621:in
`initial...
2006 Apr 06
7
[Fwd: Rails AR/Oracle Unit Test: [4185] failed]
...record/test/calculations_test.rb
U activerecord/lib/active_record/calculations.rb
U activerecord/CHANGELOG
Updated to revision 4185.
1) Error:
test_should_limit_calculation(CalculationsTest):
TypeError: can''t convert String into Array
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:310:in
`replace''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:310:in
`add_limit_offset!''
./test/../lib/active_record/base.rb:1046:in `add_limit!''
./test/../lib/active_record/calculations.rb:156:in
`construct_calculation_sql''...
2006 Apr 04
6
Oracle Problem. Maybe driver
...thing is fine until i try updating/inserting
something into the DB.
This is the error message :
wrong number of arguments (1 for 0)
RAILS_ROOT: config/..
Application Trace | Framework Trace | Full Trace
/opt/tools/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/oracle_adapter.rb:53:in
`attributes_with_quotes_pre_oracle''
/opt/tools/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/connection_adapters/oracle_adapter.rb:53:in
`attributes_with_quotes''
/opt/tools/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/base.rb:1719:in
`upd...
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,
2006 Oct 16
6
Rails AR/Oracle Unit Test: [5310] failed (but getting better)
...;': OCIError: ORA-00972: identifier is too long: CREATE TABLE lock_with_custom_column_without_defaults (id NUMBER(38) NOT NULL PRIMARY KEY, custom_lock_version NUMBER(38))
./test/aaa_create_tables_test.rb:18:in `test_load_schema''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:243:in `execute''
./test/../lib/active_record/connection_adapters/abstract/schema_statements.rb:104:in `create_table''
./test/../lib/active_record/connection_adapters/oracle_adapter.rb:368:in `create_table''
./test/../lib/active_record/migration.rb:274:in `met...
2007 Nov 15
0
Problems connecting to remote Oracle DB on windows using active record
...oci8lib.so: ORA-12514: TNS:listener does not currently
know of serv
ice requested in connect descriptor (OCIError)
from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:228:in
`initialize''
from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_recor
d/connection_adapters/oracle_adapter.rb:585:in `new''
from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_rec
If I change the adapter to ''oracle'' I get
C:\rb-play>ar_connect_ss.rb
env.c:257:in oci8lib.so: ORA-12154: TNS:could not resolve the connect
identifier
specified (OCIError...
2006 Oct 13
5
RoR + oracle + bind vars
Hi,
I have a question about bundle: RoR + oracle + bind variables.
Heaving read forums/blogs/etc I found out RoR does not use bind vars
for oracle particularly (and for all adapters in general).
Then I found Michael''s patch
(http://dev.rubyonrails.org/attachment/ticket/5199/oracle_bind.patch)
but it was not added to the following RoR versions (since the end of
May). As I suppose it was
2008 Feb 22
2
Connecting to Oracle from Rails 2.0.2
...m the command prompt: c:\where you saved file>"ruby
ruby-oci8-1.0.0-mswin32.rb"
Answer "Yes"
Assuming that 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...
2007 Mar 21
2
ORA-03106: fatal two-task communication protocol error
Has anyone encountered this error or know how to correct it?
I couldn''t find any Rails-specific info about this on google.
Here are the circumstances:
/usr/local/bin/ruby --version
ruby 1.8.4 (2005-12-24) [i686-linux]
/usr/local/bin/rails --version
Rails 1.1.6
## Create mcd app
rails mcd -d oracle
cd mcd
## Create oracle tablespace & user
sqlplus ''/ as
2007 May 15
5
Rspec + Oracle
Hi all.
Does anybody use Rspec with Oracle? I have RoR app + Oracle DB. I use
Rspec 0.9.4.
I have installed Rspec plugin and generated spec for model Country.
If I use "@countries = Country.new" in my spec I get
"ArgumentError in ''Country should be valid''
block not supplied
/vendor/plugins/rspec_on_rails/lib/spec/rails/extensions/kernel.rb:
12:in
2006 Apr 13
4
ORA-12663 and @connection.describe with Oracle7
I am trying to use Rails and an Oracle 7 database.
I have the following error message:
(eval):3:in `__send__'': ORA-12663: Services required by client not
available on the server (OCIError) from (eval):3:in `describe''
and the line oracle_adapter,rb:361:
(owner, table_name) = @connection.describe(table_name)
Do I need this describe line?
Can I replace with something else just to get the query to work?
Thanks
--
Posted via http://www.ruby-forum.com/.
2007 Jan 25
0
oci8 problems
...;'m not even trying to use the oracle active record adapter with
rails. I just have oci8 installed for the migration script.
Please help.
Thanks in advance,
andy
The error in full from mongrel.log:
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/active_record/connection_adapters/oracle_adapter.rb:536:
undefined method `define_a_column'' for class `OCI8::Cursor'' (NameError)
from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require''
from /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.0/lib/active_support/dependencies.rb:...
2008 Jan 04
2
oracle adapter + activerecord sessions do not work
...on makes
it to the end of a request.
It''s also worth mentioning the oracle adapter wouldn''t work for me at
all until I found this patch code which provides the select_rows
method, seems they forgot to implement it or something:
require ''active_record/connection_adapters/oracle_adapter''
module ActiveRecord
module ConnectionAdapters
class OracleAdapter
def select_rows(sql, name = nil)
@connection.query_with_result = true
result = execute(sql, name)
rows = []
result.each { |row| rows << row }
result.free
row...
2007 Aug 03
2
my number column returns boolean values
Hi everyone,
I''m working on a new rails project and have to build it on top of a
legacy oracle database. I''m trying to figure out how to get the
number value from a NUMBER(1) datatype. So far I''m only getting a
"true" value for 1 and "false" for any other number. From the console
I can print out my object values and can see that there are number
2006 Aug 10
3
Ruby on Rails with Oracle
Hello everyone,
I am trying to convince my colleagues to convert to Ruby on Rails,
however I am up against the following problem:
Ruby on rails seems to be primarily designed a single database doing a
small number of queries. While trying to process a webpage that does
thousands of sql queries on Oracle, I get the message that I have used
up too many cursors.
In Java, I can use stmt.close()
2007 Dec 14
17
Rails 2.0.1 RC2 - activerecord-oracle-adapter not found
...ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/lib/active_record/connection_adapters/abstract/connection_specificatio
n.rb:231:in `establish_connection'': Please install the oracle adapter:
`gem install activerecord-oracle-adapter` (no suc
h file to load -- active_record/connection_adapters/oracle_adapter)
(RuntimeError)
I installed ruby-oci8 and I''m able to communicate with the Oracle
database located on a remote machine via:
ruby -r oci8 -e "OCI8.new(''id'', ''password'', ''???.???.?.?/xe'').exec(
''SELECT * F...