I really wish that there was a standard XPath function to return just unique values. Here's how I attacked the problem ...
After building an initial database adapter, I could not get it to work and got this error while running it locally on the adapter tester:
ActiveDatabaseAdapterConfiguration.ActiveDatabaseAdapterConfiguration Error [Database] AEADB-100004
DBError: Database driver code: HYC00
Database server code: 0
Database driver message: [tibcosoftwareinc][ODBC Oracle Wire Protocol driver]Optional feature not implemented.
Spoiler alert: Need to change the database field type on adb_timestamp from timestamp(6) with time zone to just an oracle date field
I go long stretches between Tibco BW work and I find myself trying to recall how to do some tasks. This is one way I I took a repeating Name Value node and put it into a serial string. Maybe better ways to do this but this worked for me.
After upgrading to TibcoDesigner 5.7 (BW 8.9), my jdbc connections failed.
When I'd test I'd get this message:
Configuration Test Failed. Failed to find or load the JDBC driver: tibcosoftwareinc.jdbc.oracle.OracleDriver
On my Win7 box with Designer 5.7/ Business Works 5.9, I could not start the adapter tester. I had just loaded this release.
Thanks to one of my co-workers (Vara), he showed me a quirky ODBC creation.
I had used MS Visual Studio 2005 XSD editor to quickly create XSD schema documents from oracle tables for many of my tibco projects.
Now the company has loaded VS2008, I can't find that capability.
Lo and behold MS dumped it (jerks!)
Creating a concrete WSDL from a secured webservice seems to take more steps.
Capturing this fix for SoapUI when
calling a secured webservice.
This error showed up when I validate the project and when I clicked on go to resource, nothing happened and I didn't go anywhere
Just capturing how to load and configure Tibco Designer for connections to oracle database.