java - Hibernate: How to Map Composite Keys? -


i have table 3 composite keys. custom_id, patient_idpatient, service_provider_type_idservice_provider_type. current mapping below

<?xml version="1.0" encoding="utf-8"?> <!doctype hibernate-mapping public "-//hibernate/hibernate mapping dtd 3.0//en" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping>     <class name="beans.serviceprovider" table="service_provider" catalog="myglukose" optimistic-lock="version">         <id name="customid" type="string">             <column name="custom_id" not-null="true"/>         </id>         <many-to-one name="patient" class="beans.patient" fetch="select">             <column name="patient_idpatient" not-null="true"/>         </many-to-one>         <many-to-one name="serviceprovidertype" class="beans.serviceprovidertype" fetch="select">             <column name="service_provider_type_idservice_provider_type" not-null="true"/>         </many-to-one>         <property name="datecreated" type="timestamp">             <column name="date_created" length="19" />         </property>         <property name="lastupdated" type="timestamp">             <column name="last_updated" length="19" not-null="true" />         </property>     </class> </hibernate-mapping>

my sql code

create table if not exists `xxx`.`service_provider` (   `custom_id` varchar(45) not null,   `patient_idpatient` int not null,   `service_provider_type_idservice_provider_type` int not null,   `date_created` timestamp null,   `last_updated` timestamp not null default current_timestamp,   index `fk_service_provider_patient1_idx` (`patient_idpatient` asc),   index `fk_service_provider_service_provider_type1_idx` (`service_provider_type_idservice_provider_type` asc),   primary key (`custom_id`, `patient_idpatient`, `service_provider_type_idservice_provider_type`),   constraint `fk_service_provider_patient1`     foreign key (`patient_idpatient`)     references `xxx`.`patient` (`idpatient`)     on delete cascade     on update no action,   constraint `fk_service_provider_service_provider_type1`     foreign key (`service_provider_type_idservice_provider_type`)     references `xxx`.`service_provider_type` (`idservice_provider_type`)     on delete no action     on update no action) engine = innodb;

how can map these 3 composite keys in hibernate?

i know maybe have 

<composite-id name="compid">    <key-property name="customid” column="custom_id" />    <key-property name="patientidpatient" column="patient_idpatient" />    <key-property name="serviceprovidertypeidserviceprovidertype" column="service_provider_type_idservice_provider_type" /> </composite-id>

but not sure how apply xml mapping, whether should "just" add code, whether should remove first or make edits first. tried removing primary key mapping , relationship key mappings , adding above code, didnt work, ended multiple errors @ different times.

what correct way of mapping this? making edit existing xml code appreciated have complete picture of how should make work.


Comments

Post a Comment

Popular posts from this blog

4x4 Matrix in Python -

im trying code 4x4 matrix in python random integers 1-4. thats easy enough problem want each row , each column 1 time uses of each digit 1-4 example 1 2 3 4 2 3 4 1 3 4 1 2 4 1 2 3 my code 33% of time in loop there happens somthing this 2 1 4 3 3 4 2 1 1 3 x <-------- because of programm cant contiune , end in infinity loop helb how can out? code below """ programm playing game skyline """ random import randrange row1 = [] row2 = [] row3 = [] row4 = [] allrows = [row1, row2, row3, row4] column1 = [] column2 = [] column3 = [] column4 = [] allcolumns = [column1, column2, column3, column4] def board(): in range(4): j = 0 while len(allrows[i]) != 4: x = randrange(1,5) print(i, j) if x not in allrows[i] , x not in allcolumns[j]: allrows[i].append(x) allcolumns[j].append(x) j += 1 else: continue boa...
Read more

python - String indices must be integers and while issue -

i writing code school homework. assignment this: write code read book codes till "000" entered , split books 2 categories depending on first 4 digits entered isbn , issn. note : use str , check prefix of code (in case isbn , issn). here code: bookarray = [] booknumber = str(input("give me book code - type 000 if want cancel")) while booknumber != "000": bookarray.append(booknumber) booknumber = str(input("give me book code - type 000 if want cancel")) if booknumber[0,4] == "isbn": isbnarray = booknumber elif booknumber[0,4] == "issn": issnarray = booknumber print(issnarray) print(isbnarray) any regarding same appreciated! in first year in python @ school. edit: expected output should 2 lists books' code numbers. currently, face autonomous loop on "while" not sure of how , why. if booknumber[0,4] == "isbn": you're passing tuple index booknumber ex...
Read more

python - PyInstaller UAC not working in onefile mode -

hello everybody. i have small python project , want make single executable file . using... windows 7 python 3.4 pyinstaller 3.2.1 my pyinstaller command is, pyinstaller -y -w -f -n output_file_name --uac-admin --clean source_file.py this command works properly. single output file not ask admin rights when executed. , there's no shield mark on executable file icon. when remove -f option (equivalent --onefile), output executable file has shield mark on icon , ask me admin rights. not want. want single executable file. i found manifest file (output_file_name.exe.manifest) in dist\output_file_name folder. did... pyinstaller -y -w -f -n output_file_name --manifest output_file_name.exe.manifest --uac-admin --clean source_file.py but command doesn't work. single executable file still not ask admin rights. i have removed pyinstaller , installed recent development version. pip install git+https://github.com/pyinstaller/pyinstaller.git@develop but result...
Read more