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
From crash report Crash Reason: EXCEPTION_ACCESS_VIOLATION_EXECIf you have submitted crash reports then please post the IDs of one or more crash reports that have this format: *bp-xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx You can find the IDs of the submi [More]
I can't even get the combination to serve a .jsp file or .html file. Regardless of the URL that I attempt, I only get a No Context configured to process this request error from tomcat and INFO [Engine] StandardHost[localhost]: MAPPING configuration e [More]
I have the need to encrypt a zfs file system in solaris 11. and solaris 11 disk. any ideas? Solaris 11 is installed in a laptop.Yes, just enable the encryption property on the home directory datasets and not any others. Since what you want to protect [More]
Hi everybody! I bought an iMac a few months ago; I chose the 24" model with 2.93Ghz, and the GT 120 Graphic card. My question is: Is this graphic card soldered to the motherboard? What kind of Socket does it use? If one day I realize I need more GPU [More]
I just bought my ipad2 and I'm trying to access the app store but it takes a very long time to load. Is this normal? At first I thought it was just my Wi-Fi connection, but I can access safari, mails, etc in seconds but not the app store.If it is bra [More]
Hi, I haven't done that much JSP development using various tag libraries prior to looking at JSF, hence this very basic question: I am declaring and manipulating Java variables in my JSP. Is there a way to access those in my JSF tags? It seems that s [More]
Hello All,   Has anyone come across this situation before ? I have created a simple adobe form in NDS (Designer) but the deployed form that appears in IE is different. Any feedback or suggestions will be appreciated. Thank you. from Kwok WeiHello All [More]
Hi Rate category  having   Billing scheme  and  Rate category  facts. Please  let me know during  billing, on what  basis  both(  Rate category facts and billing scheme)   will trigger. and  what is difference  between them. Thanks, RaviRavi: Please [More]
Bonjour, Je continue ma découverte d'Audition (il est temps, je l'ai acheté il y a 3ans et demi!) de la suite CS5.5. J'ai vu qu'il était possible en multipiste d'insérer un fichier vidéo pour plus facilement caler l'audio retravaillée sur la vidéo. C [More]
As the topic, how can i restore Ipad one with the same IOS 5.xYes, you can connect it to iTunes on a computer, and perform the restore there: Use iTunes to restore your iOS device to factory settings http://support.apple.com/kb/ht1414Read other 5 ans [More]