묻고 답해요
164만명의 커뮤니티!! 함께 토론해봐요.
인프런 TOP Writers
-
미해결스프링 핵심 원리 - 고급편
클래스 기반 프록시에서
클래스 기반 프록시를 만들 때,프록시는 프록시 대상 클래스를 상속 받고, target을 주입 받아서 호출하는데어차피 프록시 대상 클래스를 상속 받아야한다면, 그냥 super.로직()을 호출하면 안되나요?그럼 target을 주입 받을 필요도 없어질텐데 혹시 이 방법은 왜 안되는지 궁금해서 질문 드립니다.
-
미해결비전공자를 위한 진짜 입문 올인원 개발 부트캠프
안녕하세요 공부중인데 답변 부탁드립니다.
React 말고 vue 를공부하고 왔는데 vue로 프로젝트만들라고하는데 많이다를까요?
-
미해결자바 프로그래밍 입문 강좌 (renew ver.) - 초보부터 개발자 취업까지!!
배열예제 오류
System.out.printf("s% 점수 : \t%.2f\n", name[0], (double)score[0]); System.out.printf("s% 점수 : \t%.2f\n", name[1], (double)score[1]); System.out.printf("s% 점수 : \t%.2f\n", name[2], (double)score[2]); System.out.printf("s% 점수 : \t%.2f\n", name[3], (double)score[3]); System.out.printf("s% 점수 : \t%.2f\n", name[4], (double)score[4]); 이부분에서만 에러가 나오는데 왜그런가여.. 이거없이 코드 실행하면 점수 입력 및 평균구해지는건 되는데 뭐가 문제인지 모르겠습니다..
-
미해결[코드팩토리] [중급] Flutter 진짜 실전! 상태관리, 캐시관리, Code Generation, GoRouter, 인증로직 등 중수가 되기 위한 필수 스킬들!
flutter_secure_storage: ^6.0.0 사용 때문인지요?
flutter_secure_storage: ^6.0.0이 버전을 사용했어 그런지 write 문장에서 특별한 에러가 없는데바로 read 해도 null 입니다이것은 버전 문제 일까요?-----------------------print(resp.data);final refreshToken = resp.data['refreshToken'];final accessToken = resp.data['accessToken'];print('login refreshToken:$refreshToken');print('login accessToken:$accessToken');await storage.write(key: REFRESH_TOKEN_KEY, value: refreshToken);await storage.write(key: ACCESS_TOKEN_KEY, value: accessToken);final readRefreshToken = await storage.read(key: 'REFRESH_TOKEN_KEY');final readAccessToken = await storage.read(key: 'ACCESS_TOKEN_KEY');print('readRefreshToken:$readRefreshToken');print('readAccessToken:$readAccessToken');-----------------------{refreshToken: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6InRlc3RAY29kZWZhY3RvcnkuYWkiLCJzdWIiOiJmNTViMzJkMi00ZDY4LTRjMWUtYTNjYS1kYTlkN2QwZDkyZTUiLCJ0eXBlIjoicmVmcmVzaCIsImlhdCI6MTY2NzM4NTQ3OSwiZXhwIjoxNjY3NDcxODc5fQ.B8Bik9YKNZ8VtCO7BQypqwnR8i9HCpKjWSwDuAwneZk, accessToken: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6InRlc3RAY29kZWZhY3RvcnkuYWkiLCJzdWIiOiJmNTViMzJkMi00ZDY4LTRjMWUtYTNjYS1kYTlkN2QwZDkyZTUiLCJ0eXBlIjoiYWNjZXNzIiwiaWF0IjoxNjY3Mzg1NDc5LCJleHAiOjE2NjczODU3Nzl9.pUQfDzJ4dd9pMv1FgHJqj7Pv3firnaz7s0JLAtjd5BE}I/flutter (10390): login refreshToken:eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6InRlc3RAY29kZWZhY3RvcnkuYWkiLCJzdWIiOiJmNTViMzJkMi00ZDY4LTRjMWUtYTNjYS1kYTlkN2QwZDkyZTUiLCJ0eXBlIjoicmVmcmVzaCIsImlhdCI6MTY2NzM4NTQ3OSwiZXhwIjoxNjY3NDcxODc5fQ.B8Bik9YKNZ8VtCO7BQypqwnR8i9HCpKjWSwDuAwneZkI/flutter (10390): login accessToken:eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6InRlc3RAY29kZWZhY3RvcnkuYWkiLCJzdWIiOiJmNTViMzJkMi00ZDY4LTRjMWUtYTNjYS1kYTlkN2QwZDkyZTUiLCJ0eXBlIjoiYWNjZXNzIiwiaWF0IjoxNjY3Mzg1NDc5LCJleHAiOjE2NjczODU3Nzl9.pUQfDzJ4dd9pMv1FgHJqj7Pv3firnaz7s0JLAtjd5BEI/flutter (10390): readRefreshToken:nullI/flutter (10390): readAccessToken:null
-
미해결파이썬(Python)으로 데이터 기반 주식 퀀트 투자하기 Part1
경로설정 다시
- 스샷을 보니, jupyter를 workspace 폴더가 아닌 Untitled Folder에서 실행한 것 같은데 확인부탁드려도될까요?anaconda console을 이용해서 수업자료 notebook file이 있는 폴더로 이동한뒤(cd) 해당 경로에서 jupyter lab 을 실행시키기 바랍니다.선생님 말씀대로 untitled folder에서 불러온것 같아요다만 anaconda prompt를 이용해서 주피터를 실행시킬 때 항상 하는 cd Desktop cd python_class(work space) jupyter-lab으로 실행했었고 이번 사진을 보면 또 Untitled Folder에서 실행시키지 않고도 되지만제가 답변을 명확하게 이해하지 못한것 같아요 anaconda console을 이용해서 수업자료 notebook file이 있는 폴더로 이동한뒤(cd) 해당 경로에서 jupyter lab 을 실행은 처음에 주피터를 실행시키는 cd Desktop cd python_class(work space) jupyter-lab 이거 말고 다른 건가요?Untitled Folder에서 실행하지 않더라도 예전처럼 (예를 들면lec1_0~lec1_7)이 table of conten을 눌렀을 때 한번에 안뜨네요 ㅠㅠ처음 사진 경로는 / inflearn~~part1~~ 전에는 없습니다
-
미해결블록체인 이더리움 부동산 댑(Dapp) 만들기 - 기본편
전제 소스 코드
혹시 전체 소스 코드가 있는 자료가 있을까요!? 치면서 따라하는데 디버깅하는게 너무 오래걸려서요ㅜㅜ
-
미해결10주완성 C++ 코딩테스트 | 알고리즘 코딩테스트
[코딩질문 드립니다] 백준 해킹
http://boj.kr/75e1a72c7eab45d6a16e0aa2fa830207 안녕하십니까 강사님. 백준 해킹 문제 풀다가, 틀린곳이 찾기 힘들어서 제 코딩실력에 한탄하며 강사님 교육 수강했습니다.강의 듣다보니 질문하는것도 답해주신다길래 글남겨 봅니다. 시간되시면 어디가 틀렸는지 확인해주시면 안될까요.. 감사합니다.김기정 드림
-
해결됨모의해킹 실무자가 알려주는, SQL Injection 공격 기법과 시큐어 코딩 : PART 1
php 기반 로그인 기능 제작 관련해서 질문드립니다.
제작은 했는데요 사이트 들어가면 한글이 깨져서 나와요 어떻게 해야하죠???
-
미해결[리뉴얼] React로 NodeBird SNS 만들기
노드버드 프로젝트에 테스트코드를 작성중에 있는데요!
안녕하세요! 제가 노드버드 프로젝트에 테스트코드를 작성하고 싶어서 독학하는 중에 정말 안 풀리는게 있어서 문의드립니다.. 기존에 스토어 만든 코드를 가지고 테스트용 스토어를 생성하고 있습니다. 아래는 제가 작성한 코드입니다..import React from 'react' import { render } from '@testing-library/react' import wrapper from 'redux/store'; const Wrapper = ({ children }) => { return <>{children}</> }; const customRender = (ui, options) => render(ui, { wrapper: wrapper.withRedux(Wrapper), ...options }) export * from '@testing-library/react' // override render method export { customRender as renderRedux } 아래는 오류 내용입니다. console.error Warning: React.createElement: type is invalid -- expected a string (for built-in components) or a class/function (for composite components) but got: undefined. You likely forgot to export your component from the file it's defined in, or you might have mixed up default and named imports. Check the render method of withRedux(Wrapper). at Wrapper () 12 | 13 | const customRender = (ui, options) => > 14 | render(ui, { wrapper: wrapper.withRedux(Wrapper), ...options }) | ^ 15 | 16 | export * from '@testing-library/react' 아무리 생각해도 떠오르지 않는데..혹시 조언해주실수 있으실까요 ㅜㅜ
-
미해결실전! 스프링 부트와 JPA 활용1 - 웹 애플리케이션 개발
H2 DB에 임의의 데이터 넣기
제가 schema.sql 파일로 테이블을 만들고, data.sql 파일로 row값을 넣었는데요.테이블에 의미없는 데이터를 100개정도 넣어둘려 하는데, 100개를 타이핑하기에는 힘들잖아요?그래서 같은내용의 데이터를 아이디(primary key)만 바꿔서 100개정도 넣는 쿼리문이 있나요?
-
미해결WPF (.NET Core, C#, 자막제공)
CellTemplate에 새로만들기가 안떠요
CellTemplate에 새로만들기가 안떠서 DateTemplate를 사용하지 못하는 상황인데 어떻게 하면 되나요?
-
미해결애프터이펙트 마스터 시즌1 패키지(에피소드1,2,3,4통합)
강의 1 보고 있습니다.
강의 보면서 사무실에서 뿜었습니다.거북이 설명하시는거 진짜 재밌으세요!강의도 기대됩니다.
-
해결됨따라하며 배우는 리액트 A-Z[19버전 반영]
넷플릭스 강의를 다듣고 궁금한점이있어 질문드립니다!
- 학습 관련 질문을 남겨주세요. 상세히 작성하면 더 좋아요! - 먼저 유사한 질문이 있었는지 검색해보세요. - 서로 예의를 지키며 존중하는 문화를 만들어가요. - 잠깐! 인프런 서비스 운영 관련 문의는 1:1 문의하기를 이용해주세요. 넷플릭스 로고를 누르면 새로고침이 아닌 검색페이지와 같은 다른 페이지에서 메인페이지로 다시오게 하려면 어떻게 해야할까요?? (제가 react-router-dom에 아직 이해를 못한거 같습니다.)검색페이지에서 검색을 하고 뒤로가기버튼을 누르면 타이핑한 글자 하나 하나씩 뒤로가기가 되는데 이걸 뒤로가기 했을때 바로 그 뒤에 페이지인(현재는 메인페이지로) 이동을 하려면 어떻게 해야 할까요?
-
미해결15일간의 빅데이터 파일럿 프로젝트
클라우데라 설치시 호스트 검사 오
결과가 이렇게 나와서 환경 구축하는 거 좀 알려주세요
-
해결됨스프링 핵심 원리 - 기본편
main 혹은 controller 등에서 Appconfig를 사용하는 것
[질문 내용]질문 게시판에 글을 읽다 보니public class AppConfig { public MemberService memberService() { return new MemberServiceImpl(); } public MemeberRepository memberRepository() { return new MemoryMemberRepository(); } }public class MemberServiceImpl implements MemberService { AppConfig appConfig = new AppConfig(); MemberRepository memberRepository = appConfig.memberRepository(); @Override public void join(Member member) { memberRepository.save(member); } @Override public Member findMember(Long memberId) { return memberRepository.findById(memberId); } }위와 같은 코드형식은 MemberServiceImpl이 AppConfig를 의존하는 형식이 되기 때문에 생성자를 사용하여 불필요한 의존관계를 줄인다고 보았습니다. 그렇다면 강의에서 Main 메서드나 Test 코드에서 service를 사용하기 위해 Appconfig를 사용하는 것은 Main 메서드가 AppConfig를 의존한다고 볼 수 있지 않나요? 위에서 얘기한 이유로 MemberServiceImpl에서 AppConfig를 사용하지 않는다면 Main 메서드에서는 왜 AppConfig를 사용하는지 의문입니다.
-
미해결실전! 스프링 부트와 JPA 활용2 - API 개발과 성능 최적화
setFirstResult 와 setMaxResults 적용 안되는 문제
[질문 템플릿]1. 강의 내용과 관련된 질문인가요? (예/아니오)2. 인프런의 질문 게시판과 자주 하는 질문에 없는 내용인가요? (예/아니오)3. 질문 잘하기 메뉴얼을 읽어보셨나요? (예/아니오)[질문 내용]orderRepository 파일의 findAllWithItem 함수를 통해 데이터를 불러 올때 setFirstResult 과 setMaxResults 를 통해 페이징을 하기로 코드에 설정하였습니다.하지만 실제로 api(/api/v3.1/orders?offset=1&limit=10)를 호출해보면 jpa를 통해 만들어지는 쿼리에 offset 및 limit 이 적용되지 않고 날라갑니다. 어떤 문제가 있는지 찾아보았으나 찾지 못하여 질문 올립니다.OrderRepository.javapackage jpabook.jpashop.repository; import jpabook.jpashop.api.OrderSimpleApiController; import jpabook.jpashop.domain.Order; import lombok.RequiredArgsConstructor; import org.springframework.stereotype.Repository; import javax.persistence.EntityManager; import java.util.List; @Repository @RequiredArgsConstructor public class OrderRepository { private final EntityManager em; public void save(Order order) { em.persist(order); } public Order findOne(Long id) { return em.find(Order.class, id); } public List<Order> findAll(OrderSearch orderSearch) { return em.createQuery("select o from Order o join o.member m" + " where o.status = :status" + " and m.name like :name", Order.class) .setParameter("status", orderSearch.getOrderStatus()) .setParameter("name", orderSearch.getMemberName()) .setFirstResult(0) .setMaxResults(1000) .getResultList(); } public List<Order> findAllWithMemberDelivery() { return em.createQuery( "select o from Order o" + " join fetch o.member m" + " join fetch o.delivery d", Order.class ).getResultList(); } public List<Order> findAllWithItem() { return em.createQuery( "select distinct o from Order o" + " join fetch o.member m" + " join fetch o.delivery d" + " join fetch o.orderItems oi" + " join fetch oi.item i", Order.class ).getResultList(); } public List<Order> findAllWithItem(int offset, int limit) { return em.createQuery( "select o from Order o" + " join fetch o.member m" + " join fetch o.delivery d", Order.class) .setFirstResult(offset) .setMaxResults(limit) .getResultList(); } } OrderApiController.javapackage jpabook.jpashop.api; import ch.qos.logback.classic.sift.AppenderFactoryUsingJoran; import jpabook.jpashop.domain.Address; import jpabook.jpashop.domain.Order; import jpabook.jpashop.domain.OrderItem; import jpabook.jpashop.domain.OrderStatus; import jpabook.jpashop.repository.OrderRepository; import jpabook.jpashop.repository.OrderSearch; import lombok.Data; import lombok.RequiredArgsConstructor; import org.hibernate.cache.spi.support.AbstractCachedDomainDataAccess; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import java.time.LocalDateTime; import java.util.List; import java.util.stream.Collectors; @RestController @RequiredArgsConstructor public class OrderApiController { private final OrderRepository orderRepository; @GetMapping("/api/v1/orders") public List<Order> ordersv1() { List<Order> all = orderRepository.findAll(new OrderSearch()); for (Order order : all) { order.getMember().getName(); order.getDelivery().getAddress(); List<OrderItem> orderItems = order.getOrderItems(); orderItems.stream().forEach(o-> o.getItem().getName()); } return all; } @GetMapping("/api/v2/orders") public List<OrderDto> ordersv2() { List<Order> orders = orderRepository.findAll(new OrderSearch()); List<OrderDto> result = orders.stream() .map(o -> new OrderDto(o)) .collect(Collectors.toList()); return result; } @GetMapping("/api/v3/orders") public List<OrderDto> ordersV3( @RequestParam(value = "offset", defaultValue = "0") int offset, @RequestParam(value = "limit", defaultValue = "100") int limit ) { List<Order> orders=orderRepository.findAllWithItem(offset, limit ); List<OrderDto> result = orders.stream() .map(o -> new OrderDto(o)) .collect(Collectors.toList()); return result; } @GetMapping("/api/v3.1/orders") public List<OrderDto> ordersV3_page() { List<Order> orders=orderRepository.findAllWithMemberDelivery(); List<OrderDto> result = orders.stream() .map(o -> new OrderDto(o)) .collect(Collectors.toList()); return result; } @Data static class OrderDto { private Long orderId; private String name; private LocalDateTime orderDate; private OrderStatus orderStatus; private Address address; private List<OrderItemDto> orderItems; public OrderDto(Order order) { orderId =order.getId(); name= order.getMember().getName(); orderDate = order.getOrderDate(); orderStatus = order.getStatus(); address=order.getDelivery().getAddress(); orderItems=order.getOrderItems().stream().map(orderItem -> new OrderItemDto(orderItem)).collect(Collectors.toList()); } } @Data static class OrderItemDto { private String itemName; private int orderPrice; private int count; public OrderItemDto(OrderItem orderItem) { itemName = orderItem.getItem().getName(); orderPrice=orderItem.getOrderPrice(); count=orderItem.getCount(); } } } api 호출시 터미널에 뜨는 메시지 select order0_.order_id as order_id1_6_0_, member1_.member_id as member_i1_4_1_, delivery2_.delivery_id as delivery1_2_2_, order0_.delivery_id as delivery4_6_0_, order0_.member_id as member_i5_6_0_, order0_.order_date as order_da2_6_0_, order0_.status as status3_6_0_, member1_.city as city2_4_1_, member1_.street as street3_4_1_, member1_.zipcode as zipcode4_4_1_, member1_.name as name5_4_1_, delivery2_.city as city2_2_2_, delivery2_.street as street3_2_2_, delivery2_.zipcode as zipcode4_2_2_, delivery2_.status as status5_2_2_ from orders order0_ inner join member member1_ on order0_.member_id=member1_.member_id inner join delivery delivery2_ on order0_.delivery_id=delivery2_.delivery_id Hibernate: select order0_.order_id as order_id1_6_0_, member1_.member_id as member_i1_4_1_, delivery2_.delivery_id as delivery1_2_2_, order0_.delivery_id as delivery4_6_0_, order0_.member_id as member_i5_6_0_, order0_.order_date as order_da2_6_0_, order0_.status as status3_6_0_, member1_.city as city2_4_1_, member1_.street as street3_4_1_, member1_.zipcode as zipcode4_4_1_, member1_.name as name5_4_1_, delivery2_.city as city2_2_2_, delivery2_.street as street3_2_2_, delivery2_.zipcode as zipcode4_2_2_, delivery2_.status as status5_2_2_ from orders order0_ inner join member member1_ on order0_.member_id=member1_.member_id inner join delivery delivery2_ on order0_.delivery_id=delivery2_.delivery_id 2022-11-02 16:18:50.294 INFO 31332 --- [nio-8080-exec-1] p6spy : #1667373530294 | took 0ms | statement | connection 6| url jdbc:h2:tcp://localhost/~/jpashop select order0_.order_id as order_id1_6_0_, member1_.member_id as member_i1_4_1_, delivery2_.delivery_id as delivery1_2_2_, order0_.delivery_id as delivery4_6_0_, order0_.member_id as member_i5_6_0_, order0_.order_date as order_da2_6_0_, order0_.status as status3_6_0_, member1_.city as city2_4_1_, member1_.street as street3_4_1_, member1_.zipcode as zipcode4_4_1_, member1_.name as name5_4_1_, delivery2_.city as city2_2_2_, delivery2_.street as street3_2_2_, delivery2_.zipcode as zipcode4_2_2_, delivery2_.status as status5_2_2_ from orders order0_ inner join member member1_ on order0_.member_id=member1_.member_id inner join delivery delivery2_ on order0_.delivery_id=delivery2_.delivery_id select order0_.order_id as order_id1_6_0_, member1_.member_id as member_i1_4_1_, delivery2_.delivery_id as delivery1_2_2_, order0_.delivery_id as delivery4_6_0_, order0_.member_id as member_i5_6_0_, order0_.order_date as order_da2_6_0_, order0_.status as status3_6_0_, member1_.city as city2_4_1_, member1_.street as street3_4_1_, member1_.zipcode as zipcode4_4_1_, member1_.name as name5_4_1_, delivery2_.city as city2_2_2_, delivery2_.street as street3_2_2_, delivery2_.zipcode as zipcode4_2_2_, delivery2_.status as status5_2_2_ from orders order0_ inner join member member1_ on order0_.member_id=member1_.member_id inner join delivery delivery2_ on order0_.delivery_id=delivery2_.delivery_id; 2022-11-02 16:18:50.296 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_id1_6_0_] : [BIGINT]) - [4] 2022-11-02 16:18:50.296 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([member_i1_4_1_] : [BIGINT]) - [1] 2022-11-02 16:18:50.297 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([delivery1_2_2_] : [BIGINT]) - [5] 2022-11-02 16:18:50.298 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([delivery4_6_0_] : [BIGINT]) - [5] 2022-11-02 16:18:50.298 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([member_i5_6_0_] : [BIGINT]) - [1] 2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_da2_6_0_] : [TIMESTAMP]) - [2022-11-02T16:18:45.107619] 2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([status3_6_0_] : [VARCHAR]) - [ORDER] 2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([city2_4_1_] : [VARCHAR]) - [seoul] 2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([street3_4_1_] : [VARCHAR]) - [1] 2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([zipcode4_4_1_] : [VARCHAR]) - [111] 2022-11-02 16:18:50.299 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([name5_4_1_] : [VARCHAR]) - [userA] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([city2_2_2_] : [VARCHAR]) - [seoul] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([street3_2_2_] : [VARCHAR]) - [1] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([zipcode4_2_2_] : [VARCHAR]) - [111] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([status5_2_2_] : [VARCHAR]) - [null] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_id1_6_0_] : [BIGINT]) - [11] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([member_i1_4_1_] : [BIGINT]) - [8] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([delivery1_2_2_] : [BIGINT]) - [12] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([delivery4_6_0_] : [BIGINT]) - [12] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([member_i5_6_0_] : [BIGINT]) - [8] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_da2_6_0_] : [TIMESTAMP]) - [2022-11-02T16:18:45.142303] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([status3_6_0_] : [VARCHAR]) - [ORDER] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([city2_4_1_] : [VARCHAR]) - [tokyo] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([street3_4_1_] : [VARCHAR]) - [1] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([zipcode4_4_1_] : [VARCHAR]) - [111] 2022-11-02 16:18:50.300 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([name5_4_1_] : [VARCHAR]) - [userB] 2022-11-02 16:18:50.301 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([city2_2_2_] : [VARCHAR]) - [tokyo] 2022-11-02 16:18:50.301 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([street3_2_2_] : [VARCHAR]) - [1] 2022-11-02 16:18:50.301 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([zipcode4_2_2_] : [VARCHAR]) - [111] 2022-11-02 16:18:50.301 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([status5_2_2_] : [VARCHAR]) - [null] 2022-11-02 16:18:50.306 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType : Created collection wrapper: [jpabook.jpashop.domain.Order.orderItems#4] 2022-11-02 16:18:50.307 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType : Created collection wrapper: [jpabook.jpashop.domain.Member.orders#1] 2022-11-02 16:18:50.307 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType : Created collection wrapper: [jpabook.jpashop.domain.Order.orderItems#11] 2022-11-02 16:18:50.307 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType : Created collection wrapper: [jpabook.jpashop.domain.Member.orders#8] 2022-11-02 16:18:50.310 DEBUG 31332 --- [nio-8080-exec-1] org.hibernate.SQL : select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=? Hibernate: select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=? 2022-11-02 16:18:50.311 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [4] 2022-11-02 16:18:50.312 INFO 31332 --- [nio-8080-exec-1] p6spy : #1667373530312 | took 0ms | statement | connection 6| url jdbc:h2:tcp://localhost/~/jpashop select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=? select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=4; 2022-11-02 16:18:50.315 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_it1_5_1_] : [BIGINT]) - [6] 2022-11-02 16:18:50.316 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([count2_5_1_] : [INTEGER]) - [1] 2022-11-02 16:18:50.316 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([item_id4_5_1_] : [BIGINT]) - [3] 2022-11-02 16:18:50.316 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_id5_5_1_] : [BIGINT]) - [4] 2022-11-02 16:18:50.316 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_pr3_5_1_] : [INTEGER]) - [10000] 2022-11-02 16:18:50.317 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_id5_5_0_] : [BIGINT]) - [4] 2022-11-02 16:18:50.317 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_it1_5_0_] : [BIGINT]) - [6] 2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_it1_5_1_] : [BIGINT]) - [7] 2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([count2_5_1_] : [INTEGER]) - [2] 2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([item_id4_5_1_] : [BIGINT]) - [3] 2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_id5_5_1_] : [BIGINT]) - [4] 2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_pr3_5_1_] : [INTEGER]) - [10000] 2022-11-02 16:18:50.319 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_id5_5_0_] : [BIGINT]) - [4] 2022-11-02 16:18:50.320 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_it1_5_0_] : [BIGINT]) - [7] 2022-11-02 16:18:50.324 DEBUG 31332 --- [nio-8080-exec-1] org.hibernate.SQL : select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=? Hibernate: select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=? 2022-11-02 16:18:50.325 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [3] 2022-11-02 16:18:50.325 INFO 31332 --- [nio-8080-exec-1] p6spy : #1667373530325 | took 0ms | statement | connection 6| url jdbc:h2:tcp://localhost/~/jpashop select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=? select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=3; 2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([dtype1_3_0_] : [VARCHAR]) - [B] 2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([name3_3_0_] : [VARCHAR]) - [jap2 book] 2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([price4_3_0_] : [INTEGER]) - [10000] 2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([stock_qu5_3_0_] : [INTEGER]) - [97] 2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([author8_3_0_] : [VARCHAR]) - [null] 2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([isbn9_3_0_] : [VARCHAR]) - [null] 2022-11-02 16:18:50.326 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType : Created collection wrapper: [jpabook.jpashop.domain.item.Item.categories#3] 2022-11-02 16:18:50.327 DEBUG 31332 --- [nio-8080-exec-1] org.hibernate.SQL : select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=? Hibernate: select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=? 2022-11-02 16:18:50.327 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [11] 2022-11-02 16:18:50.327 INFO 31332 --- [nio-8080-exec-1] p6spy : #1667373530327 | took 0ms | statement | connection 6| url jdbc:h2:tcp://localhost/~/jpashop select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=? select orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.count as count2_5_1_, orderitems0_.item_id as item_id4_5_1_, orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_price as order_pr3_5_1_ from order_item orderitems0_ where orderitems0_.order_id=11; 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_it1_5_1_] : [BIGINT]) - [13] 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([count2_5_1_] : [INTEGER]) - [2] 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([item_id4_5_1_] : [BIGINT]) - [10] 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_id5_5_1_] : [BIGINT]) - [11] 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_pr3_5_1_] : [INTEGER]) - [20000] 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_id5_5_0_] : [BIGINT]) - [11] 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_it1_5_0_] : [BIGINT]) - [13] 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_it1_5_1_] : [BIGINT]) - [14] 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([count2_5_1_] : [INTEGER]) - [3] 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([item_id4_5_1_] : [BIGINT]) - [10] 2022-11-02 16:18:50.328 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_id5_5_1_] : [BIGINT]) - [11] 2022-11-02 16:18:50.329 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_pr3_5_1_] : [INTEGER]) - [30000] 2022-11-02 16:18:50.329 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_id5_5_0_] : [BIGINT]) - [11] 2022-11-02 16:18:50.329 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([order_it1_5_0_] : [BIGINT]) - [14] 2022-11-02 16:18:50.329 DEBUG 31332 --- [nio-8080-exec-1] org.hibernate.SQL : select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=? Hibernate: select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=? 2022-11-02 16:18:50.330 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [BIGINT] - [10] 2022-11-02 16:18:50.330 INFO 31332 --- [nio-8080-exec-1] p6spy : #1667373530330 | took 0ms | statement | connection 6| url jdbc:h2:tcp://localhost/~/jpashop select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=? select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.artist as artist6_3_0_, item0_.etc as etc7_3_0_, item0_.author as author8_3_0_, item0_.isbn as isbn9_3_0_, item0_.actor as actor10_3_0_, item0_.director as directo11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id=10; 2022-11-02 16:18:50.330 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([dtype1_3_0_] : [VARCHAR]) - [B] 2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([name3_3_0_] : [VARCHAR]) - [spring2 book] 2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([price4_3_0_] : [INTEGER]) - [10000] 2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([stock_qu5_3_0_] : [INTEGER]) - [95] 2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([author8_3_0_] : [VARCHAR]) - [null] 2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] o.h.type.descriptor.sql.BasicExtractor : extracted value ([isbn9_3_0_] : [VARCHAR]) - [null] 2022-11-02 16:18:50.331 TRACE 31332 --- [nio-8080-exec-1] org.hibernate.type.CollectionType : Created collection wrapper: [jpabook.jpashop.domain.item.Item.categories#10]
-
미해결Node.js로 웹 크롤링하기
프록시 서버 연결 문제
이전 질문에도 있었는데 프록시 서버 연결이 안되는데 혹시 이유가 무엇일까요?코드를 그대로 작성해서 하여도 접속이 안되네요.ip를 1~2개가 아니라 10개 이상을 다른 것들로 해봤는데도 안되서 프록시 서버의 문제보다도 다른 문제가 있는 게 아닐까 싶어서요.(이전 문제들에 답변에는 다른 프록시 서버를 써보라고 하셔서 10개 이상 시도를 해본 뒤 질문드립니다(다른 사이트의 프록시 서버도 사용해보았습니다). 포트번호를 넣어서도 해보고 빼보고도 해보고 http도 붙여보고 별 난리를 다 해봤네요)감사합니다.+) 결과 화면감사합니다.
-
미해결[실전 게임 코드 리뷰] 유니티 클리커 게임
Destroy/Active(false,true) 관련 코루틴 질문
안녕하세요. 코루틴 관련되서 질문이 있어 질문 드리게 되었습니다.코루틴을 사용할때 GameObject를 SetActive 할 경우 actvie(false)한 뒤 다시 active(true)상태가 되면 코루틴이 작동을 하지 않는 것으로 알고 있습니다.만약 코루틴을 사용하려고 하는데 active 해야할 GameObject가 있다면 어떤식으로 사용하는 것이 가장 좋은 방법인가요?
-
미해결취미로 해킹#1(OverTheWire - Bandit)
ssh 명령어 쓸 때 권한 거부됬다고 떠요
혹시 몰라서 chmod 600 도 함 해봤는데 역시나 안되더라구요ㅠㅜbandit13 사용자 나가서 그냥 홈에서 scp -p 2220 bandit13@bandit.labs.overthewire.org:sshkey.private . 도 해봤는데 요것도 권한 거부 떠요ㅠㅜㅠ
-
미해결[개념반]배워서 바로 쓰는 SQL 쿼리
cross <-> inner join 문의
강의에서 cross join이 full outer join이라는 설명을 들었는데요실제로 해보니 cross join은 inner join과 같은 결과를 출력하고full outer join과는 결과가 다르더라구요.혹시 뭐가 맞는걸까요?