IT 한길

MYSQL 컬럼 구조 조회

Progamming/DB2022. 2. 9. 15:55

1. select column_name from information_schema.columns where table_name ='테이블 명';

 

 

2. show create table 테이블명\G;

저작자표시

'Progamming > DB' 카테고리의 다른 글

Mysql Base64 encode/decode  (0) 2022.04.04
MYSQL my.cnf 설정 가이드  (0) 2022.02.21
MSSQL 로그 사이즈 줄이기  (0) 2015.04.17
MS-SQL 검색결과 제한하기  (0) 2015.04.06
MSSQL 테이블 복사  (0) 2015.04.06

[OAUTH2] 페이스북(facebook) OAuthCallbackListener 샘플

IT/기타2020. 10. 14. 16:18

- Access Token 요청 (graph.facebook.com/oauth/access_token)

- 사용자 게시물 피드 조회 : /{user-id}/feed (graph.facebook.com/v2.5/me/feed)

 

저작자표시

'IT > 기타' 카테고리의 다른 글

인증서 만료일자 조회  (0) 2022.05.19
[SAML Test] 4. Service Provider 생성 및 테스트  (0) 2020.09.07
[SAML Test] 3. Setup our Identity Provider (Docker환경에 설치)  (0) 2020.09.07
[SAML Test] 1. Setup a Single Sign On SAML Test Environment with Docker and NodeJS  (0) 2020.09.07
[SAML Test] 2. CentOS 8 nvm을 이용한 node.js 설치  (0) 2020.09.07

메이븐(Maven)에서 톰캣 SSL(HTTPS) 설정

IT/Was2020. 10. 14. 16:03

- keystore 생성

- pom.xml 파일 tomcat plugin 수정 (httpsPort, keystoreFile)

<build>
    <finalName>example</finalName> 
    <plugins>
      <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-war-plugin</artifactId>
        <version>2.5</version>
      </plugin>
      <plugin>
        <groupId>org.apache.tomcat.maven</groupId>
        <artifactId>tomcat7-maven-plugin</artifactId>
        <version>2.2</version>
        <configuration>
          <port>8080</port>
          <httpsPort>8443</httpsPort>
       	  <keystoreFile>c:/test.keystore</keystoreFile>
          <path>/</path>
          <contextReloadable>true</contextReloadable>
          <systemProperties>
            <JAVA_OPTS>-Xms512m -Xmx512m --XX:MaxPermSize=256m</JAVA_OPTS>
          </systemProperties>
        </configuration>
      </plugin>
    </plugins>
  </build>

 

 

저작자표시

'IT > Was' 카테고리의 다른 글

톰캣 불필요한웹메서드 제거  (0) 2020.07.14
[Tomcat]도커(Docker)에서 톰캣 설치  (0) 2020.06.11
Jboss AS 7 서버로깅설정  (0) 2014.03.24
JBoss AS 7 설치  (0) 2014.03.07
웹로직 64비트 설치  (0) 2014.02.10

[Spring boot] lombok 에러 The method getExample() is undefined for the type Test test.java

Progamming/Spring2020. 9. 28. 11:11

Step 1:

Close your IDE.

Step 2:

Download lombox jar => https://projectlombok.org/download

Step 3:

- 설치 : 다운로드 파일 더블 클릭 or java -jar lombok.jar

 

Step 4:

- SpringToolSuite4.ini 아래 내용 추가

-Xbootclasspath/a:lombok.jar
-javaagent:lombok.jar

Step 5:

- 이클립스 재시작

 

저작자표시

'Progamming > Spring' 카테고리의 다른 글

[Spring boot] War 파일 생성 (Gradle)  (0) 2020.09.24
Spring boot(undertow) 불필요한 웹 메서드(HTTP Method) 제거  (0) 2020.07.21
[이클립스] 스프링부트 서버 종료안되는 문제 해결  (0) 2020.05.25

[Spring boot] 에러 Could not fetch the SequenceInformation from the database

카테고리 없음2020. 9. 25. 10:24

스프링 부트 테스트 중 H2->Mysql 로 변경 시 아래와 같은 오류 발생됨.

2020-09-24 16:19:42.373  INFO 3788 --- [         task-1] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
2020-09-24 16:19:42.449 ERROR 3788 --- [         task-1] o.h.e.j.e.internal.JdbcEnvironmentImpl   : Could not fetch the SequenceInformation from the database

java.sql.SQLSyntaxErrorException: Unknown table 'sequences' in information_schema
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java) ~[HikariCP-3.4.5.jar:na]
	at org.hibernate.tool.schema.extract.internal.SequenceInformationExtractorLegacyImpl.extractMetadata(SequenceInformationExtractorLegacyImpl.java:42) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.sequenceInformationList(JdbcEnvironmentImpl.java:403) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.<init>(JdbcEnvironmentImpl.java:268) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:114) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:176) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:118) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1224) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1255) [hibernate-core-5.4.20.Final.jar:5.4.20.Final]
	at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) [spring-orm-5.2.8.RELEASE.jar:5.2.8.RELEASE]
	at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) [spring-orm-5.2.8.RELEASE.jar:5.2.8.RELEASE]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) [spring-orm-5.2.8.RELEASE.jar:5.2.8.RELEASE]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_144]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_144]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_144]
	at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_144]

 

- application.yml 에서 database-platform: org.hibernate.dialect.MySQL5InnoDBDialect 추가함

spring: 
  profiles: dev
  h2: 
    console: 
      enabled: true 
      settings:
                web-allow-others: true
  jpa:
    hibernate:
      ddl-auto: create
    database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
    #database: H2
    database: MYSQL
    show-sql: true
    properties:
        hibernate.format_sql: true
        hibernate.cache.use_second_level_cache: true
        hibernate.cache.use_query_cache: false
        hibernate.generate_statistics: false
        hibernate.cache.region.factory_class: org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory
저작자표시

[Spring boot] War 파일 생성 (Gradle)

Progamming/Spring2020. 9. 24. 14:26

1. build.gradle 파일 수정

apply plugin: 'war' 

bootWar {
	archiveBaseName = "oauth2"
	archiveFileName = "oauth2.war"
	archiveVersion	= "0.0.0"
}

 

2. 명령어 실행

- >gradlew clean bootWar

 

3. build/libs 아래 war 파일 생성 확인. 

4. war 실행 테스트

 - java -jar oauth2.war

 - http://localhost:8080

저작자표시

'Progamming > Spring' 카테고리의 다른 글

[Spring boot] lombok 에러 The method getExample() is undefined for the type Test test.java  (0) 2020.09.28
Spring boot(undertow) 불필요한 웹 메서드(HTTP Method) 제거  (0) 2020.07.21
[이클립스] 스프링부트 서버 종료안되는 문제 해결  (0) 2020.05.25

리눅스 버전 확인

IT/Linux2020. 9. 22. 10:49

           grep . /etc/*-release       

           cat /etc/*-release | uniq  

           grep . /etc/issue*

           rpm -qa *-release           레드햇 계열

 

 

저작자표시

'IT > Linux' 카테고리의 다른 글

패스워드 변경 주기 삭제  (0) 2020.08.12
CentOS 8 다운로드  (0) 2020.06.08
yum : command not found (Redhat)  (0) 2020.06.08
/bin/sh^M: bad interpreter: No such file or directory 오류 발생 시  (0) 2020.06.03

[SAML Test] 4. Service Provider 생성 및 테스트

IT/기타2020. 9. 7. 17:53

1. Service Provider 생성

https://medium.com/disney-streaming/setup-a-single-sign-on-saml-test-environment-with-docker-and-nodejs-c53fc1a984c9

 

 

2. Service Provider 로그인

 - http://localhost:4300/login

 - IdP  로그인 화면으로 이동됨

IdP 로그인

 - 성공

- metadata 

저작자표시

'IT > 기타' 카테고리의 다른 글

인증서 만료일자 조회  (0) 2022.05.19
[OAUTH2] 페이스북(facebook) OAuthCallbackListener 샘플  (0) 2020.10.14
[SAML Test] 3. Setup our Identity Provider (Docker환경에 설치)  (0) 2020.09.07
[SAML Test] 1. Setup a Single Sign On SAML Test Environment with Docker and NodeJS  (0) 2020.09.07
[SAML Test] 2. CentOS 8 nvm을 이용한 node.js 설치  (0) 2020.09.07

티스토리툴바