Hi,
I am trying to configure a JDBC Adapter on my local machine, but I cannot start the adapter due to the adapter engine not finding the JDBC Driver.
This is the error:
08:27:31 (4310): ERROR: Attempt to load JDBC driver failed ("com.microsoft.jdbc.sqlserver.SQLServerDriver")
Attempt to intialize JDBC adapter failed
08:27:31 (4304): Unable to start JDBC adapter (not initialized)
Can you tell me where I can get the Driver and what settings need to be made on my local adapter engine or pc i.e. setting classpaths etc.
Thanks
Mark
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
Add a comment