It's there now. I had pasted ProviderServices twice.
Here is the SQL and error:
Code:
20:46:58,664 WARN Configurator:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/Program%20Files/MyEclipse%206.0/myeclipse/eclipse/plugins/com.genuitec.org.hibernate.eclipse_6.0.1.zmyeclipse601200710/myeclipse-data/3.0/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
Hibernate: select max(insurance_id) from insurances
Hibernate: select services0_.service_id as service1_2_1_, services0_.service_catagory_id as service2_2_1_, services0_.en_service as en3_2_1_, services0_.en_description as en4_2_1_, services0_.es_service as es5_2_1_, services0_.es_description as es6_2_1_, servicecat1_.service_catagory_id as service1_1_0_, servicecat1_.en_service_catagory as en2_1_0_, servicecat1_.en_description as en3_1_0_, servicecat1_.es_service_catagory as es4_1_0_, servicecat1_.es_description as es5_1_0_ from services services0_ left outer join service_catagories servicecat1_ on services0_.service_id=servicecat1_.service_catagory_id where services0_.service_id=?
Hibernate: select providers0_.service_id as service2_1_, providers0_.provider_id as provider1_1_, providers1_.provider_id as provider1_22_0_, providers1_.isactive as isactive22_0_, providers1_.join_date as join3_22_0_, providers1_.join_date_orig as join4_22_0_, providers1_.last_name as last5_22_0_, providers1_.first_name as first6_22_0_, providers1_.display_name as display7_22_0_, providers1_.child as child22_0_, providers1_.adolescent as adolescent22_0_, providers1_.adult as adult22_0_, providers1_.geriatric as geriatric22_0_, providers1_.description as descrip12_22_0_, providers1_.contract as contract22_0_ from provider_services providers0_ left outer join providers providers1_ on providers0_.provider_id=providers1_.provider_id where providers0_.service_id=?
Hibernate: select users0_.provider_id as provider1_1_, users0_.user_name as user2_1_, users1_.user_name as user1_5_0_, users1_.user_pass as user2_5_0_ from provider_users users0_ left outer join users users1_ on users0_.user_name=users1_.user_name where users0_.provider_id=?
Hibernate: select languages0_.provider_id as provider1_1_, languages0_.languages_id as languages2_1_, languages1_.language_id as language1_10_0_, languages1_.language as language10_0_, languages1_.description as descript3_10_0_, languages1_.language_code as language4_10_0_ from provider_languages languages0_ left outer join languages languages1_ on languages0_.languages_id=languages1_.language_id where languages0_.provider_id=?
Hibernate: select providerse0_.provider_id as provider1_2_, providerse0_.service_id as service2_2_, services1_.service_id as service1_2_0_, services1_.service_catagory_id as service2_2_0_, services1_.en_service as en3_2_0_, services1_.en_description as en4_2_0_, services1_.es_service as es5_2_0_, services1_.es_description as es6_2_0_, servicecat2_.service_catagory_id as service1_1_1_, servicecat2_.en_service_catagory as en2_1_1_, servicecat2_.en_description as en3_1_1_, servicecat2_.es_service_catagory as es4_1_1_, servicecat2_.es_description as es5_1_1_ from provider_services providerse0_ left outer join services services1_ on providerse0_.service_id=services1_.service_id left outer join service_catagories servicecat2_ on services1_.service_id=servicecat2_.service_catagory_id where providerse0_.provider_id=?
Hibernate: select locations0_.provider_id as provider2_1_, locations0_.location_id as location1_1_, locations0_.location_id as location1_19_0_, locations0_.provider_id as provider2_19_0_, locations0_.phone_id as phone3_19_0_, locations0_.address_id as address4_19_0_, locations0_.email_id as email5_19_0_, locations0_.url as url19_0_, locations0_.practice_desc as practice7_19_0_, locations0_.handycap as handycap19_0_, locations0_.public_transportation as public9_19_0_ from provider_locations locations0_ where locations0_.provider_id=?
Hibernate: select licenses0_.provider_id as provider1_1_, licenses0_.license_id as license2_1_, licenses1_.license_id as license1_11_0_, licenses1_.license as license11_0_, licenses1_.description as descript3_11_0_, licenses1_.state_issued as state4_11_0_, licenses1_.date_issued as date5_11_0_, licenses1_.expiration_date as expiration6_11_0_, licenses1_.date_issued_orig as date7_11_0_, licenses1_.expiration_date_orig as expiration8_11_0_, licenses1_.license_number as license9_11_0_ from provider_licenses licenses0_ left outer join licenses licenses1_ on licenses0_.license_id=licenses1_.license_id where licenses0_.provider_id=?
Hibernate: select insurances0_.provider_id as provider1_1_, insurances0_.insurance_id as insurance2_1_, insurances1_.insurance_id as insurance1_9_0_, insurances1_.insurance_name as insurance2_9_0_, insurances1_.company as company9_0_, insurances1_.policy_number as policy4_9_0_, insurances1_.exp_date as exp5_9_0_, insurances1_.exp_date_orig as exp6_9_0_, insurances1_.disciplin_action as disciplin7_9_0_, insurances1_.error_or_ommision as error8_9_0_, insurances1_.claim_filed as claim9_9_0_, insurances1_.disciplin_action_explain as disciplin10_9_0_, insurances1_.error_or_ommision_explain as error11_9_0_, insurances1_.claim_filed_explained as claim12_9_0_ from provider_insurances insurances0_ left outer join insurances insurances1_ on insurances0_.insurance_id=insurances1_.insurance_id where insurances0_.provider_id=?
Hibernate: select users0_.provider_id as provider1_1_, users0_.user_name as user2_1_, users1_.user_name as user1_5_0_, users1_.user_pass as user2_5_0_ from provider_users users0_ left outer join users users1_ on users0_.user_name=users1_.user_name where users0_.provider_id=?
Hibernate: select languages0_.provider_id as provider1_1_, languages0_.languages_id as languages2_1_, languages1_.language_id as language1_10_0_, languages1_.language as language10_0_, languages1_.description as descript3_10_0_, languages1_.language_code as language4_10_0_ from provider_languages languages0_ left outer join languages languages1_ on languages0_.languages_id=languages1_.language_id where languages0_.provider_id=?
Hibernate: select providerse0_.provider_id as provider1_2_, providerse0_.service_id as service2_2_, services1_.service_id as service1_2_0_, services1_.service_catagory_id as service2_2_0_, services1_.en_service as en3_2_0_, services1_.en_description as en4_2_0_, services1_.es_service as es5_2_0_, services1_.es_description as es6_2_0_, servicecat2_.service_catagory_id as service1_1_1_, servicecat2_.en_service_catagory as en2_1_1_, servicecat2_.en_description as en3_1_1_, servicecat2_.es_service_catagory as es4_1_1_, servicecat2_.es_description as es5_1_1_ from provider_services providerse0_ left outer join services services1_ on providerse0_.service_id=services1_.service_id left outer join service_catagories servicecat2_ on services1_.service_id=servicecat2_.service_catagory_id where providerse0_.provider_id=?
Hibernate: select locations0_.provider_id as provider2_1_, locations0_.location_id as location1_1_, locations0_.location_id as location1_19_0_, locations0_.provider_id as provider2_19_0_, locations0_.phone_id as phone3_19_0_, locations0_.address_id as address4_19_0_, locations0_.email_id as email5_19_0_, locations0_.url as url19_0_, locations0_.practice_desc as practice7_19_0_, locations0_.handycap as handycap19_0_, locations0_.public_transportation as public9_19_0_ from provider_locations locations0_ where locations0_.provider_id=?
Hibernate: select licenses0_.provider_id as provider1_1_, licenses0_.license_id as license2_1_, licenses1_.license_id as license1_11_0_, licenses1_.license as license11_0_, licenses1_.description as descript3_11_0_, licenses1_.state_issued as state4_11_0_, licenses1_.date_issued as date5_11_0_, licenses1_.expiration_date as expiration6_11_0_, licenses1_.date_issued_orig as date7_11_0_, licenses1_.expiration_date_orig as expiration8_11_0_, licenses1_.license_number as license9_11_0_ from provider_licenses licenses0_ left outer join licenses licenses1_ on licenses0_.license_id=licenses1_.license_id where licenses0_.provider_id=?
Hibernate: select insurances0_.provider_id as provider1_1_, insurances0_.insurance_id as insurance2_1_, insurances1_.insurance_id as insurance1_9_0_, insurances1_.insurance_name as insurance2_9_0_, insurances1_.company as company9_0_, insurances1_.policy_number as policy4_9_0_, insurances1_.exp_date as exp5_9_0_, insurances1_.exp_date_orig as exp6_9_0_, insurances1_.disciplin_action as disciplin7_9_0_, insurances1_.error_or_ommision as error8_9_0_, insurances1_.claim_filed as claim9_9_0_, insurances1_.disciplin_action_explain as disciplin10_9_0_, insurances1_.error_or_ommision_explain as error11_9_0_, insurances1_.claim_filed_explained as claim12_9_0_ from provider_insurances insurances0_ left outer join insurances insurances1_ on insurances0_.insurance_id=insurances1_.insurance_id where insurances0_.provider_id=?
Hibernate: select users0_.provider_id as provider1_1_, users0_.user_name as user2_1_, users1_.user_name as user1_5_0_, users1_.user_pass as user2_5_0_ from provider_users users0_ left outer join users users1_ on users0_.user_name=users1_.user_name where users0_.provider_id=?
Hibernate: select languages0_.provider_id as provider1_1_, languages0_.languages_id as languages2_1_, languages1_.language_id as language1_10_0_, languages1_.language as language10_0_, languages1_.description as descript3_10_0_, languages1_.language_code as language4_10_0_ from provider_languages languages0_ left outer join languages languages1_ on languages0_.languages_id=languages1_.language_id where languages0_.provider_id=?
Hibernate: select providerse0_.provider_id as provider1_2_, providerse0_.service_id as service2_2_, services1_.service_id as service1_2_0_, services1_.service_catagory_id as service2_2_0_, services1_.en_service as en3_2_0_, services1_.en_description as en4_2_0_, services1_.es_service as es5_2_0_, services1_.es_description as es6_2_0_, servicecat2_.service_catagory_id as service1_1_1_, servicecat2_.en_service_catagory as en2_1_1_, servicecat2_.en_description as en3_1_1_, servicecat2_.es_service_catagory as es4_1_1_, servicecat2_.es_description as es5_1_1_ from provider_services providerse0_ left outer join services services1_ on providerse0_.service_id=services1_.service_id left outer join service_catagories servicecat2_ on services1_.service_id=servicecat2_.service_catagory_id where providerse0_.provider_id=?
Hibernate: select locations0_.provider_id as provider2_1_, locations0_.location_id as location1_1_, locations0_.location_id as location1_19_0_, locations0_.provider_id as provider2_19_0_, locations0_.phone_id as phone3_19_0_, locations0_.address_id as address4_19_0_, locations0_.email_id as email5_19_0_, locations0_.url as url19_0_, locations0_.practice_desc as practice7_19_0_, locations0_.handycap as handycap19_0_, locations0_.public_transportation as public9_19_0_ from provider_locations locations0_ where locations0_.provider_id=?
Hibernate: select licenses0_.provider_id as provider1_1_, licenses0_.license_id as license2_1_, licenses1_.license_id as license1_11_0_, licenses1_.license as license11_0_, licenses1_.description as descript3_11_0_, licenses1_.state_issued as state4_11_0_, licenses1_.date_issued as date5_11_0_, licenses1_.expiration_date as expiration6_11_0_, licenses1_.date_issued_orig as date7_11_0_, licenses1_.expiration_date_orig as expiration8_11_0_, licenses1_.license_number as license9_11_0_ from provider_licenses licenses0_ left outer join licenses licenses1_ on licenses0_.license_id=licenses1_.license_id where licenses0_.provider_id=?
Hibernate: select insurances0_.provider_id as provider1_1_, insurances0_.insurance_id as insurance2_1_, insurances1_.insurance_id as insurance1_9_0_, insurances1_.insurance_name as insurance2_9_0_, insurances1_.company as company9_0_, insurances1_.policy_number as policy4_9_0_, insurances1_.exp_date as exp5_9_0_, insurances1_.exp_date_orig as exp6_9_0_, insurances1_.disciplin_action as disciplin7_9_0_, insurances1_.error_or_ommision as error8_9_0_, insurances1_.claim_filed as claim9_9_0_, insurances1_.disciplin_action_explain as disciplin10_9_0_, insurances1_.error_or_ommision_explain as error11_9_0_, insurances1_.claim_filed_explained as claim12_9_0_ from provider_insurances insurances0_ left outer join insurances insurances1_ on insurances0_.insurance_id=insurances1_.insurance_id where insurances0_.provider_id=?
Hibernate: select users0_.provider_id as provider1_1_, users0_.user_name as user2_1_, users1_.user_name as user1_5_0_, users1_.user_pass as user2_5_0_ from provider_users users0_ left outer join users users1_ on users0_.user_name=users1_.user_name where users0_.provider_id=?
Hibernate: select languages0_.provider_id as provider1_1_, languages0_.languages_id as languages2_1_, languages1_.language_id as language1_10_0_, languages1_.language as language10_0_, languages1_.description as descript3_10_0_, languages1_.language_code as language4_10_0_ from provider_languages languages0_ left outer join languages languages1_ on languages0_.languages_id=languages1_.language_id where languages0_.provider_id=?
Hibernate: select providerse0_.provider_id as provider1_2_, providerse0_.service_id as service2_2_, services1_.service_id as service1_2_0_, services1_.service_catagory_id as service2_2_0_, services1_.en_service as en3_2_0_, services1_.en_description as en4_2_0_, services1_.es_service as es5_2_0_, services1_.es_description as es6_2_0_, servicecat2_.service_catagory_id as service1_1_1_, servicecat2_.en_service_catagory as en2_1_1_, servicecat2_.en_description as en3_1_1_, servicecat2_.es_service_catagory as es4_1_1_, servicecat2_.es_description as es5_1_1_ from provider_services providerse0_ left outer join services services1_ on providerse0_.service_id=services1_.service_id left outer join service_catagories servicecat2_ on services1_.service_id=servicecat2_.service_catagory_id where providerse0_.provider_id=?
Hibernate: select locations0_.provider_id as provider2_1_, locations0_.location_id as location1_1_, locations0_.location_id as location1_19_0_, locations0_.provider_id as provider2_19_0_, locations0_.phone_id as phone3_19_0_, locations0_.address_id as address4_19_0_, locations0_.email_id as email5_19_0_, locations0_.url as url19_0_, locations0_.practice_desc as practice7_19_0_, locations0_.handycap as handycap19_0_, locations0_.public_transportation as public9_19_0_ from provider_locations locations0_ where locations0_.provider_id=?
Hibernate: select licenses0_.provider_id as provider1_1_, licenses0_.license_id as license2_1_, licenses1_.license_id as license1_11_0_, licenses1_.license as license11_0_, licenses1_.description as descript3_11_0_, licenses1_.state_issued as state4_11_0_, licenses1_.date_issued as date5_11_0_, licenses1_.expiration_date as expiration6_11_0_, licenses1_.date_issued_orig as date7_11_0_, licenses1_.expiration_date_orig as expiration8_11_0_, licenses1_.license_number as license9_11_0_ from provider_licenses licenses0_ left outer join licenses licenses1_ on licenses0_.license_id=licenses1_.license_id where licenses0_.provider_id=?
Hibernate: select insurances0_.provider_id as provider1_1_, insurances0_.insurance_id as insurance2_1_, insurances1_.insurance_id as insurance1_9_0_, insurances1_.insurance_name as insurance2_9_0_, insurances1_.company as company9_0_, insurances1_.policy_number as policy4_9_0_, insurances1_.exp_date as exp5_9_0_, insurances1_.exp_date_orig as exp6_9_0_, insurances1_.disciplin_action as disciplin7_9_0_, insurances1_.error_or_ommision as error8_9_0_, insurances1_.claim_filed as claim9_9_0_, insurances1_.disciplin_action_explain as disciplin10_9_0_, insurances1_.error_or_ommision_explain as error11_9_0_, insurances1_.claim_filed_explained as claim12_9_0_ from provider_insurances insurances0_ left outer join insurances insurances1_ on insurances0_.insurance_id=insurances1_.insurance_id where insurances0_.provider_id=?
Hibernate: select users0_.provider_id as provider1_1_, users0_.user_name as user2_1_, users1_.user_name as user1_5_0_, users1_.user_pass as user2_5_0_ from provider_users users0_ left outer join users users1_ on users0_.user_name=users1_.user_name where users0_.provider_id=?
Hibernate: select languages0_.provider_id as provider1_1_, languages0_.languages_id as languages2_1_, languages1_.language_id as language1_10_0_, languages1_.language as language10_0_, languages1_.description as descript3_10_0_, languages1_.language_code as language4_10_0_ from provider_languages languages0_ left outer join languages languages1_ on languages0_.languages_id=languages1_.language_id where languages0_.provider_id=?
Hibernate: select providerse0_.provider_id as provider1_2_, providerse0_.service_id as service2_2_, services1_.service_id as service1_2_0_, services1_.service_catagory_id as service2_2_0_, services1_.en_service as en3_2_0_, services1_.en_description as en4_2_0_, services1_.es_service as es5_2_0_, services1_.es_description as es6_2_0_, servicecat2_.service_catagory_id as service1_1_1_, servicecat2_.en_service_catagory as en2_1_1_, servicecat2_.en_description as en3_1_1_, servicecat2_.es_service_catagory as es4_1_1_, servicecat2_.es_description as es5_1_1_ from provider_services providerse0_ left outer join services services1_ on providerse0_.service_id=services1_.service_id left outer join service_catagories servicecat2_ on services1_.service_id=servicecat2_.service_catagory_id where providerse0_.provider_id=?
Hibernate: select locations0_.provider_id as provider2_1_, locations0_.location_id as location1_1_, locations0_.location_id as location1_19_0_, locations0_.provider_id as provider2_19_0_, locations0_.phone_id as phone3_19_0_, locations0_.address_id as address4_19_0_, locations0_.email_id as email5_19_0_, locations0_.url as url19_0_, locations0_.practice_desc as practice7_19_0_, locations0_.handycap as handycap19_0_, locations0_.public_transportation as public9_19_0_ from provider_locations locations0_ where locations0_.provider_id=?
Hibernate: select licenses0_.provider_id as provider1_1_, licenses0_.license_id as license2_1_, licenses1_.license_id as license1_11_0_, licenses1_.license as license11_0_, licenses1_.description as descript3_11_0_, licenses1_.state_issued as state4_11_0_, licenses1_.date_issued as date5_11_0_, licenses1_.expiration_date as expiration6_11_0_, licenses1_.date_issued_orig as date7_11_0_, licenses1_.expiration_date_orig as expiration8_11_0_, licenses1_.license_number as license9_11_0_ from provider_licenses licenses0_ left outer join licenses licenses1_ on licenses0_.license_id=licenses1_.license_id where licenses0_.provider_id=?
Hibernate: select insurances0_.provider_id as provider1_1_, insurances0_.insurance_id as insurance2_1_, insurances1_.insurance_id as insurance1_9_0_, insurances1_.insurance_name as insurance2_9_0_, insurances1_.company as company9_0_, insurances1_.policy_number as policy4_9_0_, insurances1_.exp_date as exp5_9_0_, insurances1_.exp_date_orig as exp6_9_0_, insurances1_.disciplin_action as disciplin7_9_0_, insurances1_.error_or_ommision as error8_9_0_, insurances1_.claim_filed as claim9_9_0_, insurances1_.disciplin_action_explain as disciplin10_9_0_, insurances1_.error_or_ommision_explain as error11_9_0_, insurances1_.claim_filed_explained as claim12_9_0_ from provider_insurances insurances0_ left outer join insurances insurances1_ on insurances0_.insurance_id=insurances1_.insurance_id where insurances0_.provider_id=?
Hibernate: select users0_.provider_id as provider1_1_, users0_.user_name as user2_1_, users1_.user_name as user1_5_0_, users1_.user_pass as user2_5_0_ from provider_users users0_ left outer join users users1_ on users0_.user_name=users1_.user_name where users0_.provider_id=?
Hibernate: select languages0_.provider_id as provider1_1_, languages0_.languages_id as languages2_1_, languages1_.language_id as language1_10_0_, languages1_.language as language10_0_, languages1_.description as descript3_10_0_, languages1_.language_code as language4_10_0_ from provider_languages languages0_ left outer join languages languages1_ on languages0_.languages_id=languages1_.language_id where languages0_.provider_id=?
Hibernate: select providerse0_.provider_id as provider1_2_, providerse0_.service_id as service2_2_, services1_.service_id as service1_2_0_, services1_.service_catagory_id as service2_2_0_, services1_.en_service as en3_2_0_, services1_.en_description as en4_2_0_, services1_.es_service as es5_2_0_, services1_.es_description as es6_2_0_, servicecat2_.service_catagory_id as service1_1_1_, servicecat2_.en_service_catagory as en2_1_1_, servicecat2_.en_description as en3_1_1_, servicecat2_.es_service_catagory as es4_1_1_, servicecat2_.es_description as es5_1_1_ from provider_services providerse0_ left outer join services services1_ on providerse0_.service_id=services1_.service_id left outer join service_catagories servicecat2_ on services1_.service_id=servicecat2_.service_catagory_id where providerse0_.provider_id=?
Hibernate: select locations0_.provider_id as provider2_1_, locations0_.location_id as location1_1_, locations0_.location_id as location1_19_0_, locations0_.provider_id as provider2_19_0_, locations0_.phone_id as phone3_19_0_, locations0_.address_id as address4_19_0_, locations0_.email_id as email5_19_0_, locations0_.url as url19_0_, locations0_.practice_desc as practice7_19_0_, locations0_.handycap as handycap19_0_, locations0_.public_transportation as public9_19_0_ from provider_locations locations0_ where locations0_.provider_id=?
Hibernate: select licenses0_.provider_id as provider1_1_, licenses0_.license_id as license2_1_, licenses1_.license_id as license1_11_0_, licenses1_.license as license11_0_, licenses1_.description as descript3_11_0_, licenses1_.state_issued as state4_11_0_, licenses1_.date_issued as date5_11_0_, licenses1_.expiration_date as expiration6_11_0_, licenses1_.date_issued_orig as date7_11_0_, licenses1_.expiration_date_orig as expiration8_11_0_, licenses1_.license_number as license9_11_0_ from provider_licenses licenses0_ left outer join licenses licenses1_ on licenses0_.license_id=licenses1_.license_id where licenses0_.provider_id=?
Hibernate: select insurances0_.provider_id as provider1_1_, insurances0_.insurance_id as insurance2_1_, insurances1_.insurance_id as insurance1_9_0_, insurances1_.insurance_name as insurance2_9_0_, insurances1_.company as company9_0_, insurances1_.policy_number as policy4_9_0_, insurances1_.exp_date as exp5_9_0_, insurances1_.exp_date_orig as exp6_9_0_, insurances1_.disciplin_action as disciplin7_9_0_, insurances1_.error_or_ommision as error8_9_0_, insurances1_.claim_filed as claim9_9_0_, insurances1_.disciplin_action_explain as disciplin10_9_0_, insurances1_.error_or_ommision_explain as error11_9_0_, insurances1_.claim_filed_explained as claim12_9_0_ from provider_insurances insurances0_ left outer join insurances insurances1_ on insurances0_.insurance_id=insurances1_.insurance_id where insurances0_.provider_id=?
Hibernate: select users0_.provider_id as provider1_1_, users0_.user_name as user2_1_, users1_.user_name as user1_5_0_, users1_.user_pass as user2_5_0_ from provider_users users0_ left outer join users users1_ on users0_.user_name=users1_.user_name where users0_.provider_id=?
Hibernate: select languages0_.provider_id as provider1_1_, languages0_.languages_id as languages2_1_, languages1_.language_id as language1_10_0_, languages1_.language as language10_0_, languages1_.description as descript3_10_0_, languages1_.language_code as language4_10_0_ from provider_languages languages0_ left outer join languages languages1_ on languages0_.languages_id=languages1_.language_id where languages0_.provider_id=?
Hibernate: select providerse0_.provider_id as provider1_2_, providerse0_.service_id as service2_2_, services1_.service_id as service1_2_0_, services1_.service_catagory_id as service2_2_0_, services1_.en_service as en3_2_0_, services1_.en_description as en4_2_0_, services1_.es_service as es5_2_0_, services1_.es_description as es6_2_0_, servicecat2_.service_catagory_id as service1_1_1_, servicecat2_.en_service_catagory as en2_1_1_, servicecat2_.en_description as en3_1_1_, servicecat2_.es_service_catagory as es4_1_1_, servicecat2_.es_description as es5_1_1_ from provider_services providerse0_ left outer join services services1_ on providerse0_.service_id=services1_.service_id left outer join service_catagories servicecat2_ on services1_.service_id=servicecat2_.service_catagory_id where providerse0_.provider_id=?
Hibernate: select locations0_.provider_id as provider2_1_, locations0_.location_id as location1_1_, locations0_.location_id as location1_19_0_, locations0_.provider_id as provider2_19_0_, locations0_.phone_id as phone3_19_0_, locations0_.address_id as address4_19_0_, locations0_.email_id as email5_19_0_, locations0_.url as url19_0_, locations0_.practice_desc as practice7_19_0_, locations0_.handycap as handycap19_0_, locations0_.public_transportation as public9_19_0_ from provider_locations locations0_ where locations0_.provider_id=?
Hibernate: select phones0_.phone_id as phone1_12_0_, phones0_.phone as phone12_0_, phones0_.phone_type as phone3_12_0_ from phones phones0_ where phones0_.phone_id=?
Hibernate: select addresses0_.address_id as address1_6_0_, addresses0_.address1 as address2_6_0_, addresses0_.address2 as address3_6_0_, addresses0_.city as city6_0_, addresses0_.state as state6_0_, addresses0_.zip as zip6_0_, addresses0_.address_type as address7_6_0_ from addresses addresses0_ where addresses0_.address_id=?
Hibernate: select emails0_.email_id as email1_8_0_, emails0_.email as email8_0_, emails0_.email_type as email3_8_0_ from emails emails0_ where emails0_.email_id=?
Hibernate: select phones0_.phone_id as phone1_12_0_, phones0_.phone as phone12_0_, phones0_.phone_type as phone3_12_0_ from phones phones0_ where phones0_.phone_id=?
Hibernate: select addresses0_.address_id as address1_6_0_, addresses0_.address1 as address2_6_0_, addresses0_.address2 as address3_6_0_, addresses0_.city as city6_0_, addresses0_.state as state6_0_, addresses0_.zip as zip6_0_, addresses0_.address_type as address7_6_0_ from addresses addresses0_ where addresses0_.address_id=?
Hibernate: select emails0_.email_id as email1_8_0_, emails0_.email as email8_0_, emails0_.email_type as email3_8_0_ from emails emails0_ where emails0_.email_id=?
Hibernate: select phones0_.phone_id as phone1_12_0_, phones0_.phone as phone12_0_, phones0_.phone_type as phone3_12_0_ from phones phones0_ where phones0_.phone_id=?
Hibernate: select addresses0_.address_id as address1_6_0_, addresses0_.address1 as address2_6_0_, addresses0_.address2 as address3_6_0_, addresses0_.city as city6_0_, addresses0_.state as state6_0_, addresses0_.zip as zip6_0_, addresses0_.address_type as address7_6_0_ from addresses addresses0_ where addresses0_.address_id=?
Hibernate: select emails0_.email_id as email1_8_0_, emails0_.email as email8_0_, emails0_.email_type as email3_8_0_ from emails emails0_ where emails0_.email_id=?
Hibernate: select phones0_.phone_id as phone1_12_0_, phones0_.phone as phone12_0_, phones0_.phone_type as phone3_12_0_ from phones phones0_ where phones0_.phone_id=?
Hibernate: select addresses0_.address_id as address1_6_0_, addresses0_.address1 as address2_6_0_, addresses0_.address2 as address3_6_0_, addresses0_.city as city6_0_, addresses0_.state as state6_0_, addresses0_.zip as zip6_0_, addresses0_.address_type as address7_6_0_ from addresses addresses0_ where addresses0_.address_id=?
Hibernate: select emails0_.email_id as email1_8_0_, emails0_.email as email8_0_, emails0_.email_type as email3_8_0_ from emails emails0_ where emails0_.email_id=?
Hibernate: select phones0_.phone_id as phone1_12_0_, phones0_.phone as phone12_0_, phones0_.phone_type as phone3_12_0_ from phones phones0_ where phones0_.phone_id=?
Hibernate: select addresses0_.address_id as address1_6_0_, addresses0_.address1 as address2_6_0_, addresses0_.address2 as address3_6_0_, addresses0_.city as city6_0_, addresses0_.state as state6_0_, addresses0_.zip as zip6_0_, addresses0_.address_type as address7_6_0_ from addresses addresses0_ where addresses0_.address_id=?
Hibernate: select emails0_.email_id as email1_8_0_, emails0_.email as email8_0_, emails0_.email_type as email3_8_0_ from emails emails0_ where emails0_.email_id=?
Hibernate: select phones0_.phone_id as phone1_12_0_, phones0_.phone as phone12_0_, phones0_.phone_type as phone3_12_0_ from phones phones0_ where phones0_.phone_id=?
Hibernate: select addresses0_.address_id as address1_6_0_, addresses0_.address1 as address2_6_0_, addresses0_.address2 as address3_6_0_, addresses0_.city as city6_0_, addresses0_.state as state6_0_, addresses0_.zip as zip6_0_, addresses0_.address_type as address7_6_0_ from addresses addresses0_ where addresses0_.address_id=?
Hibernate: select emails0_.email_id as email1_8_0_, emails0_.email as email8_0_, emails0_.email_type as email3_8_0_ from emails emails0_ where emails0_.email_id=?
Hibernate: select phones0_.phone_id as phone1_12_0_, phones0_.phone as phone12_0_, phones0_.phone_type as phone3_12_0_ from phones phones0_ where phones0_.phone_id=?
Hibernate: select addresses0_.address_id as address1_6_0_, addresses0_.address1 as address2_6_0_, addresses0_.address2 as address3_6_0_, addresses0_.city as city6_0_, addresses0_.state as state6_0_, addresses0_.zip as zip6_0_, addresses0_.address_type as address7_6_0_ from addresses addresses0_ where addresses0_.address_id=?
Hibernate: select emails0_.email_id as email1_8_0_, emails0_.email as email8_0_, emails0_.email_type as email3_8_0_ from emails emails0_ where emails0_.email_id=?
Hibernate: select phones0_.phone_id as phone1_12_0_, phones0_.phone as phone12_0_, phones0_.phone_type as phone3_12_0_ from phones phones0_ where phones0_.phone_id=?
Hibernate: select addresses0_.address_id as address1_6_0_, addresses0_.address1 as address2_6_0_, addresses0_.address2 as address3_6_0_, addresses0_.city as city6_0_, addresses0_.state as state6_0_, addresses0_.zip as zip6_0_, addresses0_.address_type as address7_6_0_ from addresses addresses0_ where addresses0_.address_id=?
Hibernate: select emails0_.email_id as email1_8_0_, emails0_.email as email8_0_, emails0_.email_type as email3_8_0_ from emails emails0_ where emails0_.email_id=?
Hibernate: select phones0_.phone_id as phone1_12_0_, phones0_.phone as phone12_0_, phones0_.phone_type as phone3_12_0_ from phones phones0_ where phones0_.phone_id=?
Hibernate: select addresses0_.address_id as address1_6_0_, addresses0_.address1 as address2_6_0_, addresses0_.address2 as address3_6_0_, addresses0_.city as city6_0_, addresses0_.state as state6_0_, addresses0_.zip as zip6_0_, addresses0_.address_type as address7_6_0_ from addresses addresses0_ where addresses0_.address_id=?
Hibernate: select emails0_.email_id as email1_8_0_, emails0_.email as email8_0_, emails0_.email_type as email3_8_0_ from emails emails0_ where emails0_.email_id=?
Hibernate: select licenses0_.provider_id as provider1_1_, licenses0_.license_id as license2_1_, licenses1_.license_id as license1_11_0_, licenses1_.license as license11_0_, licenses1_.description as descript3_11_0_, licenses1_.state_issued as state4_11_0_, licenses1_.date_issued as date5_11_0_, licenses1_.expiration_date as expiration6_11_0_, licenses1_.date_issued_orig as date7_11_0_, licenses1_.expiration_date_orig as expiration8_11_0_, licenses1_.license_number as license9_11_0_ from provider_licenses licenses0_ left outer join licenses licenses1_ on licenses0_.license_id=licenses1_.license_id where licenses0_.provider_id=?
Hibernate: select insurances0_.provider_id as provider1_1_, insurances0_.insurance_id as insurance2_1_, insurances1_.insurance_id as insurance1_9_0_, insurances1_.insurance_name as insurance2_9_0_, insurances1_.company as company9_0_, insurances1_.policy_number as policy4_9_0_, insurances1_.exp_date as exp5_9_0_, insurances1_.exp_date_orig as exp6_9_0_, insurances1_.disciplin_action as disciplin7_9_0_, insurances1_.error_or_ommision as error8_9_0_, insurances1_.claim_filed as claim9_9_0_, insurances1_.disciplin_action_explain as disciplin10_9_0_, insurances1_.error_or_ommision_explain as error11_9_0_, insurances1_.claim_filed_explained as claim12_9_0_ from provider_insurances insurances0_ left outer join insurances insurances1_ on insurances0_.insurance_id=insurances1_.insurance_id where insurances0_.provider_id=?
Hibernate: select max(provider_id) from providers
Hibernate: select max(location_id) from provider_locations
Hibernate: select max(phone_id) from phones
Hibernate: select max(address_id) from addresses
Hibernate: select max(email_id) from emails
Hibernate: insert into insurances (insurance_name, company, policy_number, exp_date, exp_date_orig, disciplin_action, error_or_ommision, claim_filed, disciplin_action_explain, error_or_ommision_explain, claim_filed_explained, insurance_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into providers (isactive, join_date, join_date_orig, last_name, first_name, display_name, child, adolescent, adult, geriatric, description, contract, provider_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
20:46:59,782 WARN JDBCExceptionReporter:71 - SQL Error: 1364, SQLState: HY000
20:46:59,788 ERROR JDBCExceptionReporter:72 - Field 'service_catagory_id' doesn't have a default value
20:46:59,791 ERROR AbstractFlushingEventListener:300 - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2048)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at wellnessnetwork.website.backing.ProviderEnroll.main(ProviderEnroll.java:916)
Caused by: java.sql.BatchUpdateException: Field 'service_catagory_id' doesn't have a default value
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:822)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
... 15 more
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2048)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at wellnessnetwork.website.backing.ProviderEnroll.main(ProviderEnroll.java:916)
Caused by: java.sql.BatchUpdateException: Field 'service_catagory_id' doesn't have a default value
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:822)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
... 15 more
Login
FAQ
Search
