Changing JDBC connection for existing Services

[spidie]

Hi There,

I'm working on an integration that I inherited from someone that makes heavy use of the JDBC adapter. The developer chose a non standard name for the connection, and chose to put it in the wrong package - so I basically need a new connection.

However - there are already a heap of adapter services that have been defined and it will take some time to recreate them all.

I looked through the .ndf files in the ns directory for the package hoping that the connection name would be somewhere in the XML and I could change it there... alas no - so I suspect it is held in the IRTNODE_PROPERTY which is not human readable.

Has anyone worked out a way to do this?

Steve

[pblok74]

Renaming seems to be nearly impossible without creating all the adapters again. But you can move the connections to a different package as long as you keep exactly the same namespace.

[spidie]

Thanks Patrick

I figured this was the case. I ended up recreating them all in the end.... http://www.wmusers.com/wmusers/clipart/sad.gif

It's for stupid things like this - that I really loath working with webmethods sometimes...

Steve

[chirag_sanghavi]

Hi,

I know that it is a very late reply to this one.

http://www.khapre.org/blog/index.aspx?pageID=/blog/archives/2004_07_01_index

Check this out.

[chirag_sanghavi]

Hi,

I know that it is a very late reply to this one.

http://www.khapre.org/blog/index.aspx?pageID=/blog/archives/2004_07_01_index

Check this out.

[vishalkhapre]

Changed adderess to this site
http://www.khapre.org/blog/archives/2004_07_01_index.aspx

[sid]

Hi Chirag,
I am trying to decode the information in the IRTNODE_PROPERTY of a SELECT JDBC ADAPTER SERVICE.The node.ndf I'm trying to decode is attached.Going by the suggested solution to decode the same, I wrote the test java program below.

But still I dont see any information in the output.
Can you suggest how to decode/de-serialize the info in the IRTNODE_PROPERTY.

Thanks,
-Sid
====================================
import com.wm.util.coder.XMLCoder;
import com.wm.util.*;
import java.io.*;
public class DecodeAdapterInfo {
public static void main(String a[]){
try {
System.out.println("Start--");
FileInputStream istream = new FileInputStream("C:\\TEMP\\ns\\GE_OFS_JDBC_Adapter_Services\\OFS_ServicesQuoteOrder_Source\\GEPS_CS_FS_GC_INRS_HDR_STG_SelectSQL\\node.ndf");
XMLCoder coder = new XMLCoder ();
Values values = new Values();
values = coder.decode(istream);
java.util.Enumeration enum = values.sortedKeys();
while(enum.hasMoreElements()){
String JDBCInfo = (String)enum.nextElement();
String JDBCValue = values.getString("IRTNODE_PROPERTY");
System.out.println(JDBCInfo+"---"+JDBCValue);
}
String JDBCInfo = values.toString();
System.out.println(JDBCInfo);
System.out.println("--End");
} catch(Exception e){
e.printStackTrace();
}
}
}
==================================

[danielw]

Use pub.art.service:setAdapterServiceNodeConnection .... Changes the connection used by a given adapter service.