I'm using Sequel with Sinatra and I created a method to get the content
from database, something like:
def getContent(sql)
require 'sequel'
dsn={
:adapter=>"oracle",
:database=>"mydatabase",
:user=>"myuser",
:password=>"mypassword"
}
connection = Sequel.connect(dsn)
res=connection.fetch(sql)
connection.disconnect
Sequel::DATABASES.delete(connection)
return res
end
But it seems that the connection to the database is not terminated so after
a few hours i reached the limit of connections on my database: OCIError:
ORA-12516: TNS:listener could not find available handler with matching
protocol stack
Any idea about how to solve this problem
Thanks.
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sequel-talk/-/yaj2jtX6AQ8J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
