Object 1: I retrieve an object which is both the parent to a child that I am inserting, and a child of a parent higher up in the hierarchy....
Object 2: I am creating a new child and calling .save() [outputDetailDAO.insertOutputDetail(outputDetail)]
What I get is:
1. 1 select for Object 1
2. 14 additional selects
Why do I get all of these selects when all I want to do is insert a child? What do I have to do to only issue 1 update?
Hibernate version:
3.1
Mapping documents:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Jan 16, 2006 9:56:45 AM by Hibernate Tools 3.1.0 beta1JBIDERC2 -->
<hibernate-mapping>
<class name="com.hibernate.OutputDetail" table="_OUTPUTDETAIL">
<id name="outputDetailId" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="OUTPUTDETAILID" length="40" />
<generator class="assigned" />
</id>
<many-to-one name="Output" class="com.hibernate.Output" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="REFOUTPUTID" length="40" not-null="true" />
</many-to-one>
<property name="outputCode" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="OUTPUTCODE" length="25" />
</property>
<property name="dateToPrint" type="calendar"><meta attribute="use-in-tostring">true</meta>
<column name="DATETOPRINT" length="10" />
</property>
<property name="datePrinted" type="calendar"><meta attribute="use-in-tostring">true</meta>
<column name="DATEPRINTED" length="10" />
</property>
<property name="receiverType" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="RECEIVERTYPE" length="25" />
</property>
<property name="receiverCode" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="RECEIVERCODE" length="40" />
</property>
<property name="transmitMethod" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="TRANSMITMETHOD" length="2" />
</property>
<property name="zipcode" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="ZIPCODE" length="10" />
</property>
<property name="outputObject" type="blob"><meta attribute="use-in-tostring">true</meta>
<column name="OUTPUTOBJECT" />
</property>
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Jan 16, 2006 9:56:46 AM by Hibernate Tools 3.1.0 beta1JBIDERC2 -->
<hibernate-mapping>
<class name="com.hibernate.Output" table="_OUTPUT">
<id name="outputId" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="OUTPUTID" length="40" />
<generator class="assigned" />
</id>
<timestamp name="updatedDate" column="UPDATEDDATE" />
<many-to-one name="InsCompAgent" class="com.hibernate.InsCompAgent" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="INSAGENTID" />
</many-to-one>
<many-to-one name="Risk" class="com.hibernate.Risk" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="RISKID" length="11" />
<column name="RISKIDREN" length="2" />
<column name="RISKIDEND" length="4" />
</many-to-one>
<many-to-one name="Quote" class="com.hibernate.Quote" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="QUOTEID" length="11" />
</many-to-one>
<many-to-one name="InsCompAgency" class="com.hibernate.InsCompAgency" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="INSAGENCYID" />
</many-to-one>
<many-to-one name="Customer" class="com.hibernate.Customer" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="CUSTOMERID" />
</many-to-one>
<property name="outputCode" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="OUTPUTCODE" length="25" />
</property>
<property name="printDate" type="calendar"><meta attribute="use-in-tostring">true</meta>
<column name="PRINTDATE" length="10" />
</property>
<property name="printedDate" type="calendar"><meta attribute="use-in-tostring">true</meta>
<column name="PRINTEDDATE" length="10" />
</property>
<property name="postingDate" type="calendar"><meta attribute="use-in-tostring">true</meta>
<column name="POSTINGDATE" length="10" />
</property>
<property name="status" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="STATUS" length="15" />
</property>
<property name="createdBy" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="CREATEDBY" length="50" />
</property>
<property name="createdDate" type="calendar"><meta attribute="use-in-tostring">true</meta>
<column name="CREATEDDATE" length="26" />
</property>
<property name="updatedBy" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="UPDATEDBY" length="50" />
</property>
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Jan 16, 2006 9:56:51 AM by Hibernate Tools 3.1.0 beta1JBIDERC2 -->
<hibernate-mapping>
<class name="com.hibernate.Risk" table="_RISK">
<composite-id name="id" class="com.hibernate.RiskId">
<key-property name="riskId" type="string">
<meta attribute="use-in-tostring">true</meta>
<column name="RISKID" length="11" />
</key-property>
<key-property name="riskIdRen" type="string">
<meta attribute="use-in-tostring">true</meta>
<column name="RISKIDREN" length="2" />
</key-property>
<key-property name="riskIdEnd" type="string">
<meta attribute="use-in-tostring">true</meta>
<column name="RISKIDEND" length="4" />
</key-property>
</composite-id>
<timestamp name="updatedDate" column="UPDATEDDATE" />
<many-to-one name="InsCompany" class="com.hibernate.InsCompany" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="COMPANYID" not-null="true" />
</many-to-one>
<many-to-one name="InsCompAgent" class="com.hibernate.InsCompAgent" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="INSAGENTID" not-null="true" />
</many-to-one>
<many-to-one name="UserInfo" class="com.hibernate.UserInfo" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="USERID" length="40" />
</many-to-one>
<many-to-one name="Customer" class="com.hibernate.Customer" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="CUSTOMERID" not-null="true" />
</many-to-one>
<many-to-one name="Address" class="com.hibernate.Address" fetch="select"><meta attribute="use-in-tostring">true</meta>
<column name="ADDRESSID" length="40" />
</many-to-one>
<property name="lob" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="LOB" length="2" />
</property>
<property name="createdBy" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="CREATEDBY" length="50" />
</property>
<property name="createdDate" type="calendar"><meta attribute="use-in-tostring">true</meta>
<column name="CREATEDDATE" length="26" />
</property>
<property name="updatedBy" type="string"><meta attribute="use-in-tostring">true</meta>
<column name="UPDATEDBY" length="50" />
</property>
</class>
</hibernate-mapping>
Code:
DAOFactory daoFactory = DAOFactory.getDAOFactory();
SessionStrategy sessionStrategy = SessionStrategyFactory.getSessionStrategy();
IdGenerator idGenerator = IdGeneratorFactory.getIdGenerator();
OutputDetailDAO outputDetailDAO = daoFactory.getOutputDetailDAO();
OutputDetail od = new OutputDetail();
String riskId = getTestProps().getProperty("riskId");
String riskIdRen = getTestProps().getProperty("riskIdRen");
String riskIdEnd = getTestProps().getProperty("riskIdEnd");
//BUILD RISKID
RiskId RiskId = new RiskId(riskId,riskIdRen,riskIdEnd);
//GET OUTPUT
OutputDAO outputDAO = DAOFactory.getDAOFactory().getOutputDAO();
Output Output = outputDAO.loadOutputByRiskId(RiskId);
//INSERT OUTPUT DETAIL
OutputDetail outputDetail = new OutputDetail();
outputDetail.setOutputDetailId(IdGeneratorFactory.getIdGenerator().generateGUID());
outputDetail.setOutput(Output);
outputDetail.setReceiverCode("TEST");
outputDetail.setZipcode("34202");
Output.getOutputDetails().add(outputDetail);
outputDetailDAO.insertOutputDetail(outputDetail);
sessionStrategy.commitTransaction();
Full stack trace of any exception that occurs:N/A
Name and version of the database you are using:DB2 8.2
The generated SQL (show_sql=true):Code:
20 Apr 2006 17:49:38,473 INFO [main] (HibernateUtil.java:112) - Query->HQL: FROM Output out WHERE out.Risk.id.riskId = :riskid AND out.Risk.id.riskIdRen = :riskidren AND out.Risk.id.riskIdEnd = :riskidend
20 Apr 2006 17:49:38,489 DEBUG [main] (AbstractBatcher.java:346) - select output0_.OUTPUTID as OUTPUTID26_, output0_.UPDATEDDATE as UPDATEDD2_26_, output0_.INSAGENTID as INSAGENTID26_, output0_.RISKID as RISKID26_, output0_.RISKIDREN as RISKIDREN26_, output0_.RISKIDEND as RISKIDEND26_, output0_.QUOTEID as QUOTEID26_, output0_.INSAGENCYID as INSAGENC8_26_, output0_.CUSTOMERID as CUSTOMERID26_, output0_.OUTPUTCODE as OUTPUTCODE26_, output0_.PRINTDATE as PRINTDATE26_, output0_.PRINTEDDATE as PRINTED12_26_, output0_.POSTINGDATE as POSTING13_26_, output0_.STATUS as STATUS26_, output0_.CREATEDBY as CREATEDBY26_, output0_.CREATEDDATE as CREATED16_26_, output0_.UPDATEDBY as UPDATEDBY26_ from DSN._OUTPUT output0_ where output0_.RISKID=? and output0_.RISKIDREN=? and output0_.RISKIDEND=?
20 Apr 2006 17:49:45,848 DEBUG [main] (AbstractBatcher.java:346) - select output0_.REFOUTPUTID as REFOUTPU2_1_, output0_.OUTPUTDETAILID as OUTPUTDE1_1_, output0_.OUTPUTDETAILID as OUTPUTDE1_15_0_, output0_.REFOUTPUTID as REFOUTPU2_15_0_, output0_.OUTPUTCODE as OUTPUTCODE15_0_, output0_.DATETOPRINT as DATETOPR4_15_0_, output0_.DATEPRINTED as DATEPRIN5_15_0_, output0_.RECEIVERTYPE as RECEIVER6_15_0_, output0_.RECEIVERCODE as RECEIVER7_15_0_, output0_.TRANSMITMETHOD as TRANSMIT8_15_0_, output0_.ZIPCODE as ZIPCODE15_0_, output0_.OUTPUTOBJECT as OUTPUTO10_15_0_ from DSN._OUTPUTDETAIL output0_ where output0_.REFOUTPUTID=?
20 Apr 2006 17:49:46,707 DEBUG [main] (AbstractBatcher.java:346) - select risk0_.RISKID as RISKID66_0_, risk0_.RISKIDREN as RISKIDREN66_0_, risk0_.RISKIDEND as RISKIDEND66_0_, risk0_.UPDATEDDATE as UPDATEDD4_66_0_, risk0_.COMPANYID as COMPANYID66_0_, risk0_.INSAGENTID as INSAGENTID66_0_, risk0_.USERID as USERID66_0_, risk0_.CUSTOMERID as CUSTOMERID66_0_, risk0_.ADDRESSID as ADDRESSID66_0_, risk0_.LOB as LOB66_0_, risk0_.CREATEDBY as CREATEDBY66_0_, risk0_.CREATEDDATE as CREATED12_66_0_, risk0_.UPDATEDBY as UPDATEDBY66_0_ from DSN._RISK risk0_ where risk0_.RISKID=? and risk0_.RISKIDREN=? and risk0_.RISKIDEND=?
20 Apr 2006 17:49:48,207 DEBUG [main] (AbstractBatcher.java:346) - select inscom0_.COMPANYID as COMPANYID60_0_, inscom0_.INSGROUPID as INSGROUPID60_0_, inscom0_.COMPANYCODE as COMPANYC3_60_0_, inscom0_.COMPANYNAME as COMPANYN4_60_0_, inscom0_.ADDRESSID as ADDRESSID60_0_, inscom0_.PHONEWORK as PHONEWORK60_0_, inscom0_.PHONEFAX as PHONEFAX60_0_, inscom0_.STATUS as STATUS60_0_, inscom0_.CREATEDBY as CREATEDBY60_0_, inscom0_.CREATEDDATE as CREATED10_60_0_, inscom0_.UPDATEDBY as UPDATEDBY60_0_, inscom0_.UPDATEDDATE as UPDATED12_60_0_, inscom0_.EMAILID as EMAILID60_0_, inscom0_.NAICS as NAICS60_0_, inscom0_.MFIND as MFIND60_0_ from DSN._INSCOMPANY inscom0_ where inscom0_.COMPANYID=?
20 Apr 2006 17:49:48,551 DEBUG [main] (AbstractBatcher.java:346) - select insgro0_.INSGROUPID as INSGROUPID80_0_, insgro0_.INSGROUPCODE as INSGROUP2_80_0_, insgro0_.INSGROUPNAME as INSGROUP3_80_0_, insgro0_.ADDRESSID as ADDRESSID80_0_, insgro0_.STATUS as STATUS80_0_, insgro0_.PHONEWORK as PHONEWORK80_0_, insgro0_.PHONEFAX as PHONEFAX80_0_, insgro0_.CREATEDBY as CREATEDBY80_0_, insgro0_.CREATEDDATE as CREATEDD9_80_0_, insgro0_.UPDATEDBY as UPDATEDBY80_0_, insgro0_.UPDATEDDATE as UPDATED11_80_0_ from DSN._INSGROUP insgro0_ where insgro0_.INSGROUPID=?
20 Apr 2006 17:49:48,738 DEBUG [main] (AbstractBatcher.java:346) - select addres0_.ADDRESSID as ADDRESSID1_0_, addres0_.ADDRESS1 as ADDRESS2_1_0_, addres0_.ADDRESS2 as ADDRESS3_1_0_, addres0_.ADDRESS3 as ADDRESS4_1_0_, addres0_.ADDRESSCITY as ADDRESSC5_1_0_, addres0_.ADDRESSSTATE as ADDRESSS6_1_0_, addres0_.ADDRESSZIP as ADDRESSZIP1_0_, addres0_.CREATEDBY as CREATEDBY1_0_, addres0_.CREATEDDATE as CREATEDD9_1_0_, addres0_.UPDATEDBY as UPDATEDBY1_0_, addres0_.UPDATEDDATE as UPDATED11_1_0_ from DSN._ADDRESS addres0_ where addres0_.ADDRESSID=?
20 Apr 2006 17:49:48,957 DEBUG [main] (AbstractBatcher.java:346) - select addres0_.ADDRESSID as ADDRESSID1_0_, addres0_.ADDRESS1 as ADDRESS2_1_0_, addres0_.ADDRESS2 as ADDRESS3_1_0_, addres0_.ADDRESS3 as ADDRESS4_1_0_, addres0_.ADDRESSCITY as ADDRESSC5_1_0_, addres0_.ADDRESSSTATE as ADDRESSS6_1_0_, addres0_.ADDRESSZIP as ADDRESSZIP1_0_, addres0_.CREATEDBY as CREATEDBY1_0_, addres0_.CREATEDDATE as CREATEDD9_1_0_, addres0_.UPDATEDBY as UPDATEDBY1_0_, addres0_.UPDATEDDATE as UPDATED11_1_0_ from DSN._ADDRESS addres0_ where addres0_.ADDRESSID=?
20 Apr 2006 17:49:49,160 DEBUG [main] (AbstractBatcher.java:346) - select inscom0_.INSAGENTID as INSAGENTID78_0_, inscom0_.USERID as USERID78_0_, inscom0_.ADDRESSID as ADDRESSID78_0_, inscom0_.PHONEHOME as PHONEHOME78_0_, inscom0_.PHONEWORK as PHONEWORK78_0_, inscom0_.PHONEFAX as PHONEFAX78_0_, inscom0_.EMAIL as EMAIL78_0_, inscom0_.SSN as SSN78_0_, inscom0_.LICENSE as LICENSE78_0_, inscom0_.LICENSESTATE as LICENSE10_78_0_, inscom0_.DOISTATUS as DOISTATUS78_0_, inscom0_.DOIDATE as DOIDATE78_0_, inscom0_.MARITALSTATUS as MARITAL13_78_0_, inscom0_.DOB as DOB78_0_, inscom0_.ACTIVE220 as ACTIVE15_78_0_, inscom0_.APPOINTMENTDATE as APPOINT16_78_0_, inscom0_.APPOINTMENTTYPE as APPOINT17_78_0_, inscom0_.COUNTY as COUNTY78_0_, inscom0_.PRIORAGENTID as PRIORAG19_78_0_, inscom0_.STATUS as STATUS78_0_, inscom0_.STATUSDATE as STATUSDATE78_0_, inscom0_.CREATEDBY as CREATEDBY78_0_, inscom0_.CREATEDDATE as CREATED23_78_0_, inscom0_.UPDATEDBY as UPDATEDBY78_0_, inscom0_.UPDATEDDATE as UPDATED25_78_0_, inscom0_.NPNBR as NPNBR78_0_ from DSN._INSCOMPAGENT inscom0_ where inscom0_.INSAGENTID=?
20 Apr 2006 17:49:49,192 DEBUG [main] (AbstractBatcher.java:346) - select userin0_.USERID as USERID58_0_, userin0_.INSGROUPID as INSGROUPID58_0_, userin0_.COMPANYID as COMPANYID58_0_, userin0_.VENDORID as VENDORID58_0_, userin0_.INSAGENCYID as INSAGENC5_58_0_, userin0_.LASTNAME as LASTNAME58_0_, userin0_.ULASTNAME as ULASTNAME58_0_, userin0_.FIRSTNAME as FIRSTNAME58_0_, userin0_.UFIRSTNAME as UFIRSTNAME58_0_, userin0_.MIDDLENAME as MIDDLENAME58_0_, userin0_.SALUTATIONNAME as SALUTAT11_58_0_, userin0_.SUFFIXNAME as SUFFIXNAME58_0_, userin0_.LOGINID as LOGINID58_0_, userin0_.PWD as PWD58_0_, userin0_.CHANGEPWD as CHANGEPWD58_0_, userin0_.NAMETYPE as NAMETYPE58_0_, userin0_.EMAIL as EMAIL58_0_, userin0_.STATUS as STATUS58_0_, userin0_.CREATEDBY as CREATEDBY58_0_, userin0_.CREATEDDATE as CREATED20_58_0_, userin0_.UPDATEDBY as UPDATEDBY58_0_, userin0_.UPDATEDDATE as UPDATED22_58_0_ from DSN._USERINFO userin0_ where userin0_.USERID=?
20 Apr 2006 17:49:50,067 DEBUG [main] (AbstractBatcher.java:346) - select insgro0_.INSGROUPID as INSGROUPID80_0_, insgro0_.INSGROUPCODE as INSGROUP2_80_0_, insgro0_.INSGROUPNAME as INSGROUP3_80_0_, insgro0_.ADDRESSID as ADDRESSID80_0_, insgro0_.STATUS as STATUS80_0_, insgro0_.PHONEWORK as PHONEWORK80_0_, insgro0_.PHONEFAX as PHONEFAX80_0_, insgro0_.CREATEDBY as CREATEDBY80_0_, insgro0_.CREATEDDATE as CREATEDD9_80_0_, insgro0_.UPDATEDBY as UPDATEDBY80_0_, insgro0_.UPDATEDDATE as UPDATED11_80_0_ from DSN._INSGROUP insgro0_ where insgro0_.INSGROUPID=?
20 Apr 2006 17:49:50,145 DEBUG [main] (AbstractBatcher.java:346) - select addres0_.ADDRESSID as ADDRESSID1_0_, addres0_.ADDRESS1 as ADDRESS2_1_0_, addres0_.ADDRESS2 as ADDRESS3_1_0_, addres0_.ADDRESS3 as ADDRESS4_1_0_, addres0_.ADDRESSCITY as ADDRESSC5_1_0_, addres0_.ADDRESSSTATE as ADDRESSS6_1_0_, addres0_.ADDRESSZIP as ADDRESSZIP1_0_, addres0_.CREATEDBY as CREATEDBY1_0_, addres0_.CREATEDDATE as CREATEDD9_1_0_, addres0_.UPDATEDBY as UPDATEDBY1_0_, addres0_.UPDATEDDATE as UPDATED11_1_0_ from DSN._ADDRESS addres0_ where addres0_.ADDRESSID=?
20 Apr 2006 17:49:50,348 DEBUG [main] (AbstractBatcher.java:346) - select inscom0_.COMPANYID as COMPANYID60_0_, inscom0_.INSGROUPID as INSGROUPID60_0_, inscom0_.COMPANYCODE as COMPANYC3_60_0_, inscom0_.COMPANYNAME as COMPANYN4_60_0_, inscom0_.ADDRESSID as ADDRESSID60_0_, inscom0_.PHONEWORK as PHONEWORK60_0_, inscom0_.PHONEFAX as PHONEFAX60_0_, inscom0_.STATUS as STATUS60_0_, inscom0_.CREATEDBY as CREATEDBY60_0_, inscom0_.CREATEDDATE as CREATED10_60_0_, inscom0_.UPDATEDBY as UPDATEDBY60_0_, inscom0_.UPDATEDDATE as UPDATED12_60_0_, inscom0_.EMAILID as EMAILID60_0_, inscom0_.NAICS as NAICS60_0_, inscom0_.MFIND as MFIND60_0_ from DSN._INSCOMPANY inscom0_ where inscom0_.COMPANYID=?
20 Apr 2006 17:49:50,551 DEBUG [main] (AbstractBatcher.java:346) - select vendor0_.VENDORID as VENDORID50_0_, vendor0_.USERID as USERID50_0_, vendor0_.MASTERVENDORID as MASTERVE3_50_0_, vendor0_.PHYSICALADDRESSID as PHYSICAL4_50_0_, vendor0_.MAILINGADDRESSID as MAILINGA5_50_0_, vendor0_.VENDORCODE as VENDORCODE50_0_, vendor0_.ENTITYTYPE as ENTITYTYPE50_0_, vendor0_.STATUS as STATUS50_0_, vendor0_.CONTACT as CONTACT50_0_, vendor0_.PHONEWORK as PHONEWORK50_0_, vendor0_.PHONEFAX as PHONEFAX50_0_, vendor0_.TAXCODE as TAXCODE50_0_, vendor0_.FEIN as FEIN50_0_, vendor0_.CREATEDBY as CREATEDBY50_0_, vendor0_.CREATEDDATE as CREATED15_50_0_, vendor0_.UPDATEDBY as UPDATEDBY50_0_, vendor0_.UPDATEDDATE as UPDATED17_50_0_, vendor0_.USERALPH1 as USERALPH18_50_0_, vendor0_.CATCONTACT as CATCONTACT50_0_, vendor0_.CATCONTACTPHONE as CATCONT20_50_0_, vendor0_.CATDEFAULTADJUSTER as CATDEFA21_50_0_ from DSN._VENDORS vendor0_ where vendor0_.VENDORID=?
20 Apr 2006 17:49:50,582 DEBUG [main] (AbstractBatcher.java:346) - select userin0_.USERID as USERID58_0_, userin0_.INSGROUPID as INSGROUPID58_0_, userin0_.COMPANYID as COMPANYID58_0_, userin0_.VENDORID as VENDORID58_0_, userin0_.INSAGENCYID as INSAGENC5_58_0_, userin0_.LASTNAME as LASTNAME58_0_, userin0_.ULASTNAME as ULASTNAME58_0_, userin0_.FIRSTNAME as FIRSTNAME58_0_, userin0_.UFIRSTNAME as UFIRSTNAME58_0_, userin0_.MIDDLENAME as MIDDLENAME58_0_, userin0_.SALUTATIONNAME as SALUTAT11_58_0_, userin0_.SUFFIXNAME as SUFFIXNAME58_0_, userin0_.LOGINID as LOGINID58_0_, userin0_.PWD as PWD58_0_, userin0_.CHANGEPWD as CHANGEPWD58_0_, userin0_.NAMETYPE as NAMETYPE58_0_, userin0_.EMAIL as EMAIL58_0_, userin0_.STATUS as STATUS58_0_, userin0_.CREATEDBY as CREATEDBY58_0_, userin0_.CREATEDDATE as CREATED20_58_0_, userin0_.UPDATEDBY as UPDATEDBY58_0_, userin0_.UPDATEDDATE as UPDATED22_58_0_ from DSN._USERINFO userin0_ where userin0_.USERID=?
Login
FAQ
Search
