With two family members as CO's you have my respect and understanding.
You came on here with a very legitimate concern and there's been a few 'off topic' ignorant statements made. Consider them for what they are as unfortunately there are some that have zero concept of the character of many that float in and out of the penal system in which you work in daily.
You have every right to be concerned.
So, back on topic.
Are you locked into either a 9mm or 40cal. in a semi auto?
Also, what least capacity weapon would you feel comfortable with?