Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Signal Handling Issue with OCI

551868Aug 11 2008 — edited Aug 20 2008
Greetings.

I have a library using OCI with Oracle 10g.
I am not doing any signal handling inside the library.
I have realized after a connection is made to Oracle 10g server and successfully terminated, the ctrl+Z signal (SIGTSTP) would not be honored. If I use the same library and make no connection to database, then the signal is honored. Other signals such as SIGINT etc are OK even if I make connections to database server.

Operations that I do using OCI are simple:
1- initialization of context (standard env creation, set attributes, handle allocation etc)
2- making connection
3- inserting using SQL insert method (statement prep, defineByPos, execute)
4- simple selection of last value of a sequence (statement prep, defineByPos, execute)
5- clean up (OCISessionEnd, OCIServerDetach,and freeing handles)

Again, I have no signal handling inside the library. I am using this over Solaris OS and the functionality is correct except for this signal issue.

My questions:
1- Is this a known issue or is this something that has been seen before?
2- what sort of signal handling is in OCI that could potentially impact my app?
3- Is there any solution that you could suggest?

thank you in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2008
Added on Aug 11 2008
9 comments
2,392 views