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
4 Answers
-
Former MemberPosted on Jun 02, 2004 at 10:48 AMAccording 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
Add comment
-
Former MemberPosted on Jun 03, 2004 at 02:26 PM
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
Add comment
-
Former MemberPosted on Jun 03, 2004 at 05:46 PM
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 comment
Add comment