Odoo Help

0

Unable to use a closed cursor and Thread

By
meriem HAKKANI
on 11/21/16, 5:23 AM 722 views

Hi

I'm developing a module importing data into a thread,Following this line I have an exception :

Unable to use a closed cursor

self.env['product.product'].search([('default_code', '=', internalRef)])

but if i don't use thread I have no exception

thanks a lot


Please show us some more of the code, it looks like the problem is on another line? :)

Yenthe
on 11/21/16, 5:41 AM
0
meriem HAKKANI
On 11/21/16, 5:52 AM

Hi Axel Mendoza

thank you very much for you answer , i tried this 

api.Environment.manage()

new_cr = registry(self._cr.dbname).cursor()

new_cr.autocommit(True)

self = self.with_env(self.env(cr=new_cr)).with_context(original_cr=self._cr)


0
Axel Mendoza
On 11/21/16, 12:12 PM

Hi Merien Hakkani

In Odoo database cursor are opened at the beginning of the request and closed after the request is processed so it means that if you are using a new thread the cursor could or couldn't remain open when you wanna use it, normally it wont be open, so you may need to create a new env for self.env  with a new cursor attached in order to make it always work

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 11/21/16, 5:23 AM
Seen: 722 times
Last updated: 11/21/16, 12:12 PM