JDBC Driver Classes / Location

According to the documentation of AF:

"All jar files(for example JDBC or JMS driver) that may additionally be required by the adapters must be located in the Java classpath when install_service.bat is called. Subsequent changes to the classpath have no affect on the created NTService."

<a href="
production\makeresults\misc_java\xi\30_SP_COR\TechnicalAdapters.sda">
production\makeresults\misc_java\xi\30_SP_COR\TechnicalAdapters.sda</a>

(that's a zip)

there TechnicalAdapters.sda\tech_adapter\Administration\Documentation\Adapter.pdf page 9

Did you guys try updating the environment variable CLASSPATH to point it SQL Server driver classpath. I had a similar issue for Oracle drivers and when i update the environment variable [Mycomputer(RMC) properties -> advanced tab -> under user variables you should see classpath or create one and include all the necessary files for class path.

Hope this helps.

Rajan Kidambi

Hi!!!

1. If you start Adapter Engine via run_adapter.bat then you can add a path to a jar file with JDBC driver to this batch file.

2. If you use Adapter Engine as a service, then please check Windows registry:

HKEY_LOCAL_MACHINE\system\currentControlSet\Serives\SAPAdapterEngine\Parameters\JVMoptions\Key1

3. Emergency solution (if all other solutions have failed):

You can unpack JDBC driver jar file into any folder you have under you CLASSPATH.

Start a new console:

a) Start->Run

b) cmd <Enter>

c) echo %CLASSPATH% <Enter>

You will see your CLASSPATH.

You can choose any folder you want, but I strongly NOT recommend you a folder that has exaclty the same subfolder name(s) like folders in your JDBC driver jar file, because you will have a problem when you will want to remove this version of driver, for example.

Good luck!!!

Regards,

Mariusz

Hello, how did you solve the problem?

Thank you

Ernesto