ORACLE + DATAPROVIDER + DATE (HOW THIS SHIT WORKS?)

[pscamara]

I GOT SOME PROBLEMS WITH DATAPROVIDER. I CANT COMMIT BECAUSE THE DATE VALUES
(only) NEVER MATCH USING ORACLE DATABASE.

documentDataProvider.commitChanges();

I am trying to update some dates but when dataprovider execute "pre-update
SELECT" i got some errors.
The data provide executes the query with date parameter format completly
different. So the query never run. If i change the date value to string
value everyting works. How to handle oracle dates into dataprovider?

The data provider is trying to execute a query with this:
Paramm[5]=(java.sql.Date,2007-01-01)
Paramm[6]=(java.sql.Date,2007-12-31)

My database table:

periodo_1 as date (just date no time, eg 01-jan-2010 00:00:00)
periodo_2 as date


13:53:34,647 INFO [STDOUT] INSERT INTO DOCUMENTOS_ADM (COD_DOCUMENTO,
COD_ORIGEM, COD_SETOR, COD_TIPO, PERIODO_1, PERIODO_2, DESCRICAO, MODULO,
ESTANTE, PRATELEIRA, CAIXA, PRAZO_2, IND_PERMANENTE, INTERVALO_1,
INTERVALO_2, LIVROS, OUTROS, IND_ESPACO, COMENTARIOS) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

13:53:34,647 INFO [STDOUT] SELECT COD_DOCUMENTO, COD_ORIGEM, COD_SETOR,
COD_TIPO, PERIODO_1, PERIODO_2, DESCRICAO, MODULO, ESTANTE, PRATELEIRA,
CAIXA, PRAZO_2, IND_PERMANENTE, INTERVALO_1, INTERVALO_2, LIVROS, OUTROS,
IND_ESPACO, COMENTARIOS FROM DOCUMENTOS_ADM WHERE COD_DOCUMENTO = ? AND
COD_ORIGEM = ? AND COD_SETOR = ? AND COD_TIPO = ? AND PERIODO_1 = ? AND
PERIODO_2 = ? AND DESCRICAO = ? AND MODULO = ? AND ESTANTE = ? AND
PRATELEIRA = ? AND CAIXA = ? AND PRAZO_2 IS NULL AND IND_PERMANENTE = ? AND
INTERVALO_1 = ? AND INTERVALO_2 = ? AND LIVROS IS NULL AND OUTROS IS NULL
AND IND_ESPACO IS NULL AND COMENTARIOS IS NULL

13:53:34,960 INFO [STDOUT] Paramm[1]=(java.lang.String,3021)
Paramm[2]=(java.lang.String,BA) Paramm[3]=(java.lang.String,S1)
Paramm[4]=(java.lang.String,000) Paramm[5]=(java.sql.Date,2007-01-01)
Paramm[6]=(java.sql.Date,2007-12-31) Paramm[7]=(java.lang.String,RELATÓRIOS
DE TESTES / CERTIFICADO CALIBRAÇÃO EQUIPAMENTOS MONITORAÇÃO (MSA, TECSONIC);
AVALIAÇÃO TREINAMENTO BÁSICO E NORMAS (SENAI))
Paramm[8]=(java.lang.String,13) Paramm[9]=(java.lang.String,01)
Paramm[10]=(java.lang.String,04) Paramm[11]=(java.lang.String,0027)
Paramm[12]=(null) Paramm[12]=(java.lang.String,1)
Paramm[13]=(java.lang.String,01-JAN-2007)
Paramm[14]=(java.lang.String,31-JAN-2007) Paramm[15]=(null)
Paramm[15]=(null) Paramm[15]=(null) Paramm[15]=(null)

13:53:35,460 INFO [STDOUT] Writer: executing pre-update SELECT

13:53:48,932 ERROR [[/ARQ]] Erro ao gravar registros:


I need some help
--
View this message in context: http://old.nabble.com/ORACLE-%2B-DATAPROVIDER-%2B-DATE-%28HOW-THIS-SHIT-WORKS-%29-tp28683660p28683660.html
Sent from the Netbeans IDE Users mailing list archive at Nabble.com.