Hello!
I think the steps to update BEA in your case (different steps than I performed, see parenthetical note at end of message) would be to use the Oracle Smart Update utility. This can be found at
C:\bea\utils\bsu\bsu.cmd if you're running Windows. You can run this in Windows because it's a GUI that looks for patches. There is also a bsu.sh for UNIX/Linux installations as well, it appears.
The patches I applied were:
J4BG - Resolution of namespace prefixes in non-conforming
SOAP Messages
1V79 - marshalling of webservice input/output incorrect for some wsdls with top-level elements defined with a type="someType" rather than an in-line complexType
LXKI - exception when web service response contains an xml comment
Your updates may be different.
At this time I'm not certain if there could be other errors with the code you showed me. I haven't built adapters that include SQL SELECT statements in them though, so I lack experience here. But try the smart update and see if that gets you anywhere. I can look back at the code if there are still issues with it.
Hope this helps!
(Sorry it took me so long to get back to you but I needed to look up what updates could be done to BEA WebLogic. I applied patches manually, but I think the steps I did were outlined by my client. As most documentation for my client are proprietary/confidential/get-me-in-trouble-able-if-I-shared-them, I was a little shy about posting those. )