database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
ㆍCUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
CUBRID Q&A 354 게시물 읽기
No. 354
Q.[큐브리드 매니저] Unable to create view: Timestamp format must be yyyy-mm-dd hh:mm:ss.[.ffffffff]
작성자
gilbird
작성일
2007-07-04 10:18
조회수
4,140

안녕하세요. 큐브리드 매니저에서 사용자스키마의 클래스를 하나 골라

우클릭하여 전체 보기를 해보았더니 다음과 같은 메시지가 나옵니다.

 

필드중에 Timestamp가 있는데 값이 없어서 이런일이 발생하는것 같습니다.

테이블 값을 고치지 않고 내용을 볼 수 있는 방법이 없을까요?

 

Unable to create view: Timestamp format must be yyyy-mm-dd hh:mm:ss.[.ffffffff]

 

java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

        at java.sql.Timestamp.valueOf(Unknown Source)

        at unisql.jdbc.jci.UInputBuffer.readTimestamp(UInputBuffer.java:234)

        at unisql.jdbc.jci.UStatement.readData(UStatement.java:2071)

        at unisql.jdbc.jci.UStatement.readAAttribute(UStatement.java:2047)

        at unisql.jdbc.jci.UStatement.readATuple(UStatement.java:2139)

        at unisql.jdbc.jci.UStatement.read_fetch_data(UStatement.java:2113)

        at unisql.jdbc.jci.UStatement.reFetch(UStatement.java:1693)

        at unisql.jdbc.jci.UStatement.fetch(UStatement.java:862)

        at unisql.jdbc.jci.UStatement.checkReFetch(UStatement.java:1936)

        at unisql.jdbc.jci.UStatement.getCursorOID(UStatement.java:1031)

        at unisql.jdbc.driver.UniSQLResultSet.getOID(UniSQLResultSet.java:1619)

        at cubridmanager.query.view.QueryExecuter.makeTuple(Unknown Source)

        at cubridmanager.query.view.QueryExecuter.makeResult(Unknown Source)

        at cubridmanager.query.view.QueryEditor.makeResult(Unknown Source)

        at cubridmanager.query.view.QueryEditor.runQuery(Unknown Source)

        at cubridmanager.query.view.QueryEditor.createPartControl(Unknown Source)

        at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:305)

        at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:180)

        at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:552)

        at org.eclipse.ui.internal.Perspective.showView(Perspective.java:1655)

        at org.eclipse.ui.internal.WorkbenchPage.busyShowView(WorkbenchPage.java:937)

        at org.eclipse.ui.internal.WorkbenchPage.access$12(WorkbenchPage.java:920)

        at org.eclipse.ui.internal.WorkbenchPage$13.run(WorkbenchPage.java:3199)

        at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69)

        at org.eclipse.ui.internal.WorkbenchPage.showView(WorkbenchPage.java:3196)

        at cubridmanager.WorkView.SetView(Unknown Source)

        at cubridmanager.cubrid.action.TableSelectAllAction.run(Unknown Source)

        at org.eclipse.jface.action.Action.runWithEvent(Action.java:996)

        at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:538)

        at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)

        at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400)

        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)

        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)

        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)

        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)

        at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)

        at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)

        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)

        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)

        at cubridmanager.Application.run(Unknown Source)

        at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)

        at org.eclipse.core.launcher.Main.basicRun(Main.java:278)

        at org.eclipse.core.launcher.Main.run(Main.java:973)

        at org.eclipse.core.launcher.Main.main(Main.java:948)

 

이 글에 대한 댓글이 총 2건 있습니다.

안녕하세요.

제가 재현을 해보았지만 정상적으로 나옵니다.

죄송하지만 큐브리드메니저 메뉴의 도구 > 데이터베이스 언로드

\"데이터베이스 언로드\" 대화창의 \"언로드 대상\"에서 \"선택 클래스만\"을 체크해주시고

문제가 되는 클래스를 선택하고 확인을 눌러 수행해 주시기 바랍니다.

 

언로드를 수행한 파일을 sidewinder@cubrid.com으로 보내 주셨으면 합니다.

 

언로드 파일의 위치는

DB가 위치한 플랫폼이 windows인 경우 DB경로에 DB명.obs 와 DB명.sch

Unix계열인 경우 DB경로의 DB명.objects 와 DB명.schema 입니다.

 

불편을 드려 죄송합니다.

 

 

>안녕하세요. 큐브리드 매니저에서 사용자스키마의 클래스를 하나 골라

>우클릭하여 전체 보기를 해보았더니 다음과 같은 메시지가 나옵니다.

>

>필드중에 Timestamp가 있는데 값이 없어서 이런일이 발생하는것 같습니다.

>테이블 값을 고치지 않고 내용을 볼 수 있는 방법이 없을까요?

>

>Unable to create view: Timestamp format must be yyyy-mm-dd hh:mm:ss.[.ffffffff]

>

>java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

>        at java.sql.Timestamp.valueOf(Unknown Source)

>        at unisql.jdbc.jci.UInputBuffer.readTimestamp(UInputBuffer.java:234)

>        at unisql.jdbc.jci.UStatement.readData(UStatement.java:2071)

>        at unisql.jdbc.jci.UStatement.readAAttribute(UStatement.java:2047)

>        at unisql.jdbc.jci.UStatement.readATuple(UStatement.java:2139)

>        at unisql.jdbc.jci.UStatement.read_fetch_data(UStatement.java:2113)

>        at unisql.jdbc.jci.UStatement.reFetch(UStatement.java:1693)

>        at unisql.jdbc.jci.UStatement.fetch(UStatement.java:862)

>        at unisql.jdbc.jci.UStatement.checkReFetch(UStatement.java:1936)

>        at unisql.jdbc.jci.UStatement.getCursorOID(UStatement.java:1031)

>        at unisql.jdbc.driver.UniSQLResultSet.getOID(UniSQLResultSet.java:1619)

>        at cubridmanager.query.view.QueryExecuter.makeTuple(Unknown Source)

>        at cubridmanager.query.view.QueryExecuter.makeResult(Unknown Source)

>        at cubridmanager.query.view.QueryEditor.makeResult(Unknown Source)

>        at cubridmanager.query.view.QueryEditor.runQuery(Unknown Source)

>        at cubridmanager.query.view.QueryEditor.createPartControl(Unknown Source)

>        at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:305)

>        at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:180)

>        at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:552)

>        at org.eclipse.ui.internal.Perspective.showView(Perspective.java:1655)

>        at org.eclipse.ui.internal.WorkbenchPage.busyShowView(WorkbenchPage.java:937)

>        at org.eclipse.ui.internal.WorkbenchPage.access$12(WorkbenchPage.java:920)

>        at org.eclipse.ui.internal.WorkbenchPage$13.run(WorkbenchPage.java:3199)

>        at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69)

>        at org.eclipse.ui.internal.WorkbenchPage.showView(WorkbenchPage.java:3196)

>        at cubridmanager.WorkView.SetView(Unknown Source)

>        at cubridmanager.cubrid.action.TableSelectAllAction.run(Unknown Source)

>        at org.eclipse.jface.action.Action.runWithEvent(Action.java:996)

>        at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:538)

>        at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)

>        at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400)

>        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)

>        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)

>        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)

>        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)

>        at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)

>        at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)

>        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)

>        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)

>        at cubridmanager.Application.run(Unknown Source)

>        at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)

>        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)

>        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)

>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

>        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

>        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

>        at java.lang.reflect.Method.invoke(Unknown Source)

>        at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)

>        at org.eclipse.core.launcher.Main.basicRun(Main.java:278)

>        at org.eclipse.core.launcher.Main.run(Main.java:973)

>        at org.eclipse.core.launcher.Main.main(Main.java:948)

 

허지웅님이 2007-07-04 11:08에 작성한 댓글입니다. Edit

안녕하세요.

 

현재 큐브리드 매니저 7.1을 사용하고 계시는 지요?

다운로드 서비스를 하고 있는 큐브리드 매니저 7.1 혹은 큐브리드 7.1을 설치 하시면

문제가 해결됩니다.

 

큐브리드 매니저 7.0에서 문제가 있었습니다.

 

불편을 드려 죄송합니다.

 

 

>안녕하세요. 큐브리드 매니저에서 사용자스키마의 클래스를 하나 골라

>우클릭하여 전체 보기를 해보았더니 다음과 같은 메시지가 나옵니다.

>

>필드중에 Timestamp가 있는데 값이 없어서 이런일이 발생하는것 같습니다.

>테이블 값을 고치지 않고 내용을 볼 수 있는 방법이 없을까요?

>

>Unable to create view: Timestamp format must be yyyy-mm-dd hh:mm:ss.[.ffffffff]

>

>java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

>        at java.sql.Timestamp.valueOf(Unknown Source)

>        at unisql.jdbc.jci.UInputBuffer.readTimestamp(UInputBuffer.java:234)

>        at unisql.jdbc.jci.UStatement.readData(UStatement.java:2071)

>        at unisql.jdbc.jci.UStatement.readAAttribute(UStatement.java:2047)

>        at unisql.jdbc.jci.UStatement.readATuple(UStatement.java:2139)

>        at unisql.jdbc.jci.UStatement.read_fetch_data(UStatement.java:2113)

>        at unisql.jdbc.jci.UStatement.reFetch(UStatement.java:1693)

>        at unisql.jdbc.jci.UStatement.fetch(UStatement.java:862)

>        at unisql.jdbc.jci.UStatement.checkReFetch(UStatement.java:1936)

>        at unisql.jdbc.jci.UStatement.getCursorOID(UStatement.java:1031)

>        at unisql.jdbc.driver.UniSQLResultSet.getOID(UniSQLResultSet.java:1619)

>        at cubridmanager.query.view.QueryExecuter.makeTuple(Unknown Source)

>        at cubridmanager.query.view.QueryExecuter.makeResult(Unknown Source)

>        at cubridmanager.query.view.QueryEditor.makeResult(Unknown Source)

>        at cubridmanager.query.view.QueryEditor.runQuery(Unknown Source)

>        at cubridmanager.query.view.QueryEditor.createPartControl(Unknown Source)

>        at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:305)

>        at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:180)

>        at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:552)

>        at org.eclipse.ui.internal.Perspective.showView(Perspective.java:1655)

>        at org.eclipse.ui.internal.WorkbenchPage.busyShowView(WorkbenchPage.java:937)

>        at org.eclipse.ui.internal.WorkbenchPage.access$12(WorkbenchPage.java:920)

>        at org.eclipse.ui.internal.WorkbenchPage$13.run(WorkbenchPage.java:3199)

>        at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69)

>        at org.eclipse.ui.internal.WorkbenchPage.showView(WorkbenchPage.java:3196)

>        at cubridmanager.WorkView.SetView(Unknown Source)

>        at cubridmanager.cubrid.action.TableSelectAllAction.run(Unknown Source)

>        at org.eclipse.jface.action.Action.runWithEvent(Action.java:996)

>        at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:538)

>        at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)

>        at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400)

>        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)

>        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)

>        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3125)

>        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2758)

>        at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)

>        at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)

>        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)

>        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)

>        at cubridmanager.Application.run(Unknown Source)

>        at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)

>        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)

>        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)

>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

>        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

>        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

>        at java.lang.reflect.Method.invoke(Unknown Source)

>        at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)

>        at org.eclipse.core.launcher.Main.basicRun(Main.java:278)

>        at org.eclipse.core.launcher.Main.run(Main.java:973)

>        at org.eclipse.core.launcher.Main.main(Main.java:948)

 

허지웅님이 2007-07-04 11:18에 작성한 댓글입니다. Edit
[Top]
No.
제목
작성자
작성일
조회
357Q.메뉴얼에 있는 예제 selectData 가 실행이 안됩니다... [2]
다트25
2007-07-04
3677
356Q.[질문] 등록된 sp를 어떻게 확인하나요? [1]
이지현
2007-07-04
3578
355Q.필드값 자동증가 옵션시 마지막에 입력된 자동증가 값을 가져오고 싶을때는 어떻게 해야 하나요?? [1]
user
2007-07-04
3994
354Q.[큐브리드 매니저] Unable to create view: Timestamp format must be yyyy-mm-dd hh:mm:ss.[.ffffffff] [2]
gilbird
2007-07-04
4140
353Q.[질문] jdk 설치 후 DB 실행이 안됩니다. [1]
이지현
2007-07-03
3486
352Q.[질문] sp등록할 때 [1]
이지현
2007-07-03
3359
351Q.backupdb에서 zip 옵션사용방법 [1]
zoom7810
2007-07-03
3782
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2023 DSN, All rights reserved.
작업시간: 0.052초, 이곳 서비스는
	PostgreSQL v16.1로 자료를 관리합니다