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

[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 einsetzen, ohne dass Code oder Daten in der Datenbank geändert werden. Typen, kann Java.math.bigdecimal nicht in Java.lang.Long -Abfrage umwandeln:
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow (AbstractQueryRunner.java:527)
bei org.apache.commons.dbutils.Queryrunner.Query (queryrunner.java:391)
at org.apache.commons.dbutils.Queryrunner.Query (queryRunner.java:252)
at> at> at org.apache.commons.dbutils.asyncQueryrunner $ 3.call (Asyncqueryrunner.java:294)
bei java.base /java.util.concurrent.futuretask.run (futuretask.java:264)
bei java.base /java.util.concurrent java.base/java.util.concurrent.futuretask.report (futuretask.java:122) < 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 < c o d e > 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 thodInvoker.java:81)
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
at 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>
Table definitions
Name Null? Type
ID NOT NULL NUMBER
NAME VARCHAR2(50)
LAST_DATE DATE
The issue is almost similar to what mentioned here JDBC connection suddenly starts checking strict type and throwing java.sql.SQLException with incompatible types but with oracle DB.
I am using commons-dbutils version 1.7