Need help with inserting date value into Oracle8i in the format dd-MMM-yyyy format.

Your help would be hightly appreciated.

-Pauly

use pub.date.DatetimeFormat service to format date string into dd-MMM-yyyy

hope this will work

Thanks & Regards,
Radhakrishna

We are facing an issue while deploying adapter services from one environment to the other in webMethods

JDBC Adapter Version: 6.5

Fixes: JDBC_6-5_Fix4
JDBC_6-5_Fix7
JDBC_6-5_Fix8

Procedure followed to deploy adapter services/connections in new environment:

1.   We have the JDBC adapter connections and adapter services maintained in separate packages. 
   

a. Across environments (Dev, QA) we have the same JDBC adapter connection name and DB schema name. Therefore upon deployment, we edit the application server name, password for the adapter connection and enable the connection. Connection looks fine.

b. Install the adapter services package and check references for all adapter services.(storedProcedureWithSignature). All services have correct references to the adapter connection

The Issue

1.   When the adapter service (configured for storedProcedureWithSignature) is executed I get the following error:
   

Could not run .com.wm.app.b2b.server.ServiceException: [ART.117.4021] Adapter Runtime (Adapter Service): Unable to invoke adapter service cox.cns.eventprocessor.services.adapter:hasOtherActiveServices. Unable to get adapter service template.
[ART.114.72] Adapter Runtime: Unable to set JavaBean properties.
[ART.114.542] could not set property “resultSetInfo” in class “com.wm.adapter.wmjdbc.services.ProcedureSignature”.
Method not found: getResultSetInfo
Also upon subsequent execution of service null exception is thrown

2.   Though once the adapter service is saved and executed, the service runs successfully. No major changes made to the adapter service when it is saved. 
   

3.   This is not the right approach and therefore looking for a solution to this strange problem.
   

If anyone has experienced such issues or has any insights on the above condition, please send in your comments. Any suggestion would be helpful!

Attempted to set the JDBC adapter got this error message any suggestion to resolve this issue would be much appreciated.

From your error message, it looks like you are not specifying the webMethods folder path and a name for the connection while creating the connection, or are specifying invalid characters.

Have you already setting a valid value?