Uploaded image for project: 'FishEye'
  1. FishEye
  2. FE-3491

Cannot restore into SQL Server 2008 using built in JAR (without copying the jtds jar into FISHEYE_INST/lib)

    XMLWordPrintable

Details

    Description

      I attempted to restore my sql data from a backup into a SQL Server db:

      C:\Code\fe\output\dist\bin>.\fisheyectl.bat restore --username sa --password magicalityness --jdbcurl jdbc:jtds:sqlserver://localhost:1433;databaseName=crucible3;instance=SQLEXPRESS2008 --dbtype sqlserver2008 --file C:\Demotions\current\dist_inst\backup\backup_2011-11-06_1128.zip
      

      but kept getting:

      WARN: your default encoding (windows-1252) does not support unicode.
      This is likely to cause problems if any of the filenames, branch names or tag names in one of your repositories contain unicode characters.
      Update your locale settings or start with the -Dfile.encoding=UTF-8 option to avoid these problems.
      ERROR - Unable to connect to SQLServer 2008 database jdbc:jtds:sqlserver://localhost:1433;databaseName=crucible2;instance=SQLEXPRESS2008: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver: is the database driver jar file properly installed in the FISHEYE_INST/lib directory?
      Cannot open target database at: jdbc:jtds:sqlserver://localhost:1433;databaseName=crucible2;instance=SQLEXPRESS2008 (Unable to connect to SQLServer 2008 database jdbc:jtds:sqlserver://localhost:1433;databaseName=crucible2;instance=SQLEXPRESS2008: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver: is the database driver jar file properly installed in the FISHEYE_INST/lib directory?)
      Press any key to continue . . .
      

      Until I copied C:\Code\fe\output\dist\lib\dbdrivers\sqlserver\jtds-1.2.5.jar over to %FISHEYE_INST%\lib\jtds-1.2.5.jar

      You should be able to do a restore using the built-in JARs.

      Apologies if this is a user error of some kind.

      Attachments

        Issue Links

          Activity

            People

              mstudman Michael Studman (Inactive)
              aahmed Adam Ahmed (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: