https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292008-12-03T21:58:22ZRedmineRedmine - Feature #2272: Redmine on Oracle Database - Windows Installationhttps://www.redmine.org/issues/2272?journal_id=59092008-12-03T21:58:22ZRodrigo Mesquita
<ul></ul><p>I've not mentioned it on the text above...</p>
<p>But the purpose of this topic is to provide the necessary information to include a How-to on redmine.org to those people who needs to use Redmine on Oracle.</p>
<p>Thanks</p> Redmine - Feature #2272: Redmine on Oracle Database - Windows Installationhttps://www.redmine.org/issues/2272?journal_id=59122008-12-04T01:17:40ZRodrigo Mesquita
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Resolved</i></li><li><strong>% Done</strong> changed from <i>90</i> to <i>100</i></li></ul><p>To start the number of issue on 1, alter the file C:\ruby\lib\ruby\gems\1.8\gems\activerecord-oracle_enhanced-adapter-1.1.8\lib\active_record\connection_adapters\oracle_enhanced_adapter.rb:</p>
<pre>
def create_table(name, options = {}, &block) #:nodoc:
create_sequence = options[:id] != false
if create_sequence
super(name, options, &block)
else
super(name, options) do |t|
class <<t
attr_accessor :create_sequence
def primary_key(*args)
self.create_sequence = true
super(*args)
end
end
result = block.call(t)
create_sequence = t.create_sequence
end
end
seq_name = options[:sequence_name] || "#{name}_seq"
execute "CREATE SEQUENCE #{seq_name} START WITH 1" if create_sequence #This line alter the value 10000 to 1
end
</pre>
<p>Despite the problem on insert...</p>
<p>Alter the db\migrate\001_start.rb</p>
<pre>
create_table "enumerations", :force => true do |t|
t.column "opt", :string, :limit => 4, :default => "", :null => false
t.column "name", :string, :limit => 40, :default => "", :null => false #Change limit of 30 to 40
end
</pre> Redmine - Feature #2272: Redmine on Oracle Database - Windows Installationhttps://www.redmine.org/issues/2272?journal_id=96192009-06-07T13:13:41ZRodrigo Mesquita
<ul><li><strong>File</strong> <a href="/attachments/2154">Installing_Redmine_Oracle.pdf</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/2154/Installing_Redmine_Oracle.pdf">Installing_Redmine_Oracle.pdf</a> added</li></ul><p>Hi folks!</p>
<p>I did some modifications on the above configuration, because i updated the version of redmine from 0.7.3 to 0.8.4 (i also tested on 0.8.0 RC1).</p>
<p>Worked fine with this environment:<br /><pre>
ruby186-26
redmine-0.8.4
ruby-oci8-1.0.3-mswin32
activerecord-oracle_enhanced-adapter 1.1.8
Oracle Database XE
Windows XP Professional SP3
</pre></p>
<p>Until now, no problem on using it. From 0.8.0 to 0.8.4 i noticed a great raise of performance, making it comparable to MySQL databases... Congratulations!</p>
<p>Sorry for the language of the document attached. Next post i'll send in English language.</p>
<p>I also ask you admins to definetly make this software Oracle's compatible.</p>
<p>Thanks.</p> Redmine - Feature #2272: Redmine on Oracle Database - Windows Installationhttps://www.redmine.org/issues/2272?journal_id=424052012-10-28T17:21:12ZDaniel Felix
<ul></ul><p>In my opinion, this ticket could be closed, doesn't it?</p> Redmine - Feature #2272: Redmine on Oracle Database - Windows Installationhttps://www.redmine.org/issues/2272?journal_id=877912018-10-03T03:12:24ZGo MAEDA
<ul><li><strong>Status</strong> changed from <i>Resolved</i> to <i>Closed</i></li></ul>