Jun, Log

안녕하세요.

작업 중에 기존의 stash를 지웠습니다.

기존의 작업 양이 많다면 식은땀이 나고 당황하실 수 있습니다.

하지만 복구 방법이 있습니다 :)

아래의 명령어를 입력해주시면 삭제했던 stash 해시를 찾을 수 있습니다.

단 시간을 보고 하나씩 하나씩 찾아보셔야 됩니다.

git fsck --no-reflog | awk '/dangling commit/ {print $3}' | xargs -L 1 git --no-pager show -s --format="%ci %H" | sort

위에서 찾은 해시를 아래 명령어로 불러 들이면 되겠습니다 ^^

git stash apply 복구할해시

감사합니다.

참고)

stackoverflow.com/questions/89332/how-to-recover-a-dropped-stash-in-git

자바 Http 통신 후 response를 받게 됩니다.

response의 값을 직접 확인 하는 방법에 대해서 알아봅니다.

1. String으로 받기

HttpResponse response = httpClient.execute(new HttpGet(URL));
HttpEntity entity = response.getEntity();
String responseString = EntityUtils.toString(entity, "UTF-8");
System.out.println(responseString);

2. Line별로 받기

HttpResponse response = httpClient.execute(new HttpGet(URL));
HttpEntity entity = response.getEntity();
InputStream is = entity.getContent();
BufferedReader r = new BufferedReader(new InputStreamReader(is, Charset.forName("UTF-8")));
String line;

while ((line = r.readLine()) != null) {
	System.out.println(line);
}

안녕하세요.

데이터 INSERT를 할때 자동으로 시퀀스를 생성하고 싶었습니다.

상황은 기존의 컬럼은 존재하나 INSERT 시 자동으로 시퀀스를 만들기 위해서 컬럼의 제약조건을 변경합니다.

테이블 이름은 tbl_board이고 컬럼 이름은 bno 입니다.

아래 코드를 활용해서 시퀀스를 생성해주세요.

  --ALTER TABLE tbl_board ADD COLUMN bno INTEGER;	//키 컬럼이 없다면 입력, 기존 키 컬럼 있다면 무시
  CREATE SEQUENCE board_bno_seq OWNED BY tbl_board.bno;
  ALTER TABLE tbl_board ALTER COLUMN bno SET DEFAULT nextval('board_bno_seq');
  UPDATE tbl_board SET bno = nextval('board_bno_seq');

시퀀스가 생성이 되었다면 INSERT 구문은 다음과 같습니다.

INSERT INTO public.tbl_board(
	title, content, writer, regdate, updatedate)
	VALUES ('테스트제목', '테스트내용', 'user00', now(), now());

INSERT 시 별도의 bno 값은 안 넣어도 자동으로 시퀀스가 생성이 되겠습니다.

감사합니다.

안녕하세요.

자바 spring 학습 및 aop 세팅 중 에러가 발생하였습니다.

에러가 발생한 부분은 aop 부분에서 발생한 것으로 생각이 됩니다.

에러 내용은 다음과 같습니다.

Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'boardDAO' defined in file [C:\Users\lg\eclipse-workspace\BoardWeb\target\classes\com\junngo\biz\board\impl\BoardDAO.class]: BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0': Initialization of bean failed; nested exception is java.lang.NoClassDefFoundError: org/aspectj/weaver/reflect/ReflectionWorld$ReflectionWorldException
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:478)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)
	at org.springframework.context.support.GenericXmlApplicationContext.<init>(GenericXmlApplicationContext.java:70)
	at com.junngo.biz.board.BoardServiceClient.main(BoardServiceClient.java:14)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0': Initialization of bean failed; nested exception is java.lang.NoClassDefFoundError: org/aspectj/weaver/reflect/ReflectionWorld$ReflectionWorldException
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
	at org.springframework.aop.framework.autoproxy.BeanFactoryAdvisorRetrievalHelper.findAdvisorBeans(BeanFactoryAdvisorRetrievalHelper.java:92)
	at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findCandidateAdvisors(AbstractAdvisorAutoProxyCreator.java:101)
	at org.springframework.aop.aspectj.annotation.AnnotationAwareAspectJAutoProxyCreator.findCandidateAdvisors(AnnotationAwareAspectJAutoProxyCreator.java:85)
	at org.springframework.aop.aspectj.autoproxy.AspectJAwareAdvisorAutoProxyCreator.shouldSkip(AspectJAwareAdvisorAutoProxyCreator.java:103)
	at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessBeforeInstantiation(AbstractAutoProxyCreator.java:248)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:988)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.resolveBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:959)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:472)
	... 9 more

Caused by: java.lang.NoClassDefFoundError: org/aspectj/weaver/reflect/ReflectionWorld$ReflectionWorldException
	at java.lang.Class.getDeclaredMethods0(Native Method)
	at java.lang.Class.privateGetDeclaredMethods(Class.java:2701)
	at java.lang.Class.getDeclaredMethods(Class.java:1975)
	at org.springframework.util.ReflectionUtils.getDeclaredMethods(ReflectionUtils.java:609)
	at org.springframework.util.ReflectionUtils.doWithMethods(ReflectionUtils.java:521)
	at org.springframework.util.ReflectionUtils.doWithMethods(ReflectionUtils.java:507)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.determineCandidateConstructors(AutowiredAnnotationBeanPostProcessor.java:241)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.determineConstructorsFromBeanPostProcessors(AbstractAutowireCapableBeanFactory.java:1069)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1042)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:325)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
	... 22 more

Caused by: java.lang.ClassNotFoundException: org.aspectj.weaver.reflect.ReflectionWorld$ReflectionWorldException
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	... 40 more

에러 내용 중 제일 아래를 보니(java.lang.ClassNotFoundException) aspectj.weaver 클래스를 찾을 수 없다고 합니다.

aspectjweaver 라이브러리가 없어서 발생하는 에러였습니다.

메이븐을 사용하신다면 pom.xml로 이동하셔서 aspectjweaver를 추가해주세요.

<dependency>
	<groupId>org.aspectj</groupId>
	<artifactId>aspectjweaver</artifactId>
	<version>${org.aspectj-version}</version>
</dependency>

라이브러리를 추가하시면 이상없이 문제가 해결되겠습니다.

감사합니다 :)

1. 파이썬애니웨어 사이트 접속 후 회원가입

www.pythonanywhere.com/

2. Console 메뉴로 이동

3. git clone을 통해서 소스코드 다운로드 (Console)

4. 가상환경 생성 및 구동 (Console)

virtualenv venv --python=python3.7
source venv/bin/activate

5. 장고 설치 (Console)

pip install django

6. 데이터베이스 초기화 (Console)

python manage.py migrate

7. 관리자 계정 생성 (Console)

python manage.py createsuperuser

8. 웹앱 설정 -> Web 메뉴로 이동

9. 웹앱 생성 -> Add a new web app

10. Manual configuration 선택, 파이썬 (3.7) 버전 선택

11. 웨앱 설정 후 Dashboard로 이동

12. WSGI 설정, Web 메뉴 -> Code -> WSGI configuration file 부분 이동 후 오른쪽 패스 선택

13. WSGI 설정을 위한 코드 입력

import os
import sys
path = "/home/junngo/bookmark"
if path not in sys.path:
    sys.path.append(path)

# from django.contrib.staticfiles.handlers import StaticFilesHandler
from django.core.wsgi import get_wsgi_application

os.environ.setdefault("DJANGO_SETTINGS_MODULE", "config.settings")
# application = StaticFilesHandler(get_wsgi_application())
application = get_wsgi_application()

14. SAVE

15. Web 메뉴 -> Virtualenv 가상환경 패스 설정

16. setting 파일에 STATIC_ROOT 추가

STATIC_ROOT = os.path.join(BASE_DIR, 'static_files')