MYSQL 컬럼 구조 조회
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 샘플
- 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) 설정
- 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
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
스프링 부트 테스트 중 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)
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 |
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 생성 및 테스트
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 로그인 화면으로 이동됨
- 성공
- 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 |