Skip to Content
author's profile photo
Former Member

JDBC Driver Classes / Location

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Jun 02, 2004 at 10:48 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I never done it myself still there are several .bat files there:

      install_service.bat

      uninstall_service.bat

      I thing one should start uninstall_service.bat, change

      install_service.bat and add new paths to the jvmoption2

      <i>Set jvmoption2=-Djava.class.path=.....</i>

      and start install_service.bat again.

  • author's profile photo
    Former Member
    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
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    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
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Jul 26, 2004 at 01:50 PM

    Hello, how did you solve the problem?

    Thank you

    Ernesto

    Add comment
    10|10000 characters needed characters exceeded