개발잡부

input { kafka { bootstrap_servers => "kafkahost:9092" topics => ["search_query_log"] group_id => "logstash" type => "search_query" consumer_threads => 1 } kafka { bootstrap_servers => "kafkahost:9092" topics => ["search_query_log2"] group_id => "logstash" type => "search_query2" consumer_threads => 1 } } filter { json { source => "message" } mutate { add_field => { "ls_timestamp" => "%{@timestam..

11:14:56 ### Error querying database. Cause: java.sql.SQLException: Error retrieving record: Unexpected Exception: java.io.EOFException message given: Can not read response from server. Expected to read 475 bytes, read 463 bytes before connection was unexpectedly lost. #autoReconnectForPools 옵션 autoReconnectForPools=true url: jdbc:mysql://{host}:{port}/{DB}?useUnicode=true&useCursorFetch=true&ch..

package com.bbongdoo.doo.keyword; import com.bbongdoo.doo.domain.Keywords; import com.bbongdoo.doo.domain.KeywordsRepository; import com.bbongdoo.doo.service.KeywordsService; import org.assertj.core.api.Assertions; import org.junit.jupiter.api.BeforeEach; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context..

Annotation package com.bbongdoo.doo.annotation; import java.lang.annotation.ElementType; import java.lang.annotation.Retention; import java.lang.annotation.RetentionPolicy; import java.lang.annotation.Target; @Target({ElementType.TYPE, ElementType.METHOD}) @Retention(RetentionPolicy.RUNTIME) public @interface Timer { } Aspect package com.bbongdoo.doo.aspect; import org.aspectj.lang.ProceedingJoi..

한개의 컬럼에 UNIQUE 설정 @Column(name="column" , unique=true) long column 두 개 이상 컬럼을 묶어 UNIQUE 설정 @Table 속성 uniqueConstraints 사용 @Entity @Table( name="keywords", uniqueConstraints={ @UniqueConstraint( name={"contstraintName"} columnNames={"keyword", "use_yn"} ) } ) @Data public class Entity{ @Column(name="keyword") String keyword; @Column(name="use_yn") String use_yn; } http://iryan.kr/t7eogjtthy 농심 먹태..

PRIMARY KEY(기본키) 테이블 생성 시 CREATE TABLE table_name ( col1 int(11) PRIMARY KEY ) CREATE TABLE table_name ( col1 int(11), col2 int(11), PRIMARY KEY (col1, col2) ) 추가 ALTER TABLE table_name ADD PRIMARY KEY (col1) 삭제 ALTER TABLE table_name DROP PRIMARY KEY UNIQUE KEY(유니크키) 테이블 생성 시 CREATE TABLE table_name ( col1 int(11), col2 int(11), UNIQUE KEY unique_name (col1, col2) ) 추가 ALTER TABLE table_name AD..

#기본 for num in range(0,5): print(num) for data in ["apple, oragnge, grape"]: print(data) a = [1,3,5,7,9] for i in a : print (i)

Table 'shop.hibernate_sequence' doesn't exist @GeneratedValue(strategy = GenerationType.IDENTITY) https://mkyong.com/spring-boot/spring-boot-mysql-table-db_name-hibernate_sequence-doesnt-exist/ spring.jpa.hibernate.use-new-id-generator-mappings=false

drop table if exists rooms; drop table if exists room_members; drop table if exists user_account; drop table if exists users; drop table if exists balance_send; drop table if exists balance_receive; CREATE TABLE `rooms` ( `id` bigint NOT NULL AUTO_INCREMENT, `room_id` varchar(3) NOT NULL, `room_name` varchar(100) NOT NULL, `category1` varchar(100) DEFAULT NULL, `category2` varchar(100) DEFAULT N..