org.apache.ojb.broker.PersistenceBrokerSQLException: * SQLException during execution of sql-statement: * sql statement was 'SELECT A0.ATTR_DATA_ID,A0.ROLE_MBR_ID,A0.KIM_TYP_ID,A0.KIM_ATTR_DEFN_ID,A0.ATTR_VAL,A0.VER_NBR,A0.OBJ_ID FROM KRIM_ROLE_MBR_ATTR_DATA_T A0 WHERE A0.ROLE_MBR_ID = ?' * Exception message is [Table 'kcdev.krim_role_mbr_attr_data_t' doesn't exist] * Vendor error code [1146] * SQL state code [42S02]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Kuali JIRA by Gayathri Athreya, 1 year ago
* SQLException during execution of sql-statement: * sql statement was 'SELECT A0.ATTR_DATA_ID,A0.ROLE_MBR_ID,A0.KIM_TYP_ID,A0.KIM_ATTR_DEFN_ID,A0.ATTR_VAL,A0.VER_NBR,A0.OBJ_ID FROM KRIM_ROLE_MBR_ATTR_DATA_T A0 WHERE A0.ROLE_MBR_ID = ?' * Exception message is [Table 'kcdev.krim_role_mbr_attr_data_t' doesn't exist] * Vendor error code [1146] * SQL state code [42S02]
via Kuali JIRA by Steven Black (deprecated), 4 months ago
* Can't prepare statement: * sql statement was 'SELECT A0.REPO_URI,A0.REPO_REV,A0.OBJ_ID,A0.VER_NBR FROM kms_svn_repo_t A0 WHERE A0.REPO_URI = ?' * Exception message is [Connection.close() has already been called. Invalid operation in this state.] * Vendor error code [0] * SQL state code [08003]
via Kuali JIRA by Steven Black (deprecated), 1 year ago
* Can't prepare statement: * sql statement was 'SELECT A0.REPO_URI,A0.REPO_REV,A0.OBJ_ID,A0.VER_NBR FROM kms_svn_repo_t A0 WHERE A0.REPO_URI = ?' * Exception message is [Connection.close() has already been called. Invalid operation in this state.] * Vendor error code [0] * SQL state code [08003]
via kuali.org by Unknown author, 2 years ago
Can't prepare statement: sql statement was 'SELECT A0.MSG_DELIV_ID,A0.STAT_CD,A0.TYP_NM,A0.SYS_ID,A0.PROC_CNT,A0.LOCKD_DTTM,A0.VER_NBR,A0.MSG_ID FROM KREN_MSG_DELIV_T A0 WHERE ( (A0.LOCKD_DTTM IS NULL ) AND A0.PROC_CNT < ?) AND (A0.STAT_CD IN
via Stack Overflow by Divya
, 2 years ago
* SQLException during execution of sql-statement:</p> <p>--some sql statement(correct one)</p> <ul> <li>Exception message is [Io exception: Software caused connection abort: socket write error]</li> <li>Vendor error code [17002]</li> </ul> <p>---adding stack trace as well</p> <ul> <li>Target class is 'com.dto.CurrentDTO'</li> <li>PK of the target object is [currentId]
via Kuali JIRA by Steven Black (deprecated), 4 months ago
.VER_NBR FROM kms_vre_t A0 WHERE (A0.doc_id = ?) AND A0.last_svn_rev_id = ? ORDER BY 1' * Exception message is [SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection
org.apache.ojb.broker.PersistenceBrokerSQLException: * SQLException during execution of sql-statement: * sql statement was 'SELECT A0.ATTR_DATA_ID,A0.ROLE_MBR_ID,A0.KIM_TYP_ID,A0.KIM_ATTR_DEFN_ID,A0.ATTR_VAL,A0.VER_NBR,A0.OBJ_ID FROM KRIM_ROLE_MBR_ATTR_DATA_T A0 WHERE A0.ROLE_MBR_ID = ?' * Exception message is [Table 'kcdev.krim_role_mbr_attr_data_t' doesn't exist] * Vendor error code [1146] * SQL state code [42S02]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source)
at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source)
at org.apache.ojb.broker.accesslayer.RsIterator.(Unknown Source)
at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknown Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.doRetrieveCollection(Unknown Source)
at org.apache.ojb.broker.core.QueryReferenceBroker.retrieveCollection(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveReference(Unknown Source)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.retrieveReference(Unknown Source)
at org.kuali.rice.krad.dao.impl.PersistenceDaoOjb.retrieveReference(PersistenceDaoOjb.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy85.retrieveReference(Unknown Source)
at org.kuali.rice.krad.service.impl.PersistenceServiceOjbImpl.retrieveReferenceObject(PersistenceServiceOjbImpl.java:149)
at sun.reflect.GeneratedMethodAccessor442.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy86.retrieveReferenceObject(Unknown Source)
at org.kuali.rice.krad.service.impl.PersistenceServiceImpl.retrieveReferenceObject(PersistenceServiceImpl.java:113)
at sun.reflect.GeneratedMethodAccessor442.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy86.retrieveReferenceObject(Unknown Source)
at org.kuali.rice.krad.service.impl.KNSLegacyDataAdapterImpl.retrieveReferenceObject(KNSLegacyDataAdapterImpl.java:206)
at org.kuali.rice.krad.service.impl.KNSLegacyDataAdapterImpl.refreshReferenceObject(KNSLegacyDataAdapterImpl.java:554)
at org.kuali.rice.krad.service.impl.LegacyDataAdapterImpl.refreshReferenceObject(LegacyDataAdapterImpl.java:255)
at org.kuali.rice.krad.service.impl.LegacyAppFrameworkAdapterServiceImpl.refreshReferenceObject(LegacyAppFrameworkAdapterServiceImpl.java:67)
at org.kuali.kra.proposaldevelopment.web.uif.ProposalDevelopmentDocumentController.createProposal(ProposalDevelopmentDocumentController.java:96)
at org.kuali.kra.proposaldevelopment.web.uif.ProposalDevelopmentDocumentController$$FastClassByCGLIB$$df81e14d.invoke()
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.kuali.kra.proposaldevelopment.web.uif.ProposalDevelopmentDocumentController$$EnhancerByCGLIB$$d4b75e3c.createProposal()
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547)
at org.kuali.kra.web.filter.PerformanceLoggingFilter.doFilter(PerformanceLoggingFilter.java:73)
at org.kuali.kra.web.filter.SessionExpiredFilter.doFilter(SessionExpiredFilter.java:46)
at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:68)
at org.springframework.web.filter.AbstractRequestLoggingFilter.doFilterInternal(AbstractRequestLoggingFilter.java:213)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1326)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:479)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:520)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:940)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:409)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:874)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java:349)
at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:441)
at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:921)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:784)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:223)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:545)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:43)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:598)
at java.lang.Thread.run(Thread.java:722)

Users with the same issue

Once, 7 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
2 times, 1 week ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
123 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.