similar to: Rails and Oracle - can select date but cannot save

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

I am trying to migrate from RoR/MYSql to JRoR/Oracle. I am using Active Record JDBC to talk to the database. The Migration process to create and populate the database tables has been painful. My latest issue is the method new_date is undefined in the JDBC adapter. I have the following gems installed: *** LOCAL GEMS *** actionmailer (2.2.2) actionpack (2.2.2) activerecord (2.2.2)

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

I tried this, which worked before: sudo gem install activerecord-oracle-adapter --source http://gems.rubyonrails.org --no-ri --no-rdoc But all I get is: ERROR: could not find activerecord-oracle-adapter locally or in a repository Anyone else able to install the Oracle adapter? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the

Hello all. I am a novice Ruby on Rails programmer, starting my first project using a legacy Oracle 10 database. Using ''reverse_scaffold'' I have created the models/controllers/views for my existing Oracle tables. All seems to work well, using /model/index, /model/show for most of my tables, *except* when one of the tables contains a Oracle ''date'' column, for

i got this error message while installing mysql gem..... kindly help me to solve this issue.... JRuby limited openssl loaded. gem install jruby-openssl for full support. http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL Building native extensions. This could take a while... ERROR: Error installing mysql: ERROR: Failed to build gem native extension. C:/Program Files/NetBeans

After installing RJDBC on RedHat Linux and using it successfully with mySQL JDBC driver i am trying to use it with Oracle database. I use the JDBC driver that works fine elsewhere (use it in DBVizualizer). However, when i try to load the driver, drv<-JDBC("oracle.jdbc.driver.OracleDriver", "/home/az05625/DBdrivers/ojdbc6.jar", identifier.quote="`") it gives me

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

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

I have been experiencing issues with an R script hanging when connecting to an Oracle database. To help debug, I found a function here in the nabble forum and made a small test script: #!/usr/bin/Rscript --no-restore --no-save --no-init-file library("RJDBC") drv<-JDBC("oracle.jdbc.OracleDriver","/home/oracle/lib/ojdbc6.jar", "'") dbCheck =

How can I pass the following Oracle 10g variables to my apache? ORACLE_BASE=/u01/oracle ORACLE_HOME=/u01/oracle/10g ORACLE_SID=king LD_LIBRARY_PATH=$ORACLE_HOME/lib LD_LIBRARY_PATH_32=$ORACLE_HOME/lib32 PATH=$PATH:$ORACLE_HOME/bin NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256; export NLS_LANG NLS_DATE_FORMAT=dd-mm-yyyy ; export NLS_DATE_FORMAT export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH

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

I''ve spent all day digging through the rails api and postgres-pr on this, I think it''s time to ask the list. Postgres stores a Date in YYYY-MM-DD format. My users want the dates in MM/DD/YYYY format. Sure, I could explicitly convert it on the app level every place where a date is displayed, but that seemed like a DRY violation. I thought I''d be clever and simply

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

I know this question could be asked on tomcat or possibly other mailing lists, but I'm hoping I can get some help here instead of joining yet another list. I'm running tomcat5 on CentOS 5.8. I'm trying to setup Oracle/Sun java rather than icedtea. I've installed the latest jdk 1.7 and setup alternatives on centos for java and javac: # java -version java version

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

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''

Hi, I''ve followed these directions : http://railswiki.pdxruby.org/HowToDefineYourOwnDateFormat.html It seems pretty straightforward but obviously it doesn''t work for me... article.date_edited.to_formatted_s(:my_format_1) produce a default formatted date, not the one I''ve defined in environment.rb : ActiveSupport::CoreExtensions::Date::Conversions::DATE_FORMATS.merge!(

hi, overhere users go nuts if they have to enter the date in iso format, so i have to make my applications in such a way that not only dates are displayed in the "dd-mm-yyy" format but also can be entered in that way. somewhere i found this code to put in the environment script: ActiveSupport::CoreExtensions::Time::Conversions::DATE_FORMATS.update( :default => ''%d/%m/%Y

Hi, In my form I have date field set as ''datetime_select'' which is fine as I wanted it in the same format. But while displaying (list action) it displays date in long format i.e. ''Tue May 30 15:39:00 Central Daylight Time 2006''. How can I format it so that it will just be diaplyed as ''dd/mm/yyyy'' format? Thanks -- Posted via