Ich bekomme java.sql.sqlexception mit inkompatiblen Typen zeitweise [geschlossen] ⇐ Java

Java-Forum
Post Reply Previous topicNext topic
Anonymous
 Ich bekomme java.sql.sqlexception mit inkompatiblen Typen zeitweise [geschlossen]

Post by Anonymous »

Dieses Problem ist sehr zufällig und startet plötzlich einen Fehler ohne Änderung der Daten in der Datenbank. Es wird wieder funktioniert, wenn ich den Server neu starte oder denselben Code neu anwende, ohne Code oder Daten in der Datenbank zu ändern.

Code: Select all

Caused by: java.util.concurrent.ExecutionException: java.sql.SQLException: Cannot set updatedDate:  incompatible types,  c a n n o t   c o n v e r t   j a v a . m a t h . B i g D e c i m a l   t o   j a v a . l a n g . L o n g   Q u e r y : < b r   / >         a t   o r g . a p a c h e . c o m m o n s . d b u t i l s . A b s t r a c t Q u e r y R u n n e r . r e t h r o w ( A b s t r a c t Q u e r y R u n n e r . j a v a : 5 2 7 ) < b r   / >         a t   o r g . a p a c h e . c o m m o n s . d b u t i l s . Q u e r y R u n n e r . q u e r y ( Q u e r y R u n n e r . j a v a : 3 9 1 ) < b r   / >         a t   o r g . a p a c h e . c o m m o n s . d b u t i l s . Q u e r y R u n n e r . q u e r y ( Q u e r y R u n n e r . j a v a : 2 5 2 ) < b r   / >         a t   o r g . a p a c h e . c o m m o n s . d b u t i l s . A s y n c Q u e r y R u n n e r $ 3 . c a l l ( A s y n c Q u e r y R u n n e r . j a v a : 2 9 4 ) < b r   / >         a t   j a v a . b a s e / j a v a . u t i l . c o n c u r r e n t . F u t u r e T a s k . r u n ( F u t u r e T a s k . j a v a : 2 6 4 ) < b r   / >         a t   j a v a . b a s e / j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r . r u n W o r k e r ( T h r e a d P o o l E x e c u t o r . j a v a : 1 1 2 8 ) < b r   / >         a t   j a v a . b a s e / j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r $ W o r k e r . r u n ( T h r e a d P o o l E x e c u t o r . j a v a : 6 2 8 ) < b r   / >         a t   j a v a . b a s e / j a v a . u t i l . c o n c u r r e n t . F u t u r e T a s k . r e p o r t ( F u t u r e T a s k . j a v a : 1 2 2 ) < b r   / >         a t   j a v a . b a s e / j a v a . u t i l . c o n c u r r e n t . F u t u r e T a s k . g e t ( F u t u r e T a s k . j a v a : 1 9 1 ) < b r   / >         a t   j d k . i n t e r n a l . r e f l e c t . G e n e r a t e d M e t h o d A c c e s s o r 2 1 5 . i n v o k e ( U n k n o w n   S o u r c e ) < b r   / >         a t   j a v a . b a s e / j d k . i n t e r n a l . r e f l e c t . D e l e g a t i n g M e t h o d A c c e s s o r I m p l . i n v o k e ( D e l e g a t i n g M e t h o d A c c e s s o r I m p l . j a v a : 4 3 ) < b r   / >         a t   j a v a . b a s e / j a v a . l a n g . r e f l e c t . M e t h o d . i n v o k e ( M e t h o d . j a v a : 5 6 6 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . s e r v e r . m o d e l . i n t e r n a l . R e s o u r c e M e t h o d I n v o c a t i o n H a n d l e r F a c t o r y . l a m b d a $ s t a t i c $ 0 ( R e s o u r c e M e t h o d I n v o c a t i o n H a n d l e r F a c t o r y . j a v a : 5 2 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . s e r v e r . m o d e l . i n t e r n a l . A b s t r a c t J a v a R e s o u r c e M e t h o d D i s p a t c h e r $ 1 . r u n ( A b s t r a c t J a v a R e s o u r c e M e t h o d D i s p a t c h e r . j a v a : 1 2 4 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . s e r v e r . m o d e l . i n t e r n a l . A b s t r a c t J a v a R e s o u r c e M e t h o d D i s p a t c h e r . i n v o k e ( A b s t r a c t J a v a R e s o u r c e M e t h o d D i s p a t c h e r . j a v a : 1 6 7 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . s e r v e r . m o d e l . i n t e r n a l . J a v a R e s o u r c e M e t h o d D i s p a t c h e r P r o v i d e r $ T y p e O u t I n v o k e r . d o D i s p a t c h ( J a v a R e s o u r c e M e t h o d D i s p a t c h e r P r o v i d e r . j a v a : 2 1 9 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . s e r v e r . m o d e l . i n t e r n a l . A b s t r a c t J a v a R e s o u r c e M e t h o d D i s p a t c h e r . d i s p a t c h ( A b s t r a c t J a v a R e s o u r c e M e t h o d D i s p a t c h e r . j a v a : 7 9 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . s e r v e r . m o d e l . R e s o u r c e M e t h o d I n v o k e r . i n v o k e ( R e s o u r c e M e t h o d I n v o k e r . j a v a : 4 7 5 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . s e r v e r . m o d e l . R e s o u r c e M e t h o d I n v o k e r . a p p l y ( R e s o u r c e M e t h o d I n v o k e r . j a v a : 3 9 7 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . s e r v e r . m o d e l . R e s o u r c e M e t h o d I n v o k e r . a p p l y ( R e s o u r c e M e t h o d I n v o k e r . j a v a : 8 1 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . s e r v e r . S e r v e r R u n t i m e $ 1 . r u n ( S e r v e r R u n t i m e . j a v a : 2 5 5 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . i n t e r n a l . E r r o r s $ 1 . c a l l ( E r r o r s . j a v a : 2 4 8 ) < b r   / >         a t   o r g . g l a s s f i s h . j e r s e y . i n t e r n a l . E r r o r s $ 1 . c a l l ( E r r o r s . j a v a : 2 4 4 ) < b r   / >         a t   org.glassfish.jersey.internal.Errors.process(Errors.java:292)
at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1631)
at io.dropwizard.servlets.ThreadNameFilter.doFilter(ThreadNameFilter.java:35)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
at io.dropwizard.jersey.filter.AllowedMethodsFilter.handle(AllowedMethodsFilter.java:47)
at io.dropwizard.jersey.filter.AllowedMethodsFilter.doFilter(AllowedMethodsFilter.java:41)
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at com.codahale.metrics.jetty9.InstrumentedHandler.handle(InstrumentedHandler.java:313)
at io.dropwizard.jetty.RoutingHandler.handle(RoutingHandler.java:52)
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:763)
at org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:54)
at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:179)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:400)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:645)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:392)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.base/java.lang.Thread.run(Thread.java:829)
< /code>
import org.apache.commons.dbutils.AsyncQueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
public class StudDaoImpl {

DataSource ds;
AsyncQueryRunner runner
public String findName(String id)  throws SQLException, IOException { Future data ="";
try {

ResultSetHandler h1 = new BeanHandler(String.class);
data = runner.query(ds.getConnection() ,"select last_date as UpdatedDate from emp where id =?", h1,id);

} catch (Exception ex) {
log.error(" Failed to fetch data for input - " + input, ex);
throw new GenericException().errorCode(500).errorMessage("Failed to fetch data for input - " + input);
}
return data.get();
}
}
< /code>
Tabellendefinitionen < /p>
Name       Null?    Type
ID         NOT NULL NUMBER
NAME                VARCHAR2(50)
LAST_DATE           DATE
Das Problem ähnelt fast dem, was die hier erwähnte JDBC-Verbindung plötzlich mit dem Überprüfen des strengen Typs und dem Werfen von java.sql.sqlexception mit inkompatiblen Typen, aber mit Oracle DB.>
Top
Post Reply Previous topicNext topic

Quick Reply

Change Text Case: 
   
  • Similar Topics
    Replies
    Views
    Last post

Return to “Java”