I have a problem in installing the trading networks on my local machine. I dont understand if iam making the mistake in giving the exact JDBC URL while installation.
This is the URL i give when installing the IS, TN, Broker. Dont know if i have to give the table name also here.
URL - jdbc:wm: oracle://localhost:1521;serviceName=orcl
orcl is the SID of Oracle Database
In the server logs i get this error:
[Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
“ErrorMsg=com.wm.app.tn.db.DatastoreException: Trading Networks could not retrieve data from your database. Go to the JDBC Pools page in the Integration Server Administrator and make sure your database URL, user name, and password are set correctly. Also make sure you created the Trading Networks database tables as described in the webMethods Installation guide”
I tried to create using Database Component Configurator with the Database Componenent specifying “PRODUCT - Trading Networks” and the same url given above but here it get this error:
[Oracle JDBC Driver][Oracle]ORA-00959: tablespace ‘WEBMDATA’ does not exist
Can someone please tell me what mistakes i do while using Database Configurator and while specifying the jdbc url.