I have a Foreign Key relationship between two tables in an Oracle v12.1.0.2.0 database. I used Visual Builder to export respective DataSource XML files. The FK reference is captured in the export (see EMPLOYEE_ID below).
DataSource #1
DataSource #2
When I attempt to load these DataSources, the console reports the following error:
Absent the includeFrom field, each DataSource is verified to be accessible, can populate a ListGrid, etc.
So Oracle knows about the Foreign Key; and Visual Builder acknowledges the Foreign Key during export of DataSource; yet it bombs when called onModuleLoad.
I've added attributes & values to the DataSource for autoDeriveSchema, schema, dbName, no joy.
I expect I can work around this by doing OperationBindings with explicit JOIN statements, but I was hoping to use includeFrom fields instead.
Please advise, thanks.
--------------------------------------------------
SmartClient Version: v9.1p_2016-02-24/PowerEdition Deployment (built 2016-02-24)
GWT 2.5.1
JDK 1.7
Using Classic Dev Mode & IE8
DataSource #1
Code:
<DataSource ID="RequestsFields" serverType="sql" dataSourceVersion="1" tableName="REQUESTS" tableCode="3298f13049d19cffaa37ca931dd4d421" allowAdvancedCriteria="true" generatedBy="v9.1p_2016-02-24/PowerEdition Deployment 2016-02-24">
<fields>
<field name="REQUEST_ID" type="float" primaryKey="true" columnCode="f68d2c3658a26018e43729b214bc84c9">
<validators>
<Validator>
<type>isFloat</type>
<stopIfFalse>true</stopIfFalse>
<typeCastValidator>true</typeCastValidator>
</Validator>
</validators>
</field>
<field name="EMPLOYEE_ID" type="float" columnCode="dcc97e32ee2155cd3544413ac8b6f685">
<validators>
<Validator>
<type>isFloat</type>
<stopIfFalse>true</stopIfFalse>
<typeCastValidator>true</typeCastValidator>
</Validator>
</validators>
<fkColumnCode>dcc97e32ee2155cd3544413ac8b6f685</fkColumnCode>
<fkTableCode>fa5473530e4d1a5a1e1eb53d2fedb10c</fkTableCode>
</field>
<!-- ... -->
</field>
<field includeFrom="EmployeeFields.NAME"/>
</fields>
</DataSource>
Code:
<DataSource ID="EmployeeFields" serverType="sql" dataSourceVersion="1" tableName="EMPLOYEE" tableCode="fa5473530e4d1a5a1e1eb53d2fedb10c" autoDeriveSchema="false" allowAdvancedCriteria="true" generatedBy="v9.1p_2016-02-24/PowerEdition Deployment 2016-02-24">
<fields>
<field name="EMPLOYEE_ID" type="float" primaryKey="true" columnCode="dcc97e32ee2155cd3544413ac8b6f685">
<validators>
<Validator>
<type>isFloat</type>
<stopIfFalse>true</stopIfFalse>
<typeCastValidator>true</typeCastValidator>
</Validator>
</validators>
</field>
<!-- ... -->
<field name="NAME" type="text" length="100" columnCode="b068931cc450442b63f5b3d276ea4297">
<validators>
<Validator>
<type>isString</type>
<stopIfFalse>true</stopIfFalse>
<typeCastValidator>true</typeCastValidator>
<defaultErrorMessage></defaultErrorMessage>
</Validator>
</validators>
</field>
<!-- ... -->
</fields>
</DataSource>
Code:
ISC: Configuring log4j from: file:/C:/EclipseProjects/MyWorkspace/MyApp/war/WEB-INF/classes/log4j.isc.config.xml
=== 2016-02-29 10:08:10,073 [main] INFO ISCInit - Isomorphic SmartClient/SmartGWT Framework - Initializing
=== 2016-02-29 10:08:10,078 [main] INFO ConfigLoader - Attempting to load framework.properties from CLASSPATH
=== 2016-02-29 10:08:10,163 [main] INFO ConfigLoader - Successfully loaded framework.properties from CLASSPATH at location: jar:file:/C:/EclipseProjects/MyWorkspace/MyApp/war/WEB-INF/lib/isomorphic_core_rpc.jar!/framework.properties
=== 2016-02-29 10:08:10,163 [main] INFO ConfigLoader - Attempting to load project.properties from CLASSPATH
=== 2016-02-29 10:08:10,164 [main] INFO ConfigLoader - Unable to locate project.properties in CLASSPATH
=== 2016-02-29 10:08:10,168 [main] INFO ConfigLoader - Successfully loaded isc_interfaces.properties from CLASSPATH at location: jar:file:/C:/EclipseProjects/MyWorkspace/MyApp/war/WEB-INF/lib/isomorphic_core_rpc.jar!/isc_interfaces.properties
=== 2016-02-29 10:08:10,168 [main] INFO ConfigLoader - Attempting to load server.properties from CLASSPATH
=== 2016-02-29 10:08:10,171 [main] INFO ConfigLoader - Successfully loaded server.properties from CLASSPATH at location: file:/C:/EclipseProjects/MyWorkspace/MyApp/war/WEB-INF/classes/server.properties
=== 2016-02-29 10:08:10,178 [main] INFO Logger - Logging system started.
=== 2016-02-29 10:08:10,181 [main] INFO ISCInit - Auto-detected webRoot - using: C:\EclipseProjects\MyWorkspace\MyApp\war
=== 2016-02-29 10:08:10,182 [main] INFO ISCInit - Isomorphic SmartClient/SmartGWT Framework (v9.1p_2016-02-24/PowerEdition Deployment 2016-02-24) - Initialization Complete
log4j:WARN No appenders could be found for logger (org.apache.jasper.compiler.JspRuntimeContext).
log4j:WARN Please initialize the log4j system properly.
=== 2016-02-29 10:08:18,468 [l0-0] INFO RequestContext - URL: '/tabbedscreenClassic.html', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,478 [l0-0] INFO Compression - /tabbedscreenClassic.html: 1678 -> 674 bytes
=== 2016-02-29 10:08:18,478 [l0-0] DEBUG ServletTools - setting cookie 'isc_cState' to: 'ready'
=== 2016-02-29 10:08:18,511 [l0-0] INFO RequestContext - URL: '/TabbedScreen/TabbedScreen.nocache.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,511 [l0-2] INFO RequestContext - URL: '/load_skin.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,513 [l0-0] INFO Compression - /TabbedScreen/TabbedScreen.nocache.js: 7077 -> 2618 bytes
=== 2016-02-29 10:08:18,514 [l0-2] INFO Compression - /load_skin.js: 31259 -> 6485 bytes
=== 2016-02-29 10:08:18,529 [l0-2] INFO RequestContext - URL: '/TabbedScreen/clear.cache.gif', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,530 [l0-0] INFO RequestContext - URL: '/TabbedScreen/sc/initsc.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,531 [l0-4] INFO RequestContext - URL: '/TabbedScreen/sc/modules/ISC_Foundation.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,532 [l0-3] INFO RequestContext - URL: '/TabbedScreen/sc/modules/ISC_Core.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,533 [l0-6] INFO RequestContext - URL: '/TabbedScreen/sc/modules/ISC_Containers.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,534 [l0-0] INFO Compression - /TabbedScreen/sc/initsc.js: 47 -> 72 bytes
=== 2016-02-29 10:08:18,535 [l0-5] INFO RequestContext - URL: '/TabbedScreen/sc/modules/ISC_Grids.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,535 [l0-2] INFO RequestContext - URL: '/TabbedScreen/sc/modules/ISC_RichTextEditor.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,539 [l0-0] INFO RequestContext - URL: '/TabbedScreen/sc/modules/ISC_Forms.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,545 [l0-4] INFO Compression - /TabbedScreen/sc/modules/ISC_Foundation.js: 284863 -> 67096 bytes
=== 2016-02-29 10:08:18,547 [l0-6] INFO Compression - /TabbedScreen/sc/modules/ISC_Containers.js: 150239 -> 35568 bytes
=== 2016-02-29 10:08:18,557 [l0-2] INFO Compression - /TabbedScreen/sc/modules/ISC_RichTextEditor.js: 62085 -> 16725 bytes
=== 2016-02-29 10:08:18,560 [l0-4] INFO RequestContext - URL: '/TabbedScreen/sc/modules/ISC_DataBinding.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,561 [l0-2] INFO RequestContext - URL: '/TabbedScreen/sc/skins/Enterprise/load_skin.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,566 [l0-2] INFO Compression - /TabbedScreen/sc/skins/Enterprise/load_skin.js: 66373 -> 10793 bytes
=== 2016-02-29 10:08:18,590 [l0-3] INFO Compression - /TabbedScreen/sc/modules/ISC_Core.js: 938795 -> 245845 bytes
=== 2016-02-29 10:08:18,593 [l0-6] INFO RequestContext - URL: '/TabbedScreen/sc/modules/ISC_Calendar.js', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:18,597 [l0-4] INFO Compression - /TabbedScreen/sc/modules/ISC_DataBinding.js: 746267 -> 184202 bytes
=== 2016-02-29 10:08:18,603 [l0-0] INFO Compression - /TabbedScreen/sc/modules/ISC_Forms.js: 815502 -> 197059 bytes
=== 2016-02-29 10:08:18,605 [l0-6] INFO Compression - /TabbedScreen/sc/modules/ISC_Calendar.js: 171791 -> 43998 bytes
=== 2016-02-29 10:08:18,616 [l0-5] INFO Compression - /TabbedScreen/sc/modules/ISC_Grids.js: 989118 -> 250858 bytes
=== 2016-02-29 10:08:19,055 [l0-5] INFO RequestContext - URL: '/MyApp/sc/skins/Enterprise/skin_styles.css', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:19,072 [l0-5] INFO Download - done streaming: C:/EclipseProjects/MyWorkspace/MyApp/war/MyApp/sc/skins/Enterprise/skin_styles.css
=== 2016-02-29 10:08:19,076 [l0-5] INFO Compression - /MyApp/sc/skins/Enterprise/skin_styles.css: 238006 -> 20941 bytes
=== 2016-02-29 10:08:19,189 [l0-5] INFO RequestContext - URL: '/skins/BrushedMetal/skin_styles.css', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:19,193 [l0-5] INFO Compression - /skins/BrushedMetal/skin_styles.css: 73007 -> 9574 bytes
=== 2016-02-29 10:08:19,258 [l0-5] INFO RequestContext - URL: '/TabbedScreen/hosted.html', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:19,259 [l0-5] INFO Compression - /TabbedScreen/hosted.html: 11781 -> 4171 bytes
=== 2016-02-29 10:08:26,421 [l0-5] INFO RequestContext - URL: '/MyApp/sc/DataSourceLoader', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; InfoPath.3; .NET4.0C; .NET4.0E)': MSIE with Accept-Encoding header, ready for compressed JS
=== 2016-02-29 10:08:26,459 [l0-5] DEBUG XML - Parsed XML from C:\EclipseProjects\MyWorkspace\MyApp\war\MyApp\sc\system\schema\builtinTypes.xml: 6ms
=== 2016-02-29 10:08:26,475 [l0-5] INFO PoolManager - SmartClient pooling started for 'simpleTypes' objects
=== 2016-02-29 10:08:26,475 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'simpleTypes'
=== 2016-02-29 10:08:26,483 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2016-02-29 10:08:26,490 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'any'
=== 2016-02-29 10:08:26,492 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'boolean'
=== 2016-02-29 10:08:26,492 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'integer'
=== 2016-02-29 10:08:26,493 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'float'
=== 2016-02-29 10:08:26,493 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'date'
=== 2016-02-29 10:08:26,494 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'time'
=== 2016-02-29 10:08:26,494 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'text'
=== 2016-02-29 10:08:26,495 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'string'
=== 2016-02-29 10:08:26,495 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'link'
=== 2016-02-29 10:08:26,496 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'int'
=== 2016-02-29 10:08:26,496 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'long'
=== 2016-02-29 10:08:26,497 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'number'
=== 2016-02-29 10:08:26,497 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'decimal'
=== 2016-02-29 10:08:26,498 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'double'
=== 2016-02-29 10:08:26,498 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'dateTime'
=== 2016-02-29 10:08:26,499 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'datetime'
=== 2016-02-29 10:08:26,499 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'validators'
=== 2016-02-29 10:08:26,499 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'positiveInteger'
=== 2016-02-29 10:08:26,500 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'integerPercent'
=== 2016-02-29 10:08:26,501 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'percent'
=== 2016-02-29 10:08:26,501 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'sequence'
=== 2016-02-29 10:08:26,502 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'enum'
=== 2016-02-29 10:08:26,502 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'intEnum'
=== 2016-02-29 10:08:26,503 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'char'
=== 2016-02-29 10:08:26,503 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'ntext'
=== 2016-02-29 10:08:26,504 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'password'
=== 2016-02-29 10:08:26,504 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'localeInt'
=== 2016-02-29 10:08:26,505 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'localeFloat'
=== 2016-02-29 10:08:26,505 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'localeCurrency'
=== 2016-02-29 10:08:26,506 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'phoneNumber'
=== 2016-02-29 10:08:26,506 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'regexp'
=== 2016-02-29 10:08:26,507 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'identifier'
=== 2016-02-29 10:08:26,507 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'URL'
=== 2016-02-29 10:08:26,507 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'url'
=== 2016-02-29 10:08:26,508 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'XPath'
=== 2016-02-29 10:08:26,508 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'HTMLString'
=== 2016-02-29 10:08:26,509 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'HTML'
=== 2016-02-29 10:08:26,509 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'html'
=== 2016-02-29 10:08:26,510 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'measure'
=== 2016-02-29 10:08:26,510 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'integerOrAuto'
=== 2016-02-29 10:08:26,511 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'integerOrIdentifier'
=== 2016-02-29 10:08:26,511 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'handler'
=== 2016-02-29 10:08:26,511 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'callback'
=== 2016-02-29 10:08:26,512 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'action'
=== 2016-02-29 10:08:26,512 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'setter'
=== 2016-02-29 10:08:26,513 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'getter'
=== 2016-02-29 10:08:26,513 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'tester'
=== 2016-02-29 10:08:26,513 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'method'
=== 2016-02-29 10:08:26,514 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'function'
=== 2016-02-29 10:08:26,514 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'expression'
=== 2016-02-29 10:08:26,515 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'className'
=== 2016-02-29 10:08:26,515 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'valueMap'
=== 2016-02-29 10:08:26,515 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'valignEnum'
=== 2016-02-29 10:08:26,516 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'alignEnum'
=== 2016-02-29 10:08:26,517 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'sideEnum'
=== 2016-02-29 10:08:26,518 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'color'
=== 2016-02-29 10:08:26,518 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'cssClass'
=== 2016-02-29 10:08:26,519 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'modifier'
=== 2016-02-29 10:08:26,519 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'modifierTimestamp'
=== 2016-02-29 10:08:26,519 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'creator'
=== 2016-02-29 10:08:26,520 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'creatorTimestamp'
=== 2016-02-29 10:08:26,520 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'binary'
=== 2016-02-29 10:08:26,521 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'imageFile'
=== 2016-02-29 10:08:26,521 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'blob'
=== 2016-02-29 10:08:26,521 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'clob'
=== 2016-02-29 10:08:26,522 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'image'
=== 2016-02-29 10:08:26,540 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'EmployeeFields'
=== 2016-02-29 10:08:26,544 [l0-5] DEBUG XML - Parsed XML from C:\EclipseProjects\MyWorkspace\MyApp\war\ds\EmployeeFields.ds.xml: 4ms
=== 2016-02-29 10:08:26,544 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'DataSource'
=== 2016-02-29 10:08:26,549 [l0-5] DEBUG XML - Parsed XML from C:\EclipseProjects\MyWorkspace\MyApp\war\MyApp\sc\system\schema\DataSource.ds.xml: 5ms
=== 2016-02-29 10:08:26,549 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2016-02-29 10:08:26,549 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'fields'
=== 2016-02-29 10:08:26,550 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'ID'
=== 2016-02-29 10:08:26,550 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'inheritsFrom'
=== 2016-02-29 10:08:26,551 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'useParentFieldOrder'
=== 2016-02-29 10:08:26,551 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'useLocalFieldsOnly'
=== 2016-02-29 10:08:26,551 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'restrictToParentFields'
=== 2016-02-29 10:08:26,552 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'valueMap'
=== 2016-02-29 10:08:26,552 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'dataFormat'
=== 2016-02-29 10:08:26,553 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'useStrictJSON'
=== 2016-02-29 10:08:26,553 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'noAutoFetch'
=== 2016-02-29 10:08:26,554 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'serverType'
=== 2016-02-29 10:08:26,554 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'callbackParam'
=== 2016-02-29 10:08:26,555 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'requestProperties'
=== 2016-02-29 10:08:26,555 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'addGlobalId'
=== 2016-02-29 10:08:26,556 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'showPrompt'
=== 2016-02-29 10:08:26,556 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'dataSourceVersion'
=== 2016-02-29 10:08:26,557 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'dbName'
=== 2016-02-29 10:08:26,557 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'schema'
=== 2016-02-29 10:08:26,557 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'tableName'
=== 2016-02-29 10:08:26,558 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'quoteTableName'
=== 2016-02-29 10:08:26,558 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'tableCode'
=== 2016-02-29 10:08:26,559 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'serverObject'
=== 2016-02-29 10:08:26,559 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'operationBindings'
=== 2016-02-29 10:08:26,559 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'field'
=== 2016-02-29 10:08:26,560 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'operationBinding'
=== 2016-02-29 10:08:26,560 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'serviceNamespace'
=== 2016-02-29 10:08:26,561 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'dataURL'
=== 2016-02-29 10:08:26,561 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'dataProtocol'
=== 2016-02-29 10:08:26,561 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'dataTransport'
=== 2016-02-29 10:08:26,562 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'defaultParams'
=== 2016-02-29 10:08:26,562 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'soapAction'
=== 2016-02-29 10:08:26,563 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'jsonPrefix'
=== 2016-02-29 10:08:26,563 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'jsonSuffix'
=== 2016-02-29 10:08:26,563 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'messageTemplate'
=== 2016-02-29 10:08:26,564 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'defaultCriteria'
=== 2016-02-29 10:08:26,564 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'tagName'
=== 2016-02-29 10:08:26,564 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'recordXPath'
=== 2016-02-29 10:08:26,565 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'recordName'
=== 2016-02-29 10:08:26,565 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'xmlNamespaces'
=== 2016-02-29 10:08:26,566 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'dropExtraFields'
=== 2016-02-29 10:08:26,566 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'schemaNamespace'
=== 2016-02-29 10:08:26,566 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'mustQualify'
=== 2016-02-29 10:08:26,567 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'xsdSimpleContent'
=== 2016-02-29 10:08:26,567 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'xsdAnyElement'
=== 2016-02-29 10:08:26,568 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'xsdAbstract'
=== 2016-02-29 10:08:26,568 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'title'
=== 2016-02-29 10:08:26,568 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'titleField'
=== 2016-02-29 10:08:26,569 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'pluralTitle'
=== 2016-02-29 10:08:26,569 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'clientOnly'
=== 2016-02-29 10:08:26,570 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'testFileName'
=== 2016-02-29 10:08:26,570 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'testData'
=== 2016-02-29 10:08:26,570 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'cacheData'
=== 2016-02-29 10:08:26,571 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'cacheAllData'
=== 2016-02-29 10:08:26,571 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'cacheAcrossOperationIds'
=== 2016-02-29 10:08:26,571 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'types'
=== 2016-02-29 10:08:26,572 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'groups'
=== 2016-02-29 10:08:26,572 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'methods'
=== 2016-02-29 10:08:26,573 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'showSuperClassActions'
=== 2016-02-29 10:08:26,573 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'createStandalone'
=== 2016-02-29 10:08:26,573 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'useFlatFields'
=== 2016-02-29 10:08:26,574 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'showLocalFieldsOnly'
=== 2016-02-29 10:08:26,574 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'globalNamespaces'
=== 2016-02-29 10:08:26,575 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'autoDeriveSchema'
=== 2016-02-29 10:08:26,575 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'autoDeriveFKs'
=== 2016-02-29 10:08:26,575 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'useLocalValidators'
=== 2016-02-29 10:08:26,576 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'autoDeriveTitles'
=== 2016-02-29 10:08:26,576 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'qualifyColumnNames'
=== 2016-02-29 10:08:26,577 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'validateRelatedRecords'
=== 2016-02-29 10:08:26,577 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'requiresAuthentication'
=== 2016-02-29 10:08:26,577 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'requiresRoles'
=== 2016-02-29 10:08:26,578 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'requires'
=== 2016-02-29 10:08:26,578 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'beanClassName'
=== 2016-02-29 10:08:26,578 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'autoJoinTransactions'
=== 2016-02-29 10:08:26,579 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'sparseUpdates'
=== 2016-02-29 10:08:26,579 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'noNullUpdates'
=== 2016-02-29 10:08:26,580 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'canExport'
=== 2016-02-29 10:08:26,580 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'progressiveLoading'
=== 2016-02-29 10:08:26,580 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'autoConvertRelativeDates'
=== 2016-02-29 10:08:26,581 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'allowAdvancedCriteria'
=== 2016-02-29 10:08:26,581 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'scriptImport'
=== 2016-02-29 10:08:26,581 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'script'
=== 2016-02-29 10:08:26,582 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'allowClientRequestedSummaries'
=== 2016-02-29 10:08:26,582 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'translatePatternOperators'
=== 2016-02-29 10:08:26,582 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'generatedBy'
=== 2016-02-29 10:08:26,605 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'DataSourceField'
=== 2016-02-29 10:08:26,609 [l0-5] DEBUG XML - Parsed XML from C:\EclipseProjects\MyWorkspace\MyApp\war\MyApp\sc\system\schema\DataSourceField.ds.xml: 3ms
=== 2016-02-29 10:08:26,610 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2016-02-29 10:08:26,610 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'fields'
=== 2016-02-29 10:08:26,610 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'name'
=== 2016-02-29 10:08:26,611 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'type'
=== 2016-02-29 10:08:26,612 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'disabled'
=== 2016-02-29 10:08:26,612 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'idAllowed'
=== 2016-02-29 10:08:26,612 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'required'
=== 2016-02-29 10:08:26,613 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'valueMap'
=== 2016-02-29 10:08:26,613 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'validators'
=== 2016-02-29 10:08:26,614 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'length'
=== 2016-02-29 10:08:26,614 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'decimalPad'
=== 2016-02-29 10:08:26,614 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'decimalPrecision'
=== 2016-02-29 10:08:26,615 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'xmlRequired'
=== 2016-02-29 10:08:26,615 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'xmlMaxOccurs'
=== 2016-02-29 10:08:26,616 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'xmlMinOccurs'
=== 2016-02-29 10:08:26,616 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'xmlNonEmpty'
=== 2016-02-29 10:08:26,617 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'xsElementRef'
=== 2016-02-29 10:08:26,617 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'canHide'
=== 2016-02-29 10:08:26,618 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'xmlAttribute'
=== 2016-02-29 10:08:26,618 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'mustQualify'
=== 2016-02-29 10:08:26,619 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'valueXPath'
=== 2016-02-29 10:08:26,619 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'childrenProperty'
=== 2016-02-29 10:08:26,620 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'title'
=== 2016-02-29 10:08:26,621 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'prompt'
=== 2016-02-29 10:08:26,621 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'detail'
=== 2016-02-29 10:08:26,622 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'canEdit'
=== 2016-02-29 10:08:26,622 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'canSave'
=== 2016-02-29 10:08:26,623 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'canView'
=== 2016-02-29 10:08:26,623 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'inapplicable'
=== 2016-02-29 10:08:26,624 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'advanced'
=== 2016-02-29 10:08:26,624 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'visibility'
=== 2016-02-29 10:08:26,624 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'hidden'
=== 2016-02-29 10:08:26,625 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'primaryKey'
=== 2016-02-29 10:08:26,625 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'foreignKey'
=== 2016-02-29 10:08:26,626 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'rootValue'
=== 2016-02-29 10:08:26,626 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'includeFrom'
=== 2016-02-29 10:08:26,626 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'includeVia'
=== 2016-02-29 10:08:26,627 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'relatedTableAlias'
=== 2016-02-29 10:08:26,627 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'showFileInline'
=== 2016-02-29 10:08:26,628 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'escapeHTML'
=== 2016-02-29 10:08:26,628 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'imageWidth'
=== 2016-02-29 10:08:26,628 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'imageHeight'
=== 2016-02-29 10:08:26,629 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'nativeName'
=== 2016-02-29 10:08:26,629 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'nativeFK'
=== 2016-02-29 10:08:26,630 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'autoDeriveFKs'
=== 2016-02-29 10:08:26,630 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'fieldName'
=== 2016-02-29 10:08:26,631 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'multiple'
=== 2016-02-29 10:08:26,631 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'validateEachItem'
=== 2016-02-29 10:08:26,631 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'pickListFields'
=== 2016-02-29 10:08:26,632 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'canFilter'
=== 2016-02-29 10:08:26,632 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'ignore'
=== 2016-02-29 10:08:26,632 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'unknownType'
=== 2016-02-29 10:08:26,633 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'canSortClientOnly'
=== 2016-02-29 10:08:26,633 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'childTagName'
=== 2016-02-29 10:08:26,634 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'basic'
=== 2016-02-29 10:08:26,634 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'maxFileSize'
=== 2016-02-29 10:08:26,634 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'frozen'
=== 2016-02-29 10:08:26,635 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'canExport'
=== 2016-02-29 10:08:26,635 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'sqlStorageStrategy'
=== 2016-02-29 10:08:26,636 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'encodeInResponse'
=== 2016-02-29 10:08:26,636 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'mimeType'
=== 2016-02-29 10:08:26,636 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'ignoreTextMatchStyle'
=== 2016-02-29 10:08:26,637 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'lenientXPath'
=== 2016-02-29 10:08:26,637 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'summaryFunction'
=== 2016-02-29 10:08:26,638 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'joinString'
=== 2016-02-29 10:08:26,638 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'joinPrefix'
=== 2016-02-29 10:08:26,638 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'joinSuffix'
=== 2016-02-29 10:08:26,639 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'allowClientRequestedSummaries'
=== 2016-02-29 10:08:26,639 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'columnCode'
=== 2016-02-29 10:08:26,642 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'field'
=== 2016-02-29 10:08:26,642 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'Validator'
=== 2016-02-29 10:08:26,645 [l0-5] DEBUG XML - Parsed XML from C:\EclipseProjects\MyWorkspace\MyApp\war\MyApp\sc\system\schema\Validator.ds.xml: 2ms
=== 2016-02-29 10:08:26,645 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2016-02-29 10:08:26,646 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'fields'
=== 2016-02-29 10:08:26,646 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'type'
=== 2016-02-29 10:08:26,647 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'name'
=== 2016-02-29 10:08:26,647 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'description'
=== 2016-02-29 10:08:26,648 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'stopIfFalse'
=== 2016-02-29 10:08:26,648 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'stopOnError'
=== 2016-02-29 10:08:26,648 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'validateOnChange'
=== 2016-02-29 10:08:26,649 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'clientOnly'
=== 2016-02-29 10:08:26,649 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'errorMessage'
=== 2016-02-29 10:08:26,649 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'max'
=== 2016-02-29 10:08:26,650 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'min'
=== 2016-02-29 10:08:26,650 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'exclusive'
=== 2016-02-29 10:08:26,651 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'mask'
=== 2016-02-29 10:08:26,651 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'transformTo'
=== 2016-02-29 10:08:26,651 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'precision'
=== 2016-02-29 10:08:26,652 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'otherField'
=== 2016-02-29 10:08:26,652 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'list'
=== 2016-02-29 10:08:26,653 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'valueMap'
=== 2016-02-29 10:08:26,653 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'substring'
=== 2016-02-29 10:08:26,653 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'operator'
=== 2016-02-29 10:08:26,654 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'count'
=== 2016-02-29 10:08:26,654 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'applyWhen'
=== 2016-02-29 10:08:26,655 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'dependentFields'
=== 2016-02-29 10:08:26,655 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'scriptImport'
=== 2016-02-29 10:08:26,655 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'serverCondition'
=== 2016-02-29 10:08:26,656 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'serverObject'
=== 2016-02-29 10:08:26,656 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'fieldName'
=== 2016-02-29 10:08:26,656 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'triggerEvent'
=== 2016-02-29 10:08:26,657 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'message'
=== 2016-02-29 10:08:26,657 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'severity'
=== 2016-02-29 10:08:26,658 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'displayMode'
=== 2016-02-29 10:08:26,658 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'duration'
=== 2016-02-29 10:08:26,658 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'formula'
=== 2016-02-29 10:08:26,659 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'formulaVars'
=== 2016-02-29 10:08:26,700 [l0-5] DEBUG DataSourceLoader - For DataSource 'EmployeeFields', got instanceId 8
=== 2016-02-29 10:08:26,715 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'RequestsFields'
=== 2016-02-29 10:08:26,721 [l0-5] DEBUG XML - Parsed XML from C:\EclipseProjects\MyWorkspace\MyApp\war\ds\RequestsFields.ds.xml: 5ms
=== 2016-02-29 10:08:26,721 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'DataSource'
=== 2016-02-29 10:08:26,723 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'DataSourceField'
=== 2016-02-29 10:08:26,725 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'field'
=== 2016-02-29 10:08:26,726 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'Validator'
=== 2016-02-29 10:08:26,738 [l0-5] DEBUG ISCKeyedObjectPool - Borrowing object for 'EmployeeFields'
=== 2016-02-29 10:08:26,739 [l0-5] WARN DataSource - DataSource RequestsFields includes fields from DataSource EmployeeFields but we cannot establish a direct or indirect relation between those DataSources. You must specify foreignKey field(s) on the including DataSource (RequestsFields) that either express a direct relationship to EmployeeFields, or express an indrect relationship via one or more intervening tables
=== 2016-02-29 10:08:26,740 [l0-5] WARN SQLDataSource - NOTE: This failure to find a relation happened despite an attempt to use native FKs derived from the schema metadata.No valid native FK fields were found.
=== 2016-02-29 10:08:26,740 [l0-5] ERROR DataSourceLoader - Exception while attempting to load a DataSource
com.isomorphic.datasource.ForeignKeyNotFoundException: DataSource RequestsFields includes fields from DataSource EmployeeFields but we cannot establish a direct or indirect relation between those DataSources. You must specify foreignKey field(s) on the including DataSource (RequestsFields) that either express a direct relationship to EmployeeFields, or express an indrect relationship via one or more intervening tables
at com.isomorphic.datasource.DataSource.getRelation(DataSource.java:4155)
at com.isomorphic.sql.SQLDataSource.getRelation(SQLDataSource.java:4223)
at com.isomorphic.datasource.DataSource.getRelation(DataSource.java:4063)
at com.isomorphic.datasource.DataSource.getIncludeFromInfo(DataSource.java:4639)
at com.isomorphic.datasource.BasicDataSource.init(BasicDataSource.java:522)
at com.isomorphic.sql.SQLDataSource.init(SQLDataSource.java:280)
at com.isomorphic.datasource.DataSource.initialize(DataSource.java:528)
at com.isomorphic.datasource.BasicDataSource.fromConfig(BasicDataSource.java:177)
at com.isomorphic.datasource.DataSource.fromConfig(DataSource.java:513)
at com.isomorphic.datasource.FileSystemDSRepo.loadDS(FileSystemDSRepo.java:110)
at com.isomorphic.datasource.DataSource.forName(DataSource.java:272)
at com.isomorphic.datasource.DataSource.forName(DataSource.java:264)
at com.isomorphic.datasource.DataSource.forName(DataSource.java:253)
at com.isomorphic.datasource.PoolableDataSourceFactory.makeUnpooledObject(PoolableDataSourceFactory.java:135)
at com.isomorphic.datasource.PoolableDataSourceFactory.makeObject(PoolableDataSourceFactory.java:151)
at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:964)
at com.isomorphic.pool.ISCKeyedObjectPool.borrowObject(ISCKeyedObjectPool.java:106)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:84)
at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:135)
at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:86)
at com.isomorphic.servlet.DataSourceLoader.processRequest(DataSourceLoader.java:157)
at com.isomorphic.servlet.DataSourceLoader.doGet(DataSourceLoader.java:100)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:260)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:829)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:513)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
=== 2016-02-29 10:08:26,741 [l0-5] ERROR DataSourceLoader - Top-level servlet error:
javax.servlet.ServletException: DataSource 'RequestsFields' failed to load due to an exception on the server:
DataSource RequestsFields includes fields from DataSource EmployeeFields but we cannot establish a direct or indirect relation between those DataSources. You must specify foreignKey field(s) on the including DataSource (RequestsFields) that either express a direct relationship to EmployeeFields, or express an indrect relationship via one or more intervening tables
See the server-side log for additional details.
at com.isomorphic.servlet.DataSourceLoader.processRequest(DataSourceLoader.java:249)
at com.isomorphic.servlet.DataSourceLoader.doGet(DataSourceLoader.java:100)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:260)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:829)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:513)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
=== 2016-02-29 10:08:26,743 [l0-5] INFO Compression - /MyApp/sc/DataSourceLoader: 7509 -> 1703 bytes
So Oracle knows about the Foreign Key; and Visual Builder acknowledges the Foreign Key during export of DataSource; yet it bombs when called onModuleLoad.
I've added attributes & values to the DataSource for autoDeriveSchema, schema, dbName, no joy.
I expect I can work around this by doing OperationBindings with explicit JOIN statements, but I was hoping to use includeFrom fields instead.
Please advise, thanks.
--------------------------------------------------
SmartClient Version: v9.1p_2016-02-24/PowerEdition Deployment (built 2016-02-24)
GWT 2.5.1
JDK 1.7
Using Classic Dev Mode & IE8
Comment