On Monday, December 7, 2015 at 12:48:15 AM UTC-8, Christian MICHON wrote:
>
> Hi,
>
> I've tried both options:
>
> DB.dump_schema_migration(:indexes=>false, :same_db=>false)
> > create_table(:workflowtasktab) do
> > String :components
>
> DB.dump_schema_migration(:indexes=>false, :same_db=>true)
> > create_table(:workflowtasktab) do
> > column :components, "VARCHAR2"
>
> DB.schema :workflowtasktab
> => [[:components, {:type=>:string, :db_type=>"VARCHAR2", :default=>nil,
> :allow_null=>true, :primary_key=>false, :column_size=>4000, :scale=>nil,
> :max_length=>4000, :ruby_default=>nil}], [...]
>
> For the OS details:
> > uname -a # it's CentOS 6.3
> Linux localhost.localdomain 2.6.32-279.el6.x86_64 #1 SMP Fri Jun 22
> 12:19:21 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
>
> I'm using the following jruby:
> ruby 1.7.23 (1.9.3p551) 2015-11-24 f496dd5 on Java HotSpot(TM) 64-Bit
> Server VM 1.7.0_72-b14 +jit [linux-amd64]
>
> Latest sequel 4.29.0
>
> JDBC Oracle thin driver is latest from Dbvisualizer package.
>
> Since I could not make it work, I used H2 linked tables to make a 'copy'
> of the schema and some of the data into H2. But I'd rather have this
> working natively in Sequel.
>
This looks like an issue in the jdbc adapter, as JDBC doesn't return the
actual database type, leaving off the sizes. To fix, we need to add the
sizes back, but that requires guesswork. To be safe, I'll try doing it
just for string and decimal types that I'm pretty sure accept sizes.
This should affect jdbc/oracle, jdbc/h2, jdbc/hsqldb, and jdbc/derby. Most
other jdbc adapters won't be affected, as they will use the
database-specific schema parsing instead of the generic JDBC schema parsing.
I'm testing this change now. Assuming no issues it should be pushed up
later today.
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
