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
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.
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
Creating a concrete WSDL from a secured webservice seems to take more steps.
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!)
Just capturing how to load and configure Tibco Designer for connections to oracle database.