% New Features And Changes In Stew4
+
+
+## New Features
+
+The new features in version 4 are listed below:
+
+special command "?" - display environment info (not OS ENV).
+: Display System Properties. (System.getProperty)
+ By defauts, displays JRE, OS and Locale.
+
+
+xxx
+: xxx
+
+
+For more details, see MANUAL.html.
+
+
+## Changes
+
+The major changes since version 3 are listed below:
+
+Requires Java6 and later
+: Java5.0 was not supported.
+ And replaced with codes including enhancements and new APIs in Java 6.
+
+Implementation
+: Improved implementation with Java6.
+ Specifically, Unnecessary classes was removed, and some codes ared replaced with more fitting APIs.
+
+
+## Others
+
-% Stew User Manual
+% Stew4 User Manual
%
% version 4.0
+
+
+## What Is Stew ?
+
+...
+
+
+## PRECAUTIONS
+
+### Password Management
+
+...
+
+
+For details, see [How To Use - Connector Settings](#Connector-Settings).
+
+
+### Rollback Does Not Work When The Connection Is Disconnecting
+
+
+...
+
+
+For details, see [How To Use - Connector Settings](#Connector-Settings).
+
+
+### Other
+
+For more information, see the project site.
+<http://stew.sourceforge.jp/>
+
+
+## Installation
+
+
+...
+
+
+
+## Running App
+
+If you want to use GUI mode, execute the following command:
+
+ > java -jar stew.jar --gui
+
+If you want to use CUI mode, execute the following command:
+
+ > java -jar stew.jar --cui
+
+At first time, a system directory ".stew" created. It is used by some configurations.
+By default, ".stew" creates at the current directory.
+
+
+## Uninstallation
+
+Remove all of installed files and ".stew" directory.
+
+
+----------------------------------------------------------------------------------------------------
+
+## Usage
+
+To access database with Stew, you need DBMS that supports JDBC and its JDBC driver.
+For details, see the manual of DBMS.
+
+
+### Configuration Of "Connector"
+
+In Stew, an asset of JDBC Connection called it "Connector".
+
+In CUI mode, to start edit tool, specifies --edit option.
+
+ # command line
+ $ stew --edit
+ # running stew
+ > --edit
+
+In GUI mode, executes "Edit Connectors" to start edit dialog.
+
+
+Connector has the following properties:
+
+Connector ID
+: ID for connector command. Allows only ASCII letters (A-Za-z0-9).
+
+Connector Name
+: The name to display at Prompt.
+
+Classpath
+: Specifies classpath of JDBC driver. This form is same with -CLASSPATH option.
+
+Driver
+: Specifies the driver class that implements java.sql.Driver.
+ (In GUI mode, you can use the "search Driver" button.)
+
+URL to connect
+: Specifies JDBC URL (same as url at DriverManager.getConnection(url)).
+
+User
+: Specifies the user ID.
+
+Password
+: Specifies the password of its user ID.
+
+Encryption
+: Specifies the type to save password into file.
+ See the next section.
+
+Readonly
+: Is set to READONLY the connection, so that you can not run the commands that update.
+ (., Which according to ReadOnly the command side)
+
+Auto Rollback
+: If it was set, the transaction will be rollbacked automatically when disconnect.
+
+
+
+### About Password Management
+
+How to save the password, you can select the encryption process.
+
+PlainTextPassword
+: Saves as plain text. (default)
+
+PbePassword
+: You can store your password by using the PBE encryption.
+
+
+### Anonymous Connector
+### Interactive Mode
+### Non-interactive Mode
+### Alias
+## Commands
+### connect - Connects to database (built-in)
+
+ > connect <connector-id>
+ > -c <connector-id>
+
+This command connects to database with prepared Connector.
+
+In interactive mode, connection is kept until disconnect.
+If already connected, disconnect it first, then connect.
+
+
+### disconnect - Disconnects from database (built-in)
+
+ > disconnect
+ > -d
+
+This command disconnects from database.
+
+If auto-rollback was available, try to rollback before disconnecting.
+
+
+### commit - Commits current transaction (built-in)
+
+This command commits current transaction.
+
+** caution: Commit cannot cancel. Please use carefully. **
+
+
+### rollback - Rollbacks current transaction (built-in)
+
+This command rollbacks a current transaction.
+
+
+### -e - Evaluates multiple commands (built-in)
+
+ > -e <command> -e <command> ...
+
+For example, you can execute two export command continuously,
+ or can execute as batch in non-interactive mode.
+
+
+### -f - Executes file content as command (built-in)
+
+ > -f <file>
+
+...
+
+
+### -s - Executes file content as script (built-in)
+
+ > -s <file>
+
+( default=JavaScript )
+
+The following variables will be available in the script:
+
+ * object of current connection: connection, conn
+ * object of Parameter: parameter, p
+ * object of OutputProcessor: outputProcessor, op
+
+
+### cd - Changes current directory (built-in)
+
+ > cd <directory>
+
+Changes current directory to specified one.
+(This current directory is not OS's, but internal Stew.)
+
+
+### @ - Displays directories (built-in)
+
+ > @
+
+Displays the paths of current directory and system directory.
+
+
+### alias - Registers alias (built-in)
+
+ > alias [<name> [<command>]]
+
+Registers the alias of command.
+When called with an argument, display the alias and its command.
+When called without arguments, display all aliases.
+
+Before registering or displaying, refreshes cached info in memory.
+If modified aliases in another process, includes you directly edit the config file,
+run this command.
+
+(implementation details:
+ for the infinite loop suppression of circular references,
+ the depth of the expansion up to 100.)
+
+ > alias
+ No aliases.
+ > alias search select * from
+ > alias count select count(*) from
+ > alias search
+ alias search=[select * from]
+ > search table1
+ >> select * from table1
+ (diplays the results of "select * from table1")
+ >
+
+
+### unalias - Removes alias (built-in)
+
+ > unalias <alias>
+
+If the specified alias does not exist, does nothing.
+Whether the target exists or not, refreshes cached info in memory.
+
+
+### exit - Exits application (built-in)
+
+ > exit
+
+This command exits Stew without confirmation.
+
+All connections will be disconnected automatically.
+Rollback will do only the connector set auto-rollback option.
+For automatic rollback, see [Usage - Configuration Of "Connector"](#configuration-of-connector).
+
+
+### load - Executes file content as SQL
+
+ > load [<SQL-file> | <data-file> <table-name> [ HEADER ]]
+
+This command executes the SQL read from specified file.
+
+When If a parameter is specified, executes file content as SQL,
+otherwise, two or more parameters, imports the file as data file.
+The file format is automatically selected by file extension.
+ *. .csv : CSV format
+ *. .xml : XML format (definition: src/net/argius/stew/io/stew-table.dtd)
+ *. otherwise: TSV format
+
+(implementation detail: this is basically same as import command,
+ executes as not batch but executes by record)
+
+
+### import - Imports from file
+
+ import <data-file> <table-name> [ HEADER ]
+
+This command imports from file as data file.
+The file format is automatically selected by file extension.
+ *. .csv : CSV format
+ *. .xml : XML format (definition: src/net/argius/stew/io/stew-table.dtd)
+ *. otherwise: TSV format
+
+(implementation detail: this is basically same as load command,
+ but uses Statement#addBatch.)
+
+
+### export - Exports to file
+
+This command exports result of command to the specified file.
+The file format is automatically selected by file extension.
+ *. .htm,html : HTML format
+ *. .csv : CSV format
+ *. .xml : XML format (definition: src/net/argius/stew/io/stew-table.dtd)
+ *. others: TSV format
+
+
+### time - Measures time to execute SQL
+
+ > time [<count>] <SQL>
+
+This command executes specified SQL and measures its execution time.
+
+If specified count, executes SQL by count continuously
+ and summaries "Total", "Ave(average)", "Max" and "Min".
+Otherwise, executes once and measure its execution time.
+
+ > time select * from EMPLOYEE
+ execution time: 0.093 seconds
+ > time 100 select * from EMPLOYEE
+ Total: 0.484 seconds
+ Ave: 0.005 seconds
+ Max: 0.094 seconds
+ Min: 0.000 seconds
+ >
+
+
+### find - Finds table names
+
+ > find <table-name-pattern> [<table-type-pattern> [<schema-pattern> [<catalog-pattern> [ FULL ]]]]
+
+This command displays list of tables allowed to show.
+The parameter including "pattern" in its name can be specified wildcard (#,?).
+
+
+### report - Reports database info
+
+ > report - | <table-name> [ FULL | PK | INDEX ]
+
+This command displays the info about current connection and connecting database.
+
+If specifies - (hyphen), displays the name and version of database and JDBC driver,
+ user and JDBC address.
+
+If only specifies table name, displays the column info about specified table.
+
+If specifies table name and option,
+displays the primary key or index info about specified table.
+
+
+### download - Downloads a column as file
+
+ > download <root-dir> SELECT <data-column> [, file-path...] FROM ...
+
+This command downloads a column data by rows and saves to file.
+
+For any data type.
+It is useful for downloading large text data or large objects (BLOB, CLOB) all at once.
+
+In order to be able to download multiple files,
+generates file name using column data.
+
+The file name will be generated by concatenate second column and after as string.
+This supporses to specify primary keys and file extension.
+
+ > download emp select FULL_NAME, JOB_COUNTRY, '/', EMP_NO, '.txt' from EMPLOYEE
+ The dir[./emp/USA] was created.
+ Downloaded. (size=14bytes, file=./emp/USA/2.txt)
+ Downloaded. (size=12bytes, file=./emp/USA/4.txt)
+ .
+ .
+ .
+ Downloaded. (size=12bytes, file=./emp/USA/24.txt)
+ The dir[./emp/England] was created.
+ Downloaded. (size=11bytes, file=./emp/England/28.txt)
+ .
+ .
+ .
+ Downloaded. (size=18bytes, file=./emp/USA/145.txt)
+ Selected 42 records.
+
+When data exist a record, specified <data-column>,
+saves file to <root-dir> as file name.
+
+Saving file already exists or no permission to write file,
+the process will abort immediately.
+
+
+### upload - Uploads file data to a column
+
+ > upload <file> <SQL(UPDATE|INSERT)>
+
+This command registers a data file to the column that specified by place-holder.
+
+
+### wait - Waits for specified interval
+
+ > wait seconds()
+
+This command waits for the interval that specified number of seconds.
+It may be useful for executing multiple commands.
+
+
+
+## The GUI Mode
+
+### Common Behaviors
+
+Standard commands, "undo", "redo", "cut", "copy", "paste", and "select all", can use in all text components via context menu or shortcut key.
+
+
+### Main Window
+
+A window has "Input/Output Area", "Result Set Table", "Database Info Tree", "Main Menu", "Status Bar" and "Find Pane".
+By default, the database info tree, the status bar and the find pane" are hidden.
+
+
+### Input/Output Area
+
+The I/O area is similar to CUI interface.
+
+... When cursor is at the end of textarea, executes command which is string from prompt to the end of textarea.
+... Otherwise, move cursor to the end of textarea.
+... The part before prompt can't edit.
+
+
+... Context menus for this component has the standard commands.
+
+
+### Result Set Table
+
+The result set table displays command results, usually query results from database.
+
+The row header (the leftmost of the table) displays the row number.
+... display "+" sign instead of the row number in the row header.
+
+Automatic column width adjustment ...
+
+
+The context menu for this component are listed below:
+
+
+Sorts clicked column
+: This command sorts clicked column, not a selected one.
+ The same column is sorted continuously, ... reverse.
+
+Copy (Ctrl-C)
+: This command copies selected cell values as text into the clipboard.
+
+Copy With Escape (Ctrl+Shift-C)
+: This command copies selected cell values as quoted strings into the clipboard.
+
+Paste (Ctrl-V)
+: This command pastes values into selected cells from the clipboard.
+ Type conversion from the text to column types of the cells depends on each JDBC driver implementation.
+
+Select All (Ctrl-A)
+: This command selects all cells in the table.
+
+Clear Selected Cell Value
+: This command clears selected cell values (actually sets NULL).
+
+Set Current Time Value
+: This command sets current time (Timestamp) into selected cells.
+
+Copy Column Names
+: This command copies the table header as text into the clipboard.
+
+Find Column Name
+: This command shows the find pane and sets find target ...
+
+Add New (Empty) Row
+: This command adds a new empty row into the table.
+
+Insert From Clipboard
+: This command ... imports data from the clipboard and inserts the data into the linking table.
+
+Duplicate Rows
+: This command adds duplicate rows ... selected cells.
+
+Link Rows Into Database
+: This command make unlink ...
+
+Delete Rows
+: This command deletes selected rows.
+ The deleted rows are also deleted from database.
+
+
+
+### Database Info Tree
+
+The database info tree is a tree view of hierarchical structure, which consists
+ catalogs, schemas, tables, table type and columns as a tree.
+Not connected: blank ...
+just connected: connector as a root node and sub nodes ...
+Each node expands ...
+
+
+The context menu for this component are listed below:
+
+
+Copy
+: This command copies displayed strings of selected nodes as text into the clipboard.
+
+Copy Simple Name
+: This command copies the simple name of selected nodes as text into the clipboard.
+
+Copy Full Name
+: This command copies the full qualified name of selected nodes as text into the clipboard.
+
+Refresh
+: This command ...
+
+Generate WHERE Phrase
+: This command generates a WHERE phrase consisting selected tables and columns ...
+ selected same name, generate ...
+
+Generate SELECT Statement (with WHERE)
+: This command generates a SELECT statement with "WHERE" keyword.
+
+Generate UPDATE Statement (with WHERE)
+: This command ...
+
+Generate INSERT Statement
+: This command ...
+
+Jump To Column By Name
+: This command ... the name of selected node. Jump to the column which has the same name in current result table if found it.
+ Double-clicking the node is the same as this command.
+
+Toggle Show Column Number
+: This command provides the toggle between showing and hiding the column number of all columns nodes.
+
+
+### Main Menu
+
+See Menus ...
+
+
+### Status Bar
+
+... Display last command and its execution time.
+...This time is not query but command.
+
+
+### Saving Configuration
+
+...
+
+
+### Key Binding
+
+...
+It is not able to change key bind after opening new window.
+... For the keywords, see https://github.com/argius/Stew4/blob/master/src/net/argius/stew/ui/window/Menu.u8p
+
+
+## Menus in the GUI Mode
+
+### File - New Window (N) Ctrl-N
+
+This command opens a new window.
+Current connections are independent of each window.
+
+
+### File - Close Window (C) Ctrl-W
+
+This command closes current window.
+If connected, show confirm dialog.
+
+If current window is only a window, processes as Quit(Q).
+
+
+### File - Quit (Q) Ctrl-Q
+
+This command quits this application.
+When executed, shows confirm dialog. Click "Yes" to quit.
+
+
+### Edit - Cut (T) Ctrl-X
+
+This command cuts the selection to the clipboard.
+
+
+### Edit - Copy (C) Ctrl-C
+
+This command copies the selection to the clipboard.
+
+
+### Edit - Paste (P) Ctrl-V
+
+This command pastes the selection to the clipboard.
+
+
+### Edit - Select All (A) Ctrl-A
+
+This command selects all text or all elements.
+
+
+### Edit - Find (F) Ctrl-F
+
+This command finds out a specific string from selected component.
+
+...
+
+
+### Edit - Toggle focus (G) Ctrl-G
+
+This command toggles focus between the result set table and the input/output area in a current window.
+
+### Edit - Clear Message (M)
+
+This command clears input/output area in a current window.
+
+
+### View - Show Status Bar (S)
+
+This command toggles the visibility of status bar in a current window.
+
+
+### View - Show Column Number (C)
+
+This command toggles the visibility of column number in the result set table of a current window.
+
+
+### View - Show Info Tree (I)
+
+This command toggles the visibility of database info tree in a current window.
+
+
+### View - Always On Top (T)
+
+This command toggles the state that always stays on top of a current window.
+
+
+### View - Refresh (R) F5
+
+This command ...
+
+
+### View - Widen Column Width (W) Ctrl-.(period)
+
+This command widens all column widths in the result set table of a current window.
+
+
+### View - Narrow Column Width (N) Ctrl-,(comma)
+
+This command narrows all column widths in the result set table of a current window.
+
+
+### View - Adjust Column Width (A) Ctrl-/(slash)
+
+This command adjusts all column widths in the result set table of a current window.
+For about adjust mode, see the next item.
+
+
+### View - Auto Adjust Mode (M)
+
+This command selects auto-adjusting mode to use when shows result.
+
+There are following modes:
+
+ * None(N): does nothing.
+ * Header(H): adjusts column width based on each header string.
+ * Value(V): adjusts based on the longest string in column values.
+ * Header And Value(A): adjusts based on the longest string in column values and column header string.
+
+
+### Command - Execute (X) Ctrl-M
+
+This command executes command.
+This is same as pressing enter key in the end of the I/O area. (... same behavior)
+
+
+### Command - BREAK (B) Ctrl-Pause(Break)
+
+This command cancels executing command.
+The process on the server is not canceled.
+
+
+### Command - History Back (P) Ctrl-Up
+
+This command rotates command histories backward.
+
+
+### Command - History Next (N) Ctrl-Down
+
+This command rotates command histories forward.
+
+
+### Command - Rollback (R)
+
+This command displays confirm dialog and click "OK" to rollback.
+
+
+### Command - Commit (M)
+
+This command displays confirm dialog and click "OK" to commit.
+
+
+### Command - Connect (C) Ctrl-E
+
+This command shows the list of connectors.
+Select connector name you want to connect to, and click "OK" to executes connect command.
+
+
+### Command - Disconnect (D) Ctrl-D
+
+This command disconnects current connection.
+This is the same as disconnect command.
+
+
+### Command - Post-Proccess (0)
+
+This command specifies the configuration of a "Post-Proccess" mode.
+
+The "Post-Proccess" is an action to notify that command finished.
+When the window which command is running, is not active, "Post-Proccess" is invoked.
+
+There are following modes:
+
+ * None(N): Does nothing.
+ * Focus(F): Focuses window.
+ * Shake(S): Shakes window.
+ * Blink(B): Blinks window.
+
+
+### Command - Encryption Key (K)
+
+This command ...
+
+
+### Command - Edit Connectors (E)
+
+This command shows the dialog to edit connectors.
+
+
+### Data - Sort (S) Alt-S
+
+This command sorts records by selected column.
+
+
+### Data - Import File (I)
+
+This command imports from file into the table of current result.
+
+
+### Data - Export File (E) Ctrl-Shift-S
+
+This command exports results into file.
+
+
+### Help - Show Help
+
+This command shows this help file by default browser.
+This feature ...
+
+
+### Help - About Stew
+
+This command shows version dialog about Stew.
+
+
+
+## Properties
+
+You can set these system properties into java -D option or stew.properties file.
+
+
+### net.argius.stew.properties - Location Of Properties File
+
+Property Value: a file path or a directory path
+
+This property specifies the location of "stew.properties" file.
+This properties file is used as system properties and searched in the following steps:
+
++If it specifies a file path, the file will be used as system properties.
++If it specifies a directory path, the file will be searched a "stew.properties" file in the directory.
++Search a file in the classpath.
++Search a file in the system directory.
+
+The first file found is used.
+If a file is not found, ... (ignore it).
+
+
+### net.argius.stew.directory - Working Directory
+
+Property Value: a directory path (default: current directory)
+
+This property specifies the current directory as a internal state at the start, but it is not a platform one.
+
+
+### net.argius.stew.query.timeout - Query Timeout
+
+Property Value: integer seconds (default: 0)
+
+This property specifies the query timeout which is used in commands.
+
+If it is under 0, the property was not set.
+
+(implementation detail: for java.sql.Statement#setQueryTimeout)
+
+
+### net.argius.stew.rowcount.limit - Limit Of Display Result Row Count
+
+Property Value: maximum number of rows (default: Integer.MAX_VALUE, about 2,147,000,000)
+
+This property specifies the maximum number of rows which show in the result set table.
+It is not used to output files, such as the export command.
+
+
+### net.argius.stew.command.Import.batch.limit - Limit Of Import Command Using Batch
+
+Property Value: limit number of rows (default: 10000)
+
+This property is used by the Import command.
+It is not used to output files, such as the export command.
+
+
+### net.argius.stew.ui.window.resident - Regident
+
+Property Value: integer minutes
+
+This is an experimental feature.
+
+The app redraws continuously at the specified interval to prevent swap-out.
+
+
+### Logger Configurations
+
+Use logging.properties in this package.
+
> alias
エイリアスは未定義です。
- > alias search select # from
- > alias count select count(#) from
+ > alias search select * from
+ > alias count select count(*) from
> alias search
- alias search=[select # from]
+ alias search=[select * from]
> search table1
- >> select # from table1
- (select # from table1 の結果)
+ >> select * from table1
+ (select * from table1 の結果)
>
「合計」「平均」「最大」「最小」を集計します。
回数を指定しない場合は、1回の実行時間を表示します。
- > time select # from EMPLOYEE
+ > time select * from EMPLOYEE
実行時間 : 0.093 秒
- > time 100 select # from EMPLOYEE
+ > time 100 select * from EMPLOYEE
合計 : 0.484 秒
平均 : 0.005 秒
最大 : 0.094 秒
### report - データベース情報表示
- > report - | <テーブル名> [ PK | INDEX ]
+ > report - | <テーブル名> [ FULL | PK | INDEX ]
接続中のコネクションに関する情報を表示します。
テーブル名とオプションが指定された場合は、PKを指定するとプライマリキーの一覧が、
INDEXを指定するとインデックスキーの一覧が、それぞれ表示されます。
+FULLを指定すると、API(DatabaseMetaData#getColumns)が返すすべての列が表示されます。
### download - 1データごとにダウンロード
It had the following features:
- * Requires only Core Libraries except JDBC driver.
+ * Requires only Core Libraries except JDBC drivers.
* Console Mode. Not only GUI.
* Never keep the cursor:
Statement and ResultSet will be released immediately.
* No dependency (version 2 and later):
No DBMS specific code.
* Supports Windows, MacOSX and Linux (version 3 and later):
- Excepts "dock mode" of MacOSX.
+ Excepts "dock mode" on MacOSX.
For more information, see MANUAL.html and FEATURE.md.
-## 2. How to Install, Migrate and Uninstall
+## 2. How to Install, Upgrade and Uninstall
How to Install
-: Just need to extract zip file. At least "stew.jar".
+: To install this software, all you need to do is extracting the archive file.
-How to Migrate
-: Just overwrite up-to-date files.
+How to Upgrade
+: To upgrade this software, you need to extract new files and overwrite them with old files.
How to Uninstall
-: Just delete installed file and ".stew" dir.
+: To uninstall this software, you need to delete installed files and a ".stew" dir.
To see the location of ".stew", exec "@" command in Stew.
Uses Apache License 2.0.
See LICENSE file.
-We omitted to write the License header in every souce file.
-
## 4. Known Issues
-i.did-mkdir=ディレクトリ[{0}]を作成しました。
-i.downloaded=ダウンロードされました。 (size={0}, file={1})
-i.exported=エクスポートされました。
-i.loaded=ロードされた {1} 件中 {0} 件 追加されました。
-i.proceeded={0} 件 処理されました。
-#i.selected={0} 件 ヒットしました。
-i.updated={0} 件 更新されました。
-i.wait-time=待機時間 : {0,number,0.000} 秒
-e.no-record=データが見つかりません。
-e.file-already-exists=ファイル[{0}]が存在します。
-e.failed-create-new-file=ファイル[{0}]の作成に失敗しました。
-e.failed-mkdir-filedir=ファイル[{0}]のディレクトリ作成に失敗しました。
+i.did-mkdir=The dir[{0}] was created.
+i.downloaded=Downloaded. (size={0}, file={1})
+i.exported=Exported.
+i.loaded=Added {0} records in loaded {1} records.
+i.proceeded=Proceeded {0} records.
+#i.selected=Found {0} records.
+i.updated=Updated {0} records.
+i.wait-time=Waited for {0,number,0.000} seconds.
+e.no-record=Record not found.
+e.file-already-exists=The file[{0}] already exists.
+e.failed-create-new-file=Failed to create the file[{0}].
+e.failed-mkdir-filedir=Failed to create dir of the file[{0}].
-usage.Count=<テーブル名> [<WHERE句>]
-usage.Download=<ルートディレクトリ> SELECT <ダウンロードするデータの列> [, ファイルパス...] FROM ...
-usage.Export=<ファイル> [ HEADER ] [command(select|find|report)] \n 注: "report -"は不可
-usage.Find=<テーブル名パターン> [<テーブル種別パターン> [<スキーマ名パターン> [<カタログ名パターン> [ FULL ]]]]
-usage.Import=[<データファイル> <テーブル名> [ HEADER ]]
-usage.Load=[<SQLファイル> | <データファイル> <テーブル名> [ HEADER ]]
-usage.Report=- | <テーブル名> [ FULL | PK | INDEX ]
-usage.Time=[<回数>] <SQL文>
-usage.Upload=<ファイル> <SQL文(UPDATE|INSERT)>
-usage.Wait=<秒(小数第3位まで)>
+usage.Count=<table-name> [<WHERE-phrase>]
+usage.Download=<root-dir> SELECT <data-column> [, file-path...] FROM ...
+usage.Export=<file> [ HEADER ] [command(select|find|report)] \n * except "report -"
+usage.Find=<table-name-pattern> [<table-type-pattern> [<schema-pattern> [<catalog-pattern> [ FULL ]]]]
+usage.Import=<data-file> <table-name> [ HEADER ]
+usage.Load=<SQL-file> | <data-file> <table-name> [ HEADER ]
+usage.Report=- | <table-name> [ FULL | PK | INDEX ]
+usage.Time=[<count>] <SQL>
+usage.Upload=<file> <SQL(UPDATE|INSERT)>
+usage.Wait=<seconds(3 digits after the decimal point)>
Export.command.usage={0}\n {1} {2}
-Find.label.name=テーブル名
-Find.label.type=テーブル種別
-Find.label.schema=スキーマ名
-Find.label.catalog=カタログ名
+Find.label.name=Table Name
+Find.label.type=Type
+Find.label.schema=Schema
+Find.label.catalog=Catalog
-Report.label.catalog=カタログ
-Report.label.schema=スキーマ
-Report.label.tablename=テーブル名
-Report.label.sequence=順番
-Report.label.columnname=カラム名
-Report.label.keyname=プライマリキー名
-Report.label.nullable=Null可
-Report.label.type=型
-Report.label.size=サイズ
+Report.label.catalog=Catalog
+Report.label.schema=Schema
+Report.label.tablename=Table Name
+Report.label.sequence=Sequence
+Report.label.columnname=Column Name
+Report.label.keyname=Key Name
+Report.label.nullable=Nullable
+Report.label.type=Type
+Report.label.size=Size
Report.dbinfo =\
-製品名 : {0}\n\
-製品バージョン : {1}\n\
-ドライバ名 : {2}\n\
-ドライババージョン : {3}\n\
-接続ユーザ@URL : {4}@{5}
+Product Name: {0}\n\
+Product Version: {1}\n\
+Driver Name: {2}\n\
+Driver Version: {3}\n\
+User@URL: {4}@{5}
-Time.once=実行時間 : {0,number,0.000} 秒
+Time.once=execution time: {0,number,0.000} seconds
Time.summary=\
-合計 : {0,number,0.000} 秒\n\
-平均 : {1,number,0.000} 秒\n\
-最大 : {2,number,0.000} 秒\n\
-最小 : {3,number,0.000} 秒
+Total: {0,number,0.000} seconds\n\
+ Ave: {1,number,0.000} seconds\n\
+ Max: {2,number,0.000} seconds\n\
+ Min: {3,number,0.000} seconds
--- /dev/null
+
+i.did-mkdir=ディレクトリ[{0}]を作成しました。
+i.downloaded=ダウンロードされました。 (size={0}, file={1})
+i.exported=エクスポートされました。
+i.loaded=ロードされた {1} 件中 {0} 件 追加されました。
+i.proceeded={0} 件 処理されました。
+#i.selected={0} 件 ヒットしました。
+i.updated={0} 件 更新されました。
+i.wait-time=待機時間 : {0,number,0.000} 秒
+e.no-record=データが見つかりません。
+e.file-already-exists=ファイル[{0}]が存在します。
+e.failed-create-new-file=ファイル[{0}]の作成に失敗しました。
+e.failed-mkdir-filedir=ファイル[{0}]のディレクトリ作成に失敗しました。
+
+usage.Count=<テーブル名> [<WHERE句>]
+usage.Download=<ルートディレクトリ> SELECT <ダウンロードするデータの列> [, ファイルパス...] FROM ...
+usage.Export=<ファイル> [ HEADER ] [command(select|find|report)] \n 注: "report -"は不可
+usage.Find=<テーブル名パターン> [<テーブル種別パターン> [<スキーマ名パターン> [<カタログ名パターン> [ FULL ]]]]
+usage.Import=[<データファイル> <テーブル名> [ HEADER ]]
+usage.Load=[<SQLファイル> | <データファイル> <テーブル名> [ HEADER ]]
+usage.Report=- | <テーブル名> [ FULL | PK | INDEX ]
+usage.Time=[<回数>] <SQL文>
+usage.Upload=<ファイル> <SQL文(UPDATE|INSERT)>
+usage.Wait=<秒(小数第3位まで)>
+
+Export.command.usage={0}\n {1} {2}
+
+Find.label.name=テーブル名
+Find.label.type=テーブル種別
+Find.label.schema=スキーマ名
+Find.label.catalog=カタログ名
+
+Report.label.catalog=カタログ
+Report.label.schema=スキーマ
+Report.label.tablename=テーブル名
+Report.label.sequence=順番
+Report.label.columnname=カラム名
+Report.label.keyname=プライマリキー名
+Report.label.nullable=Null可
+Report.label.type=型
+Report.label.size=サイズ
+Report.dbinfo =\
+製品名 : {0}\n\
+製品バージョン : {1}\n\
+ドライバ名 : {2}\n\
+ドライババージョン : {3}\n\
+接続ユーザ@URL : {4}@{5}
+
+Time.once=実行時間 : {0,number,0.000} 秒
+Time.summary=\
+合計 : {0,number,0.000} 秒\n\
+平均 : {1,number,0.000} 秒\n\
+最大 : {2,number,0.000} 秒\n\
+最小 : {3,number,0.000} 秒
i.directory-changed=The current directory was changed [{0}] to [{1}].
i.disconnected=Disconnected.
i.dump-alias={0}\=[{1}]
-i.exit=Stewを終了します。
+i.exit=Do you want to exit?
i.inserted=Inserted {0} records.
i.noalias=No aliases.
i.now=({0,date,yyyy-MM-dd}T{0,time,HH:mm:ss}{0,time,ZZZZ})
w.connection-closed-abnormally=Warning: Connection was closed abnormally.
w.error-occurred-on-auto-rollback=Warning: An error occurred when auto-rollback. ({0})
w.exceeded-limit=Warning: Over limit({0}).
-w.exit-not-available-in-sequencial-command=Warning: 連続コマンド内のEXITは無効です。
-w.unusable-keyword-for-alias=キーワード[{0}]はエイリアスに使用できません。
-e.alias-circulation-reference=エイリアスの展開回数が上限({0})を超えたため展開を中止しました。
+w.exit-not-available-in-sequencial-command=Warning: Can not use EXIT in sequencial commands.
+w.unusable-keyword-for-alias=The keyword[{0}] is not allowed for Alias.
+e.alias-circulation-reference=Failed to apply Alias because circulation-reference was over max count ({0}).
e.command=Error: {0}
e.database=Database Error: {0}
e.dir-not-exists=Directory[{0}] does not exist.
-main.start=接続設定エディタ
-main.wait=コマンドを入力 (help: コマンド一覧を表示)
-main.end=接続設定エディタを終了します。
-main.notice.filenotexists=お知らせ：接続設定ファイルが存在しません。保存時に新規に作成されます。
+main.start=Connnector Editor
+main.wait=Input command (help: show command list)
+main.end=Exit from Connnector Editor.
+main.notice.filenotexists=Notice: connector config file does not exist. If exec save, the file will be created.
proc.prompt =\ >\
-proc.added=ID "{0}" を追加しました。
-proc.modified=ID "{0}" を変更しました。
-proc.notexists=ID "{0}" は存在しません。
-proc.alreadyexists=ID "{0}" は既に存在します。
-proc.nomodification=変更はありません。
-proc.remove.confirm=削除してよろしいですか？
-proc.remove.finished=削除しました。
-proc.remove.canceled=削除を中止します。
-proc.copy.finished=コピーしました。
-proc.copy.canceled=コピーを中止します。
-proc.save.confirm=保存してよろしいですか？
-proc.save.finished=保存しました。
-proc.save.canceled=保存を中止しました。
-proc.load.confirm1=復元を実行すると現在の変更は破棄されます。
-proc.load.confirm2=復元しますか？
-proc.load.finished=復元しました。
-proc.load.canceled=復元を中止しました。
-proc.exit.confirm=終了すると、保存されていない変更は破棄されます。よろしいですか？
-property.start1=プロパティの設定。
-property.start2=現在の値を変更しない場合は何も入力しないでENTER
-property.input={0}の入力 (現在の値=[{1}])
-property.tryconnect.confirm=接続試験しますか？
-property.tryconnect.succeeded=成功しました。
-property.tryconnect.failed=失敗しました。({0})
-property.update.confirm=これでよろしいですか？
-property.retry.confirm=変更をやり直しますか？
-property.update.cancel=変更を中止します。
+proc.added=ID "{0}" was added.
+proc.modified=ID "{0}" was modified.
+proc.notexists=ID "{0}" does not exist.
+proc.alreadyexists=ID "{0}" already exists.
+proc.nomodification=Not changed.
+proc.remove.confirm=Is it ok to remove this connector?
+proc.remove.finished=Removed.
+proc.remove.canceled=To remove connector was cancelled.
+proc.copy.finished=Copied.
+proc.copy.canceled=To copy connector was cancelled.
+proc.save.confirm=Is it ok to save to file?
+proc.save.finished=Saved.
+proc.save.canceled=To save was cancelled.
+proc.load.confirm1=Loading will discard the current changes.
+proc.load.confirm2=Do you want to load?
+proc.load.finished=Loaded.
+proc.load.canceled=Loading was canceled.
+proc.exit.confirm=The application is going to exit without saving. Do you want to continue?
+property.start1=Property Configuration
+property.start2=If you do not want to skip it, press enter without input.
+property.input=Input {0} (current value=[{1}])
+property.tryconnect.confirm=Do you want to test this connector?
+property.tryconnect.succeeded=Succeeded.
+property.tryconnect.failed=Failed.({0})
+property.update.confirm=Do you want to update it?
+property.retry.confirm=Do you want to retry it?
+property.update.cancel=Updating was canceled.
help =\
- ---ヘルプ（コマンド一覧）---\n\
- help : このヘルプ\n\
- a id : 接続設定の追加(add)\n\
- m id : 接続設定の変更(modify)\n\
- r id : 接続設定の削除(remove)\n\
- copy A B : 接続設定のコピー\n\
- disp [id]: 接続設定の表示(一覧/詳細)\n\
- save : 接続設定の保存\n\
- load : 接続設定の復元（変更をリセット）\n\
- exit : 終了
+ ---Help(Command List)---\n\
+ help : This Help\n\
+ a id : Adds new Connnector (add)\n\
+ m id : Modifles Connnector (modify)\n\
+ r id : Removes Connnector (remove)\n\
+ copy A B : Copies Connnector (A to B)\n\
+ disp [id]: Displays Connnector List (all/one)\n\
+ save : Save \n\
+ load : Load Connnectors (reset modified Connnectors)\n\
+ exit : Exit
--- /dev/null
+
+main.start=接続設定エディタ
+main.wait=コマンドを入力 (help: コマンド一覧を表示)
+main.end=接続設定エディタを終了します。
+main.notice.filenotexists=お知らせ：接続設定ファイルが存在しません。保存時に新規に作成されます。
+proc.prompt =\ >\
+proc.added=ID "{0}" を追加しました。
+proc.modified=ID "{0}" を変更しました。
+proc.notexists=ID "{0}" は存在しません。
+proc.alreadyexists=ID "{0}" は既に存在します。
+proc.nomodification=変更はありません。
+proc.remove.confirm=削除してよろしいですか？
+proc.remove.finished=削除しました。
+proc.remove.canceled=削除を中止します。
+proc.copy.finished=コピーしました。
+proc.copy.canceled=コピーを中止します。
+proc.save.confirm=保存してよろしいですか？
+proc.save.finished=保存しました。
+proc.save.canceled=保存を中止しました。
+proc.load.confirm1=復元を実行すると現在の変更は破棄されます。
+proc.load.confirm2=復元しますか？
+proc.load.finished=復元しました。
+proc.load.canceled=復元を中止しました。
+proc.exit.confirm=終了すると、保存されていない変更は破棄されます。よろしいですか？
+property.start1=プロパティの設定。
+property.start2=現在の値を変更しない場合は何も入力しないでENTER
+property.input={0}の入力 (現在の値=[{1}])
+property.tryconnect.confirm=接続試験しますか？
+property.tryconnect.succeeded=成功しました。
+property.tryconnect.failed=失敗しました。({0})
+property.update.confirm=これでよろしいですか？
+property.retry.confirm=変更をやり直しますか？
+property.update.cancel=変更を中止します。
+help =\
+ ---ヘルプ（コマンド一覧）---\n\
+ help : このヘルプ\n\
+ a id : 接続設定の追加(add)\n\
+ m id : 接続設定の変更(modify)\n\
+ r id : 接続設定の削除(remove)\n\
+ copy A B : 接続設定のコピー\n\
+ disp [id]: 接続設定の表示(一覧/詳細)\n\
+ save : 接続設定の保存\n\
+ load : 接続設定の復元（変更をリセット）\n\
+ exit : 終了
-title=コネクタの設定
-connector.id=コネクタID
-connector.name=コネクタ名
-connector.classpath=クラスパス
-button.searchFile=ファイル
-connector.driver=ドライバ
-button.searchDriver=ドライバの検索
-connector.url=接続先URL
-connector.user=ユーザ
-connector.password=パスワード
-connector.encryption=暗号化処理
-connector.readonly=読取専用コマンドのみ使用する
-connector.autorollback=切断時に(自動で)ロールバックする
-button.submit=登録
-button.tryToConnect=接続試験
-button.cancel=キャンセル
-selectDriverClass=ドライバクラスの選択
-confirm.searchsystemclasspath=クラスパスが未指定のため、システムクラスパスから検索します。
-dialog.search.file.header=クラスパスの選択
-dialog.search.file.button=選択
+title=Connnector Configuration
+connector.id=Connnector ID
+connector.name=Connnector Name
+connector.classpath=Classpath
+button.searchFile=Search File
+connector.driver=Driver
+button.searchDriver=Search Driver
+connector.url=URL to connect
+connector.user=User
+connector.password=Password
+connector.encryption=Encryption
+connector.readonly=Read only
+connector.autorollback=Enables auto-rollback
+button.submit=Submit
+button.tryToConnect=Try To Connect
+button.cancel=Cancel
+selectDriverClass=Selects Driver Class
+confirm.searchsystemclasspath=Classpath was not specified. Search system classpath.
+dialog.search.file.header=Search classpath
+dialog.search.file.button=Select
try.connect=\
-接続に成功しました!\n\
-接続先名称: {0}\n\
-バージョン: {1}
+Succeeded!\n\
+Name: {0}\n\
+Version: {1}
-search.driver.classnotfound=ドライバクラスが見つかりません。
-button.referToOthers=他の設定を参照
-dialog.referToOthers.message=選択した行の内容を未入力の箇所に貼り付けます。
+search.driver.classnotfound=Driver class was not found.
+button.referToOthers=Refer to other configs
+dialog.referToOthers.message=Copy selected infos to empty cells.
--- /dev/null
+title=コネクタの設定
+connector.id=コネクタID
+connector.name=コネクタ名
+connector.classpath=クラスパス
+button.searchFile=ファイル
+connector.driver=ドライバ
+button.searchDriver=ドライバの検索
+connector.url=接続先URL
+connector.user=ユーザ
+connector.password=パスワード
+connector.encryption=暗号化処理
+connector.readonly=読取専用コマンドのみ使用する
+connector.autorollback=切断時に(自動で)ロールバックする
+button.submit=登録
+button.tryToConnect=接続試験
+button.cancel=キャンセル
+selectDriverClass=ドライバクラスの選択
+confirm.searchsystemclasspath=クラスパスが未指定のため、システムクラスパスから検索します。
+dialog.search.file.header=クラスパスの選択
+dialog.search.file.button=選択
+try.connect=\
+接続に成功しました!\n\
+接続先名称: {0}\n\
+バージョン: {1}
+
+search.driver.classnotfound=ドライバクラスが見つかりません。
+button.referToOthers=他の設定を参照
+dialog.referToOthers.message=選択した行の内容を未入力の箇所に貼り付けます。
-title=接続設定
-button.addNew=新規
-button.modify=変更
-button.rename=ID変更
-button.remove=削除
-button.up=上へ
-button.down=下へ
-button.submit=決定
-button.cancel=キャンセル
+title=Connnector Configurations
+button.addNew=Add
+button.modify=Modify
+button.rename=Rename
+button.remove=Remove
+button.up=Up
+button.down=Down
+button.submit=Submit
+button.cancel=Cancel
--- /dev/null
+title=接続設定
+button.addNew=新規
+button.modify=変更
+button.rename=ID変更
+button.remove=削除
+button.up=上へ
+button.down=下へ
+button.submit=決定
+button.cancel=キャンセル
-label=検索
-forward=次を検索
-backward=前を検索
-close=閉じる
-useregex=正規表現
-ignorecase=英字のケース無視
-message.notfound=文字列 "{0}" は見つかりませんでした
+label=Search
+forward=FORWARD
+backward=BACKWARD
+close=Close
+useregex=Use Regular Expression
+ignorecase=Ignore Case
+message.notfound=String"{0}" was not found
--- /dev/null
+
+label=検索
+forward=次を検索
+backward=前を検索
+close=閉じる
+useregex=正規表現
+ignorecase=英字のケース無視
+message.notfound=文字列 "{0}" は見つかりませんでした
}
private static void showHelp() {
- final String htmlFileName = "MANUAL_ja.html";
+ final File localeFile = new File("MANUAL_" + Locale.getDefault().getLanguage() + ".html");
+ final File htmlFile = (localeFile.exists()) ? localeFile : new File("MANUAL.html");
+ boolean wasOpened = false;
if (Desktop.isDesktopSupported()) {
Desktop desktop = Desktop.getDesktop();
if (desktop.isSupported(Desktop.Action.OPEN)) {
- File file = new File(htmlFileName);
- if (file.exists()) {
+ if (htmlFile.exists()) {
try {
- desktop.open(file);
+ desktop.open(htmlFile);
+ wasOpened = true;
} catch (IOException ex) {
throw new RuntimeException(ex);
}
}
}
- } else {
- final String msg = res.get("e.cannot-open-help-automatically", htmlFileName);
+ }
+ if (!wasOpened) {
+ final String msg = String.format("%s%nfile=%s",
+ res.get("e.cannot-open-help-automatically", htmlFile),
+ htmlFile.getAbsolutePath());
WindowOutputProcessor.showInformationMessageDialog(getRootFrame(), msg, "");
}
}
-i.cancelled=コマンドがキャンセルされました。\n（サーバ側の処理はキャンセルされていません。）
-i.choose-connection=接続を選択
-i.confirm-close=ウィンドウを閉じてよろしいですか？
-i.confirm-commit=コミットします。よろしいですか？
-i.confirm-overwrite=ファイル {0} は存在します。\n上書きしますか？
-i.confirm-quit=終了してよろしいですか？
-i.confirm-remove=削除してよろしいですか？
-i.confirm-rollback=ロールバックします。よろしいですか？
-i.confirm-save=保存してよろしいですか？
-i.confirm-without-register=登録せずに閉じてよろしいですか？
-i.confirm-without-save=保存せずに閉じてよろしいですか？
-i.exported=エクスポートされました。
-i.help-see-release-package=\
-ヘルプ機能は実装されていません。\n\n\
-簡易ヘルプについては、インストールパッケージ内の\n\
-Manual_ja.htmlを参照してください。
-i.can-only-use-after-tablenode-expanded=It can only use after the table node is expanded.
-i.input-encryption-key=暗号鍵を入力
-i.input-new-connector-id=新しいコネクタのIDを入力
-i.paren-in-processing=(処理中)
-i.reconnect-after-edited-current-connector=接続中の設定を変更する場合は、変更後に再接続してください。
-i.statusbar-message=\ 実行時間 {0} 秒 ( {1} )
-w.connector-readonly=コネクタは読取専用です。
-w.import-target-not-available=インポート先が無効です。
-w.no-connector=接続設定がありません。
-w.not-connect=接続されていません。
+i.cancelled=The command was canceled.\n(The process in the server-side may be still working.)
+i.choose-connection=Choose Connector
+i.confirm-close=Do you want to close this window?
+i.confirm-commit=Do you want to commit?
+i.confirm-overwrite=The file [{0}] already exists. Overwrite it?
+i.confirm-quit=Do you want to exit?
+i.confirm-remove=Do you want to remove it?
+i.confirm-rollback=Do you want to rollback?
+i.confirm-save=Do you want to save it?
+i.confirm-without-register=Do you really want to close without registering?
+i.confirm-without-save=Do you really want to close without saving?
+i.exported=Exported.
+i.can-only-use-after-tablenode-expanded=This command can use only after the table node is expanded.
+i.input-encryption-key=Input an encryption key
+i.input-new-connector-id=Input new connector ID.
+i.paren-in-processing=(IN PROGRESS)
+i.reconnect-after-edited-current-connector=If you want to reflect the change in the current connector, reconnect it.
+i.statusbar-message=\ Execution Time {0} seconds ( {1} )
+w.connector-readonly=This connector is read-only.
+w.import-target-not-available=The destination to import is not available.
+w.no-connector=No Connector.
+w.not-connect=Not connected.
e.cannot-open-help-automatically=Can't open help({0}) automatically on this platform.
-e.enables-select-just-1-table=テーブルは1つだけ選択できます。
-e.error=エラー
-e.error-no-detail=エラー(詳細不明)
-e.file-not-exists=ファイル {0} は存在しません。
-e.id-already-exists=ID [{0}] は既に存在します。
+e.enables-select-just-1-table=You can choose only one of tables.
+e.error=Error
+e.error-no-detail=Error(no detail)
+e.file-not-exists=The file [{0}] does not exist.
+e.id-already-exists=The ID [{0}] already exists.
# common menu items
item.cut=Cut
OSDN Git Service
