선생님 안녕하세요. 제가 몇가지 질문이 있습니다. 1. 에러 로그 확인 방법 질문 제가 선생님처럼 코드를 한번에 잘 작성하면 좋겠지만, 따라하는 과정에서 에러가 발생하였습니다. 현재 선생님 코드를 복사하여 docker 관련부분만 수정해서 작동은 합니다. 하지만 제가 다음에 aws를 사용할 때 이러한 에러가 발생한다면 어떤 오류인지 확인을 어떻게 해야할지 모르겠습니다. 예를 들어 travis ci는 Job log라는 창에서 빌드할때 에러를 확인할 수 있었습니다. 하지만 aws는 travis ci에서 성공적으로 빌드해도 에러가 발생하였는데 무엇을 고쳐야 하는지 저는 알 방법이 없었습니다... 또한 로그를 다운받아 봤지만 그파일 안에서도 다양한 txt 파일들이 있었습니다. 하지만 정작 제가 발생한 error를 어디서 확인해야 할 지 모르겠습니다.. 이러한 상황일 떄 선생님 께서는 어떻게 에러를 확인하시고 어디서 실마리를 찾는지 여쭤보고 싶습니다. 아래는 제가 에러가 발생 하였을떄 상황입니다. 2. 혹시 이러한 에러 코드가 나왔을때 선생님꼐서 정확한 정답을 내려주실수는 없어도 경험상 이러한 경우에 나온다고 말씀해주실 수 있을까요? 에러가 발생하는 경우가 다양한 것도 인지하고 있습니다. 정확히 A라는 상황에서 이런 로그가 남습니다. 라는 답변이 아니어도 선생님께서는 이러한 에러를 직면하신다면 어떻게 해결하려고 시도하실지 궁금합니다.. 2021-03-07 02:38:05 UTC+0900 WARN Environment health has transitioned from GREEN to YELLOW 2021-03-07 02:38:05 UTC+0900 WARN Elastic Load Balancer app/awseb-AWSEB-1UN2OUGOSAYCD/1ad65aededf55f2d has zero healthy instances. 2021-03-07 02:37:18 UTC+0900 ERROR During an aborted deployment, some instances may have deployed the new application version. To ensure all instances are running the same version, re-deploy the appropriate application version. 2021-03-07 02:37:18 UTC+0900 ERROR Failed to deploy application. 2021-03-07 02:37:18 UTC+0900 ERROR Unsuccessful command execution on instance id(s) 'i-0201a69c0018de7b0'. Aborting the operation. 2021-03-07 02:37:18 UTC+0900 INFO Command execution completed on all instances. Summary: [Successful: 0, TimedOut: 1]. 2021-03-07 02:37:18 UTC+0900 WARN The following instances have not responded in the allowed command timeout time (they might still finish eventually on their own): [i-0201a69c0018de7b0]. 2021-03-07 02:23:15 UTC+0900 INFO Deploying new version to instance(s). 선생님께서 바쁘실테지만 시간 괜찮으실 때 답변해주시면 정말 감사하겠습니다. 감사합니다.
1. 강의를 듣던 와중 /auth/logout 라우터 부분에서 req.logout() 이부분 설명 하실때 이 메소드가 세션쿠키가 서버에서 지워진다고 하셨는데 이 의미가 정확히 무엇인가요? 2. 저는 로그인 과정에서 세션에 세션쿠키가 저장되고 브라우저로 세션쿠키가 들어갔기 때문에 브라우저의 다음 요청부터는 세션쿠키가 함께 보내져서 서버가 그 요청을 누가 보냈는지 알게 되는 식으로 강의를 이해했는데 그러면 로그아웃시 req.logout()이 메소드는 브라우저의 세션쿠키를 지워주는 메소드로 생각되는데 제가 이해한 내용 중에서 잘 못 이해한 내용이 있나요..?
기본적인 기능을 갖춘 웹페이지서버를 AWS를 통해서 배포하려고합니다 !! 근데 가격책정하는 부분이 너무 많아서 잘못건드릴까봐 겁나기도하고 용량을 어느정도로 잡아줘야할지도 잘 감이안와가지고 ㅠㅠ 혹시 이런부분에 대해서 알 수 있는곳 있거나 팁좀 주실 수 있으신가용 ..??
안녕하세요 강사님. 이번 수업을 듣다가 오류가 나서 질문드려요 강의와 관련있는 질문 을 남겨주세요. org.hibernate.hql.internal.ast.ErrorTracker reportError ERROR: <AST>:1:36: unexpected AST node: . 우선 JpaMain 클래스 입니다. public class JpaMain { public static void main ( String [] args){ EntityManagerFactory emf = Persistence . createEntityManagerFactory ( "hello" ); //PersistenceUnitName EntityManager em = emf .createEntityManager(); EntityTransaction tx = em .getTransaction(); tx .begin(); try { Member member = new Member(); member .setUsername( "member1" ); member .setAge( 10 ); em .persist( member ); em .flush(); em .clear(); List < Member > result = em .createQuery( "Select m from Member m where m.username" , Member . class ).getResultList(); // 엔티티 프로젝션 Member findMember = result .get( 0 ); findMember .setAge( 20 ); //List<Team> result=em.createQuery("Select m.team from Member m join m.team",Team.class).getResultList(); // 엔티티프로덕션 //em.createQuery("Select o.address from Order o",Address.class).getResultList(); // 임베디드 타입 프로덕션 //List resultList = em.createQuery("Select distinct m.username, m.age from Member m").getResultList(); // 스칼라 타입 프로젝션 //Object o=resultList.get(0); //Object[] result=(Object[]) o; //System.out.println("username = "+result[0]); //System.out.println("age = "+result[1]); tx .commit(); } catch ( Exception e){ tx .rollback(); } finally { em .close(); } emf .close(); } } 엔티티 프로젝션을 실습하는데 오류가 나서 질문 드립니다. 엔티티 프로덕션, 임베디드 타입 프로젝션, 스칼라 타입 프로젝션 은 잘 작동 되는데 엔티티 프로젝션은 오류가 납니다. h2 데이터베이스에는 테이블만 생성될 뿐 데이터가 삽입되지 않았습니다.ㅠㅠ... [인텔리제이 컴파일 결과 오류] "C:\Program Files\Java\jdk-11.0.8\bin\java.exe" "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2020.2.3\lib\idea_rt.jar=65515:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2020.2.3\bin" -Dfile.encoding=UTF-8 -classpath C:\Users\IamZero\Desktop\spring\JPQL\target\classes;C:\Users\IamZero\.m2\repository\org\hibernate\hibernate-entitymanager\5.4.22.Final\hibernate-entitymanager-5.4.22.Final.jar;C:\Users\IamZero\.m2\repository\org\jboss\logging\jboss-logging\3.3.2.Final\jboss-logging-3.3.2.Final.jar;C:\Users\IamZero\.m2\repository\org\hibernate\hibernate-core\5.4.22.Final\hibernate-core-5.4.22.Final.jar;C:\Users\IamZero\.m2\repository\org\javassist\javassist\3.24.0-GA\javassist-3.24.0-GA.jar;C:\Users\IamZero\.m2\repository\antlr\antlr\2.7.7\antlr-2.7.7.jar;C:\Users\IamZero\.m2\repository\org\jboss\jandex\2.1.3.Final\jandex-2.1.3.Final.jar;C:\Users\IamZero\.m2\repository\com\fasterxml\classmate\1.5.1\classmate-1.5.1.jar;C:\Users\IamZero\.m2\repository\javax\activation\javax.activation-api\1.2.0\javax.activation-api-1.2.0.jar;C:\Users\IamZero\.m2\repository\org\glassfish\jaxb\jaxb-runtime\2.3.1\jaxb-runtime-2.3.1.jar;C:\Users\IamZero\.m2\repository\org\glassfish\jaxb\txw2\2.3.1\txw2-2.3.1.jar;C:\Users\IamZero\.m2\repository\com\sun\istack\istack-commons-runtime\3.0.7\istack-commons-runtime-3.0.7.jar;C:\Users\IamZero\.m2\repository\org\jvnet\staxex\stax-ex\1.8\stax-ex-1.8.jar;C:\Users\IamZero\.m2\repository\com\sun\xml\fastinfoset\FastInfoset\1.2.15\FastInfoset-1.2.15.jar;C:\Users\IamZero\.m2\repository\org\dom4j\dom4j\2.1.3\dom4j-2.1.3.jar;C:\Users\IamZero\.m2\repository\org\hibernate\common\hibernate-commons-annotations\5.1.0.Final\hibernate-commons-annotations-5.1.0.Final.jar;C:\Users\IamZero\.m2\repository\javax\persistence\javax.persistence-api\2.2\javax.persistence-api-2.2.jar;C:\Users\IamZero\.m2\repository\net\bytebuddy\byte-buddy\1.10.10\byte-buddy-1.10.10.jar;C:\Users\IamZero\.m2\repository\org\jboss\spec\javax\transaction\jboss-transaction-api_1.2_spec\1.1.1.Final\jboss-transaction-api_1.2_spec-1.1.1.Final.jar;C:\Users\IamZero\.m2\repository\com\h2database\h2\1.4.200\h2-1.4.200.jar;C:\Users\IamZero\.m2\repository\javax\xml\bind\jaxb-api\2.3.0\jaxb-api-2.3.0.jar jpql.JpaMain 3월 07, 2021 12:05:47 오전 org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation INFO: HHH000204: Processing PersistenceUnitInfo [name: hello] 3월 07, 2021 12:05:47 오전 org.hibernate.Version logVersion INFO: HHH000412: Hibernate ORM core version 5.4.22.Final 3월 07, 2021 12:05:48 오전 org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit> INFO: HCANN000001: Hibernate Commons Annotations {5.1.0.Final} 3월 07, 2021 12:05:48 오전 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!) 3월 07, 2021 12:05:48 오전 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator INFO: HHH10001005: using driver [org.h2.Driver] at URL [jdbc:h2:tcp://localhost/~/test] 3월 07, 2021 12:05:48 오전 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator INFO: HHH10001001: Connection properties: {password=****, user=sa} 3월 07, 2021 12:05:48 오전 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator INFO: HHH10001003: Autocommit mode: false 3월 07, 2021 12:05:48 오전 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections <init> INFO: HHH000115: Hibernate connection pool size: 20 (min=1) 3월 07, 2021 12:05:48 오전 org.hibernate.dialect.Dialect <init> INFO: HHH000400: Using dialect: org.hibernate.dialect.H2Dialect Hibernate: drop table if exists Member CASCADE Hibernate: drop table if exists ORDERS CASCADE Hibernate: drop table if exists Product CASCADE Hibernate: drop table if exists Team CASCADE Hibernate: drop sequence if exists hibernate_sequence Hibernate: create sequence hibernate_sequence start with 1 increment by 1 Hibernate: create table Member ( id bigint not null, age integer not null, username varchar(255), TEAM_ID bigint, primary key (id) ) Hibernate: create table ORDERS ( id bigint not null, city varchar(255), street varchar(255), zipcode varchar(255), orderAmount integer not null, PRODUCT_ID bigint, primary key (id) ) Hibernate: create table Product ( id bigint not null, name varchar(255), price integer not null, stockAmount integer not null, primary key (id) ) Hibernate: create table Team ( id bigint not null, name varchar(255), primary key (id) ) Hibernate: alter table Member add constraint FKl7wsny760hjy6x19kqnduasbm foreign key (TEAM_ID) references Team Hibernate: alter table ORDERS add constraint FKtlx3qxs8vwir2b80i3oumx2qm foreign key (PRODUCT_ID) references Product 3월 07, 2021 12:05:49 오전 org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@77b919a3] for (non-JTA) DDL execution was not in auto-commit mode; the Connection 'local transaction' will be committed and the Connection will be set into auto-commit mode. 3월 07, 2021 12:05:49 오전 org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@1cd3b138] for (non-JTA) DDL execution was not in auto-commit mode; the Connection 'local transaction' will be committed and the Connection will be set into auto-commit mode. 3월 07, 2021 12:05:49 오전 org.hibernate.engine.transaction.jta.platform.internal.JtaPlatformInitiator initiateService INFO: HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] Hibernate: call next value for hibernate_sequence Hibernate: /* insert jpql.Member */ insert into Member (age, TEAM_ID, username, id) values (?, ?, ?, ?) 3월 07, 2021 12:05:49 오전 org.hibernate.hql.internal.ast.ErrorTracker reportError ERROR: <AST>:1:36: unexpected AST node: . 3월 07, 2021 12:05:49 오전 org.hibernate.hql.internal.ast.ErrorTracker reportError ERROR: <AST>:1:36: unexpected AST node: . <AST>:1:36: unexpected AST node: . at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2169) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:827) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:621) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:325) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:273) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:276) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:192) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:113) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73) at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:162) at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:604) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:716) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:816) at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23) at jpql.JpaMain.main(JpaMain.java:23) 3월 07, 2021 12:05:49 오전 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PoolState stop INFO: HHH10001008: Cleaning up connection pool [jdbc:h2:tcp://localhost/~/test] Process finished with exit code 0 ------------------------------------------------------------------------------------------------------------------------------- 스칼라 타입 프로젝션 실습의 경우 데이터도 잘 나오고 있습니다. List resultList = em .createQuery( "Select distinct m.username, m.age from Member m" ).getResultList(); // 스칼라 타입 프로젝션 Object o = resultList .get( 0 ); Object [] result =( Object []) o ; ----------------------------------------------------------------------------------------------------------------------------- 다음은 실습하는데 사용한 파일입니다 [Address] @Embeddable public class Address { private String city ; private String street ; private String zipcode ; public String getCity () { return city ; } public void setCity ( String city) { this . city = city; } public String getStreet () { return street ; } public void setStreet ( String street) { this . street = street; } public String getZipcode () { return zipcode ; } public void setZipcode ( String zipcode) { this . zipcode = zipcode; } } [Member] @Entity public class Member { @Id @GeneratedValue private Long id ; private String username ; private int age ; @ManyToOne @JoinColumn (name= "TEAM_ID" ) private Team team ; public Long getId () { return id ; } public void setId ( Long id) { this . id = id; } public String getUsername () { return username ; } public void setUsername ( String username) { this . username = username; } public int getAge () { return age ; } public void setAge ( int age) { this . age = age; } public Team getTeam () { return team ; } public void setTeam ( Team team) { this . team = team; } } [Order] @Entity @Table (name= "ORDERS" ) public class Order { @Id @GeneratedValue private Long id ; private int orderAmount ; @Embedded private Address address ; @ManyToOne @JoinColumn (name= "PRODUCT_ID" ) private Product product ; public Long getId () { return id ; } public void setId ( Long id) { this . id = id; } public int getOrderAmount () { return orderAmount ; } public void setOrderAmount ( int orderAmount) { this . orderAmount = orderAmount; } public Address getAddress () { return address ; } public void setAddress ( Address address) { this . address = address; } public Product getProduct () { return product ; } public void setProduct ( Product product) { this . product = product; } } [Product] @Entity public class Product { @Id @GeneratedValue private Long id ; private String name ; private int price ; private int stockAmount ; public Long getId () { return id ; } public void setId ( Long id) { this . id = id; } public String getName () { return name ; } public void setName ( String name) { this . name = name; } public int getPrice () { return price ; } public void setPrice ( int price) { this . price = price; } public int getStockAmount () { return stockAmount ; } public void setStockAmount ( int stockAmount) { this . stockAmount = stockAmount; } } [Team] @Entity public class Team { @Id @GeneratedValue private Long id ; private String name ; @OneToMany (mappedBy = "team" ) private List < Member > members = new ArrayList<>(); public Long getId () { return id ; } public void setId ( Long id) { this . id = id; } public String getName () { return name ; } public void setName ( String name) { this . name = name; } public List < Member > getMembers () { return members ; } public void setMembers ( List < Member > members) { this . members = members; } }
안녕하세요. 현재 Postman 강의를 듣고 있습니다. mock 서버를 생성하려고 하면 아래의 이미지와 같은 에러 메시지가 발생하는데 어떻게 해결해야 하는지 잘 모르겠습니다. [질문이미지] no mock server calls yet 이 나오면서 mock server가 생성되지 않아서 실습을 진행하지 못하고 있습니다. 이때 어떻게 해결해야 하는지 가르쳐 주시면 감사하겠습니다.
여러가지 실험을 하다가 OnHitEvent() 함수 안에다 제가 분기문을 모두 주석처리 후 State = PlayerState.Moving 으로 한 뒤 플레이를 해봤습니다. OnHitEvent() { State = PlayerState.Moving } 그런데 이렇게 하면 캐릭터를 한번 공격한 후 유니티짱을 다른 곳을 클릭해서 움직이려 할 때 먹통이 되어 안움직이게 됩니다. 제가 생각하기로는 OnMouseEvent로 계속해서 이벤트를 듣고 그에따른 로직을 수행해야 할 것으로 생각이 되는데 OnMouseEvent_IdleRun 내부 최상단에 debug.log를 찍어보니 해당 함수가 호출도 않되더군요 영상대로 OnHitEvent에 State = PlayerState.Idle 이면 정상적으로 수행이 됩니다만 위의 사항이 아무리 고민해도 왜 그런지 모르겠어서 질문드립니다.
업무자동화 + 웹크롤링 강의 듣고 싶은데 예전에 다른 분 질문 답변에 이와 관련하여 강의 계획중이라고 하신걸 본것 같아 문의드려요! 혹시 언제쯤 강의가 개설될지 대략적으로라도 알려주시면 감사하겠습니다. ex1) 올해 상반기 안에는 나올꺼 같다. ex2) 아니다 무슨소리냐 데이터 기반 주식 퀀트투자 part2를 먼저 강의할 것이기 때문에 아직 한~참 멀었다.
안녕하세요, 에릭쌤~ 대부분 최상단 네비게이션 바와 메인 배너 사이에, 그리고 메인 배너 하단에 구분선을 넣어주던데요. 사실 주위 오브젝트 색상에 따라 시각적으로 애써 보지 않으면 거의 잘 안 보이는 경우도 많던데 왜들 꼭 구분선을 넣어주나 궁금증이 들었습니다. 단순히 디자인 측면이 아니라 기능적인 용도나 특별한 이유가 있을까요?
강사님 제가 스프링 입문 강의에서 만든 프로젝트에서 member클래스에 phoneNumber라는 이름으로 varchar(255)형 필드를 하나 추가했습니다. memberForm에도 추가를 해주고 스프링 통합 테스트를 돌릴 때도 member 객체를 생성하고 set으로 phoneNumber를 추가를 해줬는데도 다음과 같은 오류가 납니다. 왜 그런 걸까요 ㅠ (오류 코드는 아래와 같습니다.) 2021-03-06 21:46:04.645 INFO 14452 --- [ main] o.s.t.c.transaction.TransactionContext : Began transaction (1) for test context [DefaultTestContext@5b068087 testClass = MemberServiceIntegrationTest, testInstance = hello.project1.service.MemberServiceIntegrationTest@1b800a11, testMethod = 회원가입@MemberServiceIntegrationTest, testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@6f152006 testClass = MemberServiceIntegrationTest, locations = '{}', classes = '{class hello.project1.Project1Application}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@387a8303, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@d2de489, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@41330d4f, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@24c1b2d2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@565f390, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@7f416310], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]]; transaction manager [org.springframework.orm.jpa.JpaTransactionManager@652a1a17]; rollback [true] Hibernate: select member0_.id as id1_0_, member0_.name as name2_0_, member0_.phone_number as phone_nu3_0_ from member member0_ where member0_.name=? 2021-03-06 21:46:05.163 WARN 14452 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 42122, SQLState: 42S22 2021-03-06 21:46:05.163 ERROR 14452 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : Column "MEMBER0_.PHONE_NUMBER" not found; SQL statement: select member0_.id as id1_0_, member0_.name as name2_0_, member0_.phone_number as phone_nu3_0_ from member member0_ where member0_.name=? [42122-200] 2021-03-06 21:46:05.189 INFO 14452 --- [ main] o.s.t.c.transaction.TransactionContext : Rolled back transaction for test: [DefaultTestContext@5b068087 testClass = MemberServiceIntegrationTest, testInstance = hello.project1.service.MemberServiceIntegrationTest@1b800a11, testMethod = 회원가입@MemberServiceIntegrationTest, testException = javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement, mergedContextConfiguration = [WebMergedContextConfiguration@6f152006 testClass = MemberServiceIntegrationTest, locations = '{}', classes = '{class hello.project1.Project1Application}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@387a8303, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@d2de489, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@41330d4f, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@24c1b2d2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@565f390, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@7f416310], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]] javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1602) at org.hibernate.query.Query.getResultList(Query.java:165) at hello.project1.repository.JpaMemberRepository.findByName(JpaMemberRepository.java:33) at hello.project1.service.MemberService.validateDuplicateMember(MemberService.java:26) at hello.project1.service.MemberService.join(MemberService.java:20) at hello.project1.service.MemberService$$FastClassBySpringCGLIB$$9f40d288.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692) at hello.project1.service.MemberService$$EnhancerBySpringCGLIB$$b4c4763a.join(<generated>) at hello.project1.service.MemberServiceIntegrationTest.회원가입(MemberServiceIntegrationTest.java:30) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:688) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84) at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115) at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104) at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:210) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:206) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:131) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:65) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126) at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84) at java.base/java.util.ArrayList.forEach(ArrayList.java:1541) at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126) at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84) at java.base/java.util.ArrayList.forEach(ArrayList.java:1541) at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126) at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84) at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32) at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57) at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51) at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:108) at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:88) at org.junit.platform.launcher.core.EngineExecutionOrchestrator.lambda$execute$0(EngineExecutionOrchestrator.java:54) at org.junit.platform.launcher.core.EngineExecutionOrchestrator.withInterceptedStreams(EngineExecutionOrchestrator.java:67) at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:52) at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:96) at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:75) at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:71) at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33) at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220) at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53) Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:186) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:151) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:2103) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2040) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2018) at org.hibernate.loader.Loader.doQuery(Loader.java:948) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) at org.hibernate.loader.Loader.doList(Loader.java:2849) at org.hibernate.loader.Loader.doList(Loader.java:2831) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2663) at org.hibernate.loader.Loader.list(Loader.java:2658) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1414) at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1625) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1593) ... 82 more Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "MEMBER0_.PHONE_NUMBER" not found; SQL statement: select member0_.id as id1_0_, member0_.name as name2_0_, member0_.phone_number as phone_nu3_0_ from member member0_ where member0_.name=? [42122-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:453) at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) at org.h2.message.DbException.get(DbException.java:205) at org.h2.message.DbException.get(DbException.java:181) at org.h2.expression.ExpressionColumn.getColumnException(ExpressionColumn.java:163) at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:145) at org.h2.expression.Alias.optimize(Alias.java:52) at org.h2.command.dml.Select.prepare(Select.java:1206) at org.h2.command.Parser.prepareCommand(Parser.java:744) at org.h2.engine.Session.prepareLocal(Session.java:657) at org.h2.server.TcpServerThread.process(TcpServerThread.java:278) at org.h2.server.TcpServerThread.run(TcpServerThread.java:183) at java.base/java.lang.Thread.run(Thread.java:834) at org.h2.message.DbException.getJdbcSQLException(DbException.java:453) at org.h2.engine.SessionRemote.done(SessionRemote.java:611) at org.h2.command.CommandRemote.prepare(CommandRemote.java:85) at org.h2.command.CommandRemote.<init>(CommandRemote.java:51) at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:481) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235) at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352) at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337) at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:149) at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176) ... 98 more
3:37초에 한번에 컨테이너, 이미지.네트워크 모두 삭제하고 싶다라는 말은 A에서 다른환경의 B에게 보낸후에 A 에게 남아있는 컨테이너 잔여를 말하는건가요? 예를들어 카카오톡을 설치파일을 다운 받으면 설치 후에도 남아있는 install 파일이 저 쓰지않는 도커랑 비슷할까요? 커맨드도 중요하지만 중간중간 이 커멘드를 치면 이렇게 동작해 라는 이미지가 있으면 더욱 이해도가 높아질거 같습니다 흑흑 ㅠ
안녕하세요 이해하기 쉽게 알려주시는 도커 강의 너무 만족하고 잘 보고있는 학생입니다 영상을 보다가 Stop 과 Kill을 보여 의문점이 생겨서 문의 드립니다 제가 여기 강의에서 배운 도커라는 개념은 A에서 환경(버전,os...) 뭔가가 다른 환경에서 파일이나, 데이터를 컨테이너에 실어서 전송해준다 라고 이해를 하였습니다 근데 Stop 이랑 Kill 이라는 것은 전송하고 싶은 데이터를 전송하는 중에 Stop이나 Kill을 써서 중단을 한다는 말인가요? A에서 B로 배포나 뭔가를 옮길때 굳이 저 Stop과 Kill을 쓸 일이 있을지 의문입니다 어차피 통신은 양쪽다 된다는 가정하에 뭔가를 옮기는 행위를 도커라 배웠는데 Kill이나 Stop이 어디에 쓰이는지 궁금합니다 저같으면 일단 파일을 모두 보낸후에 받은 쪽에서 그냥 지울거 같습니다 통신중인걸 중간에 지우지 않고 아니면 혹시 A에서 B로 24시간 뭔가를 계속 쏴주어야 하나요?? 혹시 제가 이해하고 있는 개념이 도커의 개념과 많이 다르다면 힌트좀 부탁드립니다 꾸벅
