- 追加された行はこのように表示されます。
- 削除された行は
このように表示されます。
!!!SQuirrel SQL Client
http://squirrel-sql.sourceforge.net/
Javaで動作するSQL Client
!!!A5:SQL Mk-2
http://www.wind.sannet.ne.jp/m_matsu/developer/a5m2/
汎用的なデータベースクライアント。
Oracleなどにクライアントツールなしで接続できる。
!!自動コミットの機能を切る(手動でコミットとロールバックをする)
標準の設定は自動コミットになっているので注意。
+ファイル -> 新規セッション・プロパティ -> SQLタブ開く
+自動コミットSQLのチェックを外す
また、ER図をデータベースから作成できる。
!!起動バッチの改良
@echo off
call setpathjava
@rem IZPACK_JAVA is filtered in by the IzPack installer when this script is installed
set IZPACK_JAVA="%JAVA_HOME%"
@rem We detect the java executable to use according to the following algorithm:
@rem
@rem 1. If the one used by the IzPack installer is available then use that; otherwise
@rem 2. Use the java that is in the command path.
@rem
if exist "%IZPACK_JAVA%\bin\javaw.exe" (
set LOCAL_JAVA=%IZPACK_JAVA%\bin\javaw.exe
) else (
set LOCAL_JAVA=javaw.exe
)
echo Using java: %LOCAL_JAVA%
set basedir=%~f0
:strip
set removed=%basedir:~-1%
set basedir=%basedir:~0,-1%
if NOT "%removed%"=="\" goto strip
set SQUIRREL_SQL_HOME=%basedir%
@rem Check to see if we are running in a 1.6/1.7 JVM and inform the user if not and skip launch. versioncheck.jar
@rem is a special jar file which has been compiled with javac version 1.2.2, which should be able to be run by
@rem that version of higher. The arguments to JavaVersionChecker below specify the minimum acceptable version
@rem (first arg) and any other acceptable subsequent versions. <MAJOR>.<MINOR> should be all that is
@rem necessary for the version form.
"%LOCAL_JAVA%" -cp "%SQUIRREL_SQL_HOME%\lib\versioncheck.jar" JavaVersionChecker 1.6 1.7 1.8
if ErrorLevel 1 goto ExitForWrongJavaVersion
@rem If the changelist.xml file isn't present or the downloaded update jars don't exist, skip launching the updater - these files are created by the
@rem software update feature inside of SQuirreL. So their absence, simply means the software update feature hasn't been accessed.
if not exist "%SQUIRREL_SQL_HOME%\update\changeList.xml" goto launchsquirrel
SET TMP_CP="%SQUIRREL_SQL_HOME%\update\downloads\core\squirrel-sql.jar"
if not exist %TMP_CP% goto launchsquirrel
dir /b "%SQUIRREL_SQL_HOME%\update\downloads\core\*.*" >"%TEMP%\update-lib.tmp"
FOR /F "usebackq" %%I IN ("%TEMP%\update-lib.tmp") DO CALL "%SQUIRREL_SQL_HOME%\addpath.bat" "%SQUIRREL_SQL_HOME%\update\downloads\core\%%I"
SET UPDATE_CP=%TMP_CP%
SET UPDATE_PARMS=--log-config-file "%SQUIRREL_SQL_HOME%\update-log4j.properties" --squirrel-home "%SQUIRREL_SQL_HOME%" %1 %2 %3 %4 %5 %6 %7 %8 %9
"%LOCAL_JAVA%" -cp %UPDATE_CP% -Dlog4j.defaultInitOverride=true -Dprompt=true net.sourceforge.squirrel_sql.client.update.gui.installer.PreLaunchUpdateApplication %UPDATE_PARMS%
:launchsquirrel
@rem build SQuirreL's classpath
set TMP_CP="%SQUIRREL_SQL_HOME%\squirrel-sql.jar"
dir /b /s "%SQUIRREL_SQL_HOME%\lib\*.*" >"%TEMP%\squirrel-lib.tmp"
dir /b /s "%SQUIRREL_SQL_HOME%\libOption\*.*" >>"%TEMP%\squirrel-lib.tmp"
FOR /F "usebackq tokens=*" %%I IN ("%TEMP%\squirrel-lib.tmp") DO CALL "%SQUIRREL_SQL_HOME%\addpath.bat" "%%I"
SET SQUIRREL_CP=%TMP_CP%
echo "SQUIRREL_CP=%SQUIRREL_CP%"
SET TMP_PARMS=--log-config-file "%SQUIRREL_SQL_HOME%\log4j.properties" --squirrel-home "%SQUIRREL_SQL_HOME%" -userdir="%SQUIRREL_SQL_HOME%\profile" %1 %2 %3 %4 %5 %6 %7 %8 %9
@rem -Dsun.java2d.noddraw=true prevents performance problems on Win32 systems.
@rem Run with no command window. This may not work with versions of Windows prior to XP.
@rem Remove 'start "SQuirreL SQL Client" /B' for compatibility only if necessary
start "SQuirreL SQL Client" /B "%LOCAL_JAVA%" -Xmx256m -Dsun.java2d.noddraw=true -cp %SQUIRREL_CP% -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%
:ExitForWrongJavaVersion
主な修正点
*クラスパス作成時の検索対象に libOption を追加
*クラスパス作成時のdirコマンドに/sオプションを追加
*クラスパス作成時のFor コマンドに tokens=* を追加
*クラスパス作成時のパス指定を変更
*SQuirrel SQL 起動時のオプションに userdir を追加
Portableモードとして実行することが可能。
{{category2 ツール,開発}}
{{category2 データベース}}