Sitemap

Amicuk Programming Answers

ABAP MDM Connection Pool

-0001-11-30   Views:2

Advertisement

Hi, I'm trying to write a report that extracts information from MDM. Everytime it's called, it has to establish a new connection to MDM where the hand-shake takes about 20-30 secs. I was wondering if ABAP MDM Connection Pooling exist. In Java MDM, yo

Hi,
I'm trying to write a report that extracts information from MDM. Everytime it's called, it has to establish a new connection to MDM where the hand-shake takes about 20-30 secs.
I was wondering if ABAP MDM Connection Pooling exist.
In Java MDM, you can configure J2EE with connection pool, so that you can reuse a connection rather than re-establishing a new connection on every call.
I've read Thomas Jung's WIKI on "How do you implement a MDM Connection Help Class?", however I cannot reuse this class. The static attribute in the class is not persisted.
Did I do something wrong?
I tried turning it into a shared memory root class, however it complains about an object reference still exist and would not allow me to do "dettach_commit( )".
Don't know any other ways to store the connection handle in memory.
Export/Import, SPA/GPA are not OO friendly.
Cheers
Michael

The replay answer
Advertisement
Hi Andreas,
Thanks for your reply, it is good to confirm my understanding of the ABAP API connection.
For your interest, I have changed part of the connection code to increase the speed of the connection significantly.
Firstly to clarify, the connection from the ABAP stack to MDM is actually quite fast.
Upon the first call, the method CL_MDM_PROVIDER_SP04_PL03->_LOAD_FIELD_INFORMATION is called which reads the META-DATA from MDM for every table and every field. This could normally take 1 minute in our system landscape. I've changed to code to buffer the meta-data.
In a production/stable environment, it is unlikely for the META-DATA to change rapidly. Hence reading this on every connection is a waste of time.
This could be useful only if we are in implementation phase where this changes all the time.
1) In transaction MDMAPIC, I've added the ABAP implementation for MDM Version Support as my own MDM provider class ZSP04_PL03 with provider type ZCL_MDM_PROVIDER_SP04_PL03.
ZCL_MDM_PROVIDER_SP04_PL03 is a copy of CL_MDM_PROVIDER_SP04_PL03.
2) In ZCL_MDM_PROVIDER_SP04_PL03, the method LOADFIELD_INFORMATION is changed to read from buffer first before calling MDM. If the buffer is empty, it will read from MDM and store result into buffer etc.
I'm storing the information in a transparent table at the moment.
I buffer the three class attributes:
- mt_field_meta_data,
- mt_mdm_field_meta_data,
- mt_field_code2id_map.
As MT_FIELD_META_DATA is a complex structure (i.e. tables within table), I had to split it up into many different tables.
I can provide the code if you are interested.
Cheers,
Michael.

Go to See the other 5 answers

ABAP MDM Connection Pool

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm trying to write a report that extracts information from MDM. Everytime it's called, it has to establish a new connection to MDM where the hand-shake takes about 20-30 secs. I was wondering if ABAP MDM Connection Pooling exist. In Java MDM, yo[More]

ABAP MDM Connection Pool concept? Slow Performance in call

Category:DefaultRelease time:2015-10-11Views:130

Hi, I'm playing around with the MDM ABAP API, and I found the performance a bit disappointing. I followed the guide "How To identify master data records using SAP MDM 5.5 ABAP API's" and wrote a test program. The program makes a connection, trig[More]

Connection Pool establishment problem

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, we have one application with JCo mechanism. For this application, we are using one properties file, which holds ABAP connection information. From this connection information(sapconn.props), we created connection pool and fetching data fro[More]

Connection pool exausted

Category:DefaultRelease time:2015-10-11Views:130

Dear all, I am new to j2ee environment. RFC from PI Java stack to PI ABAP stack failing intermittently. Error message: Error while lookupProblem when calling an adapter by using communication channel CC_RFC_LookUp (Party: , Service: PPICLNT900, Objec[More]

Connection pool -  api

Category:DefaultRelease time:-0001-11-30Views:130

Hi, the following code try to connect mdm with connection pool : <i> Context ctx = new InitialContext(); IConnectionFactory connFactory =    (IConnectionFactory) ctx.lookup("deployedAdapters/MDM Factory/shareable/MDM Factory"); IConnection[More]

Java Documentation to Connection Pooling?

Category:DefaultRelease time:-0001-11-30Views:130

Hello, is there any Java API documentation to the Connection Pooling available? It is not listed in the SP03-Docu, but the classes exist. I don't know how to use them, so any help would be appreciated. Ah, and the Weblogs by Uri Katz are good, but no[More]

How to download ABAP(report,module pool...etc) source code to client PC?

Category:DefaultRelease time:-0001-11-30Views:130

hi guys, please advise how can i download/export ABAP(report,module pool...etc) source code to client PC? thanks.hi this report is to export to another server... PROGRAM ZDOWNLOAD_SAP LINE-SIZE 132 LINE-COUNT 62 NO STANDARD PAGE HEADING. This program[More]

RFC_FAILURE affects Connection Pool

Category:DefaultRelease time:2015-10-11Views:130

Using VB.NET (2003) with .Net Connector 2.0. An intermittent problem causes a RFC Call to fail, and an exception is raised in the .NET code. The Exception message is:      See RFC trace file or SAP system log for more details The Trace file shows: ER[More]

Connection pool / db failure

Category:DefaultRelease time:2015-10-11Views:130

WLS6.0 sp2 / Win2k Oracle 8.1.7 / Solaris 8 problem is if DB fails, the connection pool fails, and will not restart. If I run a java weblogic.Admin EXISTS_POOL command, it says the pool doesnt exist. If i run a RESET_POOL, using the system user passw[More]

RFC_ERROR_SYSTEM_FAILURE: Time limit exceeded. Connection Pool - JCO api

Category:DefaultRelease time:2015-10-11Views:130

Hi Everyone My Connection  Pool parameters JCO api. client=300 user=SISGERAL_RFC passwd=****** ashost=14.29.3.120 sysnr=00 size=10 I have these parameters on my Connection Pool and sometimes appear these wrongs in my application: 1. 2006-01-07 13:20:[More]

Connection Pool Failure: "No suitable driver"

Category:DefaultRelease time:2015-10-11Views:130

Hi, Upon server startup, I get the following result: <Nov 7, 2001 4:18:32 PM CST> <Error> <JDBC> <Cannot startup connection pool "ora cleTrufflePool" No suitable driver> I assumed it was a path problem, but in the startWe[More]

Hot
I am trying to log onto a webinar. Their website says Adobe Flash Player is disabled. I have been on Adobe website and it has checked my computer, saying that my Flash Player is enabled. Where do I go now?Hi, Which OS and browser you are using and wh [More]
I find that the Adobe forums are a great place for help and feedback. But it seems so difficult to get a response here in the Designer forum. In the other forums, I'll be getting responses to my question within an hour. Here, days will go by without [More]
I'm developing an application using EJBs in a development environment with Sun Application Server, Sql Server and NetBeans IDE 4.1. I'm using entity beans and session beans in my application. But, when I try to connect to database using a Servlet or [More]
Hello there,I have SoundBlaster Li've! 24Bit with Inspire T7900 7. Speaker System. I upgraded to Windows Vista 32Bit, used the latest Creative Driver (Feb 2007)?and now I have sound and speakers test is working....but not in music playback and stuff. [More]
Hey guys, just updated to firmware on my Sony A7II to 1.20 (from 1.10) and I'm noticing something really strange that I've never seen before. My LCD screen now has this odd blue square taking up the entire center of the screen. I took a pic with my p [More]
Hi Experts, I have a process order for quantity 1410, which has been confirmed also...if i check the order the confirmed qty and the delivered qty is showing as 1410 but the committed qty is showing as 987.. is that mean when availabilty check happen [More]
Hi, IM with SAP BYD and I have some bank statement in MULTICASH format , this format its Ok in SAP R3 but in SAP BYD i dont see the oportunity to charge with format MULTICASH, anyone know if the format ceased to exist. Regards Anthony LeveauHola Anth [More]
Hello All, We are Upgrading from SRM 5.0 Classic to SRM 7.0 Extended Classic Scenario now. In SRM 5.0 Classic scenario pricing and taxation taken care by R/3 system. Now as part of ECS migration taxation and pricing to be moved from R/3 to SRM as lea [More]
Hi all, After a difficult - but successful - upgrade of my iPhone 4S to iOS 7 (I haven't restarted my PC after upgrading iTunes, put the device in DFU mode because it was not recognised by iTunes while remained in "connecting to iTunes" screen) [More]
So I have an iPhone and want to be able to view photos for the most part on the go without having a ton of photos on my phone. Hope to have an iPad in the future to go along with this, but just iPhone for now. I have a MobileMe account already. Which [More]