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.
Thanks.
On Fri, Dec 4, 2015 at 4:30 PM, Jeremy Evans <[email protected]> wrote:
> On Friday, December 4, 2015 at 5:58:42 AM UTC-8, Christian MICHON wrote:
>>
>> Hi,
>>
>> Using the latest release 4.29.0, I'm trying to dump the schema from a
>> rather big oracle instance. I'm using CentOS + jruby.
>>
>> I'm able to perform a dump_schema_migration, but most of my columns have
>> type String, with no size. I've specific columns I know to be 4000
>> characters long, so a 255 character will fail copying data into it.
>>
>> How to configure the dump_schema_migration in order to get the size of
>> varchars? Or is it a know limitation of the schema dumper?
>>
>> Thanks.
>> Christian
>>
>
> Are you dumping with the :same_db => true option? If you plan to dump and
> replay back on the same database, that should make it use the database's
> types.
>
> However, the schema extractor (column_schema_to_ruby_type) should parse
> varchar(4000) as {:type=>String, :size=>4000}. What is the output of
> Database#schema for the column?
>
> 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.
>
--
Christian
--
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.
