Database accessibility while working with thread

Question

5.00/5 (1 vote)

See more:

I am writing mail sending script. In main thread the data is brought from database and mail is sent and as the mail sending starts few changes are made in database like sending_status become 'Sending' etc.

I have used timer thread where every 5 mins a function is called and database is updated.

My doubt is that when the main thread is running it will open connection and if the timer thread starts execution it will produce an error because the connection is already opened by main thread and timer thread will try to open connection with database.

What can be solution to this?

Posted 8-Apr-14 18:19pm

Ami_Modi

Updated 27-Apr-14 19:19pm

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 9-Apr-14 1:01am

Write more reasonable code. You can use a thread instead of timers. Anyway, without seeing your code, it's hard to see where did you screw up.
—SA

Ami_Modi 9-Apr-14 1:06am

I cant write my script here..

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-04-08T20:37:00

Solution 2

I'd suggest you to use SQLDependency class[^] instead updating database every 5 minutes in thread.

Here is an example: Using SqlDependency for data change events[^]

Posted 8-Apr-14 20:37pm

Maciej Los

Updated 8-Apr-14 20:51pm

v2

Comments

Sergey Alexandrovich Kryukov 9-Apr-14 2:49am

Agree. This is more radical approach. My 5.
—SA

Maciej Los 9-Apr-14 2:50am

Thank you, Sergey ;)

Sergey Alexandrovich Kryukov · Answer 2 · 2014-04-08T19:02:00

Solution 1

I suggested the polling schema which eliminates a whole bunch of similar problems. Please see: Polling Database with Timer[^].

—SA

Posted 8-Apr-14 19:02pm

Sergey Alexandrovich Kryukov

Comments

Maciej Los 9-Apr-14 1:51am

Self-reference, i like it!

Sergey Alexandrovich Kryukov 9-Apr-14 2:25am

Thank you, Maciej.
This is a good schema, it solves a number of problem easily.
—SA

Maciej Los 9-Apr-14 2:38am

Yeah!
Sergey, i think there is another solution for that kind of situation. Please, see my answer.