SAP Process Integration

SAP Process Integration

SQLITE JDBC Adapter for SAP PI 7.30

  • Posted on: 23 February 2013
  • By: markus.wilhelm

To be able to use the SQLITE Jdbc class within a SAP PI 7.30 JDBC Adapter (sender or receiver) you must mdify the Jdbc class a little.
SQLITE Homepage: http://www.sqlite.org/
SQLITE JDBC Adapter from Xerial: http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC

The default jdbc classes for SQLITE need native libraries being available on the host where the jdbc class is used. Xerial implemented the SQLITE libraries within their SQLITE jdbc class but you must tell the class if you want to use native or build in Java SQLITE libraries. Within the calling code you may set the variable sqlite.purejava.

Example:

public class sample
{
  public static void main(String[] args) throws ClassNotFoundException
  {
    // load the sqlite-JDBC driver using the current class loader
    System.setProperty("sqlite.purejava", "true");
    Class.forName("org.sqlite.JDBC");
...
}

This is not possible within SAP PI, so I changed the jdbc jar to allways use the build in java library for SQLITE. I changed the function getPureJavaFlag file SQLiteJDBCLoader.java in the following way. You may download the jar file here.

package org.sqlite;
 
import java.io.BufferedInputStream;
import java.io.ByteArrayOutputStream;
...
public class SQLiteJDBCLoader
{
...
    static boolean getPureJavaFlag() {
        //return Boolean.parseBoolean(System.getProperty("sqlite.purejava", "false"));
        return true;
    }
...
}
This now enables you to use SQLITE JDBC Adapter within SAP PI 7.30 as all other jdbc database connection:
- JDBC Driver: org.sqlite.JDBC
- Connection: jdbc:sqlite:/usr/sap/trans/interfaces/example.db
- leave username and password empty

SAP PI 7.10

  • Posted on: 21 January 2009
  • By: markus.wilhelm

Hi all,
well it's time to talk about IT now on my website. As you can see we do have several topics in my daily live at work and afterwards. Two years ago I managed to get a certified SAP PI 7 development consultant and after the implementation project we had a big change before Christmans. We upgraded our SAP Process Integration Server (formally known as SAP Exchange Infrastructure XI) from Pi 7.00 to PI 7.10.
We decided to upgrade our development system and to install the production system new. This way we were able to use a stepped approach. We ran two systems at the same time, one wasrunning the old PI 7.00 and one was running the new PI 7.10. Then we moved step by step every interface from the one instance to the other. As we were finished we switched off the old system and that's it.
one thing for you to think about: Be very caredfull with your SLD. Our SLD crashed during upgrade and it was a *** work to get it running again.

SAP Certified Development Consultant SAP NetWeaver 7.0 - Exchange Infrastructure

  • Posted on: 1 July 2006
  • By: markus.wilhelm

Hi,ich habe die Zeritifzierung zum "SAP Certified Development Consultant SAP NetWeaver 7.0 - Exchange Infrastructure" bestanden. Mit dieser Zertifizierung vertiefe ich mein Know How im Bereich der Schnittstellen. Nachdem ich mit Seeburger Business Integration Server jahrelang Erfahrungen gesammelt habe rundet mein Know How für SAP PI 7.0 mein Profil ab.