Repository settings

Refer to here for more information about DataSpider Studio/DataSpider Studio for Web edition.

Repository settings

Repository settings 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 settings

Repository settings provides following functions.
Description of Functions
Name of functions Menu Description Remarks
Connection settings Connection information Repository DB settings can be accessed or modified.  
Release connection Connection 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 Connection information Delete file data which is can not be viewed inside related table of repository DB.  

Connection settings

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
Using database Select type of RDB used as repository DB.
  • [DB2]
  • [MySQL]
  • [Oracle]
  • [PostgreSQL]
  • [SQL Server 2000]
  • [SQL Server 2005/2008/2008 R2]
 
JDBC driver 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.
  • If you want to specify multiple JDBC drivers,please delimit by a delimiter.
    Delimiter to be specified are as follows .
    • Windows version: ";"
    • UNIX/Linux version: :":"
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 2000 "jdbc:microsoft: sqlserver://<hostname>:<port>;DatabaseName=<database name>; SelectMethod=Cursor"
  • For SQL Server 2005/2008/2008 R2 "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.  
Connection test Connect to repository DB by the set content.  

Connected number and release connection

Releases connections of repository DB.
Description of items
Item name Description Remarks
Release connection Release pooled connections of repository DB, and reset [Present repository DB connection number] 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.
Description of items
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