JDBC Adapter 601

81

Rajesh

U need to download the fix from advantage site.

Put the fix in the updates folder in Integration server install directory. Restart Integration server.

I think I came across a similar error recently and this fix corrected it.

Thahir

82

hai thahir
This is rajesh please send a link to download the FIX from advantage
site, i failed to found it on advantage site plase help me.I frequently come accross this problem or if possible sent it an Attachment to me.

regards
rajesh

83

Rajesh,

As Thahir mentioned the fix TNS_6-0-1_Fix39,use the search option in the Advantage site,you will see some results.

Or else send request email for the fix with support@webmethods.com,they will send it to you directly.

HTH
RMG.

84

IS 6.1 - JDBC Adapter
I have a flow service that uses a JDBC Adapter. When I run it standalone it works fine. However when I call it from another flow service it fails. I have checked the values that are being passed in and they look good. I have set my JDBC Adapter for LOCAL_TRANSACTION. Any pointers?? Thanks.

85

Ghaz,

What error is it thowing?Please be more elaborate.

Also make sure the AS input values being mapped are accurate ie datatypes,null values etc…,check the pipeline details again.

Are you directly running the flowservice or stepping thru the service that has pub.art:startTransaction wrapped inside?

HTH,
RMG

86

Problem:

Not able to create JDBC service (Insert, update or any template).

Details:

  1. Successfully enabled JDBC ADAPTERS.
  2. wM Developer is keepon running the New Adapter service, while I am trying to create to NewAdapter Service. It never ends.

Reproduction Steps:

  1. created the JDBC ADAPTERS (successfully).
  2. Navigate to wM Developer -> myPackage -> myFolder -> new -> Adapter service.
  3. select JDBC
  4. select SID
  5. select Template (insert or any)
  6. give the service name
  7. wm ADAPTER KEEP ON SHOWING THE MESSAGE BOX “New Adapter Service” Running. It never ends.

Other simptoms:

  1. if I try to create JDBC Adapter service for the local machine (where wM installed), then wM-Developer is creating and things are working fine.

  2. For the same database, if I am trying to connect from remote wM Developer (I installed webmethod in another mechine) it is giving above problem.

Regards,
PPK

87

Please let me know how to resolve the above problem (new JDBC Adapter service). Do I need to do any settings?

Regards,
PPK

88

webMethods Tech/support Team,
Please provide your update…

regards,
PPK

89

Hi, all

I am rajesh i want how to place EDI ANSI X12 in to sapserver through
SAP Aadpter

please send answer for this as early as possible

regards
rajesh

90

Rajesh,

You can only send SAP IDOC/XML using via SAP Adapter.Before this you may have to convert the EDI X12 message to IDOC.

I am not sure what is ur requirment?please elaborate it.

HTH,
RMG

91

Hai

HTH
RMG

I want Answers for the following questions?
1.How to convert EDI X12 to IDOC.?
2.procedure to send those convrted IDOC to SAPserver?
3.How to get the IDOC of SAPserver to our IS?
4.How to MAP EDI to IDOC?
5.what are RFC,BAPI,ALE for what purpose they are used?

I am learning sapadapter i am new to this so i don’t no how IS convert
documents of clients in the form of XML,EDI ANSI X12 with sapsystem with
SAPAdapter

Thanks for u r reply ASAP

Regards
Rajesh

92

It sounds like you are asking for a complete training course from a volunteer forum.

You may get better results by:

  1. Doing some research on your own first. The documentation is a great place to start it is usually installed as PDF files with the webMethods software. Spend some time browsing what is already on this site.

  2. Using “this” thread for questions regarding the 6.0.1 JDBC adapter.

  3. Focusing on one area at a time and ask questions of limited scope if you want an answer in any kind of detail.

93

Does your boss have a Palm Pilot?

94

I was thinking more along the lines of one of these:

[url=“http://www.imsai.net/s2-advance_order.htm”]http://www.imsai.net/s2-advance_order.htm[/url]

95

Hai

HTH
RMG

I want Answers for the following questions?
1.How to convert EDI X12 to IDOC.?
2.procedure to send those convrted IDOC to SAPserver?
3.How to get the IDOC from SAPserver to our IS?
4.How to MAP EDI to IDOC?
5.what are RFC,BAPI,ALE for what purpose they are used?

I am learning sapadapter i am new to this so i don’t no how IS convert
documents of clients in the form of XML,EDI ANSI X12 to sapsystem with
SAPAdapter

Thanks for u r reply ASAP

Regards
Rajesh

96

Rajesh,

2 things…
1: your question is not in the correct thread, this is for JDBC Adapter [view previous responses…]
2. all answers you need are in the SAP adapter documentation. It will take 10 minutes to create a message and get it into/ out of SAP, starting from scratch. Open a thread in the correct area and you will get better answers and also a simple search via this group will also uncover the wealth of knowledge that we bring.

97

I have a adapter service to execute a stored procedure inside an Oracle package. The stored procedure takes an integer parameter and returns seven values (Char and Numeric). When I execute the service, I get " ORA-01704: string literal too long " Error. But when I execute the same from sqlplus, the stored proc returns correct results.

My guess: The output parameters which are declared as java.lang.String in the adapter service when converted to VARCHAR or CHAR in the DB is not long enough to hold the results. I may be wrong on this.

Any ideas as to what is the cause or how to fix the problem ?

Thanks in Advance.

98

what should be the url and driver for MSSQL database?

i am using-
url - jdbc:microsoft:sqlserver://hostName:portnumber;databaseName=;selectMethod=cursor;

driver - com.microsoft.jdbc.sqlserver.SQLServerDriver

i am getting an error “No suitable driver”

can someone tell me the right url and driver for SQL.

99

Nishita,
Pls refer [url=“wmusers.com”]wmusers.com

Regards,
Puneet Saxena