Hibernate: select n1_0.id,n1_0.acoustic_signal,n1_0.changed,n1_0.code,n1_0.created_by,n1_0.created_date,n1_0.description,n1_0.distance_to_stop_line,n1_0.fault_state,n1_0.foreign_id,n1_0.gid,n1_0.initial_distance_to_stop_line,n1_0.initial_latitude,n1_0.initial_longitude,n1_0.last_changed_reset_date,n1_0.last_modified_by,n1_0.last_modified_date,n1_0.latitude,n1_0.local_state,n1_0.longitude,n1_0.mute_acoustic_signal,n2_0.id,n2_0.code,n2_0.command,n2_0.created_by,n2_0.created_date,n2_0.description,n2_0.drive_time_until_deregistration,n2_0.for_notification_path,n2_0.foreign_id,n2_0.foreign_id2,n2_0.foreign_source,n2_0.function_type,n2_0.function_type_list_json,n2_0.gid,n2_0.last_modified_by,n2_0.last_modified_date,n2_0.manual_registration,n2_0.notification_path_id,n2_0.reimport_version,n2_0.relevance,n2_0.status_type,n2_0.version,n1_0.notification_point_type,o1_0.notification_point_instance_id,o1_0.id,o1_0.carrier_start_platform_code,o1_0.created_by,o1_0.created_date,o1_0.distance_from_previous_stop,o1_0.distance_route_item,o1_0.distance_route_start,o1_0.initial_carrier_start_platform_code,o1_0.initial_distance_from_previous_stop,o1_0.initial_route_element_id,o1_0.invalid,o1_0.last_modified_by,o1_0.last_modified_date,o1_0.route_id,r1_0.id,r1_0.boundary_east,r1_0.boundary_north,r1_0.boundary_south,r1_0.boundary_west,r1_0.created_by,r1_0.created_date,r1_0.end_platform_id,r1_0.gid,r1_0.last_modified_by,r1_0.last_modified_date,p1_0.route_element_id,p1_0.id,p1_0.distance_from_start,p1_0.gid,p1_0.latitude,p1_0.longitude,r1_0.show_on_map,r1_0.start_platform_id,r1_0.version,o1_0.version,n1_0.pairing_timestamp,n1_0.pairing_user_id,n1_0.reimport_version,n1_0.relevant_for_fault_logs,n1_0.relevant_for_fault_logs_description,n1_0.reliability,n1_0.remark,n1_0.sensitivity,n1_0.short_name_vsr,n1_0.state,n1_0.switch_type_id,n1_0.traffic_lane_id,n1_0.traffic_signal_id,n1_0.traffic_signal_node_id,n1_0.verification_timestamp,n1_0.verification_user_id,n1_0.version,n1_0.zuabfahrt from notification_point_instance n1_0 left join notification_point n2_0

Question

Hibernate: select n1_0.id,n1_0.acoustic_signal,n1_0.changed,n1_0.code,n1_0.created_by,n1_0.created_date,n1_0.description,n1_0.distance_to_stop_line,n1_0.fault_state,n1_0.foreign_id,n1_0.gid,n1_0.initial_distance_to_stop_line,n1_0.initial_latitude,n1_0.initial_longitude,n1_0.last_changed_reset_date,n1_0.last_modified_by,n1_0.last_modified_date,n1_0.latitude,n1_0.local_state,n1_0.longitude,n1_0.mute_acoustic_signal,n2_0.id,n2_0.code,n2_0.command,n2_0.created_by,n2_0.created_date,n2_0.description,n2_0.drive_time_until_deregistration,n2_0.for_notification_path,n2_0.foreign_id,n2_0.foreign_id2,n2_0.foreign_source,n2_0.function_type,n2_0.function_type_list_json,n2_0.gid,n2_0.last_modified_by,n2_0.last_modified_date,n2_0.manual_registration,n2_0.notification_path_id,n2_0.reimport_version,n2_0.relevance,n2_0.status_type,n2_0.version,n1_0.notification_point_type,o1_0.notification_point_instance_id,o1_0.id,o1_0.carrier_start_platform_code,o1_0.created_by,o1_0.created_date,o1_0.distance_from_previous_stop,o1_0.distance_route_item,o1_0.distance_route_start,o1_0.initial_carrier_start_platform_code,o1_0.initial_distance_from_previous_stop,o1_0.initial_route_element_id,o1_0.invalid,o1_0.last_modified_by,o1_0.last_modified_date,o1_0.route_id,r1_0.id,r1_0.boundary_east,r1_0.boundary_north,r1_0.boundary_south,r1_0.boundary_west,r1_0.created_by,r1_0.created_date,r1_0.end_platform_id,r1_0.gid,r1_0.last_modified_by,r1_0.last_modified_date,p1_0.route_element_id,p1_0.id,p1_0.distance_from_start,p1_0.gid,p1_0.latitude,p1_0.longitude,r1_0.show_on_map,r1_0.start_platform_id,r1_0.version,o1_0.version,n1_0.pairing_timestamp,n1_0.pairing_user_id,n1_0.reimport_version,n1_0.relevant_for_fault_logs,n1_0.relevant_for_fault_logs_description,n1_0.reliability,n1_0.remark,n1_0.sensitivity,n1_0.short_name_vsr,n1_0.state,n1_0.switch_type_id,n1_0.traffic_lane_id,n1_0.traffic_signal_id,n1_0.traffic_signal_node_id,n1_0.verification_timestamp,n1_0.verification_user_id,n1_0.version,n1_0.zuabfahrt from notification_point_instance n1_0 left join notification_point n2_0

on n2_0.id=n1_0.notification_point_id left join npi_on_route o1_0 on n1_0.id=o1_0.notification_point_instance_id left join route_element r1_0 on r1_0.id=o1_0.route_element_id left join point_on_route_element p1_0 on r1_0.id=p1_0.route_element_id where n1_0.id=? order by p1_0.distance_from_start

#java #programming #russian

0

21.08.2023