That’s how we followed steps :
With DB Configurator , I created DB components -
User DB Component
WMB2B_IS IS Product
WMB2B_TN TN Product
WM_MWS MWS Product
Then DBA created a one user called “WEBM” and grant select,insert,delete,update roles to this user on Schemas - WB2B_IS ,WMB2B_TN,WM_MWS.
(Note : DBA created WEBM just as user ,it has no objects underlying it but it has access to other schemas)
So in JDBC Pool connections ,we are using a schema user (WEBM) instead of schema owner (WMB2B_IS,WMB2B_TN,WM_MWS).
Now while passing connection parameters ,
jdbc:wm:oracle://elgwmdev:1527;serviceName=webm82d
User : WEBM
pwd : *******
I need a param to pass the schema owner name (WMB2B_IS , WMB2B_TN or WM_MWS).And as per guide for DataDirect Connect JDBC 4.2 driver ,I don’t see any param provided to pass the schema name.
It seems like it’s a driver limitation and we have to use schema owner as User while estabilishing connection.
Any thoughts ?
#webMethods#webMethods-Archive#Integration-Server-and-ESB