thr3ads.net - Rails - activerecord-jdbc-adapter 0.9 oracle number id problem [Mar 2009]

If this information is useful, please help other people find it:
Share via:

Mark Becker

2009-Mar-03 19:40 UTC

activerecord-jdbc-adapter 0.9 oracle number id problem

I''m having a problem using jruby on rails with a legacy oracle database
(Oracle Database 10g Enterprise Edition Release 10.1.0.3.0).  The oracle
number primary key is getting converted into a decimal, which is causing
restful style URIs not to work.  For example I''m seeing URIs like
http://localhost:3000/members/show/7201.0?tab=names where the id should
be an integer, not a double, and they result in "Missing template"
errors.

A friend of mine said that the same problem arose for him when he
updated from activerecord-jdbc-adapter version 0.8 to version 0.9, which
is what I''m using.  Is this a known issue?  Is there a workaround short
of changing the database to use integer primary keys? That isn''t an
option for us.

Here''s my configuration:

jruby 1.1.6 (ruby 1.8.6 patchlevel 114) (2008-12-17 rev 8388)
[amd64-java]
rails (2.2.2)
activerecord (2.2.2)
activerecord-jdbc-adapter (0.9)
activerecord-oracle-adapter (1.0.0.9250)
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Greg Donald

2009-Mar-04 02:48 UTC

head link

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

On Tue, Mar 3, 2009 at 1:40 PM, Mark Becker
<rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:>
> I''m having a problem using jruby on rails with a legacy oracle
database
> (Oracle Database 10g Enterprise Edition Release 10.1.0.3.0).  The oracle
> number primary key is getting converted into a decimal, which is causing
> restful style URIs not to work.
>
> activerecord-oracle-adapter (1.0.0.9250)
Have you tried the activerecord-oracle_enhanced-adapter ?  It solved a
number of issues for me.


-- 
Greg Donald
http://destiney.com/

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Nick Sieger

2009-Mar-04 04:27 UTC

head link

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

On Tue, Mar 3, 2009 at 1:40 PM, Mark Becker
<rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:>
> I''m having a problem using jruby on rails with a legacy oracle
database
> (Oracle Database 10g Enterprise Edition Release 10.1.0.3.0).  The oracle
> number primary key is getting converted into a decimal, which is causing
> restful style URIs not to work.  For example I''m seeing URIs like
> http://localhost:3000/members/show/7201.0?tab=names where the id should
> be an integer, not a double, and they result in "Missing
template"
> errors.
>
> A friend of mine said that the same problem arose for him when he
> updated from activerecord-jdbc-adapter version 0.8 to version 0.9, which
> is what I''m using.  Is this a known issue?  Is there a workaround
short
> of changing the database to use integer primary keys? That isn''t
an
> option for us.
>
> Here''s my configuration:
>
> jruby 1.1.6 (ruby 1.8.6 patchlevel 114) (2008-12-17 rev 8388)
> [amd64-java]
> rails (2.2.2)
> activerecord (2.2.2)
> activerecord-jdbc-adapter (0.9)
If you could file a bug [1] and provide a short test case, we''ll try
to have this fixed for 0.9.1, due out in a week or two. In your
example/test case, please be sure to provide the schema or migration
that you use to create the table.

Thanks,
/Nick

[1]: http://kenai.com/jira/browse/ACTIVERECORD_JDBC

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Sylvain

2009-Mar-20 14:41 UTC

head link

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Hello Nick,
I experience the same bug described by Mark with version 0.9.1, so I
guess he did not file a bug report in Jira.
Can you please confirm, so I open a bug ?
One last question, when do you plan to release a 0.9.2 version ?

Thanks again for your time and your work you give to the ruby and
rails community.

  Sylvain

On Mar 4, 5:27 am, Nick Sieger
<nicksie...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> On Tue, Mar 3, 2009 at 1:40 PM, Mark Becker
>
>
>
> <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:
>
> > I''m having a problem using jruby on rails with a
legacyoracledatabase
> > (OracleDatabase 10g Enterprise Edition Release 10.1.0.3.0).  Theoracle
> > number primary key is getting converted into a decimal, which is
causing
> > restful style URIs not to work.  For example I''m seeing URIs
like
> >http://localhost:3000/members/show/7201.0?tab=nameswhere the id should
> > be an integer, not a double, and they result in "Missing
template"
> > errors.
>
> > A friend of mine said that the same problem arose for him when he
> > updated fromactiverecord-jdbc-adapterversion 0.8 to version 0.9, which
> > is what I''m using.  Is this a known issue?  Is there a
workaround short
> > of changing the database to use integer primary keys? That
isn''t an
> > option for us.
>
> > Here''s my configuration:
>
> > jruby 1.1.6 (ruby 1.8.6 patchlevel 114) (2008-12-17 rev 8388)
> > [amd64-java]
> > rails (2.2.2)
> >activerecord(2.2.2)
> >activerecord-jdbc-adapter(0.9)
>
> If you could file a bug [1] and provide a short test case, we''ll
try
> to have this fixed for 0.9.1, due out in a week or two. In your
> example/test case, please be sure to provide the schema or migration
> that you use to create the table.
>
> Thanks,
> /Nick
>
> [1]:http://kenai.com/jira/browse/ACTIVERECORD_JDBC
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Guillaume Desrat

2009-Mar-25 15:27 UTC

head link

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Hi,

I think I''ve found where the problem is.

In the file lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/
jdbc_adapter/jdbc_oracle.rb, there''s this :

module JdbcSpec
  ...
  module Column
  ...
    private
    def simplified_type(field_type)
        case field_type
        when /^number\(1\)$/i                  : :boolean
        when /char/i                           : :string
        when /float|double/i                   : :float
        when /int/i                            : :integer
        when /num|dec|real/i                   : @scale =0 ? :integer : :decimal
        when /date|time/i                      : :datetime
        when /clob/i                           : :text
        when /blob/i                           : :binary
        end
    end
  end
end

When I read my model columns, both integer and number(x,0) Oracle
columns report as following :

#<ActiveRecord::ConnectionAdapters::JdbcColumn:0x18af9c0
@precision=nil, @limit=nil, @sql_type="NUMBER", @name="id",
@type=:decimal, @scale=nil, @null=false, @primary=true, @default=nil>

As @scale is nil and not 0, the simplified_type returned is :decimal,
not :integer.


The corresponding case line :
        when /num|dec|real/i                   : @scale =0 ? :integer : :decimal
should be replaced by :
        when /num|dec|real/i                   : (@scale.nil? ||
@scale == 0) ? :integer : :decimal


This works fine for me. If it does for you, could you please open an
issue so that the next version includes it ?


Kind regards,

--
Guillaume Desrat
http://www.rubyfrance.org/

On 20 mar, 15:41, Sylvain
<sylvain.pe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> Hello Nick,
> I experience the same bug described by Mark with version 0.9.1, so I
> guess he did not file a bug report in Jira.
> Can you please confirm, so I open a bug ?
> One last question, when do you plan to release a 0.9.2 version ?
>
> Thanks again for your time and your work you give to the ruby and
> rails community.
>
>   Sylvain
>
> On Mar 4, 5:27 am, Nick Sieger
<nicksie...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> > On Tue, Mar 3, 2009 at 1:40 PM, Mark Becker
>
> > <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:
>
> > > I''m having aproblemusing jruby on rails with a
legacyoracledatabase
> > > (OracleDatabase 10g Enterprise Edition Release 10.1.0.3.0). 
Theoracle
> > >numberprimary key is getting converted into a decimal, which is
causing
> > > restful style URIs not to work.  For example I''m seeing
URIs like
> >
>http://localhost:3000/members/show/7201.0?tab=nameswheretheidshould
> > > be an integer, not a double, and they result in "Missing
template"
> > > errors.
>
> > > A friend of mine said that the sameproblemarose for him when he
> > > updated fromactiverecord-jdbc-adapterversion 0.8 to version 0.9,
which
> > > is what I''m using.  Is this a known issue?  Is there a
workaround short
> > > of changing the database to use integer primary keys? That
isn''t an
> > > option for us.
>
> > > Here''s my configuration:
>
> > > jruby 1.1.6 (ruby 1.8.6 patchlevel 114) (2008-12-17 rev 8388)
> > > [amd64-java]
> > > rails (2.2.2)
> > >activerecord(2.2.2)
> > >activerecord-jdbc-adapter(0.9)
>
> > If you could file a bug [1] and provide a short test case,
we''ll try
> > to have this fixed for 0.9.1, due out in a week or two. In your
> > example/test case, please be sure to provide the schema or migration
> > that you use to create the table.
>
> > Thanks,
> > /Nick
>
> > [1]:http://kenai.com/jira/browse/ACTIVERECORD_JDBC
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Sylvain

2009-Mar-30 15:07 UTC

head link

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Thanks Guillaume, you''re terrific !

On Mar 25, 5:27 pm, Guillaume Desrat
<guillaume.des...-HujFcYLiWL6M4zKIHC2jIg@public.gmane.org>
wrote:> Hi,
>
> I think I''ve found where the problem is.
>
> In the file lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/
> jdbc_adapter/jdbc_oracle.rb, there''s this :
>
> module JdbcSpec
>   ...
>   module Column
>   ...
>     private
>     def simplified_type(field_type)
>         case field_type
>         when /^number\(1\)$/i                  : :boolean
>         when /char/i                           : :string
>         when /float|double/i                   : :float
>         when /int/i                            : :integer
>         when /num|dec|real/i                   : @scale => 0 ? :integer
: :decimal
>         when /date|time/i                      : :datetime
>         when /clob/i                           : :text
>         when /blob/i                           : :binary
>         end
>     end
>   end
> end
>
> When I read my model columns, both integer and number(x,0) Oracle
> columns report as following :
>
> #<ActiveRecord::ConnectionAdapters::JdbcColumn:0x18af9c0
> @precision=nil, @limit=nil, @sql_type="NUMBER",
@name="id",
> @type=:decimal, @scale=nil, @null=false, @primary=true, @default=nil>
>
> As @scale is nil and not 0, the simplified_type returned is :decimal,
> not :integer.
>
> The corresponding case line :
>         when /num|dec|real/i                   : @scale => 0 ? :integer
: :decimal
> should be replaced by :
>         when /num|dec|real/i                   : (@scale.nil? ||
> @scale == 0) ? :integer : :decimal
>
> This works fine for me. If it does for you, could you please open an
> issue so that the next version includes it ?
>
> Kind regards,
>
> --
> Guillaume Desrathttp://www.rubyfrance.org/
>
> On 20 mar, 15:41, Sylvain
<sylvain.pe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> > Hello Nick,
> > I experience the same bug described by Mark with version 0.9.1, so I
> > guess he did not file a bug report in Jira.
> > Can you please confirm, so I open a bug ?
> > One last question, when do you plan to release a 0.9.2 version ?
>
> > Thanks again for your time and your work you give to the ruby and
> > rails community.
>
> >   Sylvain
>
> > On Mar 4, 5:27 am, Nick Sieger
<nicksie...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> > > On Tue, Mar 3, 2009 at 1:40 PM, Mark Becker
>
> > >
<rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:
>
> > > > I''m having aproblemusing jruby on rails with a
legacyoracledatabase
> > > > (OracleDatabase 10g Enterprise Edition Release 10.1.0.3.0).
 Theoracle
> > > >numberprimary key is getting converted into a decimal, which
is causing
> > > > restful style URIs not to work.  For example I''m
seeing URIs like
> > >
>http://localhost:3000/members/show/7201.0?tab=nameswheretheidshould
> > > > be an integer, not a double, and they result in
"Missing template"
> > > > errors.
>
> > > > A friend of mine said that the sameproblemarose for him when
he
> > > > updated fromactiverecord-jdbc-adapterversion 0.8 to version
0.9, which
> > > > is what I''m using.  Is this a known issue?  Is
there a workaround short
> > > > of changing the database to use integer primary keys? That
isn''t an
> > > > option for us.
>
> > > > Here''s my configuration:
>
> > > > jruby 1.1.6 (ruby 1.8.6 patchlevel 114) (2008-12-17 rev
8388)
> > > > [amd64-java]
> > > > rails (2.2.2)
> > > >activerecord(2.2.2)
> > > >activerecord-jdbc-adapter(0.9)
>
> > > If you could file a bug [1] and provide a short test case,
we''ll try
> > > to have this fixed for 0.9.1, due out in a week or two. In your
> > > example/test case, please be sure to provide the schema or
migration
> > > that you use to create the table.
>
> > > Thanks,
> > > /Nick
>
> > > [1]:http://kenai.com/jira/browse/ACTIVERECORD_JDBC--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Nick Sieger

2009-Mar-30 15:58 UTC

head link

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

On Wed, Mar 25, 2009 at 10:27 AM, Guillaume Desrat
<guillaume.desrat-HujFcYLiWL6M4zKIHC2jIg@public.gmane.org>
wrote:>
> Hi,
>
> I think I''ve found where the problem is.
>
> In the file lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/
> jdbc_adapter/jdbc_oracle.rb, there''s this :
>
> module JdbcSpec
>  ...
>  module Column
>  ...
>    private
>    def simplified_type(field_type)
>        case field_type
>        when /^number\(1\)$/i                  : :boolean
>        when /char/i                           : :string
>        when /float|double/i                   : :float
>        when /int/i                            : :integer
>        when /num|dec|real/i                   : @scale => 0 ? :integer :
:decimal
>        when /date|time/i                      : :datetime
>        when /clob/i                           : :text
>        when /blob/i                           : :binary
>        end
>    end
>  end
> end
>
> When I read my model columns, both integer and number(x,0) Oracle
> columns report as following :
>
> #<ActiveRecord::ConnectionAdapters::JdbcColumn:0x18af9c0
> @precision=nil, @limit=nil, @sql_type="NUMBER",
@name="id",
> @type=:decimal, @scale=nil, @null=false, @primary=true, @default=nil>
>
> As @scale is nil and not 0, the simplified_type returned is :decimal,
> not :integer.
>
>
> The corresponding case line :
>        when /num|dec|real/i                   : @scale => 0 ? :integer :
:decimal
> should be replaced by :
>        when /num|dec|real/i                   : (@scale.nil? ||
> @scale == 0) ? :integer : :decimal
>
>
> This works fine for me. If it does for you, could you please open an
> issue so that the next version includes it ?
Guillaume, merci bien pour votres enquêtes.

I can certainly make the fix, but if possible it would be nice to have
an Oracle test to verify the problem and ensure we don''t regress. Can
you tell me how the column in your database is set up so we can create
a test case?

Cordialement,

/Nick

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Guillaume Desrat

2009-Apr-06 16:53 UTC

head link

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Hello,

sorry for answering so late.
> Guillaume, merci bien pour votres enquêtes.
You''re welcome. Thanks for your work, Nick.
> I can certainly make the fix, but if possible it would be nice to have
> an Oracle test to verify the problem and ensure we don''t regress.
Can
> you tell me how the column in your database is set up so we can create
> a test case?
The ID column is defined as NUMBER(38) and the PAGES is an INTEGER
one. The ID is not nullable while the PAGES one is.


Regards,

--
Guillaume Desrat
http://www.rubyfrance.org/
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Ales Bukovsky

2009-May-14 13:40 UTC

head link

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Hello,

First of all, thank you Guillaume very much for the workaround.

I would like to ask whether this issue had been reported in JRuby bug 
tracker? If so, does anyone knows the ticket #>I can''t find it 
anywhere...

Since this problem still exists in 0.9.1 version I''d like to stress
that
it actually renders Rails running on JRuby using Oracle backend (via 
JDBC adapter) almost inoperational. None of the generated path/URL 
helpers (model_url, edit_model_path etc.) and functions that use them 
(like form_for) work. Everything starts running properly with the 
described workaround in place. Note there still could be a related issue 
in Rails as well but the BigDecimal typecast for ID column certainly 
contributes to it.

Thanks

~Ales~

-- 
Posted via http://www.ruby-forum.com/.

Nick Sieger

2009-May-14 14:22 UTC

head link

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

I don''t know of one. Ales, if you could create a new issue for this at
http://kenai.com/jira/browse/ACTIVERECORD_JDBC, that would be great.

Thanks,
/Nick

On Thu, May 14, 2009 at 8:40 AM, Ales Bukovsky
<rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:>
> Hello,
>
> First of all, thank you Guillaume very much for the workaround.
>
> I would like to ask whether this issue had been reported in JRuby bug
> tracker? If so, does anyone knows the ticket #>I can''t find it
> anywhere...
>
> Since this problem still exists in 0.9.1 version I''d like to
stress that
> it actually renders Rails running on JRuby using Oracle backend (via
> JDBC adapter) almost inoperational. None of the generated path/URL
> helpers (model_url, edit_model_path etc.) and functions that use them
> (like form_for) work. Everything starts running properly with the
> described workaround in place. Note there still could be a related issue
> in Rails as well but the BigDecimal typecast for ID column certainly
> contributes to it.
>
> Thanks
>
> ~Ales~
>
> --
> Posted via http://www.ruby-forum.com/.
>
> >
>

Ales Bukovsky

2009-May-14 15:31 UTC

head link

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

It''s officially reported now:

http://kenai.com/jira/browse/ACTIVERECORD_JDBC-17

Thanks

-Ales-
-- 
Posted via http://www.ruby-forum.com/.

Rails - Mar 2009 - activerecord-jdbc-adapter 0.9 oracle number id problem

activerecord-jdbc-adapter 0.9 oracle number id problem

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Re: activerecord-jdbc-adapter 0.9 oracle number id problem

Re: activerecord-jdbc-adapter 0.9 oracle number id problem