Repository DB Management

Refer to here for more information about Web Console edition.

Repository DB Management

Repository DB Management is a tool to manage or set items of repository DB.
For more information about repository DB, please refer to "Repository DB".
This is administrative function and can only be performed by administrators.

Functions provided by Repository DB Management

Repository DB Management provides following functions.
Description of Functions
Name of functions Tab Description Remarks
Connection settings Connection information Repository DB settings can be accessed or modified.  
Connected number and release connection Connected number management Releases connections of repository DB.  
Initial value and upper bound value of connected number Specifies initial value and upper bound value of repository DB connection number.  
Connection lifetime settings Specifies connection lifetime and check interval to close connection. The checking runs at intervals of specified milliseconds and closes connections in the pool that are not used and over their lifetime.  
Repository DB connection check when DataSpiderServer starts up Reconnection settings Specifies test connect count and interval used in starting up DataSpiderServer. DataSpiderServer tries to connect to the repository database up to the specified count times at the specified intervals, and the server starts up without repository database if all the attempts fail.  
Repository DB connection check when DataSpiderServer is operating Specifies reconnect count and interval used when connection to the repository database are requested in scripts and user operations and connection had been disconnected for some reason.  
Cleanup repository DB Other Deletes file data which is can not be viewed inside related table of repository DB.
  • This tab is displayed as [General] on Studio for Web.

Connection information

Repository DB settings can be accessed or modified.
Install by the setting with repository DB, if after that you change to setting without repository DB, then set each item, restart DataSpiderServer to change to environment using repository DB.
If you made configuration changes, the changes will be reflected after restarting DataSpiderServer .
About repository DB construction, refer to "Repository DB"".
Description of items
Item name Description Remarks
DBMS Select type of RDB used as repository DB.
  • [DB2]
  • [MySQL]
  • [Oracle]
  • [PostgreSQL]
  • [SQL Server]
  • If using Amazon RDS as repository DB, select DBMS depending on RDB type of Amazon RDS.
  • SQL Server 2000 hasn't already been supported.
JDBC driver path Input or select path of JDBC drive used in repository DB JDBC connection.

Click [Browse] button to activate the file Selectr and Select the file.
  • For file path, specify absolute path of the local file system of server OS.
URL Enter the URL of a JDBC connection.
  • For DB2 "jdbc:db2://<hostname>:<port>/<database name>>"
  • For MySQL "jdbc:mysql://<hostname>:<port>/<database name>"
  • For Oracle "jdbc:oracle:thin:@<hostname>:<port>:<service name/SID>"
  • For PostgreSQL "jdbc:postgresql://<hostname>:<port>/<database name>"
  • For SQL Server "jdbc: sqlserver://<hostname>:<port>;DatabaseName=<database name>"
  
User Enter connection user of repository DB.  
Password Input password of connection user for the repository DB connection.  
Property Action
Item name Description Remarks
Setup wizard Use "Repository connection setup wizard" for connection setting.  
Connection test Connect to repository DB by the set content.  

Connected number management

Releases connections of repository DB.
Property Action
Item name Description Remarks
Release Release pooled connections of repository DB, and reset [Current repository DB Connections] value to "0".  

Initial value and upper bound value of connected number

Specifies initial value and upper bound value of repository DB connection number.
If you made configuration changes, the changes will be reflected after restarting DataSpiderServer .
Description of items
Item name Description Remarks
Initial number Enter the number of pooled connections when DataSpiderServer starts.
  • The default value is "0".
Upper bound number Enter the maximum number of pooled connections.
  • The default value is "10".

Connection lifetime settings

Specifies connection lifetime and check interval to close connection. The checking runs at intervals of specified milliseconds and closes connections in the pool that are not used and over their lifetime.
If you made configuration changes, the changes will be reflected after restarting DataSpiderServer .
Description of items
Item name Description Remarks
Lifetime Input time (ms) that pooled connections becomes target of component pool GC.
For more information about component pool GC, refer to "The life time of a component maintained in a pool".
  • The default value is "1800000" (30 minutes).
Check interval The period to check connection which is target of component pool GC when [Lifetime] is over.
For more information about component pool GC, refer to "The life time of a component maintained in a pool".
  • he default value is "3600000" (60 minutes).

Repository DB connection check when DataSpiderServer starts up

Specify the cycle and reconnection retry times when failing in connecting to Repository DB when starting DataSpiderServer. Even if you reconnect by the set times and cycle but cannot establish a connection, start DataSpiderServer without repository DB.
If you made configuration changes, the changes will be reflected after restarting DataSpiderServer .
Description of items
Item name Description Remarks
Test connect count If failing in connecting to repository DB when starting DataSpiderServer, input reconnection times.
  • The default value is "3".
Test connect interval If failing in connecting to repository DB when starting DataSpiderServer, input reconnection intervals (Millisecond).
  • The default value is "5000".

Repository DB connection check when DataSpiderServer is operating

If failing in connecting to repository DB when running DataSpiderServer then specify the times and cycle of reconnection.
Even if you reconnect by the set times and cycle but cannot establish a connection, stop DataSpiderServer.
If you made configuration changes, the changes will be reflected after restarting DataSpiderServer .
Description of items
Item name Description Remarks
Reconnect count If failing in connecting to repository DB when starting DataSpiderServer, input reconnection times.
  • The default value is "10".
Reconnect interval If failing in connecting to repository DB when starting DataSpiderServer, input reconnection intervals (Millisecond)
  • The default value is "1000".

Cleanup repository DB

Delete file data which is can not be viewed inside related table of repository DB.By cleanup process, you can secure the free space of repository DB.
Property Action
Item name Description Remarks
Cleanup repository DB Delete file data which is can not be viewed inside related table of repository DB.  

Specification Limits

Notes