Hi Mark

Thanks for the response

We start our sap pi system via SAP management console
VM Name:

SAP Java Server VM


VM Vendor:

SAP AG


VM Java Version:

1.6.0_85

VM Runtime Version:

6.1.072 24.71-b13


Im wondering if the VM runtime version is the issue
Tested with Jaybird-2.2.13-JDK_1.6.zip<https://github.com/FirebirdSQL/jaybird/releases/download/v2.2.13/Jaybird-2.2.13-JDK_1.6.zip> and Jaybird-3.0.1-JDK_1.8.zip<https://github.com/FirebirdSQL/jaybird/releases/download/v3.0.1/Jaybird-3.0.1-JDK_1.8.zip> same error as below


We have SQL JDBC deployed and that works connecting to a SQL database


Classpath environment variable set as system varible
echo %classpath%
E:\usr\sap\D30\DVEBMGS00\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib\jaybird-full-3.0.1.jar

Driver deployed on SAP PI java
antlr-runtime-3.4.jar
com.sap.aii.adapter.lib_api.jar
connector-api-1.5.jar
jaybird-full-3.0.1.jar
log4j-core.jar
sqljdbc.jar

Driver class is org.firebirdsql.jdbc.FBDriver
JDBC URL jdbc:firebirdsql://172.25.1.98:3050/C:\SIGMAMRP\SIGMAMRP.FDB

Error when testing connection
ClassNotFoundException Occurred : Driver Class Could not be found.org.firebirdsql.jdbc.FBDriver
---------------------------------------------------------------
Exception Stack Trace : java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
------------------------- Loader Info -------------------------
ClassLoader name: [sap.com/testconnectionsEAR]
Loader hash code: 4829e40a
Living status: alive
Direct parent loaders:
[system:Frame]
[interface:webservices]
[interface:cross]
[interface:security]
[interface:transactionext]
[library:webservices_lib]
[library:opensql]
[library:jms]
[library:ejb20]
[service:p4]
[service:ejb]
[service:servlet_jsp]
Resources:
E:\usr\sap\D30\DVEBMGS00\j2ee\cluster\apps\sap.com\testconnectionsEAR\servlet_jsp\ftpjdbc\root\WEB-INF\classes


From: Firebird-Java@yahoogroups.com [mailto:Firebird-Java@yahoogroups.com]
Sent: Friday, 18 August 2017 2:10 PM
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java] FW: jdbc driver error



On 2017-08-18 09:22, Andrew Fletcher andrew.fletcher@...
[Firebird-Java] wrote:

> Hi
>
> We want to connect from our sap PI system to a database running on
> Firebird Version 2.5.4
>
> We have deployed JDBC driver jaybird-3.0.1.jar into our pi(java)
> system and set classpath environment variable to the location of the
> driver
>
> Below is the error which we are getting when we try to connect to
> Database
>
> Please can you assist with a solution.
>
> Is there a way to connect SAP ERP ehp6 to firebird database?
>
> Driver Class Could not be found.org.firebirdsql.jdbc.FBDriver

Please include the error as text, attachments are stripped, and also
post exactly how you defined your classpath and how you start your
application (and note that most Java applications will ignore the
CLASSPATH environment variable). However if you need support for how to
correctly include JDBC drivers in SAP ERP, I suggest you contact SAP
instead.

If I had to guess, the problem is either that SAP ERP does not use the
classpath environment variable (most Java applications don't use that)
or that you forgot to include the connector-api-1.5.jar dependency of
Jaybird.

Mark


Andrew Fletcher
SAP Basis Consultant
T
M +27 83 4695729
Eandrew.fletcher@...

http://www.britehouse.co.za

View our disclaimer at: http://www.britehouse.co.za/Pages/disclaimer.aspx



[Non-text portions of this message have been removed]