vinculação

1 resposta
M

pessoal to com um problema no meu projeto tenho um JFrame de consulta com um jtable q vinculei com o banco de pois da vinculção começou a dar este erro

Exception in thread AWT-EventQueue-0 Local Exception Stack:

Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: Cannot convert value 0000-00-00 00:00:00 from column 33 to TIMESTAMP.

Error Code: 0

Call: SELECT ID, MARGEMLUCRO, CUSTOFIXO, PRODUTO, OUTROSIMP, UN, COD_IDENTIF, ESTOQUE, OBS, FORNECEDOR, COMISSIONADO, VALOR_CUSTO, FABRICANTE, VALOR_VENDA2, SITU_TRIB, MINIMO, REFERENCIA, ALIQUOTA_ICMS, CODIGO, CLASS_FISCAL, COD_I, ULT_SAIDA, TOTAL, EST_ANT, DATAINC, SAIDA_EST, FLAG, ENTRADA_EST, VALOR_VENDA3, EST_ATUAL, ALIQUOTA_IPI, GRUPO_CONT, ULT_ENTRADA, PR, CUSTOMEDIO, PR_PERC, MAXIMO, MINIMO_PERC, GRUPO, DESCRICAO, TIPOESTOQUE, PREVISTO, VALOR_VENDA, CHAVE FROM sge.produto

Query: ReportQuery(Frames.Produto)

at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:311)

at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.getObject(DatabaseAccessor.java:970)

at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.fetchRow(DatabaseAccessor.java:761)

at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:547)

at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:452)

at oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:473)

at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)

at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:214)

at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:285)

at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:615)

at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2416)

at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2382)

at oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuery(ReportQuery.java:802)

at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:628)

at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:692)

at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:746)

at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2233)

at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:952)

at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:924)

at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:367)

at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:478)

at Frames.JFIntensConsulta.initComponents(JFIntensConsulta.java:33)

at Frames.JFIntensConsulta.(JFIntensConsulta.java:17)

at Frames.JFIntensConsulta$5.run(JFIntensConsulta.java:234)

at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:701)

at java.awt.EventQueue.access$000(EventQueue.java:102)

at java.awt.EventQueue$3.run(EventQueue.java:662)

at java.awt.EventQueue$3.run(EventQueue.java:660)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:671)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:244)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:163)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:147)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:139)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:97)

Caused by: java.sql.SQLException: Cannot convert value 0000-00-00 00:00:00 from column 33 to TIMESTAMP.

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)

at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1339)

at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:578)

at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6754)

at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6073)

at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5029)

at oracle.toplink.essentials.internal.databaseaccess.DatabasePlatform.getObjectFromResultSet(DatabasePlatform.java:792)

at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.getObject(DatabaseAccessor.java:955)

 36 more

Caused by: java.sql.SQLException: Value [B@537030 can not be represented as java.sql.Timestamp

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)

at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1037)

 42 more

se alguém puder min ajudar eu agradeço valeu !!!

1 Resposta

pmlm
Criado 3 de julho de 2012
Ultima resposta 4 de jul. de 2012
Respostas 1
Participantes 2