Displaying 20 results from an estimated 100 matches similar to: "Oracle unit test problem in Rails 1.1.2/Ruby-OCI 0.1.14"
2006 Apr 20
4
oci8 mac os x intel
Is rails + oci8 + mac os x intel a winning combination? It appears
that oci8 might be a issue.
2006 Apr 12
0
Re: Re: Oracle unit test problem in Rails 1.1.2/Ruby-OCI 0.1
> -----Original Message-----
> From: rails-bounces@lists.rubyonrails.org
> [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Lori Olson
> Sent: Tuesday, April 11, 2006 8:04 PM
> To: rails@lists.rubyonrails.org
> Subject: [Rails] Re: Re: Oracle unit test problem in Rails
> 1.1.2/Ruby-OCI 0.1
>
>
> Wilson Bilkovich wrote:
> > On 4/11/06, Lori Olson
2005 Aug 25
5
ROracle and select query empty
Hi,
I just installed ROracle and RDBI. The connection to the database seems
to work also. My problem is when I am selection rows that really exist
in the database, it is returning nothing. Where should I look to see
what could be my problem?
Thank you very much,
Mathieu
> drv <- dbDriver("Oracle")
> summary(drv, verbose=TRUE)
<OraDriver:(6721)>
Driver name:
2006 Feb 07
5
OCI adapter slowdown on dictionary access
Hi,
after some experience with Rails on MySQL databases I gave it a try on one
of our larger Oracle database.
I was facing a problem when Rails tried to detect the columns for a
model/table. The appropriate 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
2005 Aug 25
0
Irregular Time Series: zoo & its: Pros & Cons
I am the maintainer of its, but not it's original author.
One of the main strengths of its is that it uses POSIXct dates.
Zoo has the flexibility of using almost any date format, but I don't
know if the other date formats can store hour, min, sec data.
You might want to do a little exploring with each before you commit.
I'll be happy to give you a hand if you decide to work with
2004 Nov 22
3
Mode context extremely poor performance.
Hi all,
I curently have a big problem. One request (listed above) using context
take up to 1000 more time than the on RAW or ext2 database. I have ran
this request on a single IA32 machine with Redhat and dbf on ext2. The
average reponse time is less than a sec. The same request on RAC 4 nodes
cluster on RAW take the same average time. On ext2 idem. But on OCFS it
took up to 15 sec randomly
2004 Nov 22
3
Mode context extremely poor performance.
Hi all,
I curently have a big problem. One request (listed above) using context
take up to 1000 more time than the on RAW or ext2 database. I have ran
this request on a single IA32 machine with Redhat and dbf on ext2. The
average reponse time is less than a sec. The same request on RAC 4 nodes
cluster on RAW take the same average time. On ext2 idem. But on OCFS it
took up to 15 sec randomly
2006 Apr 13
2
Legacy database with varchar2 primary key?
I rememeber seeing an article about how to cope with legacy databases
where the primary key is defined as VARCHAR2. I only want read-access
to the data.
Does anyone have a link to such an article? Or can give advice?
--
Posted via http://www.ruby-forum.com/.
2011 Mar 11
2
Problem with Redmine
I am having a problem getting Redmine to run with Oracle (11.2) backend.
I get this error (below) because Oracle table names are limited to 30
characters. Does anyone around here know of a fix or workaround? I''m
wondering if I can simple change the table name, or if that will break
the application.
When doing a db migrate to an Oracle db this creates the error below.
I''m so
2008 May 23
12
Modules will no longer be automatically included in RSpec version 1.1.4
Can anyone (David?) shed some light on what exactly this warning is
complaining about? I started seeing it when I upgraded to Rails 2.1
RC1 and the latest RSpec from git.
I''m getting it in some helper specs that I''m writing. And yes, I am
including a module there, to reuse some utility methods I originally
wrote for my controller tests (I''m switching to specs
2010 Feb 03
2
sqlUpdate RODBC
Dear all,
I using R version 2.9.0 on Windows XP and want to insert data from a data
frame in R into a oracle database via sqlUpdate with the package RODBC.
My example is the following:
TEST0<-data.frame(NR=c(1,2,600),NAME=c("JK","TR","AR"),
DATUM=c("2009-01-01","2010-01-02","2010-06-09"))
If I create the table in the database with
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
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_.*,
2006 Jan 11
8
Oracle and Rails seems really slow.... In development
I''m just looking into how to connect to Oracle using Rails. I''ve got
everything connecting and working as it should.
I have a Users table in Oracle:
create_table "users", :force => true do |t|
t.column "username", :string
t.column "created_on", :datetime
t.column "email", :string
t.column "note", :text
2007 Feb 09
0
Oracle ADT columns
Hi,
has anybody worked with oracle adt columns in the Rails ?
I have a table with a column what has DER data type, described below:
create or replace TYPE "DER" AS OBJECT
(READABLE VARCHAR2(4000)
,DER BLOB
)
obviously as a result I always have ''unsupported datatype'' error
message.
I''ve tried to add to oracle adapter and then to oci8 processing of
this data
2008 Jun 03
5
Autotest/RSpec 1.1.4/Rails 2.1 Infinite Loop?
I just got back from RailsConf, and upgraded on of my development apps
to 2.1, and now autotest is going into an infinite loop. It runs tests
continuously instead of waiting for files to be saved before rerunning.
Has anybody else seen this, or know how to get around it?
Thanks,
Andrew
2006 Jan 16
11
Plans to intigrate ObjectGraph in to Rails
Are there any plans to move the schema definition from migrations to the
model, where it should be?
Like og does, which I think is used by the ruby Nitro framework...
ObjectGraph:
http://www.rubygarden.org/index.cgi/Libraries/og_tutorial.rdoc
Example code:
[code]
class Post
property :title, String, :sql => ''VARCHAR2(32) NOT NULL''
property :body, String
property
2008 Dec 25
2
Switching to active_record_store session management errors out
Hello,
Running Ruby 1.8.6 and Rails 2.2.2 against an Oracle XE database
(sigh).
I just upgraded Rails from 1.2.3 to 2.2.2, which made my cookie based
system for storing session information to error out due to the 4Kb
limit. So, I tried to turn on the active_record_store system by un-
commenting out the "config.action_controller.session_store
= :active_record_store" line in
2006 Mar 18
9
RJS - not working in IE
I searched thru all the postings about RJS, and I didn''t find one person
who complained of problems specific to IE, but that''s what I''ve got.
My environment is:
Rails 1.0 + RJS Plugin
Updated Javascripts to Scriptaculous 1.5.3 (for evalScripts support)
Monkeypatched in_place_editor to support evalScripts
I have just started using RJS, and I have two .rjs templates.
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,