Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

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

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

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

    Hello, how did you solve the problem?

    Thank you

    Ernesto

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.