HI,
I'm trying to save data from a JSF GUI via Java Beans and Hibernate to a MS-SQL DB.
In my DB are several fields which are are allowed to be null.
If I leave a text-field(null allowed in DB) empty in my gui hibernate enters an empty String ("") to the corresponding field in the DB table. So far so good.
But if I load this data set back to my gui, hibernate obviously interprets the empty string("") as a single space (" "). This is annoying, because this way I always have a space in my textfield. And this space will be saved to DB, exept it is removed by the user manually.
Am I doing anything wrong? How can I suppress this?
Hibernate version: 2.1.8
Full stack trace of any exception that occurs: none
Name and version of the database you are using: MS SQL 8
The generated SQL (show_sql=true): Have fun :) one field where my problem happens is e.g. STATEMENT_NR
Hibernate: select geneproper0_.GUID as GUID, geneproper0_.CODE as CODE, geneproper0_.VALUE as VALUE from GENE_PROPERTY geneproper0_ where (geneproper0_.CODE='kmRate' )
Hibernate: select accojourna0_.GUID as GUID, accojourna0_.JOURNALTYPE as JOURNALT2_, accojourna0_.ENTRYTYPE as ENTRYTYPE, accojourna0_.CODE as CODE, accojourna0_.DESCRIPTION as DESCRIPT5_, accojourna0_.DESCRIPTION_LONG as DESCRIPT6_, accojourna0_.DATE as DATE, accojourna0_.SUPPLIER as SUPPLIER, accojourna0_.INVOICE_DATE as INVOICE_9_, accojourna0_.INVOICE_NR as INVOICE_NR, accojourna0_.INVOICE_TEXT as INVOICE11_, accojourna0_.BOOKING_DATE as BOOKING12_, accojourna0_.MATURITY_DATE as MATURIT13_, accojourna0_.PRIORITY as PRIORITY, accojourna0_.REMINDER_DATE as REMINDE15_, accojourna0_.STATEMENT_NR as STATEME16_, accojourna0_.NET as NET, accojourna0_.VAT as VAT, accojourna0_.GROSS as GROSS, accojourna0_.IS_COMPANY_CAR as IS_COMP20_, accojourna0_.KM_AMOUNT as KM_AMOUNT, accojourna0_.KM_RATE as KM_RATE, accojourna0_.CITY_TO as CITY_TO, accojourna0_.PROJ_ORDER_DETAIL as PROJ_OR24_, accojourna0_.GENE_SUPPLIER as GENE_SU25_, accojourna0_.ACCO_TYPE as ACCO_TYPE, accojourna0_.GENE_CALC_TYPE as GENE_CA27_, accojourna0_.EMPL_EMPLOYEE_CAR as EMPL_EM28_, accojourna0_.GENE_VAT as GENE_VAT, accojourna0_.ACCO_BUDGET_DETAIL as ACCO_BU30_, accojourna0_.ACCO_BANK as ACCO_BANK from ACCO_JOURNAL accojourna0_ where (accojourna0_.CODE='B00000002' )
Listening for transport dt_shmem at address: tomcat_shared_memory_id
Hibernate: select projpropos0_.GUID as GUID11_, projpropos0_.ACTIVE as ACTIVE11_, projpropos0_.DESCRIPTION as DESCRIPT3_11_, projpropos0_.DESCRIPTION_LONG as DESCRIPT4_11_, projpropos0_.ACCORDING_EXPENSE as ACCORDIN5_11_, projpropos0_.PUG2 as PUG211_, projpropos0_.TACTICAL_CHARGE as TACTICAL7_11_, projpropos0_.PRICE as PRICE11_, projpropos0_.PROBABILITY as PROBABIL9_11_, projpropos0_.DATE_END as DATE_END11_, projpropos0_.PROJ_PROPOSAL_GROUP as PROJ_PR11_11_, projpropos0_.PROJ_DETAIL_STATUS as PROJ_DE12_11_, projpropos0_.PROJ_JOB as PROJ_JOB11_, projpropos0_.GENE_ITEM as GENE_ITEM11_, projpropos1_.GUID as GUID0_, projpropos1_.CODE as CODE0_, projpropos1_.DESCRIPTION as DESCRIPT3_0_, projpropos1_.PROJ_PROJECT as PROJ_PRO4_0_, projprojec2_.GUID as GUID1_, projprojec2_.CODE as CODE1_, projprojec2_.DESCRIPTION as DESCRIPT3_1_, projprojec2_.DATE_BEGIN as DATE_BEGIN1_, projprojec2_.DATE_END as DATE_END1_, projprojec2_.CUST_PARTNER as CUST_PAR6_1_, projprojec2_.CUST_CUSTOMER as CUST_CUS7_1_, custpartne3_.GUID as GUID2_, custpartne3_.ACTIVE as ACTIVE2_, custpartne3_.LASTNAME as LASTNAME2_, custpartne3_.FIRSTNAME as FIRSTNAME2_, custpartne3_.SALUTATION as SALUTATION2_, custpartne3_.JOB_POSITION as JOB_POSI6_2_, custpartne3_.TEL_WORK as TEL_WORK2_, custpartne3_.TEL_MOBILE as TEL_MOBILE2_, custpartne3_.FAX as FAX2_, custpartne3_.EMAIL as EMAIL2_, custpartne3_.CUST_CUSTOMER as CUST_CU11_2_, custcustom4_.GUID as GUID3_, custcustom4_.ACTIVE as ACTIVE3_, custcustom4_.CODE as CODE3_, custcustom4_.NAME as NAME3_, custcustom4_.NAME2 as NAME23_, custcustom4_.ABBREVIATION as ABBREVIA6_3_, custcustom4_.POSTAL_CODE as POSTAL_C7_3_, custcustom4_.STREET as STREET3_, custcustom4_.CITY as CITY3_, custcustom4_.COUNTRY as COUNTRY3_, custcustom4_.PAYMENT_TARGET as PAYMENT11_3_, custcustom4_.DISCOUNT as DISCOUNT3_, custcustom4_.BANK as BANK3_, custcustom4_.BANK_CODE as BANK_CODE3_, custcustom4_.ACCOUNT_NR as ACCOUNT_NR3_, custcustom4_.UID as UID3_, custcustom4_.IBAN as IBAN3_, custcustom4_.SWIFT as SWIFT3_, custcustom4_.CUSTOMER_SINCE as CUSTOME19_3_, custcustom4_.VAT as VAT3_, custcustom4_.EMPL_EMPLOYEE_CRM as EMPL_EM21_3_, custcustom4_.EMPL_EMPLOYEE_PAR as EMPL_EM22_3_, emplemploy5_.GUID as GUID4_, emplemploy5_.ACTIVE as ACTIVE4_, emplemploy5_.CODE as CODE4_, emplemploy5_.LASTNAME as LASTNAME4_, emplemploy5_.FIRSTNAME as FIRSTNAME4_, emplemploy5_.EMAIL as EMAIL4_, emplemploy5_.DESCRIPTION_LONG as DESCRIPT7_4_, emplemploy5_.GENE_CONFESSION as GENE_CON8_4_, geneconfes6_.GUID as GUID5_, geneconfes6_.CODE as CODE5_, geneconfes6_.DESCRIPTION as DESCRIPT3_5_, projdetail7_.GUID as GUID6_, projdetail7_.CODE as CODE6_, projdetail7_.DESCRIPTION as DESCRIPT3_6_, projjob8_.GUID as GUID7_, projjob8_.CODE as CODE7_, projjob8_.DESCRIPTION as DESCRIPT3_7_, projjob8_.DESCRIPTION_LONG as DESCRIPT4_7_, projjob8_.DATE_BEGIN as DATE_BEGIN7_, projjob8_.DATE_END as DATE_END7_, projjob8_.ACTIVE as ACTIVE7_, projjob8_.PROBABILITY as PROBABIL8_7_, projjob8_.PROPOSAL_DATE as PROPOSAL9_7_, projjob8_.GENE_COMPCENTER as GENE_CO10_7_, projjob8_.CUST_PARTNER as CUST_PA11_7_, projjob8_.EMPL_EMPLOYEE as EMPL_EM12_7_, projjob8_.PROJ_PROJECT as PROJ_PR13_7_, genecompce9_.GUID as GUID8_, genecompce9_.CODE as CODE8_, genecompce9_.DESCRIPTION as DESCRIPT3_8_, geneitem10_.GUID as GUID9_, geneitem10_.CODE as CODE9_, geneitem10_.DESCRIPTION as DESCRIPT3_9_, geneitem10_.DESCRIPTION_LONG as DESCRIPT4_9_, geneitem10_.GENE_COMPCENTER as GENE_COM5_9_, genecompce11_.GUID as GUID10_, genecompce11_.CODE as CODE10_, genecompce11_.DESCRIPTION as DESCRIPT3_10_ from PROJ_PROPOSAL_DETAIL projpropos0_ left outer join PROJ_PROPOSAL_GROUP projpropos1_ on projpropos0_.PROJ_PROPOSAL_GROUP=projpropos1_.GUID left outer join PROJ_PROJECT projprojec2_ on projpropos1_.PROJ_PROJECT=projprojec2_.GUID left outer join CUST_PARTNER custpartne3_ on projprojec2_.CUST_PARTNER=custpartne3_.GUID left outer join CUST_CUSTOMER custcustom4_ on custpartne3_.CUST_CUSTOMER=custcustom4_.GUID left outer join EMPL_EMPLOYEE emplemploy5_ on custcustom4_.EMPL_EMPLOYEE_CRM=emplemploy5_.GUID left outer join GENE_CONFESSION geneconfes6_ on emplemploy5_.GENE_CONFESSION=geneconfes6_.GUID left outer join PROJ_DETAIL_STATUS projdetail7_ on projpropos0_.PROJ_DETAIL_STATUS=projdetail7_.GUID left outer join PROJ_JOB projjob8_ on projpropos0_.PROJ_JOB=projjob8_.GUID left outer join GENE_COMPCENTER genecompce9_ on projjob8_.GENE_COMPCENTER=genecompce9_.GUID left outer join GENE_ITEM geneitem10_ on projpropos0_.GENE_ITEM=geneitem10_.GUID left outer join GENE_COMPCENTER genecompce11_ on geneitem10_.GENE_COMPCENTER=genecompce11_.GUID where projpropos0_.GUID=?
Hibernate: select projprojec0_.GUID as GUID4_, projprojec0_.CODE as CODE4_, projprojec0_.DESCRIPTION as DESCRIPT3_4_, projprojec0_.DATE_BEGIN as DATE_BEGIN4_, projprojec0_.DATE_END as DATE_END4_, projprojec0_.CUST_PARTNER as CUST_PAR6_4_, projprojec0_.CUST_CUSTOMER as CUST_CUS7_4_, custpartne1_.GUID as GUID0_, custpartne1_.ACTIVE as ACTIVE0_, custpartne1_.LASTNAME as LASTNAME0_, custpartne1_.FIRSTNAME as FIRSTNAME0_, custpartne1_.SALUTATION as SALUTATION0_, custpartne1_.JOB_POSITION as JOB_POSI6_0_, custpartne1_.TEL_WORK as TEL_WORK0_, custpartne1_.TEL_MOBILE as TEL_MOBILE0_, custpartne1_.FAX as FAX0_, custpartne1_.EMAIL as EMAIL0_, custpartne1_.CUST_CUSTOMER as CUST_CU11_0_, custcustom2_.GUID as GUID1_, custcustom2_.ACTIVE as ACTIVE1_, custcustom2_.CODE as CODE1_, custcustom2_.NAME as NAME1_, custcustom2_.NAME2 as NAME21_, custcustom2_.ABBREVIATION as ABBREVIA6_1_, custcustom2_.POSTAL_CODE as POSTAL_C7_1_, custcustom2_.STREET as STREET1_, custcustom2_.CITY as CITY1_, custcustom2_.COUNTRY as COUNTRY1_, custcustom2_.PAYMENT_TARGET as PAYMENT11_1_, custcustom2_.DISCOUNT as DISCOUNT1_, custcustom2_.BANK as BANK1_, custcustom2_.BANK_CODE as BANK_CODE1_, custcustom2_.ACCOUNT_NR as ACCOUNT_NR1_, custcustom2_.UID as UID1_, custcustom2_.IBAN as IBAN1_, custcustom2_.SWIFT as SWIFT1_, custcustom2_.CUSTOMER_SINCE as CUSTOME19_1_, custcustom2_.VAT as VAT1_, custcustom2_.EMPL_EMPLOYEE_CRM as EMPL_EM21_1_, custcustom2_.EMPL_EMPLOYEE_PAR as EMPL_EM22_1_, emplemploy3_.GUID as GUID2_, emplemploy3_.ACTIVE as ACTIVE2_, emplemploy3_.CODE as CODE2_, emplemploy3_.LASTNAME as LASTNAME2_, emplemploy3_.FIRSTNAME as FIRSTNAME2_, emplemploy3_.EMAIL as EMAIL2_, emplemploy3_.DESCRIPTION_LONG as DESCRIPT7_2_, emplemploy3_.GENE_CONFESSION as GENE_CON8_2_, geneconfes4_.GUID as GUID3_, geneconfes4_.CODE as CODE3_, geneconfes4_.DESCRIPTION as DESCRIPT3_3_ from PROJ_PROJECT projprojec0_ left outer join CUST_PARTNER custpartne1_ on projprojec0_.CUST_PARTNER=custpartne1_.GUID left outer join CUST_CUSTOMER custcustom2_ on custpartne1_.CUST_CUSTOMER=custcustom2_.GUID left outer join EMPL_EMPLOYEE emplemploy3_ on custcustom2_.EMPL_EMPLOYEE_CRM=emplemploy3_.GUID left outer join GENE_CONFESSION geneconfes4_ on emplemploy3_.GENE_CONFESSION=geneconfes4_.GUID where projprojec0_.GUID=?
Hibernate: select custcustom0_.GUID as GUID2_, custcustom0_.ACTIVE as ACTIVE2_, custcustom0_.CODE as CODE2_, custcustom0_.NAME as NAME2_, custcustom0_.NAME2 as NAME22_, custcustom0_.ABBREVIATION as ABBREVIA6_2_, custcustom0_.POSTAL_CODE as POSTAL_C7_2_, custcustom0_.STREET as STREET2_, custcustom0_.CITY as CITY2_, custcustom0_.COUNTRY as COUNTRY2_, custcustom0_.PAYMENT_TARGET as PAYMENT11_2_, custcustom0_.DISCOUNT as DISCOUNT2_, custcustom0_.BANK as BANK2_, custcustom0_.BANK_CODE as BANK_CODE2_, custcustom0_.ACCOUNT_NR as ACCOUNT_NR2_, custcustom0_.UID as UID2_, custcustom0_.IBAN as IBAN2_, custcustom0_.SWIFT as SWIFT2_, custcustom0_.CUSTOMER_SINCE as CUSTOME19_2_, custcustom0_.VAT as VAT2_, custcustom0_.EMPL_EMPLOYEE_CRM as EMPL_EM21_2_, custcustom0_.EMPL_EMPLOYEE_PAR as EMPL_EM22_2_, emplemploy1_.GUID as GUID0_, emplemploy1_.ACTIVE as ACTIVE0_, emplemploy1_.CODE as CODE0_, emplemploy1_.LASTNAME as LASTNAME0_, emplemploy1_.FIRSTNAME as FIRSTNAME0_, emplemploy1_.EMAIL as EMAIL0_, emplemploy1_.DESCRIPTION_LONG as DESCRIPT7_0_, emplemploy1_.GENE_CONFESSION as GENE_CON8_0_, geneconfes2_.GUID as GUID1_, geneconfes2_.CODE as CODE1_, geneconfes2_.DESCRIPTION as DESCRIPT3_1_ from CUST_CUSTOMER custcustom0_ left outer join EMPL_EMPLOYEE emplemploy1_ on custcustom0_.EMPL_EMPLOYEE_CRM=emplemploy1_.GUID left outer join GENE_CONFESSION geneconfes2_ on emplemploy1_.GENE_CONFESSION=geneconfes2_.GUID where custcustom0_.GUID=?
Hibernate: select genevat0_.GUID as GUID0_, genevat0_.CODE as CODE0_, genevat0_.VAT as VAT0_ from GENE_VAT genevat0_ where genevat0_.GUID=?
DEBUG [07 Apr 2005 14:09:17,296] (com.fit.core.faces.journalentry.JournalentryDetail:160) load() -> guid:a0000000b0000000c0000003d0000002
Hibernate: select projjob0_.GUID as GUID6_, projjob0_.CODE as CODE6_, projjob0_.DESCRIPTION as DESCRIPT3_6_, projjob0_.DESCRIPTION_LONG as DESCRIPT4_6_, projjob0_.DATE_BEGIN as DATE_BEGIN6_, projjob0_.DATE_END as DATE_END6_, projjob0_.ACTIVE as ACTIVE6_, projjob0_.PROBABILITY as PROBABIL8_6_, projjob0_.PROPOSAL_DATE as PROPOSAL9_6_, projjob0_.GENE_COMPCENTER as GENE_CO10_6_, projjob0_.CUST_PARTNER as CUST_PA11_6_, projjob0_.EMPL_EMPLOYEE as EMPL_EM12_6_, projjob0_.PROJ_PROJECT as PROJ_PR13_6_, genecompce1_.GUID as GUID0_, genecompce1_.CODE as CODE0_, genecompce1_.DESCRIPTION as DESCRIPT3_0_, custpartne2_.GUID as GUID1_, custpartne2_.ACTIVE as ACTIVE1_, custpartne2_.LASTNAME as LASTNAME1_, custpartne2_.FIRSTNAME as FIRSTNAME1_, custpartne2_.SALUTATION as SALUTATION1_, custpartne2_.JOB_POSITION as JOB_POSI6_1_, custpartne2_.TEL_WORK as TEL_WORK1_, custpartne2_.TEL_MOBILE as TEL_MOBILE1_, custpartne2_.FAX as FAX1_, custpartne2_.EMAIL as EMAIL1_, custpartne2_.CUST_CUSTOMER as CUST_CU11_1_, custcustom3_.GUID as GUID2_, custcustom3_.ACTIVE as ACTIVE2_, custcustom3_.CODE as CODE2_, custcustom3_.NAME as NAME2_, custcustom3_.NAME2 as NAME22_, custcustom3_.ABBREVIATION as ABBREVIA6_2_, custcustom3_.POSTAL_CODE as POSTAL_C7_2_, custcustom3_.STREET as STREET2_, custcustom3_.CITY as CITY2_, custcustom3_.COUNTRY as COUNTRY2_, custcustom3_.PAYMENT_TARGET as PAYMENT11_2_, custcustom3_.DISCOUNT as DISCOUNT2_, custcustom3_.BANK as BANK2_, custcustom3_.BANK_CODE as BANK_CODE2_, custcustom3_.ACCOUNT_NR as ACCOUNT_NR2_, custcustom3_.UID as UID2_, custcustom3_.IBAN as IBAN2_, custcustom3_.SWIFT as SWIFT2_, custcustom3_.CUSTOMER_SINCE as CUSTOME19_2_, custcustom3_.VAT as VAT2_, custcustom3_.EMPL_EMPLOYEE_CRM as EMPL_EM21_2_, custcustom3_.EMPL_EMPLOYEE_PAR as EMPL_EM22_2_, emplemploy4_.GUID as GUID3_, emplemploy4_.ACTIVE as ACTIVE3_, emplemploy4_.CODE as CODE3_, emplemploy4_.LASTNAME as LASTNAME3_, emplemploy4_.FIRSTNAME as FIRSTNAME3_, emplemploy4_.EMAIL as EMAIL3_, emplemploy4_.DESCRIPTION_LONG as DESCRIPT7_3_, emplemploy4_.GENE_CONFESSION as GENE_CON8_3_, geneconfes5_.GUID as GUID4_, geneconfes5_.CODE as CODE4_, geneconfes5_.DESCRIPTION as DESCRIPT3_4_, projprojec6_.GUID as GUID5_, projprojec6_.CODE as CODE5_, projprojec6_.DESCRIPTION as DESCRIPT3_5_, projprojec6_.DATE_BEGIN as DATE_BEGIN5_, projprojec6_.DATE_END as DATE_END5_, projprojec6_.CUST_PARTNER as CUST_PAR6_5_, projprojec6_.CUST_CUSTOMER as CUST_CUS7_5_ from PROJ_JOB projjob0_ left outer join GENE_COMPCENTER genecompce1_ on projjob0_.GENE_COMPCENTER=genecompce1_.GUID left outer join CUST_PARTNER custpartne2_ on projjob0_.CUST_PARTNER=custpartne2_.GUID left outer join CUST_CUSTOMER custcustom3_ on custpartne2_.CUST_CUSTOMER=custcustom3_.GUID left outer join EMPL_EMPLOYEE emplemploy4_ on custcustom3_.EMPL_EMPLOYEE_CRM=emplemploy4_.GUID left outer join GENE_CONFESSION geneconfes5_ on emplemploy4_.GENE_CONFESSION=geneconfes5_.GUID left outer join PROJ_PROJECT projprojec6_ on projjob0_.PROJ_PROJECT=projprojec6_.GUID where projjob0_.GUID=?
Hibernate: select custcustom0_.GUID as GUID2_, custcustom0_.ACTIVE as ACTIVE2_, custcustom0_.CODE as CODE2_, custcustom0_.NAME as NAME2_, custcustom0_.NAME2 as NAME22_, custcustom0_.ABBREVIATION as ABBREVIA6_2_, custcustom0_.POSTAL_CODE as POSTAL_C7_2_, custcustom0_.STREET as STREET2_, custcustom0_.CITY as CITY2_, custcustom0_.COUNTRY as COUNTRY2_, custcustom0_.PAYMENT_TARGET as PAYMENT11_2_, custcustom0_.DISCOUNT as DISCOUNT2_, custcustom0_.BANK as BANK2_, custcustom0_.BANK_CODE as BANK_CODE2_, custcustom0_.ACCOUNT_NR as ACCOUNT_NR2_, custcustom0_.UID as UID2_, custcustom0_.IBAN as IBAN2_, custcustom0_.SWIFT as SWIFT2_, custcustom0_.CUSTOMER_SINCE as CUSTOME19_2_, custcustom0_.VAT as VAT2_, custcustom0_.EMPL_EMPLOYEE_CRM as EMPL_EM21_2_, custcustom0_.EMPL_EMPLOYEE_PAR as EMPL_EM22_2_, emplemploy1_.GUID as GUID0_, emplemploy1_.ACTIVE as ACTIVE0_, emplemploy1_.CODE as CODE0_, emplemploy1_.LASTNAME as LASTNAME0_, emplemploy1_.FIRSTNAME as FIRSTNAME0_, emplemploy1_.EMAIL as EMAIL0_, emplemploy1_.DESCRIPTION_LONG as DESCRIPT7_0_, emplemploy1_.GENE_CONFESSION as GENE_CON8_0_, geneconfes2_.GUID as GUID1_, geneconfes2_.CODE as CODE1_, geneconfes2_.DESCRIPTION as DESCRIPT3_1_ from CUST_CUSTOMER custcustom0_ left outer join EMPL_EMPLOYEE emplemploy1_ on custcustom0_.EMPL_EMPLOYEE_CRM=emplemploy1_.GUID left outer join GENE_CONFESSION geneconfes2_ on emplemploy1_.GENE_CONFESSION=geneconfes2_.GUID where custcustom0_.GUID=?
Hibernate: select projpropos0_.PROJ_JOB as PROJ_JOB__, projpropos0_.GUID as GUID__, projpropos0_.GUID as GUID9_, projpropos0_.ACTIVE as ACTIVE9_, projpropos0_.DESCRIPTION as DESCRIPT3_9_, projpropos0_.DESCRIPTION_LONG as DESCRIPT4_9_, projpropos0_.ACCORDING_EXPENSE as ACCORDIN5_9_, projpropos0_.PUG2 as PUG29_, projpropos0_.TACTICAL_CHARGE as TACTICAL7_9_, projpropos0_.PRICE as PRICE9_, projpropos0_.PROBABILITY as PROBABIL9_9_, projpropos0_.DATE_END as DATE_END9_, projpropos0_.PROJ_PROPOSAL_GROUP as PROJ_PR11_9_, projpropos0_.PROJ_DETAIL_STATUS as PROJ_DE12_9_, projpropos0_.PROJ_JOB as PROJ_JOB9_, projpropos0_.GENE_ITEM as GENE_ITEM9_, projpropos1_.GUID as GUID0_, projpropos1_.CODE as CODE0_, projpropos1_.DESCRIPTION as DESCRIPT3_0_, projpropos1_.PROJ_PROJECT as PROJ_PRO4_0_, projprojec2_.GUID as GUID1_, projprojec2_.CODE as CODE1_, projprojec2_.DESCRIPTION as DESCRIPT3_1_, projprojec2_.DATE_BEGIN as DATE_BEGIN1_, projprojec2_.DATE_END as DATE_END1_, projprojec2_.CUST_PARTNER as CUST_PAR6_1_, projprojec2_.CUST_CUSTOMER as CUST_CUS7_1_, custpartne3_.GUID as GUID2_, custpartne3_.ACTIVE as ACTIVE2_, custpartne3_.LASTNAME as LASTNAME2_, custpartne3_.FIRSTNAME as FIRSTNAME2_, custpartne3_.SALUTATION as SALUTATION2_, custpartne3_.JOB_POSITION as JOB_POSI6_2_, custpartne3_.TEL_WORK as TEL_WORK2_, custpartne3_.TEL_MOBILE as TEL_MOBILE2_, custpartne3_.FAX as FAX2_, custpartne3_.EMAIL as EMAIL2_, custpartne3_.CUST_CUSTOMER as CUST_CU11_2_, custcustom4_.GUID as GUID3_, custcustom4_.ACTIVE as ACTIVE3_, custcustom4_.CODE as CODE3_, custcustom4_.NAME as NAME3_, custcustom4_.NAME2 as NAME23_, custcustom4_.ABBREVIATION as ABBREVIA6_3_, custcustom4_.POSTAL_CODE as POSTAL_C7_3_, custcustom4_.STREET as STREET3_, custcustom4_.CITY as CITY3_, custcustom4_.COUNTRY as COUNTRY3_, custcustom4_.PAYMENT_TARGET as PAYMENT11_3_, custcustom4_.DISCOUNT as DISCOUNT3_, custcustom4_.BANK as BANK3_, custcustom4_.BANK_CODE as BANK_CODE3_, custcustom4_.ACCOUNT_NR as ACCOUNT_NR3_, custcustom4_.UID as UID3_, custcustom4_.IBAN as IBAN3_, custcustom4_.SWIFT as SWIFT3_, custcustom4_.CUSTOMER_SINCE as CUSTOME19_3_, custcustom4_.VAT as VAT3_, custcustom4_.EMPL_EMPLOYEE_CRM as EMPL_EM21_3_, custcustom4_.EMPL_EMPLOYEE_PAR as EMPL_EM22_3_, emplemploy5_.GUID as GUID4_, emplemploy5_.ACTIVE as ACTIVE4_, emplemploy5_.CODE as CODE4_, emplemploy5_.LASTNAME as LASTNAME4_, emplemploy5_.FIRSTNAME as FIRSTNAME4_, emplemploy5_.EMAIL as EMAIL4_, emplemploy5_.DESCRIPTION_LONG as DESCRIPT7_4_, emplemploy5_.GENE_CONFESSION as GENE_CON8_4_, geneconfes6_.GUID as GUID5_, geneconfes6_.CODE as CODE5_, geneconfes6_.DESCRIPTION as DESCRIPT3_5_, projdetail7_.GUID as GUID6_, projdetail7_.CODE as CODE6_, projdetail7_.DESCRIPTION as DESCRIPT3_6_, geneitem8_.GUID as GUID7_, geneitem8_.CODE as CODE7_, geneitem8_.DESCRIPTION as DESCRIPT3_7_, geneitem8_.DESCRIPTION_LONG as DESCRIPT4_7_, geneitem8_.GENE_COMPCENTER as GENE_COM5_7_, genecompce9_.GUID as GUID8_, genecompce9_.CODE as CODE8_, genecompce9_.DESCRIPTION as DESCRIPT3_8_ from PROJ_PROPOSAL_DETAIL projpropos0_ left outer join PROJ_PROPOSAL_GROUP projpropos1_ on projpropos0_.PROJ_PROPOSAL_GROUP=projpropos1_.GUID left outer join PROJ_PROJECT projprojec2_ on projpropos1_.PROJ_PROJECT=projprojec2_.GUID left outer join CUST_PARTNER custpartne3_ on projprojec2_.CUST_PARTNER=custpartne3_.GUID left outer join CUST_CUSTOMER custcustom4_ on custpartne3_.CUST_CUSTOMER=custcustom4_.GUID left outer join EMPL_EMPLOYEE emplemploy5_ on custcustom4_.EMPL_EMPLOYEE_CRM=emplemploy5_.GUID left outer join GENE_CONFESSION geneconfes6_ on emplemploy5_.GENE_CONFESSION=geneconfes6_.GUID left outer join PROJ_DETAIL_STATUS projdetail7_ on projpropos0_.PROJ_DETAIL_STATUS=projdetail7_.GUID left outer join GENE_ITEM geneitem8_ on projpropos0_.GENE_ITEM=geneitem8_.GUID left outer join GENE_COMPCENTER genecompce9_ on geneitem8_.GENE_COMPCENTER=genecompce9_.GUID where projpropos0_.PROJ_JOB=?
Hibernate: select projjob0_.GUID as GUID6_, projjob0_.CODE as CODE6_, projjob0_.DESCRIPTION as DESCRIPT3_6_, projjob0_.DESCRIPTION_LONG as DESCRIPT4_6_, projjob0_.DATE_BEGIN as DATE_BEGIN6_, projjob0_.DATE_END as DATE_END6_, projjob0_.ACTIVE as ACTIVE6_, projjob0_.PROBABILITY as PROBABIL8_6_, projjob0_.PROPOSAL_DATE as PROPOSAL9_6_, projjob0_.GENE_COMPCENTER as GENE_CO10_6_, projjob0_.CUST_PARTNER as CUST_PA11_6_, projjob0_.EMPL_EMPLOYEE as EMPL_EM12_6_, projjob0_.PROJ_PROJECT as PROJ_PR13_6_, genecompce1_.GUID as GUID0_, genecompce1_.CODE as CODE0_, genecompce1_.DESCRIPTION as DESCRIPT3_0_, custpartne2_.GUID as GUID1_, custpartne2_.ACTIVE as ACTIVE1_, custpartne2_.LASTNAME as LASTNAME1_, custpartne2_.FIRSTNAME as FIRSTNAME1_, custpartne2_.SALUTATION as SALUTATION1_, custpartne2_.JOB_POSITION as JOB_POSI6_1_, custpartne2_.TEL_WORK as TEL_WORK1_, custpartne2_.TEL_MOBILE as TEL_MOBILE1_, custpartne2_.FAX as FAX1_, custpartne2_.EMAIL as EMAIL1_, custpartne2_.CUST_CUSTOMER as CUST_CU11_1_, custcustom3_.GUID as GUID2_, custcustom3_.ACTIVE as ACTIVE2_, custcustom3_.CODE as CODE2_, custcustom3_.NAME as NAME2_, custcustom3_.NAME2 as NAME22_, custcustom3_.ABBREVIATION as ABBREVIA6_2_, custcustom3_.POSTAL_CODE as POSTAL_C7_2_, custcustom3_.STREET as STREET2_, custcustom3_.CITY as CITY2_, custcustom3_.COUNTRY as COUNTRY2_, custcustom3_.PAYMENT_TARGET as PAYMENT11_2_, custcustom3_.DISCOUNT as DISCOUNT2_, custcustom3_.BANK as BANK2_, custcustom3_.BANK_CODE as BANK_CODE2_, custcustom3_.ACCOUNT_NR as ACCOUNT_NR2_, custcustom3_.UID as UID2_, custcustom3_.IBAN as IBAN2_, custcustom3_.SWIFT as SWIFT2_, custcustom3_.CUSTOMER_SINCE as CUSTOME19_2_, custcustom3_.VAT as VAT2_, custcustom3_.EMPL_EMPLOYEE_CRM as EMPL_EM21_2_, custcustom3_.EMPL_EMPLOYEE_PAR as EMPL_EM22_2_, emplemploy4_.GUID as GUID3_, emplemploy4_.ACTIVE as ACTIVE3_, emplemploy4_.CODE as CODE3_, emplemploy4_.LASTNAME as LASTNAME3_, emplemploy4_.FIRSTNAME as FIRSTNAME3_, emplemploy4_.EMAIL as EMAIL3_, emplemploy4_.DESCRIPTION_LONG as DESCRIPT7_3_, emplemploy4_.GENE_CONFESSION as GENE_CON8_3_, geneconfes5_.GUID as GUID4_, geneconfes5_.CODE as CODE4_, geneconfes5_.DESCRIPTION as DESCRIPT3_4_, projprojec6_.GUID as GUID5_, projprojec6_.CODE as CODE5_, projprojec6_.DESCRIPTION as DESCRIPT3_5_, projprojec6_.DATE_BEGIN as DATE_BEGIN5_, projprojec6_.DATE_END as DATE_END5_, projprojec6_.CUST_PARTNER as CUST_PAR6_5_, projprojec6_.CUST_CUSTOMER as CUST_CUS7_5_ from PROJ_JOB projjob0_ left outer join GENE_COMPCENTER genecompce1_ on projjob0_.GENE_COMPCENTER=genecompce1_.GUID left outer join CUST_PARTNER custpartne2_ on projjob0_.CUST_PARTNER=custpartne2_.GUID left outer join CUST_CUSTOMER custcustom3_ on custpartne2_.CUST_CUSTOMER=custcustom3_.GUID left outer join EMPL_EMPLOYEE emplemploy4_ on custcustom3_.EMPL_EMPLOYEE_CRM=emplemploy4_.GUID left outer join GENE_CONFESSION geneconfes5_ on emplemploy4_.GENE_CONFESSION=geneconfes5_.GUID left outer join PROJ_PROJECT projprojec6_ on projjob0_.PROJ_PROJECT=projprojec6_.GUID where projjob0_.GUID=?
Hibernate: select custcustom0_.GUID as GUID2_, custcustom0_.ACTIVE as ACTIVE2_, custcustom0_.CODE as CODE2_, custcustom0_.NAME as NAME2_, custcustom0_.NAME2 as NAME22_, custcustom0_.ABBREVIATION as ABBREVIA6_2_, custcustom0_.POSTAL_CODE as POSTAL_C7_2_, custcustom0_.STREET as STREET2_, custcustom0_.CITY as CITY2_, custcustom0_.COUNTRY as COUNTRY2_, custcustom0_.PAYMENT_TARGET as PAYMENT11_2_, custcustom0_.DISCOUNT as DISCOUNT2_, custcustom0_.BANK as BANK2_, custcustom0_.BANK_CODE as BANK_CODE2_, custcustom0_.ACCOUNT_NR as ACCOUNT_NR2_, custcustom0_.UID as UID2_, custcustom0_.IBAN as IBAN2_, custcustom0_.SWIFT as SWIFT2_, custcustom0_.CUSTOMER_SINCE as CUSTOME19_2_, custcustom0_.VAT as VAT2_, custcustom0_.EMPL_EMPLOYEE_CRM as EMPL_EM21_2_, custcustom0_.EMPL_EMPLOYEE_PAR as EMPL_EM22_2_, emplemploy1_.GUID as GUID0_, emplemploy1_.ACTIVE as ACTIVE0_, emplemploy1_.CODE as CODE0_, emplemploy1_.LASTNAME as LASTNAME0_, emplemploy1_.FIRSTNAME as FIRSTNAME0_, emplemploy1_.EMAIL as EMAIL0_, emplemploy1_.DESCRIPTION_LONG as DESCRIPT7_0_, emplemploy1_.GENE_CONFESSION as GENE_CON8_0_, geneconfes2_.GUID as GUID1_, geneconfes2_.CODE as CODE1_, geneconfes2_.DESCRIPTION as DESCRIPT3_1_ from CUST_CUSTOMER custcustom0_ left outer join EMPL_EMPLOYEE emplemploy1_ on custcustom0_.EMPL_EMPLOYEE_CRM=emplemploy1_.GUID left outer join GENE_CONFESSION geneconfes2_ on emplemploy1_.GENE_CONFESSION=geneconfes2_.GUID where custcustom0_.GUID=?
Hibernate: select projpropos0_.PROJ_JOB as PROJ_JOB__, projpropos0_.GUID as GUID__, projpropos0_.GUID as GUID9_, projpropos0_.ACTIVE as ACTIVE9_, projpropos0_.DESCRIPTION as DESCRIPT3_9_, projpropos0_.DESCRIPTION_LONG as DESCRIPT4_9_, projpropos0_.ACCORDING_EXPENSE as ACCORDIN5_9_, projpropos0_.PUG2 as PUG29_, projpropos0_.TACTICAL_CHARGE as TACTICAL7_9_, projpropos0_.PRICE as PRICE9_, projpropos0_.PROBABILITY as PROBABIL9_9_, projpropos0_.DATE_END as DATE_END9_, projpropos0_.PROJ_PROPOSAL_GROUP as PROJ_PR11_9_, projpropos0_.PROJ_DETAIL_STATUS as PROJ_DE12_9_, projpropos0_.PROJ_JOB as PROJ_JOB9_, projpropos0_.GENE_ITEM as GENE_ITEM9_, projpropos1_.GUID as GUID0_, projpropos1_.CODE as CODE0_, projpropos1_.DESCRIPTION as DESCRIPT3_0_, projpropos1_.PROJ_PROJECT as PROJ_PRO4_0_, projprojec2_.GUID as GUID1_, projprojec2_.CODE as CODE1_, projprojec2_.DESCRIPTION as DESCRIPT3_1_, projprojec2_.DATE_BEGIN as DATE_BEGIN1_, projprojec2_.DATE_END as DATE_END1_, projprojec2_.CUST_PARTNER as CUST_PAR6_1_, projprojec2_.CUST_CUSTOMER as CUST_CUS7_1_, custpartne3_.GUID as GUID2_, custpartne3_.ACTIVE as ACTIVE2_, custpartne3_.LASTNAME as LASTNAME2_, custpartne3_.FIRSTNAME as FIRSTNAME2_, custpartne3_.SALUTATION as SALUTATION2_, custpartne3_.JOB_POSITION as JOB_POSI6_2_, custpartne3_.TEL_WORK as TEL_WORK2_, custpartne3_.TEL_MOBILE as TEL_MOBILE2_, custpartne3_.FAX as FAX2_, custpartne3_.EMAIL as EMAIL2_, custpartne3_.CUST_CUSTOMER as CUST_CU11_2_, custcustom4_.GUID as GUID3_, custcustom4_.ACTIVE as ACTIVE3_, custcustom4_.CODE as CODE3_, custcustom4_.NAME as NAME3_, custcustom4_.NAME2 as NAME23_, custcustom4_.ABBREVIATION as ABBREVIA6_3_, custcustom4_.POSTAL_CODE as POSTAL_C7_3_, custcustom4_.STREET as STREET3_, custcustom4_.CITY as CITY3_, custcustom4_.COUNTRY as COUNTRY3_, custcustom4_.PAYMENT_TARGET as PAYMENT11_3_, custcustom4_.DISCOUNT as DISCOUNT3_, custcustom4_.BANK as BANK3_, custcustom4_.BANK_CODE as BANK_CODE3_, custcustom4_.ACCOUNT_NR as ACCOUNT_NR3_, custcustom4_.UID as UID3_, custcustom4_.IBAN as IBAN3_, custcustom4_.SWIFT as SWIFT3_, custcustom4_.CUSTOMER_SINCE as CUSTOME19_3_, custcustom4_.VAT as VAT3_, custcustom4_.EMPL_EMPLOYEE_CRM as EMPL_EM21_3_, custcustom4_.EMPL_EMPLOYEE_PAR as EMPL_EM22_3_, emplemploy5_.GUID as GUID4_, emplemploy5_.ACTIVE as ACTIVE4_, emplemploy5_.CODE as CODE4_, emplemploy5_.LASTNAME as LASTNAME4_, emplemploy5_.FIRSTNAME as FIRSTNAME4_, emplemploy5_.EMAIL as EMAIL4_, emplemploy5_.DESCRIPTION_LONG as DESCRIPT7_4_, emplemploy5_.GENE_CONFESSION as GENE_CON8_4_, geneconfes6_.GUID as GUID5_, geneconfes6_.CODE as CODE5_, geneconfes6_.DESCRIPTION as DESCRIPT3_5_, projdetail7_.GUID as GUID6_, projdetail7_.CODE as CODE6_, projdetail7_.DESCRIPTION as DESCRIPT3_6_, geneitem8_.GUID as GUID7_, geneitem8_.CODE as CODE7_, geneitem8_.DESCRIPTION as DESCRIPT3_7_, geneitem8_.DESCRIPTION_LONG as DESCRIPT4_7_, geneitem8_.GENE_COMPCENTER as GENE_COM5_7_, genecompce9_.GUID as GUID8_, genecompce9_.CODE as CODE8_, genecompce9_.DESCRIPTION as DESCRIPT3_8_ from PROJ_PROPOSAL_DETAIL projpropos0_ left outer join PROJ_PROPOSAL_GROUP projpropos1_ on projpropos0_.PROJ_PROPOSAL_GROUP=projpropos1_.GUID left outer join PROJ_PROJECT projprojec2_ on projpropos1_.PROJ_PROJECT=projprojec2_.GUID left outer join CUST_PARTNER custpartne3_ on projprojec2_.CUST_PARTNER=custpartne3_.GUID left outer join CUST_CUSTOMER custcustom4_ on custpartne3_.CUST_CUSTOMER=custcustom4_.GUID left outer join EMPL_EMPLOYEE emplemploy5_ on custcustom4_.EMPL_EMPLOYEE_CRM=emplemploy5_.GUID left outer join GENE_CONFESSION geneconfes6_ on emplemploy5_.GENE_CONFESSION=geneconfes6_.GUID left outer join PROJ_DETAIL_STATUS projdetail7_ on projpropos0_.PROJ_DETAIL_STATUS=projdetail7_.GUID left outer join GENE_ITEM geneitem8_ on projpropos0_.GENE_ITEM=geneitem8_.GUID left outer join GENE_COMPCENTER genecompce9_ on geneitem8_.GENE_COMPCENTER=genecompce9_.GUID where projpropos0_.PROJ_JOB=?
Hibernate: select genecalcty0_.GUID as x0_0_, genecalcty0_.DESCRIPTION as x1_0_ from GENE_CALC_TYPE genecalcty0_
Hibernate: select genecalcty0_.GUID as x0_0_, genecalcty0_.DESCRIPTION as x1_0_ from GENE_CALC_TYPE genecalcty0_
Hibernate: select this.GUID as GUID0_, this.CODE as CODE0_, this.VAT as VAT0_ from GENE_VAT this where 1=1 order by this.GUID asc
Hibernate: select this.GUID as GUID0_, this.CODE as CODE0_, this.VAT as VAT0_ from GENE_VAT this where 1=1 order by this.GUID asc
Hibernate: select this.GUID as GUID0_, this.CODE as CODE0_, this.DESCRIPTION as DESCRIPT3_0_, this.OPENING_BALANCE as OPENING_4_0_ from ACCO_BANK this where 1=1 order by this.DESCRIPTION asc
Hibernate: select this.GUID as GUID0_, this.CODE as CODE0_, this.DESCRIPTION as DESCRIPT3_0_, this.OPENING_BALANCE as OPENING_4_0_ from ACCO_BANK this where 1=1 order by this.DESCRIPTION asc
Debug level Hibernate log excerpt: I guess this is of no use... but the heck with it...
DEBUG [07 Apr 2005 14:09:11,640] (com.fit.core.faces.journalentry.JournalentryDetail:107) Setting guid preliminary to:
DEBUG [07 Apr 2005 14:09:11,640] (com.fit.core.faces.journalentry.JournalentryDetail:116) Setting guidJob preliminary to:
DEBUG [07 Apr 2005 14:09:16,624] (com.fit.core.faces.journalentry.JournalentryDetail:127) load() -> code:B00000002
|