On Tuesday, April 14, 2015 at 8:09:28 AM UTC-7, John-Junior Murray wrote:
>
> Hi,
>
> I'm having a few issues using Sequel and I'm wondering if you can help.
>
> The Oracle database we connect to requires pooled connections (handled on
> the database side). I can see in the documentation that you're able to
> specify max_connections, but this launches X amount of dedicated
> connections.
>
> we're currently connecting as below
>
> $db = Sequel.oracle('database', :user=>'user', :password=>'pword',
>> :max_connections=>80)
>
>
> Is there a way you can either -
>
> 1) Specify that the database should pool the connections instead of the
> app.
>
I don't think Sequel supports this currently. However, if you let me know
how you do it using ruby-oci8 directly, I may be able to explain how to do
so with Sequel, or provide patches.
> 2) Pass an oracle connection string into sequel?
>
I don't think Sequel uses oracle connection strings, but you can use
Sequel's general connection string handling:
DB = Sequel.connect('oracle://user:pword@host/database')
Again, if you can show what you want using ruby-oci8 directly, I may be
able to provide more help.
Also, as shown here, it is a better idea to use a constant and not a global
variable for storing the Sequel::Database object.
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.
