similar to: Oracle Schema

Just realized I have a nice problem. using Postgresql... When I save something via Rails to the table it''s saved with a GMT offset (so 12:00 becomes 16:00) But the database is configured to save everything as GMT. Which means -- when I query it via SQL it''s coming back as now + 4 hours instead of just plain now. Where/How do I get this back in sync? -- You received this

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

Hi, After a few days of struggling, I was able to run this command successfully. ruby -r oci8 -e "OCI8.new(''xxx_dba'', ''xxx'', ''//xxxx:1521/ xxxxx.xxx.org'').exec(''SELECT 1 from dual'') {|r| puts r.join}" I got "1.0" as output and I got my prompt back. So, I went back to the RoR app that I am working on,

Hi, Does anyone know why gem can''t find activerecord-oracle-adapter? C:\>rails --version Rails 2.0.1 C:\>gem install activerecord-oracle-adapter ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find activerecord-oracle-adapter (> 0) in any repository It all started when I tried to run Mongrel on a Win32 box: C:\web\FDS_Server>mongrel_rails start

Hello folks. I''m new in Ruby also ROR. I installed oracle intant client and test it it works fine. Now I wanna connect to oracle db. But its got some error. like this *custom_require.rb:36:in `require'': cannot load such file -- oci8 (LoadError)* my code is here. require ''oci8'' oci =

I''m seeing a behavior in Rails that I find very strange. Having worked quite a bit with Oracle with other languages I would always dutifully do ALTER SESSION SET NLS_DATE_FORMAT = <my_date_format> and ensure I use that date format in my application. With Rails I still have not figured out how to execute an ALTER SESSION statement after connecting to the database (I''m using

Hi, My setup is: Ruby 1.8.6 Rails 2.3.5 activerecord-oracle-adapter (1.0.0.9250) I upgraded Rails and the adapter recently and I just went through hell trying to find a problem while inserting a record in a table. Rails was giving me this error: OCIError (ORA-02289: sequence does not exist): stmt.c:539:in oci8lib.so c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:753:in `exec''

I would like to know if there is a way to ''package'' an application with all the associated gems and ship it to a new server and having it to "just work" in a Windows environment. Although I have never done it I know that Rails can be frozen into the application. I am wondering if I can do the same thing with other gems. I have found this

Hello Everyone, I need some help related to the below requirements: -> I need to setup production environment without installing Ruby or Rails or other related gems into it. I did accomplish the same using JRuby, bundler and warbler plugin. And deployed the WAR file into Apache Tomcat server. But now I have to do this without JRuby & Apache Tomcat. -> I have to setup Apache with

Hi Everyone, I am pretty new to Rails. I have very little idea about everything. But for my new project i have been asked to do some research on Solr search and implement it on Rails. Please provide me some link on tutorials and guides about Solr on Rails. Trouble is... have to do it by tomorrow. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are

Hi every one How are you? after a days and searching in forums i still can not find some things that helping me to connect Rails with postgre SQL of course those are helpful but not for a stupid person like me :D So i need my friends helping me here and advice me to how can i connect this two things (ROR and Postgre Sql) I need your help so much My eyes going blind because of searching and

A little background. We are deploying a rails app on jboss by using warbler and the app is using rails 3.0.3. There are several parameters the customer may need to change. Some of these parameters include database connection information, ie shema, username, password, host, port, and database. We are connecting through oracle thorugh the jdbc adapter. My problem lies in the fact that I cannot

Hello, I run many gameservers (about 10), each gameserver has a different database and all gameserver''s databases has the table "players" which is associated to the model Player. So every time I want to work with the Player model I need connect to a different database depending on which gameserver I am working on. My problem is that I need to make rails choose which database

Hello folks, I´m here trying to find the way to solve my problem. When i try to run rake db:create or rake db:create:all the process stops and the databases are not created. I change the directives, putting --trace before the rake db:create and the steps are C:\appws\cookbook>rake db:create --trace (in C:/appws/cookbook) ** Invoke db:create (first_time) ** Invoke db:load_config (first_time)

Hi, I''ve been trying to get JRuby 1.5.3 with Rails 3 to run on the Tomcat6 server with little success. Has anyone been able to do this? If so, what issues did you have to overcome to get this to work? Also, is this a combination that you would recommend for a production site, or is it all too new and untested? The latest issue I''m stuck on right now is with the mysql-connector-

The recent discussion about different graphing solutions made me think. What is everyone using for general reports? Currently I have a web based application at work that has roughly 20 different reports ranging from simple tabular data with totaling at the bottom to pretty, colorized, graphic logo''s,etc... going to clients, and finally complex ones I hate to think about such as

Hello. Tired of searching and finding nothing useful. Moving application to laptop for trip. Installed: - Ruby (1.8.6, patchlevel 111) - Rails (2.2.2) - Oracle adapter (1.0.0.9250) - ruby-oci8 (2.0.1) - Oracle 10g Express Edition database.yml: development: adapter: oracle etc... When I start Mongrel (ruby script/server) I get the error above. I''ve looked everywhere I can think of.

Hello All: I''m looking for a Redmine developer for a minimum 4-month contract with a major Canadian company in the Mississauga (Airport) area. The job is to design a new project management web portal for both internal teams and external vendors. The current portal is written in JEE on Tomcat with SOPHIA connecting to a MySQL backend. Must Have Competency: - RoR development

Does any one know how to setup SQLserver with ruby1.9. It was working on an earlier version and now nothing works! I have installed the gems dbi ,dbd-odbc and activerecord-odbc-adapter and can connect in straight Ruby. However, using rails with database.yml nothing works! I hosed everything and reinstalled rails and now, I get Win32/Parite virus on ruby.exe. Any ideas? I''m losing

Hello all, I''m in my 5th month on Ruby on Rails and still learning. I have an application that works fine in sqlite3 and then the boss says he wants it migrated to Oracle. Now, I know very little about Oracle, enough to get into trouble. When I did the migration everything went haywire. Well, I''ve refactored several problems and now I have another. I have two models with a