similar to: Is anyone using oracle with RoR successfully?

Hi folks, Does anyone know how to install the OCI8 ruby interface on Debian64 without having to install Oracle? My understanding, from experience with Debian i386, is that you need Oracle (specifically the SQLPlus) installed to be able to compile OCI8. Since my new dev machine is AMD64 running Debian, I''m stuck. My rails applications need to connect to a remote Oracle 10g, but cannot

Hi folks, Does anyone know how to tackle Swedish letters in Rails. Am I completely off track in thinking that it should be done using map or regex in some clever way? Bealach

Has anyone experienced "hangs" with the WEBrick/OCI8 combination? The sequence of actions I perform to consistently get WEBrick to hang is: 1. start WEBrick 2. list a table form my Oracle 10g DB 3. startup sqlplus and update a few records in the table 4. go back to my browser and reload the table Here none of the chances I made directly to the table are reflected in the listing.

Hello, I have Oracle XE installed. I have a table USERS. When I try to generate a scaffold it gives me this error. I tried also with Mysql and it worked. E:\radrails\projects\MPS>ruby script\generate scaffold user exists app/controllers/ exists app/helpers/ create app/views/user exists test/functional/ dependency model exists app/models/ exists

Running ruby script/generate scaffold Product Admin is a wonderful way to set up well, exactly what it says, a scaffold. My problem is that I have several other tables that are linked, through foreign keys, to the Product table. Say an "authors" table. Now when I go enter a new product, a book, I want the application to provide a drop down list of authors generated from the records in

Long afternoon, but finally got it. Hope this spares you some pain: Installation instructions mainly based on: http://ruby.about.com/od/enterprise/ss/ruby_oracle.htm Install Oracle Instant Client: mkdir C:\oracle cd c:\oracle Get the following files from here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html and unzip them into the c:\oracle\ unzip

Sorry to have to post this again - it was probably under the wrong subject and went unnoticed. Is there a standard for providing user documentation for methods that I expose through we services? The default documentation (method names and return types) that appears when the user visits http://localhost:3000/backend/invoke is concise and correct, but a bit terse. How can I give my users a little

Hi, Environment: Solaris 10, Orale 10g, Apache 2.2, Ruby 1.8.4, Rails 1.2.3, Ruby OCI8 1.0.0-rc2 As soon as I compiled and installed the Ruby/OCI8 interface, I got the following error from my application: ========================= [notice] mod_fcgid: call /export/home/invido/invido/portal2/public/ dispatch.fcgi with wrapper /usr/local/bin/ruby /export/home/invido/

Hi Folks, I''m having trouble with setting up web services with layered dispatching. I''ve defined my controller (backend_controller.rb) as: class BackendController < ApplicationController web_service_dispatching_mode :layered web_service_scaffold :invoke web_service (:car) {CarService.new} end and my service (node_service.rb) as:

I''m new at this so please be patient. I have a very simple schema consisting of a around 10 tables in Postgresql. The aim is to provide a system for PC administrators to keep track of PC''s dotted around various venues (shops, libraries etc.). The sort of info I want to store is PC specs, PC network specs, PC ownership specs, PC location specs and contact person details. So I end

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

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

Hi folks, I need your opinions on a basic design issue. I''ve seen the light of RoR and have replaced my Perl (DBI/CGI) based web server <-> RDBMS communication with RoR, but I still have a whole host of users (other servers/OS''s etc) out there wanting to talk to my RDBMS and they only talk Perl. Also they don''t want to talk Perl/DBI directly (they are not allowed

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

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,

I am trying to generate my first scaffold but I am getting a 500 error from http://127.0.0.1:3000/foo . Below is the information about my system, as well as the commands I am typing. I have also included the DDL ( Oracle 10g ). I am mid way through chapter 6 of "Agile Web Development w/ Rails". Why aren''t there any files under app/controllers/ ? C:\tmp\rubyWork>ruby

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_.*,

i''m working on ubuntu 11.04; i need to create some rails application with oracle database on local computer. i installed: ruby 1.9.2, rails 3.1, oracle 10g XE, rubu-oci8 2.0.6, gem ''activerecord-oracle_enhanced-adapter'', create database user named ''orak'' with password ''orakpass'' through 127.0.0.1:8080/apex, i maked new application

My Application runs fine when run on webrick, but throws up database error 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

I'm looking to move some Solaris 2.6 and 7 machines to openssh. Showstopper bug: openssh (up to 3.1p1) doesn't seem to correctly implement expired passwords. Looking back through the archive, it looks like Dave Dykstra submitted a patch for this problem relative to an older version of openssh at least as early as last August: