Signal Handling Issue with OCI
551868Aug 11 2008 — edited Aug 20 2008Greetings.
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.