Hello,

I am attempting to set up a simple subscriber-only driver to an MS SQL
2005 database. I have done an nearly identical configuration with Oracle
without any issue, but for some reason with MS SQL it is complaining
that the Primary Key value is missing form the event, although the table
primary key is part of the event. The database is set up for indirect
synchronization, using one primary table of single-valued attributes and
a few two column tables for multi-value attributes. The primary key is
not auto-generated but is supplied from the identity vault, an attribute
called "udcid".

See Level 5 trace below. I have already tried several variations in the
schema mapping policy to schema qualify or not schema qualify the mapped
class name, or to table-name qualify or not qualify the column name.

Why does it not see the value of udc_id in the event as providing the
required primary key value for dbo.people?

[06/12/12 13:40:06.192]:SQL 2005 idm_people ST:Start transaction.
[06/12/12 13:40:06.192]:SQL 2005 idm_people
ST:type(resync-entry)entry-id(35530)
dn(\T=PORTAL-PROD\dc=edu\dc=drew\OU=People\CN=elarsson) class-id(-1)
class-name(null)
[06/12/12 13:40:06.193]:SQL 2005 idm_people ST:Processing events for
transaction.
[06/12/12 13:40:06.194]:SQL 2005 idm_people ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.14.5471">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<sync cached-time="20120612174006.097Z" class-name="User"
event-id="Wayne#20120612174006#1#1"
qualified-src-dn="dc=edu\dc=drew\OU=People\CN=elarsson"
src-dn="\PORTAL-PROD\edu\drew\People\elarsson" src-entry-id="35530"
timestamp="0#0">
<association state="migrate"></association>
</sync>
</input>
</nds>
[06/12/12 13:40:06.195]:SQL 2005 idm_people ST:Applying event
transformation policies.
[06/12/12 13:40:06.195]:SQL 2005 idm_people ST:Applying policy:
%+C%14CSub Event Transform%-C.
[06/12/12 13:40:06.195]:SQL 2005 idm_people ST: Applying to sync #1.
[06/12/12 13:40:06.195]:SQL 2005 idm_people ST: Evaluating selection
criteria for rule 'Scope Filtering'.
[06/12/12 13:40:06.195]:SQL 2005 idm_people ST: (if-class-name
equal "User") = TRUE.
[06/12/12 13:40:06.195]:SQL 2005 idm_people ST: (if-src-dn
not-in-container "edu\drew\People") = FALSE.
[06/12/12 13:40:06.195]:SQL 2005 idm_people ST: Rule rejected.
[06/12/12 13:40:06.196]:SQL 2005 idm_people ST:Policy returned:
[06/12/12 13:40:06.196]:SQL 2005 idm_people ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.14.5471">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<sync cached-time="20120612174006.097Z" class-name="User"
event-id="Wayne#20120612174006#1#1"
qualified-src-dn="dc=edu\dc=drew\OU=People\CN=elarsson"
src-dn="\PORTAL-PROD\edu\drew\People\elarsson" src-entry-id="35530"
timestamp="0#0">
<association state="migrate"></association>
</sync>
</input>
</nds>
[06/12/12 13:40:06.196]:SQL 2005 idm_people ST:Subscriber processing
sync for \PORTAL-PROD\edu\drew\People\elarsson.
[06/12/12 13:40:06.197]:SQL 2005 idm_people ST:Reading relevant
attributes from \PORTAL-PROD\edu\drew\People\elarsson.
[06/12/12 13:40:06.197]:SQL 2005 idm_people ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.14.5471">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User"
dest-dn="\PORTAL-PROD\edu\drew\People\elarsson" dest-entry-id="35530"
scope="entry">
<read-attr attr-name="CN"/>
<read-attr attr-name="drewInstructorAssignedSections"/>
<read-attr attr-name="drewPersonBannerID"/>
<read-attr attr-name="drewPersonBannerUser"/>
<read-attr attr-name="drewPersonBirthdate"/>
<read-attr attr-name="drewPersonDiningEndDate"/>
<read-attr attr-name="drewPersonDiningPlan"/>
<read-attr attr-name="drewPersonDiningStartDate"/>
<read-attr attr-name="drewPersonGender"/>
<read-attr attr-name="drewPersonHomeEmail"/>
<read-attr attr-name="drewPersonInstitutionRoles"/>
<read-attr attr-name="drewPersonJobDepartment"/>
<read-attr attr-name="drewPersonJobTitle"/>
<read-attr attr-name="drewPersonLibraryID"/>
<read-attr attr-name="drewResidenceBuilding"/>
<read-attr attr-name="drewResidenceCheckIn"/>
<read-attr attr-name="drewResidenceCheckOut"/>
<read-attr attr-name="drewResidenceRoom"/>
<read-attr attr-name="drewStudentRegisteredSections"/>
<read-attr attr-name="Full Name"/>
<read-attr attr-name="Generational Qualifier"/>
<read-attr attr-name="Given Name"/>
<read-attr attr-name="Initials"/>
<read-attr attr-name="Internet EMail Address"/>
<read-attr attr-name="mobile"/>
<read-attr attr-name="Password Expiration Time"/>
<read-attr attr-name="personalTitle"/>
<read-attr attr-name="preferredName"/>
<read-attr attr-name="pwmStatus"/>
<read-attr attr-name="SA"/>
<read-attr attr-name="Surname"/>
<read-attr attr-name="Telephone Number"/>
<read-attr attr-name="udcid"/>
<read-attr attr-name="uidNumber"/>
</query>
</input>
</nds>
[06/12/12 13:40:06.199]:SQL 2005 idm_people ST:Pumping XDS to
eDirectory.
[06/12/12 13:40:06.199]:SQL 2005 idm_people ST:Performing operation
query for \PORTAL-PROD\edu\drew\People\elarsson.
[06/12/12 13:40:06.201]:SQL 2005 idm_people ST:Read result:
[06/12/12 13:40:06.201]:SQL 2005 idm_people ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.14.5471">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<instance class-name="User"
qualified-src-dn="dc=edu\dc=drew\OU=People\CN=elarsson"
src-dn="\PORTAL-PROD\edu\drew\People\elarsson" src-entry-id="35530">
<association state="migrate"></association>
<attr attr-name="CN">
<value naming="true" timestamp="1305321699#105"
type="string">elarsson</value>
</attr>
<attr attr-name="drewPersonBannerID">
<value timestamp="1325607127#2"
type="string">000779204</value>
</attr>
<attr attr-name="drewPersonBannerUser">
<value timestamp="1331496815#10"
type="string">ELARSSON</value>
</attr>
<attr attr-name="drewPersonBirthdate">
<value timestamp="1331496815#14"
type="string">7-1-1980</value>
</attr>
<attr attr-name="drewPersonGender">
<value timestamp="1331496815#6" type="string">Male</value>
</attr>
<attr attr-name="drewPersonHomeEmail">
<value timestamp="1331496815#29"
type="string">windexcowboy@gmail.com</value>
</attr>
<attr attr-name="drewPersonInstitutionRoles">
<value timestamp="1331496815#16"
type="string">BANNERINB;INTCOMP;</value>
<value timestamp="1331496815#17"
type="string">EMPLOYEE;INTCOMP;</value>
<value timestamp="1331496815#18"
type="string">FINANCE;INTCOMP;</value>
<value timestamp="1331496815#19"
type="string">FORMER_STUDENT;INTCOMP;</value>
<value timestamp="1331496815#21"
type="string">STAFF_ADMIN;INTCOMP;</value>
<value timestamp="1335846988#1"
type="string">FINAID;INTCOMP;</value>
</attr>
<attr attr-name="drewPersonJobDepartment">
<value timestamp="1331496815#32" type="string">ETC</value>
</attr>
<attr attr-name="drewPersonJobTitle">
<value timestamp="1331496815#23" type="string">Dir and Systems
Architect, ETC</value>
</attr>
<attr attr-name="Full Name">
<value timestamp="1331496815#30" type="string">Mr Erik Axel
Larsson</value>
</attr>
<attr attr-name="Given Name">
<value timestamp="1331496815#15" type="string">Erik</value>
</attr>
<attr attr-name="Initials">
<value timestamp="1331496815#12" type="string">Axel</value>
</attr>
<attr attr-name="Internet EMail Address">
<value timestamp="1305321699#58"
type="string">elarsson@drew.edu</value>
</attr>
<attr attr-name="mobile">
<value timestamp="1331496815#39"
type="teleNumber">973-7271099</value>
</attr>
<attr attr-name="Password Expiration Time">
<value timestamp="1328567683#21"
type="time">1344119663</value>
</attr>
<attr attr-name="preferredName">
<value timestamp="1333322835#2" type="string">E. Axel</value>
</attr>
<attr attr-name="SA">
<value timestamp="1331496815#31"
type="string">PEPIN-ETC</value>
</attr>
<attr attr-name="Surname">
<value timestamp="1305321699#82" type="string">Larsson</value>
</attr>
<attr attr-name="Telephone Number">
<value timestamp="1331496815#8"
type="teleNumber">973-4083048</value>
</attr>
<attr attr-name="udcid">
<value timestamp="1305423987#7"
type="string">95633040870BB5EA6A9BE5AF4105FF8B</value>
</attr>
<attr attr-name="uidNumber">
<value timestamp="1305321699#84" type="int">1508</value>
</attr>
</instance>
<status level="success"></status>
</output>
</nds>
[06/12/12 13:40:06.205]:SQL 2005 idm_people ST:Synthetic add:
[06/12/12 13:40:06.205]:SQL 2005 idm_people ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.14.5471">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<add class-name="User" event-id="Wayne#20120612174006#1#1"
qualified-src-dn="dc=edu\dc=drew\OU=People\CN=elarsson"
src-dn="\PORTAL-PROD\edu\drew\People\elarsson" src-entry-id="35530">
<association state="migrate"></association>
<add-attr attr-name="CN">
<value naming="true" timestamp="1305321699#105"
type="string">elarsson</value>
</add-attr>
<add-attr attr-name="drewPersonBannerID">
<value timestamp="1325607127#2"
type="string">000779204</value>
</add-attr>
<add-attr attr-name="drewPersonBannerUser">
<value timestamp="1331496815#10"
type="string">ELARSSON</value>
</add-attr>
<add-attr attr-name="drewPersonBirthdate">
<value timestamp="1331496815#14"
type="string">7-1-1980</value>
</add-attr>
<add-attr attr-name="drewPersonGender">
<value timestamp="1331496815#6" type="string">Male</value>
</add-attr>
<add-attr attr-name="drewPersonHomeEmail">
<value timestamp="1331496815#29"
type="string">windexcowboy@gmail.com</value>
</add-attr>
<add-attr attr-name="drewPersonInstitutionRoles">
<value timestamp="1331496815#16"
type="string">BANNERINB;INTCOMP;</value>
<value timestamp="1331496815#17"
type="string">EMPLOYEE;INTCOMP;</value>
<value timestamp="1331496815#18"
type="string">FINANCE;INTCOMP;</value>
<value timestamp="1331496815#19"
type="string">FORMER_STUDENT;INTCOMP;</value>
<value timestamp="1331496815#21"
type="string">STAFF_ADMIN;INTCOMP;</value>
<value timestamp="1335846988#1"
type="string">FINAID;INTCOMP;</value>
</add-attr>
<add-attr attr-name="drewPersonJobDepartment">
<value timestamp="1331496815#32" type="string">ETC</value>
</add-attr>
<add-attr attr-name="drewPersonJobTitle">
<value timestamp="1331496815#23" type="string">Dir and Systems
Architect, ETC</value>
</add-attr>
<add-attr attr-name="Full Name">
<value timestamp="1331496815#30" type="string">Mr Erik Axel
Larsson</value>
</add-attr>
<add-attr attr-name="Given Name">
<value timestamp="1331496815#15" type="string">Erik</value>
</add-attr>
<add-attr attr-name="Initials">
<value timestamp="1331496815#12" type="string">Axel</value>
</add-attr>
<add-attr attr-name="Internet EMail Address">
<value timestamp="1305321699#58"
type="string">elarsson@drew.edu</value>
</add-attr>
<add-attr attr-name="mobile">
<value timestamp="1331496815#39"
type="teleNumber">973-7271099</value>
</add-attr>
<add-attr attr-name="Password Expiration Time">
<value timestamp="1328567683#21"
type="time">1344119663</value>
</add-attr>
<add-attr attr-name="preferredName">
<value timestamp="1333322835#2" type="string">E. Axel</value>
</add-attr>
<add-attr attr-name="SA">
<value timestamp="1331496815#31"
type="string">PEPIN-ETC</value>
</add-attr>
<add-attr attr-name="Surname">
<value timestamp="1305321699#82" type="string">Larsson</value>
</add-attr>
<add-attr attr-name="Telephone Number">
<value timestamp="1331496815#8"
type="teleNumber">973-4083048</value>
</add-attr>
<add-attr attr-name="udcid">
<value timestamp="1305423987#7"
type="string">95633040870BB5EA6A9BE5AF4105FF8B</value>
</add-attr>
<add-attr attr-name="uidNumber">
<value timestamp="1305321699#84" type="int">1508</value>
</add-attr>
</add>
<status level="success"></status>
</output>
</nds>
[06/12/12 13:40:06.210]:SQL 2005 idm_people ST:Applying object matching
policies.
[06/12/12 13:40:06.210]:SQL 2005 idm_people ST:Applying policy:
%+C%14CMatching Rule%-C.
[06/12/12 13:40:06.210]:SQL 2005 idm_people ST: Applying to add #1.
[06/12/12 13:40:06.210]:SQL 2005 idm_people ST: Evaluating selection
criteria for rule 'User: Match on udcid'.
[06/12/12 13:40:06.211]:SQL 2005 idm_people ST: (if-operation
equal "add") = TRUE.
[06/12/12 13:40:06.211]:SQL 2005 idm_people ST: (if-class-name
equal "User") = TRUE.
[06/12/12 13:40:06.211]:SQL 2005 idm_people ST: Rule selected.
[06/12/12 13:40:06.211]:SQL 2005 idm_people ST: Applying rule 'User:
Match on udcid'.
[06/12/12 13:40:06.211]:SQL 2005 idm_people ST: Action:
do-find-matching-object(scope="subtree",arg-match-attr("udcid")).
[06/12/12 13:40:06.211]:SQL 2005 idm_people ST:
arg-match-attr("udcid")
[06/12/12 13:40:06.211]:SQL 2005 idm_people ST: Query from
policy
[06/12/12 13:40:06.212]:SQL 2005 idm_people ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.14.5471">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="User" scope="subtree">
<search-class class-name="User"/>
<search-attr attr-name="udcid">
<value timestamp="1305423987#7"
type="string">95633040870BB5EA6A9BE5AF4105FF8B</value>
</search-attr>
<read-attr/>
</query>
</input>
</nds>
[06/12/12 13:40:06.212]:SQL 2005 idm_people ST: Fixing up
association references.
[06/12/12 13:40:06.212]:SQL 2005 idm_people ST: Applying schema
mapping policies to output.
[06/12/12 13:40:06.213]:SQL 2005 idm_people ST: Applying policy:
%+C%14CSchema+Mapping+Rule%-C.
[06/12/12 13:40:06.213]:SQL 2005 idm_people ST: Mapping
attr-name 'udcid' to 'udc_id'.
[06/12/12 13:40:06.213]:SQL 2005 idm_people ST: Mapping
class-name 'User' to 'dbo.people'.
[06/12/12 13:40:06.213]:SQL 2005 idm_people ST: Mapping
class-name 'User' to 'dbo.people'.
[06/12/12 13:40:06.213]:SQL 2005 idm_people ST: Applying output
transformation policies.
[06/12/12 13:40:06.213]:SQL 2005 idm_people ST: Applying policy:
%+C%14COutput Transformation%-C.
[06/12/12 13:40:06.213]:SQL 2005 idm_people ST: Applying to
query #1.
[06/12/12 13:40:06.214]:SQL 2005 idm_people ST: Evaluating
selection criteria for rule 'Reformat birthdate'.
[06/12/12 13:40:06.214]:SQL 2005 idm_people ST: Rule
selected.
[06/12/12 13:40:06.214]:SQL 2005 idm_people ST: Applying
rule 'Reformat birthdate'.
[06/12/12 13:40:06.214]:SQL 2005 idm_people ST: Action:
do-reformat-op-attr("birthdate",token-convert-time(dest-format="!CTIME",dest-tz="UTC",src-format="M-d-yyyy",token-local-variable("current-value"))).
[06/12/12 13:40:06.214]:SQL 2005 idm_people ST: Policy
returned:
[06/12/12 13:40:06.214]:SQL 2005 idm_people ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.14.5471">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="dbo.people" event-id="0" scope="subtree">
<search-class class-name="dbo.people"/>
<search-attr attr-name="udc_id">
<value timestamp="1305423987#7"
type="string">95633040870BB5EA6A9BE5AF4105FF8B</value>
</search-attr>
<read-attr/>
</query>
</input>
</nds>
[06/12/12 13:40:06.215]:SQL 2005 idm_people ST: Submitting
document to subscriber shim:
[06/12/12 13:40:06.215]:SQL 2005 idm_people ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.14.5471">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<query class-name="dbo.people" event-id="0" scope="subtree">
<search-class class-name="dbo.people"/>
<search-attr attr-name="udc_id">
<value timestamp="1305423987#7"
type="string">95633040870BB5EA6A9BE5AF4105FF8B</value>
</search-attr>
<read-attr/>
</query>
</input>
</nds>
[06/12/12 13:40:06.216]:SQL 2005 idm_people ST: Opening
temporary Subscriber query file.
[06/12/12 13:40:06.217]:SQL 2005 idm_people ST: File
'./jdbc_b55dcce0-304a-4e80-6c89-e0cc5db54a30_0' opened.
[06/12/12 13:40:06.217]:SQL 2005 idm_people ST: Connecting to
database...
[06/12/12 13:40:06.217]:SQL 2005 idm_people ST: BEGIN Open
connection 'dedicated0'.
[06/12/12 13:40:06.217]:SQL 2005 idm_people ST: BEGIN
Instantiate connection.
[06/12/12 13:40:06.257]:SQL 2005 idm_people ST: Allocated
connection 130d3ef4.
[06/12/12 13:40:06.257]:SQL 2005 idm_people ST: END
Instantiate connection.
[06/12/12 13:40:06.257]:SQL 2005 idm_people ST: END Open
connection.
[06/12/12 13:40:06.257]:SQL 2005 idm_people ST: Connected to
database.
[06/12/12 13:40:06.257]:SQL 2005 idm_people ST: Metadata has not
been retrieved.
[06/12/12 13:40:06.257]:SQL 2005 idm_people ST: Retrieving
database metadata
[06/12/12 13:40:06.257]:SQL 2005 idm_people ST: BEGIN Get
database properties.
[06/12/12 13:40:06.258]:SQL 2005 idm_people ST: Database name:
Microsoft SQL Server
[06/12/12 13:40:06.258]:SQL 2005 idm_people ST: Database
version: 09.00.4035
[06/12/12 13:40:06.258]:SQL 2005 idm_people ST: JDBC driver
name: jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
[06/12/12 13:40:06.258]:SQL 2005 idm_people ST: JDBC driver
version: 1.2.5
[06/12/12 13:40:06.258]:SQL 2005 idm_people ST: JDBC driver
major version: 1
[06/12/12 13:40:06.258]:SQL 2005 idm_people ST: JDBC driver
minor version: 2
[06/12/12 13:40:06.390]:SQL 2005 idm_people ST: Case
sensitive: false
[06/12/12 13:40:06.390]:SQL 2005 idm_people ST: Stored case:
mixed
[06/12/12 13:40:06.390]:SQL 2005 idm_people ST: Association
case: upper
[06/12/12 13:40:06.391]:SQL 2005 idm_people ST: Username:
'idm_people_user'
[06/12/12 13:40:06.392]:SQL 2005 idm_people ST: Allocated
result set 5235167d.
[06/12/12 13:40:06.392]:SQL 2005 idm_people ST: Closed
result set 5235167d.
[06/12/12 13:40:06.393]:SQL 2005 idm_people ST: Supported
table types: ["TABLE"]
[06/12/12 13:40:06.393]:SQL 2005 idm_people ST: Supported view
types: ["VIEW"]
[06/12/12 13:40:06.393]:SQL 2005 idm_people ST: Supports
views: true
[06/12/12 13:40:06.393]:SQL 2005 idm_people ST: Maximum number
of columns in select statement: 4096
[06/12/12 13:40:06.393]:SQL 2005 idm_people ST: Maximum number
of connections: unknown/unlimited
[06/12/12 13:40:06.393]:SQL 2005 idm_people ST: Maximum number
of open statements: unknown/unlimited
[06/12/12 13:40:06.393]:SQL 2005 idm_people ST: Supports
transactions: true
[06/12/12 13:40:06.393]:SQL 2005 idm_people ST: Supports
multiple transactions over multiple connections: true
[06/12/12 13:40:06.394]:SQL 2005 idm_people ST: Supports mixed
DML And DDL transactions: true
[06/12/12 13:40:06.394]:SQL 2005 idm_people ST: Supports only
DML transactions: false
[06/12/12 13:40:06.394]:SQL 2005 idm_people ST: DDL statement
in transaction forces commit: false
[06/12/12 13:40:06.394]:SQL 2005 idm_people ST: DDL statement
ignored in transactions: false
[06/12/12 13:40:06.394]:SQL 2005 idm_people ST: Supports
schema qualifiers in DML statements: true
[06/12/12 13:40:06.394]:SQL 2005 idm_people ST: Supports
schema qualifiers in procedure calls: true
[06/12/12 13:40:06.395]:SQL 2005 idm_people ST: Supports LIKE
escape clauses: true
[06/12/12 13:40:06.395]:SQL 2005 idm_people ST: Wildcard
escape character: \
[06/12/12 13:40:06.395]:SQL 2005 idm_people ST: Supports batch
updates: true
[06/12/12 13:40:06.395]:SQL 2005 idm_people ST: Supports
retrieval of auto-generated keys: true
[06/12/12 13:40:06.395]:SQL 2005 idm_people ST: Supports
limited outer joins: true
[06/12/12 13:40:06.395]:SQL 2005 idm_people ST: Supports
column aliasing: true
[06/12/12 13:40:06.395]:SQL 2005 idm_people ST: Database major
version: 9
[06/12/12 13:40:06.395]:SQL 2005 idm_people ST: Database minor
version: 0
[06/12/12 13:40:06.396]:SQL 2005 idm_people ST: Searching for
database descriptor file matching the runtime database.
[06/12/12 13:40:06.396]:SQL 2005 idm_people ST: Searching all
descriptors.
[06/12/12 13:40:06.396]:SQL 2005 idm_people ST: Loading
database descriptor file '_ms_sqlserver_2005.xml'.
[06/12/12 13:40:06.396]:SQL 2005 idm_people ST: Applying
imports to driver descriptor '_jtds_jdbc.xml'.
[06/12/12 13:40:06.396]:SQL 2005 idm_people ST: Applying
import '_ms_sqlserver_2005.xml'.
[06/12/12 13:40:06.396]:SQL 2005 idm_people ST:

<!--
Please send suggestions for improving this descriptor file to
idm@lists.novell.com with the keywords "jdbc" and "descriptor"
somewhere in the subject line.
-->
<database>
<identity>
<name>Microsoft SQL Server 2005 (9) or later</name>
<regex-name>.*microsoft.*</regex-name>
<!--
NOTE: major/minor version numbers take precedence over the
full string version number;
they're used when available; availability is determined by
the third-party JDBC driver;
when at all possible, it's recommended that you use a
driver that returns this information;
doing so minimizes the possibility of a collision between
descriptor files whose full version
regular expressions may clash given their complexity and
the varieties of presentation by
third-party drivers
-->
<!-- ([1-9]([0-9])+) = two or more digits, no preceding zeros
-->

<regex-major-version>^(9|([1-9]([0-9])+))$</regex-major-version>
<!-- (?&lt;!(\d|\p{Punct})) preceding character can't be a
digit or punctuation-->
<!-- (0*) allow for preceding zeroes -->
<!-- (9(\.|\s|$) 9 followed by a period, whitespace, or
end-of-line -->
<!-- ([1-9]([0-9]){1})(\.|\s|$)) two digits > 9 followed by a
period, whitespace, or end-of-line -->
<regex-version>.*(?&lt;!(\d|\p{Punct}))((0*)((9(\.|\s|$)) )|([1-9]([0-9]){1})(\.|\s|$)).*</regex-version>
</identity>
<options>

<add-default-values-on-view-insert>1</add-default-values-on-view-insert>
</options>
</database>
[06/12/12 13:40:06.399]:SQL 2005 idm_people ST: Runtime
descriptor:
[06/12/12 13:40:06.399]:SQL 2005 idm_people ST:
<jdbc-driver>
<identity>
<name>jTDS JDBC Driver</name>
<jdbc-class>net.sourceforge.jtds.jdbc.Driver</jdbc-class>
</identity>
<sql-type-map>
<type>
<from>-11</from>
<to>-2</to>
</type>
<type>
<from>-10</from>
<to>-1</to>
</type>
<type>
<from>-9</from>
<to>12</to>
</type>
<type>
<from>1111</from>
<to>12</to>
</type>
</sql-type-map>
<options>

<add-default-values-on-view-insert>1</add-default-values-on-view-insert>
</options>
<errors>
<connectivity>
<sql-state-class>
<value>08</value>
</sql-state-class>
<error-code>
<value>0</value>
</error-code>
<actions>
<exec-sql>SELECT NULL FROM sysusers WHERE -1 = 0</exec-sql>
</actions>
</connectivity>
<retry>
<sql-state>
<value>S1011</value>
</sql-state>
<sql-state>
<value>S1T00</value>
</sql-state>
</retry>
<authentication>
<sql-state>
<value>28000</value>
</sql-state>
<error-code>
<value>4060</value>
</error-code>
<error-code>
<value>18452</value>
</error-code>
<error-code>
<value>18456</value>
</error-code>
</authentication>
<fatal>
<sql-state>
<value>08007</value>
</sql-state>
</fatal>
</errors>
</jdbc-driver>
[06/12/12 13:40:06.401]:SQL 2005 idm_people ST: Parameter:
'reuse-statements' Value: true
[06/12/12 13:40:06.401]:SQL 2005 idm_people ST: Parameter:
'left-outer-join-operator' Value: 'LEFT OUTER JOIN'
[06/12/12 13:40:06.401]:SQL 2005 idm_people ST: Parameter:
'add-default-values-on-view-insert' Value: true
[06/12/12 13:40:06.401]:SQL 2005 idm_people ST: Parameter:
'current-timestamp-stmt' Value: 'SELECT
(CURRENT_TIMESTAMP)'
[06/12/12 13:40:06.402]:SQL 2005 idm_people ST: Parameter:
'include-table-filter' Value: '.*'
[06/12/12 13:40:06.402]:SQL 2005 idm_people ST: Parameter:
'exclude-table-filter' Value: null
[06/12/12 13:40:06.402]:SQL 2005 idm_people ST: Parameter:
'function-return-method' Value: 'dynamic'
[06/12/12 13:40:06.402]:SQL 2005 idm_people ST: Parameter:
'use-manual-transactions' Value: true
[06/12/12 13:40:06.402]:SQL 2005 idm_people ST: Parameter:
'minimal-metadata' Value: false
[06/12/12 13:40:06.403]:SQL 2005 idm_people ST: Parameter:
'handle-stmt-results' Value: 'multiple'
[06/12/12 13:40:06.403]:SQL 2005 idm_people ST: Parameter:
'transaction-isolation-level' Value: 'read committed'
[06/12/12 13:40:06.403]:SQL 2005 idm_people ST: Parameter:
'use-single-connection' Value: false
[06/12/12 13:40:06.403]:SQL 2005 idm_people ST: Parameter:
'time-translator-class' Value: 'public
com.novell.nds.dirxml.driver.jdbc.db.DBTimestamp(j ava.lang.String,java.lang.String,java.lang.String, java.lang.String)'
[06/12/12 13:40:06.403]:SQL 2005 idm_people ST: Parameter:
'supports-schemas-in-metadata-retrieval' Value: true
[06/12/12 13:40:06.404]:SQL 2005 idm_people ST: Parameter:
'lock-generator-class' Value: 'class
com.novell.nds.dirxml.driver.jdbc.db.lock.DBLockGe nerator'
[06/12/12 13:40:06.404]:SQL 2005 idm_people ST: Parameter:
'connection-properties' Value: ''
[06/12/12 13:40:06.404]:SQL 2005 idm_people ST: END Get
database properties.
[06/12/12 13:40:06.404]:SQL 2005 idm_people ST: BEGIN Get
metadata from schema 'dbo'.
[06/12/12 13:40:06.404]:SQL 2005 idm_people ST: Adjusting
schema name to stored case.
[06/12/12 13:40:06.404]:SQL 2005 idm_people ST: Stored case
name: 'dbo'
[06/12/12 13:40:06.404]:SQL 2005 idm_people ST: BEGIN Get
parent table metadata.
[06/12/12 13:40:06.405]:SQL 2005 idm_people ST: Tables visible
in schema 'dbo' using type filter ["TABLE"]:
[06/12/12 13:40:06.486]:SQL 2005 idm_people ST: Allocated
result set b94d3bc.
[06/12/12 13:40:06.486]:SQL 2005 idm_people ST: people
[06/12/12 13:40:06.486]:SQL 2005 idm_people ST:
people_assignments
[06/12/12 13:40:06.486]:SQL 2005 idm_people ST:
people_inst_roles
[06/12/12 13:40:06.486]:SQL 2005 idm_people ST:
people_job_depts
[06/12/12 13:40:06.486]:SQL 2005 idm_people ST:
people_job_titles
[06/12/12 13:40:06.486]:SQL 2005 idm_people ST:
people_registrations
[06/12/12 13:40:06.486]:SQL 2005 idm_people ST: Closed
result set b94d3bc.
[06/12/12 13:40:06.672]:SQL 2005 idm_people ST: Allocated
result set 57d8e194.
[06/12/12 13:40:06.672]:SQL 2005 idm_people ST: Closed
result set 57d8e194.
[06/12/12 13:40:06.672]:SQL 2005 idm_people ST: BEGIN Get
metadata for parent table 'people'.
[06/12/12 13:40:06.698]:SQL 2005 idm_people ST: Allocated
result set 5fc1e89a.
[06/12/12 13:40:06.698]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.698]:SQL 2005 idm_people ST: Name:
'udc_id'
[06/12/12 13:40:06.698]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.698]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.698]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.698]:SQL 2005 idm_people ST: Length:
48
[06/12/12 13:40:06.698]:SQL 2005 idm_people ST: Position:
1
[06/12/12 13:40:06.699]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:06.699]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.699]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.699]:SQL 2005 idm_people ST: Name:
'ulogin_id'
[06/12/12 13:40:06.699]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.699]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.699]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.699]:SQL 2005 idm_people ST: Length:
48
[06/12/12 13:40:06.699]:SQL 2005 idm_people ST: Position:
2
[06/12/12 13:40:06.700]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.700]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.700]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.700]:SQL 2005 idm_people ST: Name:
'banner_id'
[06/12/12 13:40:06.700]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.700]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.700]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.700]:SQL 2005 idm_people ST: Length:
9
[06/12/12 13:40:06.700]:SQL 2005 idm_people ST: Position:
3
[06/12/12 13:40:06.701]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.701]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.701]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.701]:SQL 2005 idm_people ST: Name:
'library_id'
[06/12/12 13:40:06.701]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.701]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.701]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.701]:SQL 2005 idm_people ST: Length:
48
[06/12/12 13:40:06.701]:SQL 2005 idm_people ST: Position:
4
[06/12/12 13:40:06.702]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.702]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.702]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.702]:SQL 2005 idm_people ST: Name:
'unix_uid'
[06/12/12 13:40:06.702]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.INTEGER
[06/12/12 13:40:06.702]:SQL 2005 idm_people ST: Native Type:
int
[06/12/12 13:40:06.702]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.702]:SQL 2005 idm_people ST: Precision:
10
[06/12/12 13:40:06.702]:SQL 2005 idm_people ST: Scale:
0
[06/12/12 13:40:06.703]:SQL 2005 idm_people ST: Position:
5
[06/12/12 13:40:06.703]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.703]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.703]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.703]:SQL 2005 idm_people ST: Name:
'given_name'
[06/12/12 13:40:06.703]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.703]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.703]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.703]:SQL 2005 idm_people ST: Length:
60
[06/12/12 13:40:06.704]:SQL 2005 idm_people ST: Position:
6
[06/12/12 13:40:06.704]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.704]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.704]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.704]:SQL 2005 idm_people ST: Name:
'surname'
[06/12/12 13:40:06.704]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.704]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.704]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.704]:SQL 2005 idm_people ST: Length:
60
[06/12/12 13:40:06.705]:SQL 2005 idm_people ST: Position:
7
[06/12/12 13:40:06.705]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.705]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.705]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.705]:SQL 2005 idm_people ST: Name:
'middle_truncated'
[06/12/12 13:40:06.705]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.705]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.705]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.705]:SQL 2005 idm_people ST: Length:
60
[06/12/12 13:40:06.706]:SQL 2005 idm_people ST: Position:
8
[06/12/12 13:40:06.706]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.706]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.706]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.706]:SQL 2005 idm_people ST: Name:
'personal_title'
[06/12/12 13:40:06.706]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.706]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.706]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.706]:SQL 2005 idm_people ST: Length:
60
[06/12/12 13:40:06.707]:SQL 2005 idm_people ST: Position:
9
[06/12/12 13:40:06.707]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.707]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.707]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.707]:SQL 2005 idm_people ST: Name:
'generation_qualifier'
[06/12/12 13:40:06.707]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.707]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.707]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.707]:SQL 2005 idm_people ST: Length:
60
[06/12/12 13:40:06.708]:SQL 2005 idm_people ST: Position:
10
[06/12/12 13:40:06.708]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.708]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.708]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.708]:SQL 2005 idm_people ST: Name:
'pref_name'
[06/12/12 13:40:06.708]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.708]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.708]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.708]:SQL 2005 idm_people ST: Length:
60
[06/12/12 13:40:06.709]:SQL 2005 idm_people ST: Position:
11
[06/12/12 13:40:06.709]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.709]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.709]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.709]:SQL 2005 idm_people ST: Name:
'full_name'
[06/12/12 13:40:06.709]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.709]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.709]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.709]:SQL 2005 idm_people ST: Length:
255
[06/12/12 13:40:06.709]:SQL 2005 idm_people ST: Position:
12
[06/12/12 13:40:06.710]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.710]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.710]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.710]:SQL 2005 idm_people ST: Name:
'drew_email'
[06/12/12 13:40:06.710]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.710]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.710]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.710]:SQL 2005 idm_people ST: Length:
128
[06/12/12 13:40:06.710]:SQL 2005 idm_people ST: Position:
13
[06/12/12 13:40:06.711]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.711]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.711]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.711]:SQL 2005 idm_people ST: Name:
'personal_email'
[06/12/12 13:40:06.711]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.711]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.711]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.711]:SQL 2005 idm_people ST: Length:
128
[06/12/12 13:40:06.711]:SQL 2005 idm_people ST: Position:
14
[06/12/12 13:40:06.712]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.712]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.712]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.712]:SQL 2005 idm_people ST: Name:
'campus_mail'
[06/12/12 13:40:06.712]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.712]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.712]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.712]:SQL 2005 idm_people ST: Length:
255
[06/12/12 13:40:06.712]:SQL 2005 idm_people ST: Position:
15
[06/12/12 13:40:06.713]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.713]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.713]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.713]:SQL 2005 idm_people ST: Name:
'campus_phone'
[06/12/12 13:40:06.713]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.713]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.713]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.713]:SQL 2005 idm_people ST: Length:
64
[06/12/12 13:40:06.713]:SQL 2005 idm_people ST: Position:
16
[06/12/12 13:40:06.714]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.714]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.714]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.714]:SQL 2005 idm_people ST: Name:
'mobile_phone'
[06/12/12 13:40:06.714]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.714]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.714]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.714]:SQL 2005 idm_people ST: Length:
64
[06/12/12 13:40:06.714]:SQL 2005 idm_people ST: Position:
17
[06/12/12 13:40:06.715]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.715]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.715]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.715]:SQL 2005 idm_people ST: Name:
'birthdate'
[06/12/12 13:40:06.715]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.TIMESTAMP
[06/12/12 13:40:06.715]:SQL 2005 idm_people ST: Native Type:
datetime
[06/12/12 13:40:06.715]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.715]:SQL 2005 idm_people ST: Size:
23
[06/12/12 13:40:06.715]:SQL 2005 idm_people ST: Position:
18
[06/12/12 13:40:06.715]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.716]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.716]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.716]:SQL 2005 idm_people ST: Name:
'gender'
[06/12/12 13:40:06.716]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.716]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.716]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.716]:SQL 2005 idm_people ST: Length:
50
[06/12/12 13:40:06.716]:SQL 2005 idm_people ST: Position:
19
[06/12/12 13:40:06.716]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.717]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.717]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.717]:SQL 2005 idm_people ST: Name:
'banner_user_id'
[06/12/12 13:40:06.717]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.717]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.717]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.717]:SQL 2005 idm_people ST: Length:
50
[06/12/12 13:40:06.717]:SQL 2005 idm_people ST: Position:
20
[06/12/12 13:40:06.717]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.718]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.718]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.718]:SQL 2005 idm_people ST: Name:
'dining_plan'
[06/12/12 13:40:06.718]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.718]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.718]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.718]:SQL 2005 idm_people ST: Length:
50
[06/12/12 13:40:06.718]:SQL 2005 idm_people ST: Position:
21
[06/12/12 13:40:06.718]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.719]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.719]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.719]:SQL 2005 idm_people ST: Name:
'dining_start'
[06/12/12 13:40:06.719]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.TIMESTAMP
[06/12/12 13:40:06.719]:SQL 2005 idm_people ST: Native Type:
datetime
[06/12/12 13:40:06.719]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.719]:SQL 2005 idm_people ST: Size:
23
[06/12/12 13:40:06.719]:SQL 2005 idm_people ST: Position:
22
[06/12/12 13:40:06.719]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.720]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.720]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.720]:SQL 2005 idm_people ST: Name:
'dining_end'
[06/12/12 13:40:06.720]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.TIMESTAMP
[06/12/12 13:40:06.720]:SQL 2005 idm_people ST: Native Type:
datetime
[06/12/12 13:40:06.720]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.720]:SQL 2005 idm_people ST: Size:
23
[06/12/12 13:40:06.720]:SQL 2005 idm_people ST: Position:
23
[06/12/12 13:40:06.720]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.721]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.721]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.721]:SQL 2005 idm_people ST: Name:
'residence_building'
[06/12/12 13:40:06.721]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.721]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.721]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.721]:SQL 2005 idm_people ST: Length:
50
[06/12/12 13:40:06.721]:SQL 2005 idm_people ST: Position:
24
[06/12/12 13:40:06.722]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.722]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.722]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.722]:SQL 2005 idm_people ST: Name:
'residence_room'
[06/12/12 13:40:06.722]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.722]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.722]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.722]:SQL 2005 idm_people ST: Length:
50
[06/12/12 13:40:06.722]:SQL 2005 idm_people ST: Position:
25
[06/12/12 13:40:06.723]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.723]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.723]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.723]:SQL 2005 idm_people ST: Name:
'residence_check_in'
[06/12/12 13:40:06.723]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.TIMESTAMP
[06/12/12 13:40:06.723]:SQL 2005 idm_people ST: Native Type:
datetime
[06/12/12 13:40:06.723]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.723]:SQL 2005 idm_people ST: Size:
23
[06/12/12 13:40:06.723]:SQL 2005 idm_people ST: Position:
26
[06/12/12 13:40:06.724]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.724]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.724]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.724]:SQL 2005 idm_people ST: Name:
'residence_check_out'
[06/12/12 13:40:06.724]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.TIMESTAMP
[06/12/12 13:40:06.724]:SQL 2005 idm_people ST: Native Type:
datetime
[06/12/12 13:40:06.724]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.724]:SQL 2005 idm_people ST: Size:
23
[06/12/12 13:40:06.724]:SQL 2005 idm_people ST: Position:
27
[06/12/12 13:40:06.725]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.725]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.725]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.725]:SQL 2005 idm_people ST: Name:
'pwm_status'
[06/12/12 13:40:06.725]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:06.725]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:06.725]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.725]:SQL 2005 idm_people ST: Length:
50
[06/12/12 13:40:06.725]:SQL 2005 idm_people ST: Position:
28
[06/12/12 13:40:06.726]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.726]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.726]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:06.726]:SQL 2005 idm_people ST: Name:
'pwd_expiration_time'
[06/12/12 13:40:06.726]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.TIMESTAMP
[06/12/12 13:40:06.726]:SQL 2005 idm_people ST: Native Type:
datetime
[06/12/12 13:40:06.726]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:06.726]:SQL 2005 idm_people ST: Size:
23
[06/12/12 13:40:06.727]:SQL 2005 idm_people ST: Position:
29
[06/12/12 13:40:06.727]:SQL 2005 idm_people ST: Nullable:
YES
[06/12/12 13:40:06.727]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:06.727]:SQL 2005 idm_people ST: Closed
result set 5fc1e89a.
[06/12/12 13:40:06.727]:SQL 2005 idm_people ST: BEGIN Get
primary key metadata for table 'dbo.people'.
[06/12/12 13:40:06.731]:SQL 2005 idm_people ST: Allocated
result set 338e0793.
[06/12/12 13:40:06.731]:SQL 2005 idm_people ST: Closed
result set 338e0793.
[06/12/12 13:40:06.731]:SQL 2005 idm_people ST: END Get
primary key metadata for table 'dbo.people'.
[06/12/12 13:40:06.828]:SQL 2005 idm_people ST: Allocated
result set 31935e56.
[06/12/12 13:40:06.828]:SQL 2005 idm_people ST: Closed
result set 31935e56.
[06/12/12 13:40:06.958]:SQL 2005 idm_people ST: Allocated
result set 42167987.
[06/12/12 13:40:06.959]:SQL 2005 idm_people ST: Closed
result set 42167987.
[06/12/12 13:40:06.960]:SQL 2005 idm_people ST: Allocated
result set 5184aff6.
[06/12/12 13:40:06.960]:SQL 2005 idm_people ST: Closed
result set 5184aff6.
[06/12/12 13:40:06.962]:SQL 2005 idm_people ST: Allocated
result set 5e3c6949.
[06/12/12 13:40:06.962]:SQL 2005 idm_people ST: Closed
result set 5e3c6949.
[06/12/12 13:40:06.964]:SQL 2005 idm_people ST: Allocated
result set 502467f4.
[06/12/12 13:40:06.964]:SQL 2005 idm_people ST: Closed
result set 502467f4.
[06/12/12 13:40:06.965]:SQL 2005 idm_people ST: Allocated
result set 624ed47.
[06/12/12 13:40:06.966]:SQL 2005 idm_people ST: Closed
result set 624ed47.
[06/12/12 13:40:06.967]:SQL 2005 idm_people ST: Allocated
result set 6255d377.
[06/12/12 13:40:06.967]:SQL 2005 idm_people ST: Closed
result set 6255d377.
[06/12/12 13:40:06.968]:SQL 2005 idm_people ST: Allocated
result set 70ae5c10.
[06/12/12 13:40:06.968]:SQL 2005 idm_people ST: Closed
result set 70ae5c10.
[06/12/12 13:40:06.970]:SQL 2005 idm_people ST: Allocated
result set 471e583b.
[06/12/12 13:40:06.970]:SQL 2005 idm_people ST: Closed
result set 471e583b.
[06/12/12 13:40:06.971]:SQL 2005 idm_people ST: Allocated
result set 1932adf7.
[06/12/12 13:40:06.972]:SQL 2005 idm_people ST: Closed
result set 1932adf7.
[06/12/12 13:40:06.973]:SQL 2005 idm_people ST: Allocated
result set 4e3b400d.
[06/12/12 13:40:06.973]:SQL 2005 idm_people ST: Closed
result set 4e3b400d.
[06/12/12 13:40:06.975]:SQL 2005 idm_people ST: Allocated
result set 13ea3d9b.
[06/12/12 13:40:06.975]:SQL 2005 idm_people ST: Closed
result set 13ea3d9b.
[06/12/12 13:40:06.976]:SQL 2005 idm_people ST: Allocated
result set 77729553.
[06/12/12 13:40:06.976]:SQL 2005 idm_people ST: Closed
result set 77729553.
[06/12/12 13:40:06.978]:SQL 2005 idm_people ST: Allocated
result set 3a9b969.
[06/12/12 13:40:06.978]:SQL 2005 idm_people ST: Closed
result set 3a9b969.
[06/12/12 13:40:06.979]:SQL 2005 idm_people ST: Allocated
result set 7bcb9e5f.
[06/12/12 13:40:06.979]:SQL 2005 idm_people ST: Closed
result set 7bcb9e5f.
[06/12/12 13:40:06.981]:SQL 2005 idm_people ST: Allocated
result set 750aae77.
[06/12/12 13:40:06.981]:SQL 2005 idm_people ST: Closed
result set 750aae77.
[06/12/12 13:40:06.982]:SQL 2005 idm_people ST: Allocated
result set 104442a9.
[06/12/12 13:40:06.982]:SQL 2005 idm_people ST: Closed
result set 104442a9.
[06/12/12 13:40:06.984]:SQL 2005 idm_people ST: Allocated
result set 71746d96.
[06/12/12 13:40:06.984]:SQL 2005 idm_people ST: Closed
result set 71746d96.
[06/12/12 13:40:06.985]:SQL 2005 idm_people ST: Allocated
result set 12c6cd0b.
[06/12/12 13:40:06.985]:SQL 2005 idm_people ST: Closed
result set 12c6cd0b.
[06/12/12 13:40:06.986]:SQL 2005 idm_people ST: Allocated
result set 39bf96ce.
[06/12/12 13:40:06.987]:SQL 2005 idm_people ST: Closed
result set 39bf96ce.
[06/12/12 13:40:06.988]:SQL 2005 idm_people ST: Allocated
result set 5145cc00.
[06/12/12 13:40:06.988]:SQL 2005 idm_people ST: Closed
result set 5145cc00.
[06/12/12 13:40:06.989]:SQL 2005 idm_people ST: Allocated
result set 3d543daf.
[06/12/12 13:40:06.990]:SQL 2005 idm_people ST: Closed
result set 3d543daf.
[06/12/12 13:40:06.991]:SQL 2005 idm_people ST: Allocated
result set 659dcb9d.
[06/12/12 13:40:06.991]:SQL 2005 idm_people ST: Closed
result set 659dcb9d.
[06/12/12 13:40:06.993]:SQL 2005 idm_people ST: Allocated
result set 5aa2e489.
[06/12/12 13:40:06.993]:SQL 2005 idm_people ST: Closed
result set 5aa2e489.
[06/12/12 13:40:06.994]:SQL 2005 idm_people ST: Allocated
result set 7c4a0cdb.
[06/12/12 13:40:06.994]:SQL 2005 idm_people ST: Closed
result set 7c4a0cdb.
[06/12/12 13:40:06.996]:SQL 2005 idm_people ST: Allocated
result set 61923d9c.
[06/12/12 13:40:06.996]:SQL 2005 idm_people ST: Closed
result set 61923d9c.
[06/12/12 13:40:06.998]:SQL 2005 idm_people ST: Allocated
result set 480afecf.
[06/12/12 13:40:06.998]:SQL 2005 idm_people ST: Closed
result set 480afecf.
[06/12/12 13:40:06.999]:SQL 2005 idm_people ST: Allocated
result set 49deecfc.
[06/12/12 13:40:06.999]:SQL 2005 idm_people ST: Closed
result set 49deecfc.
[06/12/12 13:40:07.001]:SQL 2005 idm_people ST: Allocated
result set 4a98ba47.
[06/12/12 13:40:07.001]:SQL 2005 idm_people ST: Closed
result set 4a98ba47.
[06/12/12 13:40:07.002]:SQL 2005 idm_people ST: Allocated
result set 70edb193.
[06/12/12 13:40:07.003]:SQL 2005 idm_people ST: Closed
result set 70edb193.
[06/12/12 13:40:07.003]:SQL 2005 idm_people ST: END Get
metadata for parent table 'people'.
[06/12/12 13:40:07.004]:SQL 2005 idm_people ST: Allocated
result set 52563d1.
[06/12/12 13:40:07.004]:SQL 2005 idm_people ST: Closed
result set 52563d1.
[06/12/12 13:40:07.005]:SQL 2005 idm_people ST: Allocated
result set 59bc30fa.
[06/12/12 13:40:07.005]:SQL 2005 idm_people ST: Closed
result set 59bc30fa.
[06/12/12 13:40:07.006]:SQL 2005 idm_people ST: Allocated
result set 52339b1c.
[06/12/12 13:40:07.006]:SQL 2005 idm_people ST: Closed
result set 52339b1c.
[06/12/12 13:40:07.007]:SQL 2005 idm_people ST: Allocated
result set 3a0c756d.
[06/12/12 13:40:07.007]:SQL 2005 idm_people ST: Closed
result set 3a0c756d.
[06/12/12 13:40:07.008]:SQL 2005 idm_people ST: Allocated
result set 7f164e1.
[06/12/12 13:40:07.008]:SQL 2005 idm_people ST: Closed
result set 7f164e1.
[06/12/12 13:40:07.008]:SQL 2005 idm_people ST: BEGIN Get view
metadata.
[06/12/12 13:40:07.008]:SQL 2005 idm_people ST: Views visible
in schema 'dbo' using type filter ["VIEW"]:
[06/12/12 13:40:07.352]:SQL 2005 idm_people ST: Allocated
result set 7915f3d9.
[06/12/12 13:40:07.352]:SQL 2005 idm_people ST: Closed
result set 7915f3d9.
[06/12/12 13:40:07.352]:SQL 2005 idm_people ST: END Get view
metadata.
[06/12/12 13:40:07.352]:SQL 2005 idm_people ST: END Get
parent table metadata.
[06/12/12 13:40:07.352]:SQL 2005 idm_people ST: Number of
tables/views visible in schema: 6
[06/12/12 13:40:07.353]:SQL 2005 idm_people ST: BEGIN Get
metadata for children of table 'people'.
[06/12/12 13:40:07.476]:SQL 2005 idm_people ST: Allocated
result set 103c69aa.
[06/12/12 13:40:07.477]:SQL 2005 idm_people ST: Closed
result set 103c69aa.
[06/12/12 13:40:07.477]:SQL 2005 idm_people ST: BEGIN Get
metadata for table 'people_assignments'.
[06/12/12 13:40:07.479]:SQL 2005 idm_people ST: Allocated
result set 6e3d2039.
[06/12/12 13:40:07.479]:SQL 2005 idm_people ST: Closed
result set 6e3d2039.
[06/12/12 13:40:07.482]:SQL 2005 idm_people ST: Allocated
result set 6f0eb6b9.
[06/12/12 13:40:07.482]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:07.482]:SQL 2005 idm_people ST: Name:
'udc_id'
[06/12/12 13:40:07.483]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:07.483]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:07.483]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:07.483]:SQL 2005 idm_people ST: Length:
48
[06/12/12 13:40:07.483]:SQL 2005 idm_people ST: Position:
1
[06/12/12 13:40:07.483]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:07.483]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:07.483]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:07.483]:SQL 2005 idm_people ST: Name:
'assigned_section'
[06/12/12 13:40:07.483]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:07.484]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:07.484]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:07.484]:SQL 2005 idm_people ST: Length:
255
[06/12/12 13:40:07.484]:SQL 2005 idm_people ST: Position:
2
[06/12/12 13:40:07.484]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:07.484]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:07.484]:SQL 2005 idm_people ST: Closed
result set 6f0eb6b9.
[06/12/12 13:40:07.484]:SQL 2005 idm_people ST: END Get
metadata for table 'people_assignments'.
[06/12/12 13:40:07.485]:SQL 2005 idm_people ST: BEGIN Get
metadata for table 'people_inst_roles'.
[06/12/12 13:40:07.487]:SQL 2005 idm_people ST: Allocated
result set 2efe64a5.
[06/12/12 13:40:07.487]:SQL 2005 idm_people ST: Closed
result set 2efe64a5.
[06/12/12 13:40:07.489]:SQL 2005 idm_people ST: Allocated
result set 3f81a4bd.
[06/12/12 13:40:07.489]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:07.489]:SQL 2005 idm_people ST: Name:
'udc_id'
[06/12/12 13:40:07.489]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:07.489]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:07.489]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:07.489]:SQL 2005 idm_people ST: Length:
48
[06/12/12 13:40:07.489]:SQL 2005 idm_people ST: Position:
1
[06/12/12 13:40:07.490]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:07.490]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:07.490]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:07.490]:SQL 2005 idm_people ST: Name:
'role'
[06/12/12 13:40:07.490]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:07.490]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:07.490]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:07.490]:SQL 2005 idm_people ST: Length:
50
[06/12/12 13:40:07.490]:SQL 2005 idm_people ST: Position:
2
[06/12/12 13:40:07.491]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:07.491]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:07.491]:SQL 2005 idm_people ST: Closed
result set 3f81a4bd.
[06/12/12 13:40:07.491]:SQL 2005 idm_people ST: END Get
metadata for table 'people_inst_roles'.
[06/12/12 13:40:07.491]:SQL 2005 idm_people ST: BEGIN Get
metadata for table 'people_job_depts'.
[06/12/12 13:40:07.493]:SQL 2005 idm_people ST: Allocated
result set 586694dd.
[06/12/12 13:40:07.493]:SQL 2005 idm_people ST: Closed
result set 586694dd.
[06/12/12 13:40:07.495]:SQL 2005 idm_people ST: Allocated
result set 36b76682.
[06/12/12 13:40:07.495]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:07.495]:SQL 2005 idm_people ST: Name:
'udc_id'
[06/12/12 13:40:07.496]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:07.496]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:07.496]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:07.496]:SQL 2005 idm_people ST: Length:
48
[06/12/12 13:40:07.496]:SQL 2005 idm_people ST: Position:
1
[06/12/12 13:40:07.496]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:07.496]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:07.496]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:07.496]:SQL 2005 idm_people ST: Name:
'job_dept'
[06/12/12 13:40:07.497]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:07.497]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:07.497]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:07.497]:SQL 2005 idm_people ST: Length:
255
[06/12/12 13:40:07.497]:SQL 2005 idm_people ST: Position:
2
[06/12/12 13:40:07.497]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:07.497]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:07.497]:SQL 2005 idm_people ST: Closed
result set 36b76682.
[06/12/12 13:40:07.497]:SQL 2005 idm_people ST: END Get
metadata for table 'people_job_depts'.
[06/12/12 13:40:07.498]:SQL 2005 idm_people ST: BEGIN Get
metadata for table 'people_job_titles'.
[06/12/12 13:40:07.500]:SQL 2005 idm_people ST: Allocated
result set 42aafcde.
[06/12/12 13:40:07.500]:SQL 2005 idm_people ST: Closed
result set 42aafcde.
[06/12/12 13:40:07.502]:SQL 2005 idm_people ST: Allocated
result set 67bf7503.
[06/12/12 13:40:07.502]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:07.502]:SQL 2005 idm_people ST: Name:
'udc_id'
[06/12/12 13:40:07.502]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:07.502]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:07.502]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:07.502]:SQL 2005 idm_people ST: Length:
48
[06/12/12 13:40:07.503]:SQL 2005 idm_people ST: Position:
1
[06/12/12 13:40:07.503]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:07.503]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:07.503]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:07.503]:SQL 2005 idm_people ST: Name:
'job_title'
[06/12/12 13:40:07.503]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:07.503]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:07.503]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:07.503]:SQL 2005 idm_people ST: Length:
1024
[06/12/12 13:40:07.503]:SQL 2005 idm_people ST: Position:
2
[06/12/12 13:40:07.504]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:07.504]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:07.504]:SQL 2005 idm_people ST: Closed
result set 67bf7503.
[06/12/12 13:40:07.504]:SQL 2005 idm_people ST: END Get
metadata for table 'people_job_titles'.
[06/12/12 13:40:07.504]:SQL 2005 idm_people ST: BEGIN Get
metadata for table 'people_registrations'.
[06/12/12 13:40:07.506]:SQL 2005 idm_people ST: Allocated
result set 4a9b4d2b.
[06/12/12 13:40:07.506]:SQL 2005 idm_people ST: Closed
result set 4a9b4d2b.
[06/12/12 13:40:07.508]:SQL 2005 idm_people ST: Allocated
result set 19e76851.
[06/12/12 13:40:07.508]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:07.509]:SQL 2005 idm_people ST: Name:
'udc_id'
[06/12/12 13:40:07.509]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:07.509]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:07.509]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:07.509]:SQL 2005 idm_people ST: Length:
48
[06/12/12 13:40:07.509]:SQL 2005 idm_people ST: Position:
1
[06/12/12 13:40:07.509]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:07.509]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:07.509]:SQL 2005 idm_people ST: BEGIN Column.
[06/12/12 13:40:07.510]:SQL 2005 idm_people ST: Name:
'reg_section'
[06/12/12 13:40:07.510]:SQL 2005 idm_people ST: SQL Type:
java.sql.Types.VARCHAR
[06/12/12 13:40:07.510]:SQL 2005 idm_people ST: Native Type:
varchar
[06/12/12 13:40:07.510]:SQL 2005 idm_people ST: Parameter
Type: IN
[06/12/12 13:40:07.510]:SQL 2005 idm_people ST: Length:
255
[06/12/12 13:40:07.510]:SQL 2005 idm_people ST: Position:
2
[06/12/12 13:40:07.510]:SQL 2005 idm_people ST: Nullable:
NO
[06/12/12 13:40:07.510]:SQL 2005 idm_people ST: END Column.
[06/12/12 13:40:07.510]:SQL 2005 idm_people ST: Closed
result set 19e76851.
[06/12/12 13:40:07.511]:SQL 2005 idm_people ST: END Get
metadata for table 'people_registrations'.
[06/12/12 13:40:07.511]:SQL 2005 idm_people ST: END Get
metadata for children of table 'people'.
[06/12/12 13:40:07.511]:SQL 2005 idm_people ST: BEGIN Get
foreign key metadata for table 'people'.
[06/12/12 13:40:07.513]:SQL 2005 idm_people ST: Allocated
result set 2771ab20.
[06/12/12 13:40:07.513]:SQL 2005 idm_people ST: Closed
result set 2771ab20.
[06/12/12 13:40:07.514]:SQL 2005 idm_people ST: END Get
foreign key metadata for table 'people'.
[06/12/12 13:40:07.514]:SQL 2005 idm_people ST: Number of
table/view definitions cached from schema: 6
[06/12/12 13:40:07.514]:SQL 2005 idm_people ST: Number of
syncable classes in schema: 1
[06/12/12 13:40:07.514]:SQL 2005 idm_people ST: Cached
tables/views:
[06/12/12 13:40:07.514]:SQL 2005 idm_people ST: dbo.people
[06/12/12 13:40:07.515]:SQL 2005 idm_people ST:
dbo.people_assignments
[06/12/12 13:40:07.515]:SQL 2005 idm_people ST:
dbo.people_inst_roles
[06/12/12 13:40:07.515]:SQL 2005 idm_people ST:
dbo.people_job_depts
[06/12/12 13:40:07.515]:SQL 2005 idm_people ST:
dbo.people_job_titles
[06/12/12 13:40:07.515]:SQL 2005 idm_people ST:
dbo.people_registrations
[06/12/12 13:40:07.515]:SQL 2005 idm_people ST: END Get
metadata from schema 'dbo'.
[06/12/12 13:40:07.515]:SQL 2005 idm_people ST: Retrieved
database metadata.
[06/12/12 13:40:07.515]:SQL 2005 idm_people ST: BEGIN Set
transaction isolation level.
[06/12/12 13:40:07.515]:SQL 2005 idm_people ST: Transaction
isolation level: read committed
[06/12/12 13:40:07.516]:SQL 2005 idm_people ST: END Set
transaction isolation level.
[06/12/12 13:40:07.516]:SQL 2005 idm_people ST: Acquired lock on
connection 'dedicated0'.
[06/12/12 13:40:07.516]:SQL 2005 idm_people ST: Interpreting
filter.
[06/12/12 13:40:07.516]:SQL 2005 idm_people ST: BEGIN Handle
QUERY.
[06/12/12 13:40:07.516]:SQL 2005 idm_people ST: BEGIN Interpret
initial query.
[06/12/12 13:40:07.516]:SQL 2005 idm_people ST: Base object:
schema
[06/12/12 13:40:07.516]:SQL 2005 idm_people ST: Scope: subtree
[06/12/12 13:40:07.517]:SQL 2005 idm_people ST: END Interpret
initial query.
[06/12/12 13:40:07.517]:SQL 2005 idm_people ST: Acquired lock on
file './jdbc_b55dcce0-304a-4e80-6c89-e0cc5db54a30_0'.
[06/12/12 13:40:07.517]:SQL 2005 idm_people ST: SELECT udc_id
FROM dbo.people WHERE udc_id = ? ORDER BY udc_id
[06/12/12 13:40:07.518]:SQL 2005 idm_people ST: BEGIN
Instantiate prepared statement.
[06/12/12 13:40:07.518]:SQL 2005 idm_people ST: Allocating
statement from connection 130d3ef4.
[06/12/12 13:40:07.518]:SQL 2005 idm_people ST: Allocated
statement SELECT udc_id FROM dbo.people WHERE udc_id = ? ORDER BY
udc_id.
[06/12/12 13:40:07.518]:SQL 2005 idm_people ST: END
Instantiate prepared statement.
[06/12/12 13:40:07.518]:SQL 2005 idm_people ST: IN @ index 1,
field 'udc_id', length: 32, value = '95633040870BB5EA6A9BE5AF4105FF8B'
[06/12/12 13:40:07.527]:SQL 2005 idm_people ST: Allocated
result set 4001683e from statement SELECT udc_id FROM dbo.people WHERE
udc_id = ? ORDER BY udc_id.
[06/12/12 13:40:07.527]:SQL 2005 idm_people ST: Closed
result set 4001683e.
[06/12/12 13:40:07.527]:SQL 2005 idm_people ST: Closed
statement SELECT udc_id FROM dbo.people WHERE udc_id = ? ORDER BY
udc_id.
[06/12/12 13:40:07.527]:SQL 2005 idm_people ST: Released file
lock.
[06/12/12 13:40:07.527]:SQL 2005 idm_people ST: END Handle
QUERY.
[06/12/12 13:40:07.527]:SQL 2005 idm_people ST: Released
connection lock.
[06/12/12 13:40:07.528]:SQL 2005 idm_people ST: Number of
statements allocated on connection 'dedicated0': 0.
[06/12/12 13:40:07.528]:SQL 2005 idm_people ST:
SubscriptionShim.execute() returned:
[06/12/12 13:40:07.528]:SQL 2005 idm_people ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20090520_1228" instance="SQL 2005 idm_people"
version="3.5.4">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="0" level="success"></status>
</output>
</nds>
[06/12/12 13:40:07.528]:SQL 2005 idm_people ST: No input
transformation policies.
[06/12/12 13:40:07.528]:SQL 2005 idm_people ST: Applying schema
mapping policies to input.
[06/12/12 13:40:07.529]:SQL 2005 idm_people ST: Applying policy:
%+C%14CSchema+Mapping+Rule%-C.
[06/12/12 13:40:07.529]:SQL 2005 idm_people ST: Resolving
association references.
[06/12/12 13:40:07.529]:SQL 2005 idm_people ST: Query from
policy result
[06/12/12 13:40:07.529]:SQL 2005 idm_people ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20090520_1228" instance="SQL 2005 idm_people"
version="3.5.4">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="0" level="success"></status>
</output>
</nds>
[06/12/12 13:40:07.530]:SQL 2005 idm_people ST: No matches
found.
[06/12/12 13:40:07.530]:SQL 2005 idm_people ST:Policy returned:


--
Axel Larsson
Drew University
------------------------------------------------------------------------
elarsson's Profile: http://forums.novell.com/member.php?userid=14888
View this thread: http://forums.novell.com/showthread.php?t=456814