cscdans
Well Known Member
Hello,
I am runnging E1 Standalone 812 (Tools 896) WinXP / MSDE.
I successfilly got the COM-Infterface to work, but I have heavy problems getting the Java examples to work.
First the provided Java-DynCon Example in C:\E812\system\Classes\samples\ConnectorSamples\runDynConNewEventDriver.bat
When I start it, I get a SpecFailureException:
Exception in thread "main" com.jdedwards.system.connector.dynamic.spec.SpecFailureException: Cannot connect to Oneworld Spec Sourceata Source not found in Oneworld Database Data source for F9860, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local.)
at com.jdedwards.system.connector.dynamic.spec.source.OneworldBSFNSpecSource.<init>(Unknown Source)
at com.jdedwards.system.connector.dynamic.sample.addressbook.AddressbookClient.initGUI(Unknown Source)
at com.jdedwards.system.connector.dynamic.sample.addressbook.AddressbookClient.main(Unknown Source)
I modified the runDynConAddressBook.bat:
set JAVA_HOME=C:\E812\system\JDK\jre
"%JAVA_HOME%\bin\java.exe" -cp C:\E812\system\OC4J\j2ee\home\applibmsbase.jar;C:\E812\system\OC4J\j2ee\home\applib\mssqlserver.jar;C:\E812\system\OC4J\j2ee\home\applib\msutil.jar -jar addrconnector.jar
My 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.
#=======================================================================
#=======================================================================
# OneWorld specific information
#
# These sections apply only when accessing OneWorld data. These
# sections are ignored for standalone database access.
#=======================================================================
#-----------------------------------------------------------------------
# Bootstrap session
#
# This information is used to sign on to provide access to system
# tables. JDBj signs this user on via the security server at bootstrap-
# time, so if it is not valid, then no OneWorld database access is
# possible.
#
# 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 SESSION]
user=DEMO
password=DEMO
environment=DEMO812
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 OneWorld 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
# ---------------- --------------------------------------- -----------
# server The server (i.e. the host). AS/400,
# SQL Server
# ---------------- --------------------------------------- -----------
# 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
# ---------------- --------------------------------------- -----------
# owner The owner. Oracle,
# SQL Server,
# UDB
# ---------------- --------------------------------------- -----------
# lob Supports lobs. Oracle,
#
# AS/400
# ---------------- --------------------------------------- -----------
# unicode Performs unicode conversion. SQL Server
# ---------------- --------------------------------------- -----------
#
# 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 Local
databaseType=M
#databaseType=S
server=localhost
serverPort=3372
database=System Local
physicalDatabase=JDESY812
owner=dbo
lob=false
unicode=true
databaseInstance=JDELocal
#-----------------------------------------------------------------------
# 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. If this section is not specified, then JDBj will
# use the OCM to find the serialized spec table. If it is not valid, no
# OneWorld 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=Local - DEMO Specs
databaseType=M
server=localhost
serverPort=3372
database=Local - DEMO Specs
physicalDatabase=SPEC_MASTER
owner=dbo
lob=false
unicode=true
databaseInstance=JDELocal
user=jde
password=jde
#=======================================================================
# END - OneWorld specific information
#
# The rest of the sections apply when accessing OneWorld 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=C:\E812\system\OC4J\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes
[JDBj-LOGS]
jdbcTrace=false
[JDBj-SERVER]
dbcsConversionTolerant=true
#-----------------------------------------------------------------------
# Connection pool settings
#
# These are used only when J2EE connection pooling is not available.
#-----------------------------------------------------------------------
[JDBj-CONNECTION POOL]
jdbcPooling=false
minConnection=5
maxConnection=5
initialConnection=5
poolGrowth=5
connectionTimeout=1800000
cleanPoolInterval=600000
maxSize=50
purgeCacheSize=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]
; 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
; Force single data source property. Indicates whether JDBj
; should force operations involving multiple database objects to
; run against a single data source. If this is true, JDBj will
; only resolve the physical data source for the first database
; object involved in a given operation. Otherwise, JDBj will
; resolve physical data sources for all database objects and
; throw an exception if a single operation spans multiple data
; sources.
;
; Valid values: true, false
# forceSingleDataSource=false
; No where paren property. Certain TableIO system function
; queries require a long list of selections in the where clause
; without any intermediate parentheses. Specifying a composite
; selections alone for this case creates intermediate
; parentheses. If this property is set to a true then the JDBj
; will create SQL without any intermediate parenetheses.
;
; Valid values: true, false
# noWhereParen=false
; Result set timeout property. Sets the the number of
; milliseconds for the result set timeout. A result set will
; timeout if it has not had any operations for a period of time.
;
; Valid values: -1 or greater
# resultSetTimeout=60000
; Retry interval property. Sets the interval (in milliseconds)
; to wait before retrying idempotent database operations. -1
; means not to retry, 0 means retry immediately.
;
; Valid values: -1 or greater
# retryInterval=0
; Retry maximum property. Sets the number of times to retry
; idempotent database operations. -1 means to retry
; indefinitely.
;
; Valid values: -1 or greater
# retryMaximum=5
; Spec consistency check property. Sets the level of spec
; consistency checking. Set this property to a higher level to
; improve exception messages relating to spec inconsistency
; problems. Set this to a lower level when it is not needed
; since it may degrade performance.
;
; Valid values: full, minimal, none
# specConsistencyCheck=minimal
; Spec generate on demand property. Indicates whether JDBj
; should generate specs on demand if it can not find them
; in the persistent cache.
;
; Valid values: true, false
specGenerateOnDemand=true
; Transaction isolation property. Sets the isolation level to be
; used for transactions.
;
; Valid values: default, none, read uncommitted, read committed,
; repeatable read, serializable
# transactionIsolation=default
; Transaction timeout property. Sets the number of milliseconds
; for the transaction timeout. A transaction will timeout if it
; has not had any operations for a period of time. If this
; timeout is set to a -1 then the transaction timeout feature
; will be disabled. (This currently only happens when JDBj is
; run as part of a JAS transaction.)
;
; Valid values: -1 or greater
# transactionTimeout=120000
; Trigger auto fetch property. Indicates whether JDBj should
; automatically fetch rows to be changed in order to pass them
; to OneWorld triggers. This is needed for certain triggers to
; work properly.
;
; Valid values: true, false
# triggerAutoFetch=false
; Updatable result set timeout property. Sets the the number of
; milliseconds for the updatable result set timeout. An
; updatable result set will timeout if it has not had any
; operations for a period of time. -1 indicates that updatable
; result sets should have the same value as RESULT_SET_TIMEOUT.
;
; Valid values: -1 or greater
# updatableResultSetTimeout=-1
; Usage execution threshold property. Sets the expected maximum
; time (in milliseconds) for a single database operation to
; execute. If a single database operation takes longer than this
; threshold, then the statement and time will be logged as part
; of usage tracking.
;
; Valid values: 0 or greater
usageExecutionThreshold=20000
; Usage fetch size threshold property. Sets the expected maximum
; fetch size (in rows) for a single fetch to return. If a single
; fetch returns more than than this threshold, then the actual
; fetch size will be logged as part of usage tracking. -1
; indicates that any fetch size is valid.
;
; Valid values: -1 or greater
usageFetchSizeThreshold=500
; Usage result set open threshold property. Sets the expected
; maximum time (in milliseconds) for a result set to remain
; open. If a result set is left open longer than this threshold,
; then the result set and time will be logged as part of usage
; tracking. This does not automatically close the result set. A
; usage result set open threshold value of -1 indicates that no
; such usage tracking will occur.
;
; Valid values: -1 or greater
# usageResultSetOpenThreshold=60000
; Usage tracking property. Enables or disables usage tracking.
; This provides additional tracking and logging to use during
; testing. Usage tracking does incur a performance penalty so it
; should be disabled for production code.
;
; Valid values: true, false
# usageTracking=false
; Usage tracking output property. Specifies the destination of
; usage tracking output.
;
; Valid values: log, exception
# usageTrackingOutput=log
; Usage transaction active threshold property. Sets the expected
; maximum time (in milliseconds) for a transaction to remain
; active. If a transaction is left active longer than this
; threshold, then the transaction and time will be logged as
; part of usage tracking. This does not automatically rollback
; the transaction. A usage transaction active threshold value of
; -1 indicates that no such usage tracking will occur.
;
; Valid values: -1 or greater
# usageTransactionActiveThreshold=120000
#=======================================================================
# END OF FILE
#=======================================================================
My jdeinterop.ini:
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;
;Please Edit this File before first use. The Server name must be
;changed from OWES1 to the actual name.
; [SERVER]
; glossaryTextServer=OWES1:6010
; # Encoding scheme
; # 1252- English and Western European
; # 932- Japanese
; # 950- Traditional Chinese
; # 936- Simplified Chinese
; # 949- Korean
; codePage=1252
;
;
;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[SERVER]
glossaryTextServer=OWES1:6012
codePage=1252
[JDENET]
serviceNameConnect=6012
enterpriseServerTimeout=1200000
maxPoolSize=30
#==========================================================
# Define Cache feature for Connector
#==========================================================
[CACHE]
UserSession=18000000
SpecExpire=300000000
#==========================================================
# Define the features for inbound Business Function call
#==========================================================
[INTEROP]
enterpriseServer=localhost
#port=
port=6012
manual_timeout=30000000
Repository=C:\E812\system\Classes\com\jdedwards\application\interop
#==========================================================
# Define the features for outbound events
#==========================================================
[EVENTS]
port=6010
ListenerMaxConnection=100
ListenerMaxQueueEntry=100
outbound_timeout=6000000
#==========================================================
# JNDI information for communication with the J2EE server.
#==========================================================
initialContextFactory=com.ibm.websphere.naming.WsnInitialContextFactory
jndiProviderURL=corbaloc:iiop:localhost:2809
#==========================================================
# URL for communicating with the event client service.
#==========================================================
eventServiceURL=http://localhost:9080/e1events/EventClientService
#==========================================================
# Security Server. Security server port is in [JDENET]
#==========================================================
[SECURITY]
NumServers=1
SecurityServer=localhost
#==========================================================
# OCMEnabled--It will enforce Connector to use OCM to find
# enterpriser server or use setting in [Interop]section.
#==========================================================
[OCM]
OCMEnabled=false
and at least my jdelog.properties:
[E1LOG]
FILE=C:\\jderoot.log
LEVEL=WARN
FORMAT=APPS
MAXFILESIZE=2MB
MAXBACKUPINDEX=4
COMPONENT=ALL
APPEND=TRUE
[LOG1]
FILE=C:\\JDEjas.log
LEVEL=APP
FORMAT=APPS
MAXFILESIZE=2MB
MAXBACKUPINDEX=4
COMPONENT=RUNTIME | INTEROP | JDBJ
APPEND=TRUE
[LOG2]
FILE=C:\\JDEjasdebug.log
LEVEL=DEBUG
FORMAT=TOOLS_THREAD
MAXFILESIZE=2MB
MBMAXBACKUPINDEX=4
COMPONENT=RUNTIME | INTEROP | JDBJ
APPEND=TRUE
JDEjasdebug_20070720.log:
20 Jul 2007 11:25:17,828 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBj version information:
20 Jul 2007 11:25:17,828 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Specification title: null
Specification version: null
Specification vendor: null
Implementation title: null
Implementation version: null
Implementation vendor: null
20 Jul 2007 11:25:17,860 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property AS400 Database ASP default value null.
20 Jul 2007 11:25:17,860 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property AS400 Package default value JDBj.
20 Jul 2007 11:25:17,860 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property AS400 Package Library default value null.
20 Jul 2007 11:25:17,860 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property AS400 Extended Dynamic default value true.
20 Jul 2007 11:25:17,875 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBC driver com.microsoft.jdbc.sqlserver.SQLServerDriver not found in ClassPath
20 Jul 2007 11:25:17,985 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBj bootstrap spec map initialized.
20 Jul 2007 11:25:17,985 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBj bootstrap data source initialized: System Local.
20 Jul 2007 11:25:17,985 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBj serialized access override found in config file.
20 Jul 2007 11:25:17,985 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBj bootstrap spec physical connection properties initialized: (JDE,*********).
20 Jul 2007 11:25:18,016 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property Transaction Timeout default value 120000.
20 Jul 2007 11:25:18,016 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Transaction 1 state initialized to auto commit.
20 Jul 2007 11:25:18,031 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property Service Cache Purge default value 600000.
20 Jul 2007 11:25:18,047 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property OCM Cache Purge default value 600000.
20 Jul 2007 11:25:18,047 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property Security Cache Purge default value 600000.
20 Jul 2007 11:25:18,047 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property Spec Cache Purge default value 600000.
20 Jul 2007 11:25:18,078 [Line ?] [main] [DEBUG ] - [JDBJ] JDBj lookup service database access #1.
20 Jul 2007 11:25:18,078 [Line ?] [main] [DEBUG ] - [JDBJ] Resolved database object F986101 to data source System Local.
20 Jul 2007 11:25:18,078 [Line ?] [main] [DEBUG ] - [JDBJ] Using runtime property Force Single Data Source default value false.
20 Jul 2007 11:25:18,094 [Line ?] [main] [DEBUG ] - [JDBJ] Using runtime property Transaction Isolation default value default.
20 Jul 2007 11:25:18,094 [Line ?] [main] [DEBUG ] - [JDBJ] No available connection in pool - Creating new connection for poolKey jdbc:microsoft:sqlserver://localhost\JDELocal_JDESY812_true_JDE
20 Jul 2007 11:25:18,094 [Line ?] [main] [DEBUG ] - [JDBJ] dataSource.isUnicode() = [true]
20 Jul 2007 11:25:18,094 [Line ?] [main] [DEBUG ] - [JDBJ] sendStringParametersAsUnicode = [true]
20 Jul 2007 11:25:18,094 [Line ?] [main] [DEBUG ] - [JDBJ] Connecting to System Local with URL : jdbc:microsoft:sqlserver://localhost\JDELocal DBUser : JDE
20 Jul 2007 11:25:18,094 [Line ?] [main] [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local. java.sql.SQLException: No suitable driver
20 Jul 2007 11:25:18,094 [Line ?] [main] [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local.
So I suggest something wit my jdbj.ini or jdeinterop.ini is wrong.
Even other Expamples (running genjava /cmd addressbookcmd with the Example code from the Connector-pdf) don't work. There alwasy seem to be problems asscessing F9860 for reading Specs.
Does anybody got the examples with standlone to work? Any suggestions are welcome, best regards,
Carsten
I am runnging E1 Standalone 812 (Tools 896) WinXP / MSDE.
I successfilly got the COM-Infterface to work, but I have heavy problems getting the Java examples to work.
First the provided Java-DynCon Example in C:\E812\system\Classes\samples\ConnectorSamples\runDynConNewEventDriver.bat
When I start it, I get a SpecFailureException:
Exception in thread "main" com.jdedwards.system.connector.dynamic.spec.SpecFailureException: Cannot connect to Oneworld Spec Sourceata Source not found in Oneworld Database Data source for F9860, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local.)
at com.jdedwards.system.connector.dynamic.spec.source.OneworldBSFNSpecSource.<init>(Unknown Source)
at com.jdedwards.system.connector.dynamic.sample.addressbook.AddressbookClient.initGUI(Unknown Source)
at com.jdedwards.system.connector.dynamic.sample.addressbook.AddressbookClient.main(Unknown Source)
I modified the runDynConAddressBook.bat:
set JAVA_HOME=C:\E812\system\JDK\jre
"%JAVA_HOME%\bin\java.exe" -cp C:\E812\system\OC4J\j2ee\home\applibmsbase.jar;C:\E812\system\OC4J\j2ee\home\applib\mssqlserver.jar;C:\E812\system\OC4J\j2ee\home\applib\msutil.jar -jar addrconnector.jar
My 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.
#=======================================================================
#=======================================================================
# OneWorld specific information
#
# These sections apply only when accessing OneWorld data. These
# sections are ignored for standalone database access.
#=======================================================================
#-----------------------------------------------------------------------
# Bootstrap session
#
# This information is used to sign on to provide access to system
# tables. JDBj signs this user on via the security server at bootstrap-
# time, so if it is not valid, then no OneWorld database access is
# possible.
#
# 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 SESSION]
user=DEMO
password=DEMO
environment=DEMO812
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 OneWorld 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
# ---------------- --------------------------------------- -----------
# server The server (i.e. the host). AS/400,
# SQL Server
# ---------------- --------------------------------------- -----------
# 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
# ---------------- --------------------------------------- -----------
# owner The owner. Oracle,
# SQL Server,
# UDB
# ---------------- --------------------------------------- -----------
# lob Supports lobs. Oracle,
#
# AS/400
# ---------------- --------------------------------------- -----------
# unicode Performs unicode conversion. SQL Server
# ---------------- --------------------------------------- -----------
#
# 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 Local
databaseType=M
#databaseType=S
server=localhost
serverPort=3372
database=System Local
physicalDatabase=JDESY812
owner=dbo
lob=false
unicode=true
databaseInstance=JDELocal
#-----------------------------------------------------------------------
# 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. If this section is not specified, then JDBj will
# use the OCM to find the serialized spec table. If it is not valid, no
# OneWorld 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=Local - DEMO Specs
databaseType=M
server=localhost
serverPort=3372
database=Local - DEMO Specs
physicalDatabase=SPEC_MASTER
owner=dbo
lob=false
unicode=true
databaseInstance=JDELocal
user=jde
password=jde
#=======================================================================
# END - OneWorld specific information
#
# The rest of the sections apply when accessing OneWorld 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=C:\E812\system\OC4J\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes
[JDBj-LOGS]
jdbcTrace=false
[JDBj-SERVER]
dbcsConversionTolerant=true
#-----------------------------------------------------------------------
# Connection pool settings
#
# These are used only when J2EE connection pooling is not available.
#-----------------------------------------------------------------------
[JDBj-CONNECTION POOL]
jdbcPooling=false
minConnection=5
maxConnection=5
initialConnection=5
poolGrowth=5
connectionTimeout=1800000
cleanPoolInterval=600000
maxSize=50
purgeCacheSize=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]
; 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
; Force single data source property. Indicates whether JDBj
; should force operations involving multiple database objects to
; run against a single data source. If this is true, JDBj will
; only resolve the physical data source for the first database
; object involved in a given operation. Otherwise, JDBj will
; resolve physical data sources for all database objects and
; throw an exception if a single operation spans multiple data
; sources.
;
; Valid values: true, false
# forceSingleDataSource=false
; No where paren property. Certain TableIO system function
; queries require a long list of selections in the where clause
; without any intermediate parentheses. Specifying a composite
; selections alone for this case creates intermediate
; parentheses. If this property is set to a true then the JDBj
; will create SQL without any intermediate parenetheses.
;
; Valid values: true, false
# noWhereParen=false
; Result set timeout property. Sets the the number of
; milliseconds for the result set timeout. A result set will
; timeout if it has not had any operations for a period of time.
;
; Valid values: -1 or greater
# resultSetTimeout=60000
; Retry interval property. Sets the interval (in milliseconds)
; to wait before retrying idempotent database operations. -1
; means not to retry, 0 means retry immediately.
;
; Valid values: -1 or greater
# retryInterval=0
; Retry maximum property. Sets the number of times to retry
; idempotent database operations. -1 means to retry
; indefinitely.
;
; Valid values: -1 or greater
# retryMaximum=5
; Spec consistency check property. Sets the level of spec
; consistency checking. Set this property to a higher level to
; improve exception messages relating to spec inconsistency
; problems. Set this to a lower level when it is not needed
; since it may degrade performance.
;
; Valid values: full, minimal, none
# specConsistencyCheck=minimal
; Spec generate on demand property. Indicates whether JDBj
; should generate specs on demand if it can not find them
; in the persistent cache.
;
; Valid values: true, false
specGenerateOnDemand=true
; Transaction isolation property. Sets the isolation level to be
; used for transactions.
;
; Valid values: default, none, read uncommitted, read committed,
; repeatable read, serializable
# transactionIsolation=default
; Transaction timeout property. Sets the number of milliseconds
; for the transaction timeout. A transaction will timeout if it
; has not had any operations for a period of time. If this
; timeout is set to a -1 then the transaction timeout feature
; will be disabled. (This currently only happens when JDBj is
; run as part of a JAS transaction.)
;
; Valid values: -1 or greater
# transactionTimeout=120000
; Trigger auto fetch property. Indicates whether JDBj should
; automatically fetch rows to be changed in order to pass them
; to OneWorld triggers. This is needed for certain triggers to
; work properly.
;
; Valid values: true, false
# triggerAutoFetch=false
; Updatable result set timeout property. Sets the the number of
; milliseconds for the updatable result set timeout. An
; updatable result set will timeout if it has not had any
; operations for a period of time. -1 indicates that updatable
; result sets should have the same value as RESULT_SET_TIMEOUT.
;
; Valid values: -1 or greater
# updatableResultSetTimeout=-1
; Usage execution threshold property. Sets the expected maximum
; time (in milliseconds) for a single database operation to
; execute. If a single database operation takes longer than this
; threshold, then the statement and time will be logged as part
; of usage tracking.
;
; Valid values: 0 or greater
usageExecutionThreshold=20000
; Usage fetch size threshold property. Sets the expected maximum
; fetch size (in rows) for a single fetch to return. If a single
; fetch returns more than than this threshold, then the actual
; fetch size will be logged as part of usage tracking. -1
; indicates that any fetch size is valid.
;
; Valid values: -1 or greater
usageFetchSizeThreshold=500
; Usage result set open threshold property. Sets the expected
; maximum time (in milliseconds) for a result set to remain
; open. If a result set is left open longer than this threshold,
; then the result set and time will be logged as part of usage
; tracking. This does not automatically close the result set. A
; usage result set open threshold value of -1 indicates that no
; such usage tracking will occur.
;
; Valid values: -1 or greater
# usageResultSetOpenThreshold=60000
; Usage tracking property. Enables or disables usage tracking.
; This provides additional tracking and logging to use during
; testing. Usage tracking does incur a performance penalty so it
; should be disabled for production code.
;
; Valid values: true, false
# usageTracking=false
; Usage tracking output property. Specifies the destination of
; usage tracking output.
;
; Valid values: log, exception
# usageTrackingOutput=log
; Usage transaction active threshold property. Sets the expected
; maximum time (in milliseconds) for a transaction to remain
; active. If a transaction is left active longer than this
; threshold, then the transaction and time will be logged as
; part of usage tracking. This does not automatically rollback
; the transaction. A usage transaction active threshold value of
; -1 indicates that no such usage tracking will occur.
;
; Valid values: -1 or greater
# usageTransactionActiveThreshold=120000
#=======================================================================
# END OF FILE
#=======================================================================
My jdeinterop.ini:
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;
;Please Edit this File before first use. The Server name must be
;changed from OWES1 to the actual name.
; [SERVER]
; glossaryTextServer=OWES1:6010
; # Encoding scheme
; # 1252- English and Western European
; # 932- Japanese
; # 950- Traditional Chinese
; # 936- Simplified Chinese
; # 949- Korean
; codePage=1252
;
;
;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[SERVER]
glossaryTextServer=OWES1:6012
codePage=1252
[JDENET]
serviceNameConnect=6012
enterpriseServerTimeout=1200000
maxPoolSize=30
#==========================================================
# Define Cache feature for Connector
#==========================================================
[CACHE]
UserSession=18000000
SpecExpire=300000000
#==========================================================
# Define the features for inbound Business Function call
#==========================================================
[INTEROP]
enterpriseServer=localhost
#port=
port=6012
manual_timeout=30000000
Repository=C:\E812\system\Classes\com\jdedwards\application\interop
#==========================================================
# Define the features for outbound events
#==========================================================
[EVENTS]
port=6010
ListenerMaxConnection=100
ListenerMaxQueueEntry=100
outbound_timeout=6000000
#==========================================================
# JNDI information for communication with the J2EE server.
#==========================================================
initialContextFactory=com.ibm.websphere.naming.WsnInitialContextFactory
jndiProviderURL=corbaloc:iiop:localhost:2809
#==========================================================
# URL for communicating with the event client service.
#==========================================================
eventServiceURL=http://localhost:9080/e1events/EventClientService
#==========================================================
# Security Server. Security server port is in [JDENET]
#==========================================================
[SECURITY]
NumServers=1
SecurityServer=localhost
#==========================================================
# OCMEnabled--It will enforce Connector to use OCM to find
# enterpriser server or use setting in [Interop]section.
#==========================================================
[OCM]
OCMEnabled=false
and at least my jdelog.properties:
[E1LOG]
FILE=C:\\jderoot.log
LEVEL=WARN
FORMAT=APPS
MAXFILESIZE=2MB
MAXBACKUPINDEX=4
COMPONENT=ALL
APPEND=TRUE
[LOG1]
FILE=C:\\JDEjas.log
LEVEL=APP
FORMAT=APPS
MAXFILESIZE=2MB
MAXBACKUPINDEX=4
COMPONENT=RUNTIME | INTEROP | JDBJ
APPEND=TRUE
[LOG2]
FILE=C:\\JDEjasdebug.log
LEVEL=DEBUG
FORMAT=TOOLS_THREAD
MAXFILESIZE=2MB
MBMAXBACKUPINDEX=4
COMPONENT=RUNTIME | INTEROP | JDBJ
APPEND=TRUE
JDEjasdebug_20070720.log:
20 Jul 2007 11:25:17,828 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBj version information:
20 Jul 2007 11:25:17,828 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Specification title: null
Specification version: null
Specification vendor: null
Implementation title: null
Implementation version: null
Implementation vendor: null
20 Jul 2007 11:25:17,860 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property AS400 Database ASP default value null.
20 Jul 2007 11:25:17,860 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property AS400 Package default value JDBj.
20 Jul 2007 11:25:17,860 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property AS400 Package Library default value null.
20 Jul 2007 11:25:17,860 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property AS400 Extended Dynamic default value true.
20 Jul 2007 11:25:17,875 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBC driver com.microsoft.jdbc.sqlserver.SQLServerDriver not found in ClassPath
20 Jul 2007 11:25:17,985 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBj bootstrap spec map initialized.
20 Jul 2007 11:25:17,985 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBj bootstrap data source initialized: System Local.
20 Jul 2007 11:25:17,985 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBj serialized access override found in config file.
20 Jul 2007 11:25:17,985 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] JDBj bootstrap spec physical connection properties initialized: (JDE,*********).
20 Jul 2007 11:25:18,016 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property Transaction Timeout default value 120000.
20 Jul 2007 11:25:18,016 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Transaction 1 state initialized to auto commit.
20 Jul 2007 11:25:18,031 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property Service Cache Purge default value 600000.
20 Jul 2007 11:25:18,047 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property OCM Cache Purge default value 600000.
20 Jul 2007 11:25:18,047 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property Security Cache Purge default value 600000.
20 Jul 2007 11:25:18,047 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [JDBJ] Using runtime property Spec Cache Purge default value 600000.
20 Jul 2007 11:25:18,078 [Line ?] [main] [DEBUG ] - [JDBJ] JDBj lookup service database access #1.
20 Jul 2007 11:25:18,078 [Line ?] [main] [DEBUG ] - [JDBJ] Resolved database object F986101 to data source System Local.
20 Jul 2007 11:25:18,078 [Line ?] [main] [DEBUG ] - [JDBJ] Using runtime property Force Single Data Source default value false.
20 Jul 2007 11:25:18,094 [Line ?] [main] [DEBUG ] - [JDBJ] Using runtime property Transaction Isolation default value default.
20 Jul 2007 11:25:18,094 [Line ?] [main] [DEBUG ] - [JDBJ] No available connection in pool - Creating new connection for poolKey jdbc:microsoft:sqlserver://localhost\JDELocal_JDESY812_true_JDE
20 Jul 2007 11:25:18,094 [Line ?] [main] [DEBUG ] - [JDBJ] dataSource.isUnicode() = [true]
20 Jul 2007 11:25:18,094 [Line ?] [main] [DEBUG ] - [JDBJ] sendStringParametersAsUnicode = [true]
20 Jul 2007 11:25:18,094 [Line ?] [main] [DEBUG ] - [JDBJ] Connecting to System Local with URL : jdbc:microsoft:sqlserver://localhost\JDELocal DBUser : JDE
20 Jul 2007 11:25:18,094 [Line ?] [main] [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local. java.sql.SQLException: No suitable driver
20 Jul 2007 11:25:18,094 [Line ?] [main] [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local.
So I suggest something wit my jdbj.ini or jdeinterop.ini is wrong.
Even other Expamples (running genjava /cmd addressbookcmd with the Example code from the Connector-pdf) don't work. There alwasy seem to be problems asscessing F9860 for reading Specs.
Does anybody got the examples with standlone to work? Any suggestions are welcome, best regards,
Carsten