Category Archives: PostgreSQL

PostgreSQLの外部キー制約を追加、削除する方法

1.追加
ALTER TABLE EMPLOYEE_MANAGE ADD FOREIGN KEY (USER_ID) REFERENCES USER_CFT(USER_ID)
ON
DELETE CASCADE;

2.表示
SELECT
*
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
CONSTRAINT_TYPE = ‘FOREIGN KEY’
AND TABLE_NAME = ‘EMPLOYEE_MANAGE’;

3.削除
ALTER TABLE EMPLOYEE_MANAGE DROP CONSTRAINT USER_ID

「PoStgreSQL入門」substr()で文字列の一部を取得する

SQL構文
select substr(‘1234’,0,3) as cft

postgreSQLの場合、結果:12
Oracleの場合、結果:12
MySQLの場合、結果:空白

「Postgresql入門」複合主キーを設定するサンプル

1.テーブルを作成する場合
CREATE TABLE PointUser(
— ユーザID
userid varchar(20),
— ユーザ名
username varchar(255),
— 登録日時
create_date timestamp NOT NULL,
— 更新日時
modify_date timestamp NOT NULL,
— 住所
address varchar(50) NULL,
PRIMARY KEY(userid,username)
);

2.作成済みのテーブルに複合主キーを設定する場合
SQL構文:
ALTER TABLE table_name
ADD PRIMARY KEY(coloumn_name1, coloumn_name2);

「PostgresSQL入門」dblinkでリモートデータベースで問い合わせを実行する方法

1.dblink_connectでDBに接続
SELECT dblink_connect(‘mycoon’,’hostaddr=127.0.0.1 port=5432 dbname=postgres user=postgres password=99999′);

2. BEGINコマンドの実行
SELECT dblink_exec(‘mycoon’, ‘BEGIN’);

3. データベース操作(update,insert,create等)
SELECT dblink_exec(‘mycoon’, ‘insert into tb1 select generate_series(10,20),”hello”’);

4. トランザクションのコミット
SELECT dblink_exec(‘mycoon’, ‘COMMIT’);
5. リモートデータベースへの永続的な接続を閉じる
SELECT dblink_disconnect(‘mycoon’);

Teiid Web Console 1.2をダウンロード

ダウンロード
提供元サイトからダウンロード

Teiid web console はTeildサーバーを管理、監視している。新バージョンではAudit/Command/traceログを有効するのを追加、いつくかのbugを修正

概要:
Deploying a VDB to a running server, and undeploy
Create and deploy a Data Source
Check translator property
Change deployed VDB configuration.

jQuery EasyUI 1.3.6ダウンロード

ダウンロード:
提供元からダウンロード

更新内容:

バグ修復
  • treegrid: The ‘getChecked’ method can not return correct checked rows. fixed.
  • tree: The checkbox does not display properly on async tree when ‘onlyLeafCheck’ property is true. fixed.
改善内容
  • treegrid: All the selecting and checking methods are extended from datagrid component.
  • linkbutton: The icon alignment is fully supported, possible values are: ‘top’,’bottom’,’left’,’right’.
  • linkbutton: Add ‘size’ property, possible values are: ‘small’,’large’.
  • linkbutton: Add ‘onClick’ event.
  • menubutton: Add ‘menuAlign’ property that allows the user set top level menu alignment.
  • combo: Add ‘panelAlign’ property, possible values are: ‘left’,’right’.
  • calendar: The ‘formatter’,’styler’ and ‘validator’ options are available to custom the calendar dates.
  • calendar: Add ‘onChange’ event.
  • panel: Add ‘method’,’queryParams’ and ‘loader’ options.
  • panel: Add ‘onLoadError’ event.
  • datagrid: Add ‘onBeginEdit’ event that fires when a row goes into edit mode.
  • datagrid: Add ‘onEndEdit’ event that fires when finishing editing but before destroying editors.
  • datagrid: Add ‘sort’ method and ‘onBeforeSortColumn’ event.
  • datagrid: The ‘combogrid’ editor has been integrated into datagrid.
  • datagrid: Add ‘ctrlSelect’ property that only allows multi-selection when ctrl+click is used.
  • slider: Add ‘converter’ option that allows users determine how to convert a value to the slider position or the slider position to the value.
  • searchbox: Add ‘disabled’ property.
  • searchbox: Add ‘disable’,’enable’,’clear’,’reset’ methods.
  • spinner: Add ‘readonly’ property, ‘readonly’ method and ‘onChange’ event.

Scientific Linux 7 Alpha ダウンロード

ダウンロード
SL-7-x86_64-DVD.iso (6,377MB), SL-7-x86_64-netinst.iso(392MB)

changelog

JBoss Overlord 1.1.0.Beta1 ダウンロード

ダウンロード
提供元サイトからダウンロード

更新内容:

SRAMP:

  • Maven facade (early preview)
  • Many doc improvements
  • Moved from jline to aesh

詳細内容の確認http://red.ht/TBjjAl

DTGov:

  • Jetty 8 Support
  • New Admin UI to manage Workflow Triggers
  • Notification Service email templates can now come from S-RAMP

詳細内容の確認http://red.ht/1lyY0pF

RTGov:

  • New UI to replace previous Gadget Server approach
  • Integration with Elasticsearch and Kibana for analytics
詳細内容の確認http://red.ht/1iVa0r6

Oracle Enterprise Pack for Eclipse Lunaダウンロード

ダウンロード
提供元サイトからダウンロード

  • Oracle ADF Tools
  • Oracle Cloud Tools
  • Oracle Coherence Tools
  • Oracle Database Tools
  • Oracle MAF Tools
  • Oracle WebLogic Server Tools
  • GlassFish Tools

Eclipse SDK 4.4 ダウンロード

ダウンロード
提供元サイトからダウンロード
softpediaサイトからダウンロード
freewarefilesサイトからダウンロード

更新内容:

  • Platform:
  • Migration Wizard: Building on the changes introduced in M5 to detect changes in shared installs, Eclipse now includes a migration wizard to help users through the re-ininstallation of their plug-ins.
  • This wizard is presented in two situations. First, when a read-only installation of Eclipse is being changed (i.e. Eclipse is being updated or plugins are added / remove), second when a new read-only installation of Eclipse is run for the first time.
  • BIDI Text Direction: New API has been added to allow text direction to be set independent of the widget orientation. For more info see Snippet 364.
  • New SWT color constant for hyperlinks: A new constant (SWT_COLOR_LINK_FOREGROUND) has been added that will return the native color of hyperlinks on all platforms.
  • Whole word option on File Search page: The File Search page now allows to search for words via a new option.
  • Open Search dialog on last used page: The Search dialog can now be configured to open on the last used page, instead of computing the best matching page based on the current selection:
  • JDT:
  • ‘Convert to if-!-return’ Quick Assist: Ever encountered a long if statement that can be safely inverted to an early return, so that you can ignore the code that follows, and make it easier to understand? Now, you can just use a Quick Assist (Ctrl+1) on the if statement to do this refactoring.
  • Package names are linked in Javadoc hover and view: You can now click individual package names displayed in the header of the Javadoc hover or the Javadoc view to see the package Javadoc.
  • Javadoc and Declaration view indicate when out of sync: The Javadoc and Declaration view now indicate when their content is no longer in sync with the current selection.
  • Only one JUnit (4.11): The org.junit bundle has been updated to JUnit 4.11. At the same time, our good old friend org.junit_3.8.2 has been retired, and the org.junit4 compatibility bundle has also been removed. Your Require-Bundle: entries should just point to org.junit;bundle-version=”4.11.0″ (or an earlier version, if you like). Note that JUnit 4 still contains the JUnit 3 APIs. If you need org.junit_3.8.2 back for whatever reason, you can still get it from Orbit.
  • Improved evaluation of generics while debugging: Significant improvements have been made in the debug evaluation engine to support the use of generics. This impacts the use of conditional breakpoints, the display view, the expressions view, and the inspect/display/execute actions. Previously, evaluations acting on classes with generics would sometimes encounter compilation errors.
  • API to contribute location information for non-standard JRE / JDK libraries: JDT Debug now provides an extension point org.eclipse.jdt.launching.libraryLocationResolvers that you can use to contribute location information for non-standard JRE / JDK libraries. For example, this extension point can be used to provide Javadoc and source locations for JARs in the ext location of a JRE. Extenders must provide an implementation of org.eclipse.jdt.launching.ILibraryLocationResolver which can provide package roots, source paths, Javadoc locations and index locations for a library.
  • PDE:
  • API Tools Analysis and Freeze tasks can run with unresolved bundles: The API Tools Analysis and API Freeze Ant tasks will now process bundles with resolver errors such as missing dependencies. This means you can now get analysis results for an incomplete product. The Ant tasks produce reports based on a reference baseline and a profile. Previously both the baseline and the profile had to describe complete products. Any bundle that had resolver errors due to missing dependencies would be skipped. Now these bundles will be processed. Resolver errors can affect the results, therefore a list of resolver errors is included in the XML output and warnings are added to the HTML report. To return to the old behavior of skipping unresolved bundles, you can set processunresolvedbundles=”false” on your Ant task.
3 / 1012345...10...最後 »