DB.synchronize do |conn|
begin
if conn.isWrapperFor(Java::oracle::jdbc::OracleConnection)
oracle_conn = conn.unwrap(Java::oracle::jdbc::OracleConnection)
end
rescue Java::JavaSql::SQLException => e
oracle_conn = conn
end
# do something with oracle_conn
end
That's working for me.
Am Mittwoch, 24. Januar 2018 15:39:55 UTC+1 schrieb Nicolai Sticht:
>
> I have some problems to access the underlying connection when using Sequel
> with a jndi connection pool.
>
> My code works fine as long as I'm using the following connection url:
>
> url = "jdbc:oracle:thin:#{userid}/#{password}@#{host_ip}:1521:#{db_name}"
>
> DB = Sequel.connect(url)
>
> When is switch to our jndi connection pool
>
> url = 'jdbc:jndi:java:comp/env/jdbc/name'
>
> I get the following error:
>
> NoMethodError: undefined method `createARRAY' for
> #<Java::OrgApacheTomcatDbcpDbcp::PoolingDataSource::PoolGuardConnectionWrapper:0x24c55ed0>
>
> Is there an easy way to access the underlying oracle connection when using
> jndi connection pool with Sequel?
>
> Any help would be very much appreciated.
>
> Regards
> Nick
>
--
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 https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
