Forum Discussion

Michael_Heinze's avatar
Michael_Heinze
Contributor
16 years ago

[SOLVED]jdbc sql driver error

hello,

i have a fresh install of 3.5 beta 2 with ms sql server driver nightly version Build daily-2010-02-17-[1], Build Date 2010/02/17 06:27.

when i open a project created in 3.0.2 with a sql query to delete from database i am getting a load jdbc driver error when i test the connection:

Can't get the Connection for specified properties; java.lang.Exception: Failed to init connection for drvr [com.microsoft.sqlserver.jdbc.SQLServerDriver], connectionString [jdbc:sqlserver://nightly-db1:1433;databaseName=Reservation;user=STUser;password=#####]

when i now copy the driver file sqljdbc.jar from soapUI-Pro-3.5...\jdbc_drivers to soapUI-Pro-3.5...\bin\ext it works fine.

seems to be some hardcoded file reverence or a not included load path.

regards,
Chris

4 Replies

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    16 years ago
    Hi,

    The JDBC Driver to load and use for the DataSource  must be available in the soapUI classpath either by placing it in a soapui/bin/ext directory, the jre/lib/ext directory or by directly modifying the soapui.bat/.sh files to include the required jar files. Therefore you have to manually add the driver, or during the installation you can check to include it.
    The thing is that new version is being installed to new path by default and is not using the old bin/ext content.
    This is the way it works and not a bug.

    Regards,
    /Dragica
    eviware.com
  • Michael_Heinze's avatar
    Michael_Heinze
    Contributor
    16 years ago
    hello,

    i had checked the install sql driver during the setup. but it wasnt copied to the /bin/ext folder.

    i did another install right now on a machine where 3.5 wasnt installed before and it was the same behavior: sql driver install was checked during install, but sqljdbc.jar isnt copied to the bin/ext folder.

    in my opinion if there is an install option it should be copied and no manual action should be required.

    regards,
    Chris