Ahsen1982
Active Member
Hi list;
Trying to install IBM WebSphere Enterprise Application Server Fixpack.
Basically I am trying to install JAS Application Server in PeopleSoft E1 8.10. Well this is my 1st experience to install PSFT JAS
Server in my life becuase I am new in this CNC Feild. Well I followed the Installation guide and complete my installation.
Well every thing ok so far, But When I am trying to log in from http://was:81/jde/owhtml I cannot!!!.
So I checked the versions of IBM , ok Currently I am using IBM Websphere Enterprise Application Server V5.0.2, Then I dowloaded
Fixes & Fix Pack from IBM WebSite, I And I installed , but facing same problem, Cannot log in the server. Well any body have any cue about this issue.
Well Please go through with the JAS.ini & Jdbj.ini file, And do let me know the steps to install FIXPACK of Websphere may be I am following the wrong issue.
So please do help me out.
Bye
Ahsen
======================================JAS.INI=====================================
# Please refer to the JAS Installation Guide for detailed information on
# this file.
#
#
[SECURITY]
DataSource=System - 810
SecurityServer=ente810
UseLogonCookie=FALSE
CookieLifeTime=7
SSOEnabled=FALSE
SSOUserIDOnly=FALSE
# set password only if SSOUserIDOnly is set to TRUE
Password=
[OWWEB]
PathCodes=('PD810','PY810')
MO QUEUE=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\moqueue
ProxyPoolSize=50
F0005Prefix=DR
F0004Prefix=DT
#ProxyHost=
#ProxyPort=
MAXUser=200
FtpPort=21
FtpUsr=anonymous
FtpPwd=anonymous
UseMOWinNTShare=TRUE
PrintImmediate=FALSE
KeepUBE=TRUE
UBEQueue=QBATCH
SystemDateFormat=MDE
SystemDateSeparator=/
VirtualClientTimeOut=300000
InYourFaceError=TRUE
# The HelpPath key determines where JAS looks for help files.
# Syntax: "http://[machine]/[path]/".
# Note, if you specify "/jde/owhelp/", this machine is assumed.
HelpPath=/jde/owhelp/
[CACHE]
# These intervals are in milliseconds. For example, 60000ms = 1 minute
UserSession=2400000
UserProfile=1200000
CacheCheck=60000
Menu=3600000
[SERVER COMPONENTS]
#
# Do not modify this section
#
com.jdedwards.jas.UserManager
com.jdedwards.jas.JDBCProxy
com.jdedwards.jas.JDEORB
com.jdedwards.jas.DDValidation
com.jdedwards.jas.security.SecurityBroker
com.jdedwards.jas.UDCJDBC
com.jdedwards.jas.JDEUDCText
com.jdedwards.jas.JDEUpdates
com.jdedwards.jas.JDEQueries
com.jdedwards.jas.JDEOWDirect
com.jdedwards.jas.ServerQuery
com.jdedwards.jas.JDESignon
com.jdedwards.runtime.virtual.MAFComponentLoader
[JDENET]
# Enterprise Server JDENET port
serviceNameConnect=6012
# JAS Server JDENET Listening port
serviceNameListen=6012
# Maximum number of dedicated kernel types
maxKernelRanges=1
# Time out value for requests sent to the Enterprise Server
enterpriseServerTimeout=90000
# JDENET socket connection pool size
maxPoolSize=50
# Directory for JDENET temporary file
tempFileDir=C:\DOCUME~1\arizwan\LOCALS~1\Temp
# Clustered logical datasource retry interval
ClusterRetryInterval=60000
# Dedicated Kernel Definitions
[JDENET_KERNEL_DEF1]
krnlName=XAPI Kernel
processClassName=com.jdedwards.runtime.virtual.xapi.PublishedMessageProcessor
startMessageRange=15001
endMessageRange=15250
maxNumberOfThread=3
[SERVER]
# Enterprise Server and port providing Glossary Text information
glossaryTextServer=ENTE810:6012
# Encoding scheme
# 1252- English and Western European
# 932- Japanese
# 950- Traditional Chinese
# 936- Simplified Chinese
# 949- Korean
codePage=1252
[LOGS]
Debug=TRUE
logs=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\JAS.LOG
Debudlog=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\JASDEBUG.LOG
# JDBC Trace (in stdout)
rtdebugTrace=TRUE
rtlog=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\rt.log
rtdebug=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\rtdebug.log
rtlogType=All
#or =BSFN|TableIO|SYSFUNC|MISC|ER|EVENT|THREAD (any combination).
# The STDERR and STDOUT keys must point to the same directory that was supplied for the
# STDERR and STDOUT fields when defining the WebSphere Application Server.
# This is usually the INTERNET directory under B7333.
#
stderr=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\stderr.txt
stdout=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\stdout.txt
[JAS INSTANCE]
# This is for JAS redirector only
# RoundRobin will be used as default if ther is no entry in [JAS WEIGHT].
# If redirect based on JAS instance weight, then each instance's weight must specified,
# otherwise, weight 0 will be assumed, which means the server will not get
# any redirected request
# example: JAS1=http://127.0.0.1/jde
# Note: in this example, "JAS1" is the key, if weight will be given,
# this key must be used in [JAS WEIGHT] section to match this JAS instance
[JAS WEIGHT]
# The key must match the key in [JAS INSTANCE] section
# example: JAS1=2
# The weight is ratio based, for example:
# JAS1=2
# JAS2=1
# That means JAS1 will take as twice load as JAS2
[REDIRECTOR]
# interval unit is milliseconds
Interval=5000
# This is the location that Redirector will redirect to, if no server is available.
# If it is empty, redirect will display a simple page tells user that no server is available
# example: NoServerAvailableURL=http://servername/path/noserver.html
NoServerAvailableURL=
[TRANSACTIONS]
# Configuration settings to customize transaction processing within JAS.
# ReapInterval : Interval in minutes of how often the TransactionReaper
# should check for abandoned transactions.
# Valid values: Integer from 1 to n
# Default: 5 minutes
# MaxAge : Maximum age in minutes of a transaction. Transactions
# older than this will be rolled back by the
# TransactionReaper.
# Valid values: Integer from 1 to n
# Default: 10 minutes
#
ReapInterval=5
MaxAge=10
[ERPINTERACTIVITY]
#interactivity level. valid values are: LOW, MEDIUM, and HIGH
InteractivityLevel=HIGH
# whether multiple browsers fetch is enabled
MultipleBrowserEnabled=TRUE
# the maximum number of open browsers for each user
MaxOpenBrowsers=5
# the number of records fetched for each database fetch before getting a system warning
DBFetchLimitBeforeWarning=2000
====================================== JDbj.INI======================================================
#=======================================================================
# jdbj.ini - JDBj configuration
#
# This file contains configuration information for JDBj, which provides
# general database access capabilities on behalf of J.D. Edwards Java
# solutions.
#
# IMPORTANT: All keys in this file are case sensitive.
#=======================================================================
#=======================================================================
# ERP specific information
#
# These sections apply only when accessing ERP data. These sections are
# ignored for standalone database access.
#=======================================================================
#-----------------------------------------------------------------------
# Bootstrap session
#
# The user, password, role information is optional. It is used by the
# the JDBJ Unit tests and JDBExplorer only if these parameters are not
# specified on the command line. The environment is required field otherwise
# JAS cannot signon to the HTML client.
#
# NOTES: * This information in this section corresponds to the information
# specified in the [DB SYSTEM SETTINGS] section of this installation's
# JDE.INI file.
#-----------------------------------------------------------------------
[JDBj-BOOTSTRAP SESSION]
user=PSFT
password=PSFT
environment=JPY810
role=*ALL
#-----------------------------------------------------------------------
# Bootstrap physical data source
#
# This defines the data source where the OCM and some other system
# tables reside. JDBj uses this at bootstrap time and later to look up
# OCM entries on demand. If it is not valid, then no ERP database
# access is possible.
#
# Here is a description of each field in this section:
#
# ---------------- --------------------------------------- -----------
# Field Description Applies to
# ---------------- --------------------------------------- -----------
# name The data source name. This is not that All
# important for bootstrap connections,
# but it does show up in error messages
# and the log.
# ---------------- --------------------------------------- -----------
# databaseType The database type. One of the All
# following:
#
# I = AS/400
# O = Oracle
# S = SQL Server
# W = UDB
# M = MSDE
# ---------------- --------------------------------------- -----------
# server The server (i.e. the host), or AS/400,
# "localhost". SQL Server
# MSDE
# ---------------- --------------------------------------- -----------
# database The database. Oracle,UDB
# ---------------- --------------------------------------- -----------
# serverPort The server port. SQL Server
# ---------------- --------------------------------------- -----------
# physicalDatabase The physical database (used as library AS/400,
# qualifier for AS/400). SQL Server,
# MSDE
# ---------------- --------------------------------------- -----------
# owner The owner. Oracle,
# SQL Server,
# UDB,
# MSDE
# ---------------- --------------------------------------- -----------
# lob Supports lobs. Oracle,
#
# AS/400
# ---------------- --------------------------------------- -----------
# unicode Performs unicode conversion. SQL Server
# MSDE
# ---------------- --------------------------------------- -----------
# databaseInstance The instance name of server. (JDELocal) MSDE
# ---------------- --------------------------------------- -----------
# translateOn AS400 translate on (default is FASLE) AS400
# ---------------- --------------------------------------- -----------
#-----------------------------------------------------------------------
#
# NOTES: * This information in this section should match the
# corresponding information specified in the
# [DB SYSTEM SETTINGS] section of this installation's JDE.INI
# file.
#-----------------------------------------------------------------------
[JDBj-BOOTSTRAP DATA SOURCE]
name=System - 810
databaseType=S
server=ente810
serverPort=1433
database=
physicalDatabase=PS810
owner=SY810
lob=false
unicode=false
databaseInstance=
translateOn=
#-----------------------------------------------------------------------
# Bootstrap spec data source (Optional)
#
# This defines the data source where the serialized spec tables reside.
# JDBj uses this at bootstrap time and after to look up serialized spec
# objects on demand. JDBj first looks for the name specified in this
# section in the Data Source Master table (F98611). If it finds a data
# source there, it uses it to read the serialized spec tables. If it
# does not find the data source in the Data Source Master table, then
# it initializes a new data source based on the rest of the fields in
# this section.
#
# If this section is not specified, then JDBj uses the OCM to find the
# serialized spec tables. If it is not valid, then no ERP database
# access is possible.
#
# See the description for "Bootstrap physical data source" above for
# information about which fields must be filled in for a given database
# platform.
#-----------------------------------------------------------------------
[JDBj-SPEC DATA SOURCE]
name=system - 810
databaseType=S
server=ente810
serverPort=1433
database=
physicalDatabase=PS810
owner=SY810
lob=false
unicode=false
user=PFST
password=PSFT
#=======================================================================
# END - ERP specific information
#
# The rest of the sections apply when accessing ERP and standalone data.
#=======================================================================
#-----------------------------------------------------------------------
# JDBC drivers
#
# This defines JDBC drivers and JDBC specific settings.
#-----------------------------------------------------------------------
[JDBj-JDBC DRIVERS]
ORACLE=oracle.jdbc.driver.OracleDriver
AS400=com.ibm.as400.access.AS400JDBCDriver
SQLSERVER=com.microsoft.jdbc.sqlserver.SQLServerDriver
UDB=COM.ibm.db2.jdbc.app.DB2Driver
[JDBj-ORACLE]
tns=
[JDBj-LOGS]
jdbcTrace=true
[JDBj-SERVER]
dbcsConversionTolerant=true
#-----------------------------------------------------------------------
# Connection pool settings
#-----------------------------------------------------------------------
[JDBj-CONNECTION POOL]
; The minimum number of connections to a data source. When closing old connections,
; the value set by this parameter will remain in the pool regardless of use.
;
; Valid values: 0 or greater
; Default value: 5
minConnection=5
; The maximum number of connections to a data source for all users. Additional
; database connection requests beyond this value will be queued for the next available
; connection.
;
; Valid values: 1 or greater (must be equal to or greater than "minConnection")
; Default value: 50
maxConnection=50
; The number of connections to initialize upon pool creation.
;
; Valid values: a value equal to or greater than "minConnection" AND equal to or
; less than "maxConnection"
; Default value: 5
initialConnection=5
; The increment of connections the system will create when a request for a connection
; cannot be satisfied with the current allocation as long as the maxConnection value
; has not been reached.
;
; Valid values: The rule of thumb is (poolGrowth >= maxConnection/10)
; Default value: 5
poolGrowth=5
; Amount of time in milliseconds that a connection remains idle before it is flagged
; to be cleaned up. Keeping this value high may or may not add to performance. Reducing
; the value may reduce memory consumption.
;
; Valid values: 0 or greater
; Default value: 1800000 (30 minutes)
connectionTimeout=1800000
; Amount of time in milliseconds that the pool cleaner is set to clean data sources
; that have a validation string. When cleaning occurs, any connections which have been
; flagged as idle will be cleaned up. The amount of time between a connection
; becoming idle and being cleaned up can be as long as the connectionTimeout value plus
; the cleanPoolInterval value.
;
; Valid values: 0 or greater
; Default value: 600000 (10 minutes)
cleanPoolInterval=600000
; The maximum number of JDBC prepared statements cached on each JDBC connection.
;
; Valid values: 0 or greater
; Default value: 50
maxSize=50
; The number of JDBC statements purged from a JDBC connection if the maxSize limit is
; reached. The statements purged will be the statements in the cache which have not
; been used for the longest amount of time.
;
; Valid values: The rule of thumb is (cachePurgeSize >= maxSize/10 + 2)
; Default value: 5
cachePurgeSize=5
#-----------------------------------------------------------------------
# JDBj Runtime properties
#
# These are all optional. They correspond to system runtime properties
# applicable to JDBj logical connections.
#
# NOTES: * In each case, the values listed are the defaults. The
# template default entries are commented out. Make sure
# and remove the pound sign (#) when changing these values.
#-----------------------------------------------------------------------
[JDBj-RUNTIME PROPERTIES]
; AS400 Database ASP property. Use this setting if you are running your iSeries
; server with multiple user databases or IASP (Independent Auxiliary Storage Pool)
; and have your EnterpriseOne tables located on the IASP. The IASP name can be found
; by using the command WRKRDBDIRE. This entry is not needed if you only have *LOCAL
; configured on your system in the WRKRDBDIRE Remote Location name.
;
; Valid values: Any valid string
# AS400DatabaseASP=null
; AS400 package name property. Overrides the default sql package
; name on the AS400 with the specified name.
;
; Valid values: Any valid string
# as400Package=JDBj
; AS400 package library name property. Overrides the default sql package
; library name on the AS400 with the specified name.
;
; Valid values: Any valid string
# as400PackageLibrary=JDBj-Library
; AS400 extended dynamic property. Overrides the default extended dynamic
; setting with the specified setting. If specified to a false, AS400 database
; will not use packages. This will have a negative impact on performance.
;
; Valid values: true, false
# as400ExtendedDynamic=true
; Data cache entry size threshold property. Sets the maximum
; size (in rows) for a single entry in the data cache. If a
; potential entry exceeds this threshold, then it will not be
; cached. -1 indicates that all eligible entries should be
; cached.
;
; Valid values: -1 or greater
# dataCacheEntrySizeThreshold=500
; Data cache entry threshold property. Sets the maximum size (in
; entries) for the data cache. If the data cache exceeds this
; size, then the least recently used entries are removed to
; make room for the new entry. -1 indicates that there is no
; maximum.
;
; Valid values: -1 or greater
# dataCacheEntryThreshold=100
; Data varification property. Enable or disable the data ve
Trying to install IBM WebSphere Enterprise Application Server Fixpack.
Basically I am trying to install JAS Application Server in PeopleSoft E1 8.10. Well this is my 1st experience to install PSFT JAS
Server in my life becuase I am new in this CNC Feild. Well I followed the Installation guide and complete my installation.
Well every thing ok so far, But When I am trying to log in from http://was:81/jde/owhtml I cannot!!!.
So I checked the versions of IBM , ok Currently I am using IBM Websphere Enterprise Application Server V5.0.2, Then I dowloaded
Fixes & Fix Pack from IBM WebSite, I And I installed , but facing same problem, Cannot log in the server. Well any body have any cue about this issue.
Well Please go through with the JAS.ini & Jdbj.ini file, And do let me know the steps to install FIXPACK of Websphere may be I am following the wrong issue.
So please do help me out.
Bye
Ahsen
======================================JAS.INI=====================================
# Please refer to the JAS Installation Guide for detailed information on
# this file.
#
#
[SECURITY]
DataSource=System - 810
SecurityServer=ente810
UseLogonCookie=FALSE
CookieLifeTime=7
SSOEnabled=FALSE
SSOUserIDOnly=FALSE
# set password only if SSOUserIDOnly is set to TRUE
Password=
[OWWEB]
PathCodes=('PD810','PY810')
MO QUEUE=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\moqueue
ProxyPoolSize=50
F0005Prefix=DR
F0004Prefix=DT
#ProxyHost=
#ProxyPort=
MAXUser=200
FtpPort=21
FtpUsr=anonymous
FtpPwd=anonymous
UseMOWinNTShare=TRUE
PrintImmediate=FALSE
KeepUBE=TRUE
UBEQueue=QBATCH
SystemDateFormat=MDE
SystemDateSeparator=/
VirtualClientTimeOut=300000
InYourFaceError=TRUE
# The HelpPath key determines where JAS looks for help files.
# Syntax: "http://[machine]/[path]/".
# Note, if you specify "/jde/owhelp/", this machine is assumed.
HelpPath=/jde/owhelp/
[CACHE]
# These intervals are in milliseconds. For example, 60000ms = 1 minute
UserSession=2400000
UserProfile=1200000
CacheCheck=60000
Menu=3600000
[SERVER COMPONENTS]
#
# Do not modify this section
#
com.jdedwards.jas.UserManager
com.jdedwards.jas.JDBCProxy
com.jdedwards.jas.JDEORB
com.jdedwards.jas.DDValidation
com.jdedwards.jas.security.SecurityBroker
com.jdedwards.jas.UDCJDBC
com.jdedwards.jas.JDEUDCText
com.jdedwards.jas.JDEUpdates
com.jdedwards.jas.JDEQueries
com.jdedwards.jas.JDEOWDirect
com.jdedwards.jas.ServerQuery
com.jdedwards.jas.JDESignon
com.jdedwards.runtime.virtual.MAFComponentLoader
[JDENET]
# Enterprise Server JDENET port
serviceNameConnect=6012
# JAS Server JDENET Listening port
serviceNameListen=6012
# Maximum number of dedicated kernel types
maxKernelRanges=1
# Time out value for requests sent to the Enterprise Server
enterpriseServerTimeout=90000
# JDENET socket connection pool size
maxPoolSize=50
# Directory for JDENET temporary file
tempFileDir=C:\DOCUME~1\arizwan\LOCALS~1\Temp
# Clustered logical datasource retry interval
ClusterRetryInterval=60000
# Dedicated Kernel Definitions
[JDENET_KERNEL_DEF1]
krnlName=XAPI Kernel
processClassName=com.jdedwards.runtime.virtual.xapi.PublishedMessageProcessor
startMessageRange=15001
endMessageRange=15250
maxNumberOfThread=3
[SERVER]
# Enterprise Server and port providing Glossary Text information
glossaryTextServer=ENTE810:6012
# Encoding scheme
# 1252- English and Western European
# 932- Japanese
# 950- Traditional Chinese
# 936- Simplified Chinese
# 949- Korean
codePage=1252
[LOGS]
Debug=TRUE
logs=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\JAS.LOG
Debudlog=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\JASDEBUG.LOG
# JDBC Trace (in stdout)
rtdebugTrace=TRUE
rtlog=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\rt.log
rtdebug=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\rtdebug.log
rtlogType=All
#or =BSFN|TableIO|SYSFUNC|MISC|ER|EVENT|THREAD (any combination).
# The STDERR and STDOUT keys must point to the same directory that was supplied for the
# STDERR and STDOUT fields when defining the WebSphere Application Server.
# This is usually the INTERNET directory under B7333.
#
stderr=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\stderr.txt
stdout=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\stdout.txt
[JAS INSTANCE]
# This is for JAS redirector only
# RoundRobin will be used as default if ther is no entry in [JAS WEIGHT].
# If redirect based on JAS instance weight, then each instance's weight must specified,
# otherwise, weight 0 will be assumed, which means the server will not get
# any redirected request
# example: JAS1=http://127.0.0.1/jde
# Note: in this example, "JAS1" is the key, if weight will be given,
# this key must be used in [JAS WEIGHT] section to match this JAS instance
[JAS WEIGHT]
# The key must match the key in [JAS INSTANCE] section
# example: JAS1=2
# The weight is ratio based, for example:
# JAS1=2
# JAS2=1
# That means JAS1 will take as twice load as JAS2
[REDIRECTOR]
# interval unit is milliseconds
Interval=5000
# This is the location that Redirector will redirect to, if no server is available.
# If it is empty, redirect will display a simple page tells user that no server is available
# example: NoServerAvailableURL=http://servername/path/noserver.html
NoServerAvailableURL=
[TRANSACTIONS]
# Configuration settings to customize transaction processing within JAS.
# ReapInterval : Interval in minutes of how often the TransactionReaper
# should check for abandoned transactions.
# Valid values: Integer from 1 to n
# Default: 5 minutes
# MaxAge : Maximum age in minutes of a transaction. Transactions
# older than this will be rolled back by the
# TransactionReaper.
# Valid values: Integer from 1 to n
# Default: 10 minutes
#
ReapInterval=5
MaxAge=10
[ERPINTERACTIVITY]
#interactivity level. valid values are: LOW, MEDIUM, and HIGH
InteractivityLevel=HIGH
# whether multiple browsers fetch is enabled
MultipleBrowserEnabled=TRUE
# the maximum number of open browsers for each user
MaxOpenBrowsers=5
# the number of records fetched for each database fetch before getting a system warning
DBFetchLimitBeforeWarning=2000
====================================== JDbj.INI======================================================
#=======================================================================
# jdbj.ini - JDBj configuration
#
# This file contains configuration information for JDBj, which provides
# general database access capabilities on behalf of J.D. Edwards Java
# solutions.
#
# IMPORTANT: All keys in this file are case sensitive.
#=======================================================================
#=======================================================================
# ERP specific information
#
# These sections apply only when accessing ERP data. These sections are
# ignored for standalone database access.
#=======================================================================
#-----------------------------------------------------------------------
# Bootstrap session
#
# The user, password, role information is optional. It is used by the
# the JDBJ Unit tests and JDBExplorer only if these parameters are not
# specified on the command line. The environment is required field otherwise
# JAS cannot signon to the HTML client.
#
# NOTES: * This information in this section corresponds to the information
# specified in the [DB SYSTEM SETTINGS] section of this installation's
# JDE.INI file.
#-----------------------------------------------------------------------
[JDBj-BOOTSTRAP SESSION]
user=PSFT
password=PSFT
environment=JPY810
role=*ALL
#-----------------------------------------------------------------------
# Bootstrap physical data source
#
# This defines the data source where the OCM and some other system
# tables reside. JDBj uses this at bootstrap time and later to look up
# OCM entries on demand. If it is not valid, then no ERP database
# access is possible.
#
# Here is a description of each field in this section:
#
# ---------------- --------------------------------------- -----------
# Field Description Applies to
# ---------------- --------------------------------------- -----------
# name The data source name. This is not that All
# important for bootstrap connections,
# but it does show up in error messages
# and the log.
# ---------------- --------------------------------------- -----------
# databaseType The database type. One of the All
# following:
#
# I = AS/400
# O = Oracle
# S = SQL Server
# W = UDB
# M = MSDE
# ---------------- --------------------------------------- -----------
# server The server (i.e. the host), or AS/400,
# "localhost". SQL Server
# MSDE
# ---------------- --------------------------------------- -----------
# database The database. Oracle,UDB
# ---------------- --------------------------------------- -----------
# serverPort The server port. SQL Server
# ---------------- --------------------------------------- -----------
# physicalDatabase The physical database (used as library AS/400,
# qualifier for AS/400). SQL Server,
# MSDE
# ---------------- --------------------------------------- -----------
# owner The owner. Oracle,
# SQL Server,
# UDB,
# MSDE
# ---------------- --------------------------------------- -----------
# lob Supports lobs. Oracle,
#
# AS/400
# ---------------- --------------------------------------- -----------
# unicode Performs unicode conversion. SQL Server
# MSDE
# ---------------- --------------------------------------- -----------
# databaseInstance The instance name of server. (JDELocal) MSDE
# ---------------- --------------------------------------- -----------
# translateOn AS400 translate on (default is FASLE) AS400
# ---------------- --------------------------------------- -----------
#-----------------------------------------------------------------------
#
# NOTES: * This information in this section should match the
# corresponding information specified in the
# [DB SYSTEM SETTINGS] section of this installation's JDE.INI
# file.
#-----------------------------------------------------------------------
[JDBj-BOOTSTRAP DATA SOURCE]
name=System - 810
databaseType=S
server=ente810
serverPort=1433
database=
physicalDatabase=PS810
owner=SY810
lob=false
unicode=false
databaseInstance=
translateOn=
#-----------------------------------------------------------------------
# Bootstrap spec data source (Optional)
#
# This defines the data source where the serialized spec tables reside.
# JDBj uses this at bootstrap time and after to look up serialized spec
# objects on demand. JDBj first looks for the name specified in this
# section in the Data Source Master table (F98611). If it finds a data
# source there, it uses it to read the serialized spec tables. If it
# does not find the data source in the Data Source Master table, then
# it initializes a new data source based on the rest of the fields in
# this section.
#
# If this section is not specified, then JDBj uses the OCM to find the
# serialized spec tables. If it is not valid, then no ERP database
# access is possible.
#
# See the description for "Bootstrap physical data source" above for
# information about which fields must be filled in for a given database
# platform.
#-----------------------------------------------------------------------
[JDBj-SPEC DATA SOURCE]
name=system - 810
databaseType=S
server=ente810
serverPort=1433
database=
physicalDatabase=PS810
owner=SY810
lob=false
unicode=false
user=PFST
password=PSFT
#=======================================================================
# END - ERP specific information
#
# The rest of the sections apply when accessing ERP and standalone data.
#=======================================================================
#-----------------------------------------------------------------------
# JDBC drivers
#
# This defines JDBC drivers and JDBC specific settings.
#-----------------------------------------------------------------------
[JDBj-JDBC DRIVERS]
ORACLE=oracle.jdbc.driver.OracleDriver
AS400=com.ibm.as400.access.AS400JDBCDriver
SQLSERVER=com.microsoft.jdbc.sqlserver.SQLServerDriver
UDB=COM.ibm.db2.jdbc.app.DB2Driver
[JDBj-ORACLE]
tns=
[JDBj-LOGS]
jdbcTrace=true
[JDBj-SERVER]
dbcsConversionTolerant=true
#-----------------------------------------------------------------------
# Connection pool settings
#-----------------------------------------------------------------------
[JDBj-CONNECTION POOL]
; The minimum number of connections to a data source. When closing old connections,
; the value set by this parameter will remain in the pool regardless of use.
;
; Valid values: 0 or greater
; Default value: 5
minConnection=5
; The maximum number of connections to a data source for all users. Additional
; database connection requests beyond this value will be queued for the next available
; connection.
;
; Valid values: 1 or greater (must be equal to or greater than "minConnection")
; Default value: 50
maxConnection=50
; The number of connections to initialize upon pool creation.
;
; Valid values: a value equal to or greater than "minConnection" AND equal to or
; less than "maxConnection"
; Default value: 5
initialConnection=5
; The increment of connections the system will create when a request for a connection
; cannot be satisfied with the current allocation as long as the maxConnection value
; has not been reached.
;
; Valid values: The rule of thumb is (poolGrowth >= maxConnection/10)
; Default value: 5
poolGrowth=5
; Amount of time in milliseconds that a connection remains idle before it is flagged
; to be cleaned up. Keeping this value high may or may not add to performance. Reducing
; the value may reduce memory consumption.
;
; Valid values: 0 or greater
; Default value: 1800000 (30 minutes)
connectionTimeout=1800000
; Amount of time in milliseconds that the pool cleaner is set to clean data sources
; that have a validation string. When cleaning occurs, any connections which have been
; flagged as idle will be cleaned up. The amount of time between a connection
; becoming idle and being cleaned up can be as long as the connectionTimeout value plus
; the cleanPoolInterval value.
;
; Valid values: 0 or greater
; Default value: 600000 (10 minutes)
cleanPoolInterval=600000
; The maximum number of JDBC prepared statements cached on each JDBC connection.
;
; Valid values: 0 or greater
; Default value: 50
maxSize=50
; The number of JDBC statements purged from a JDBC connection if the maxSize limit is
; reached. The statements purged will be the statements in the cache which have not
; been used for the longest amount of time.
;
; Valid values: The rule of thumb is (cachePurgeSize >= maxSize/10 + 2)
; Default value: 5
cachePurgeSize=5
#-----------------------------------------------------------------------
# JDBj Runtime properties
#
# These are all optional. They correspond to system runtime properties
# applicable to JDBj logical connections.
#
# NOTES: * In each case, the values listed are the defaults. The
# template default entries are commented out. Make sure
# and remove the pound sign (#) when changing these values.
#-----------------------------------------------------------------------
[JDBj-RUNTIME PROPERTIES]
; AS400 Database ASP property. Use this setting if you are running your iSeries
; server with multiple user databases or IASP (Independent Auxiliary Storage Pool)
; and have your EnterpriseOne tables located on the IASP. The IASP name can be found
; by using the command WRKRDBDIRE. This entry is not needed if you only have *LOCAL
; configured on your system in the WRKRDBDIRE Remote Location name.
;
; Valid values: Any valid string
# AS400DatabaseASP=null
; AS400 package name property. Overrides the default sql package
; name on the AS400 with the specified name.
;
; Valid values: Any valid string
# as400Package=JDBj
; AS400 package library name property. Overrides the default sql package
; library name on the AS400 with the specified name.
;
; Valid values: Any valid string
# as400PackageLibrary=JDBj-Library
; AS400 extended dynamic property. Overrides the default extended dynamic
; setting with the specified setting. If specified to a false, AS400 database
; will not use packages. This will have a negative impact on performance.
;
; Valid values: true, false
# as400ExtendedDynamic=true
; Data cache entry size threshold property. Sets the maximum
; size (in rows) for a single entry in the data cache. If a
; potential entry exceeds this threshold, then it will not be
; cached. -1 indicates that all eligible entries should be
; cached.
;
; Valid values: -1 or greater
# dataCacheEntrySizeThreshold=500
; Data cache entry threshold property. Sets the maximum size (in
; entries) for the data cache. If the data cache exceeds this
; size, then the least recently used entries are removed to
; make room for the new entry. -1 indicates that there is no
; maximum.
;
; Valid values: -1 or greater
# dataCacheEntryThreshold=100
; Data varification property. Enable or disable the data ve