Announcement

**Isomorphic** · 2 Apr 2024, 15:10

For the first two (isc_userSkin DataSource), these would be from requests for skin resources that you don't have deployed in your app - basically if the skin isn't present on disk, we assume it was one created in the Skin Editor tool, and try to look it up from a DataSource.

You should take a look at the paths for those requests. The most common reasons for such requests are:

1) accidently loading two skins at once (covered in the QuickStart Guide)
2) rendering a component before the skin has been loaded (so it falls back to "standard" skin)

However, it could also be some kind of recently introduced bug - if you let us know the paths, we'll be able to figure it out.

As far as the last stack trace, we're thinking this is the key line:

at com.juve.core.spring.testing.OracleAuthenticationProvider.authenticate(OracleAuthenticationProvider.java:36) [classes/:build]

That seems like there is some test code that is maybe trying to probe for a DataSource that doesn't exist, and ends up invoking the Hibernate system. If you can look earlier in the log, you should see what the DataSource ID was.

**claudiobosticco** · 12 Apr 2024, 06:01

Hello, about the isc_userSkin error: actually I see it only when opening the developer console. I'm using Twilight and I've got only this skin deployed.

About the Hibernate error: actually it is raised for the very first fetch my application does, during the index.jsp loading. The exact position of the error in fact changes, above was when I log in, but if I refresh it's in another position:

Code:

2024-04-12T14:58:53,474 DEBUG SQL 7: Executing SQL query on 'dbJFrame': SELECT AUTH_USERS_ROLES.ID_REC, AUTH_USERS_ROLES.ID_ROLE_FK, AUTH_USERS_ROLES.ID_USER_FK, ROLES.ROLE AS NOME_GRUPPO, AUTH_USERS_ROLES.CREATOR, AUTH_USERS_ROLES.CREATOR_TIMESTAMP, AUTH_USERS_ROLES.MODIFIER, AUTH_USERS_ROLES.MODIFIER_TIMESTAMP, ROLES.ROLE, ROLES.DESCRIPTION AS ROLE_DESCRIPTION, USERS.EMAIL, ROLES.IS_SUPER_USER, ROLES_APPS.APP_ID FROM DBJFRAME.AUTH_USERS_ROLES JOIN DBJFRAME.AUTH_ROLES ROLES ON AUTH_USERS_ROLES.ID_ROLE_FK = ROLES.ID_REC JOIN DBJFRAME.AUTH_USERS USERS ON AUTH_USERS_ROLES.ID_USER_FK = USERS.ID_REC JOIN DBJFRAME.AUTH_APPS ROLES_APPS ON ROLES.ID_APP_FK = ROLES_APPS.ID_REC WHERE ((ROLES_APPS.APP_ID = 'JcaAuth' AND ROLES_APPS.APP_ID IS NOT NULL) AND (LOWER(USERS.EMAIL)=LOWER('me@foo.com') AND USERS.EMAIL IS NOT NULL)) ORDER BY ROLE
2024-04-12T14:58:53,485 WARN InterfaceProvider Configuration error - cannot find provider for interface: IHibernateDataSource
java.lang.ClassNotFoundException: com.isomorphic.hibernate.HibernateDataSource
    at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1291) ~[catalina.jar:8.5.23]
    at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119) ~[catalina.jar:8.5.23]
    at java.lang.Class.forName0(Native Method) ~[?:?]
    at java.lang.Class.forName(Class.java:315) ~[?:?]
    at com.isomorphic.base.Reflection._classForName(Reflection.java:333) ~[isomorphic-core-rpc-13.1-d20240407.jar:?]
    at com.isomorphic.base.Reflection.classForName(Reflection.java:297) ~[isomorphic-core-rpc-13.1-d20240407.jar:?]
    at com.isomorphic.interfaces.InterfaceProvider.exists(InterfaceProvider.java:160) [isomorphic-core-rpc-13.1-d20240407.jar:?]
    at com.isomorphic.interfaces.InterfaceProvider.exists(InterfaceProvider.java:138) [isomorphic-core-rpc-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLConnectionManager.<clinit>(SQLConnectionManager.java:85) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLTransaction.startTransaction(SQLTransaction.java:143) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLDataSource.getTransactionalConnection(SQLDataSource.java:608) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:1180) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLDriver.executeQuery(SQLDriver.java:1728) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:668) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:662) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1915) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1732) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:508) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:452) [isomorphic-sql-13.1-d20240407.jar:?]
    at com.isomorphic.datasource.DataSource.execute(DataSource.java:2967) [isomorphic-core-rpc-13.1-d20240407.jar:?]
    at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) [isomorphic-core-rpc-13.1-d20240407.jar:?]
    at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) [isomorphic-core-rpc-13.1-d20240407.jar:?]
    at com.isomorphic.application.AppBase.execute(AppBase.java:498) [isomorphic-core-rpc-13.1-d20240407.jar:?]
    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3688) [isomorphic-core-rpc-13.1-d20240407.jar:?]
    at com.juve.core.UserDetails.fetchUserRoles(UserDetails.java:323) [classes/:?]
    at com.juve.core.UserDetails.<init>(UserDetails.java:191) [classes/:?]
    at org.apache.jsp.index_jsp._jspService(index_jsp.java:315) [JcaAuth/:?]
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) [jasper.jar:8.5.23]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [servlet-api.jar:?]
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443) [jasper.jar:8.5.23]
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385) [jasper.jar:8.5.23]
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329) [jasper.jar:8.5.23]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [servlet-api.jar:?]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.23]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.23]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
    at com.juve.utils.Log4j2SessionFilter.doFilter(Log4j2SessionFilter.java:72) [classes/:?]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
    at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263) [isomorphic-core-rpc-13.1-d20240407.jar:?]
    at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91) [isomorphic-core-rpc-13.1-d20240407.jar:?]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.authentication.ui.DefaultLogoutPageGeneratingFilter.doFilterInternal(DefaultLogoutPageGeneratingFilter.java:52) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:206) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:185) [catalina.jar:8.5.23]
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.23]
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [catalina.jar:8.5.23]
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [catalina.jar:8.5.23]
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.23]
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) [catalina.jar:8.5.23]
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.23]
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [catalina.jar:8.5.23]
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-coyote.jar:8.5.23]
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.23]
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:8.5.23]
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-coyote.jar:8.5.23]
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.23]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.23]
    at java.lang.Thread.run(Thread.java:829) [?:?]
2024-04-12T14:58:53,501 INFO PoolManager SmartClient pooling disabled for 'dbJFrame' objects
2024-04-12T14:58:53,501 DEBUG PoolableSQLConnectionFactory makeObject() created an unpooled Connection '1464455268'
2024-04-12T14:58:53,502 DEBUG SQLConnectionManager Borrowed connection '1464455268' from DBCP
2024-04-12T14:58:53,504 DEBUG SQLTransaction Started new dbJFrame transaction "1464455268"
2024-04-12T14:58:53,504 INFO SQL Executing SQL query on 'dbJFrame': SELECT AUTH_USERS_ROLES.ID_REC, AUTH_USERS_ROLES.ID_ROLE_FK, AUTH_USERS_ROLES.ID_USER_FK, ROLES.ROLE AS NOME_GRUPPO, AUTH_USERS_ROLES.CREATOR, AUTH_USERS_ROLES.CREATOR_TIMESTAMP, AUTH_USERS_ROLES.MODIFIER, AUTH_USERS_ROLES.MODIFIER_TIMESTAMP, ROLES.ROLE, ROLES.DESCRIPTION AS ROLE_DESCRIPTION, USERS.EMAIL, ROLES.IS_SUPER_USER, ROLES_APPS.APP_ID FROM DBJFRAME.AUTH_USERS_ROLES JOIN DBJFRAME.AUTH_ROLES ROLES ON AUTH_USERS_ROLES.ID_ROLE_FK = ROLES.ID_REC JOIN DBJFRAME.AUTH_USERS USERS ON AUTH_USERS_ROLES.ID_USER_FK = USERS.ID_REC JOIN DBJFRAME.AUTH_APPS ROLES_APPS ON ROLES.ID_APP_FK = ROLES_APPS.ID_REC WHERE ((ROLES_APPS.APP_ID = 'JcaAuth' AND ROLES_APPS.APP_ID IS NOT NULL) AND (LOWER(USERS.EMAIL)=LOWER('me@foo.com') AND USERS.EMAIL IS NOT NULL)) ORDER BY ROLE
2024-04-12T14:58:53,583 INFO DSResponse DSResponse: List with 3 items

as you may see, the query is actually executed after the exception. It's a query executed in server code like this:

Code:

DSRequest dsRequest = new DSRequest("AUTH_USERS_ROLES", DataSource.OP_FETCH);
        dsRequest.setDSTransaction(dsTransaction);
        AdvancedCriteria advancedCriteria = new AdvancedCriteria(...);
        dsRequest.setAdvancedCriteria(advancedCriteria);
        dsRequest.setSortBy("ROLE");
        DSResponse dsResponse = dsRequest.execute();

**Isomorphic** · 12 Apr 2024, 11:51

On the userSkin problem: that makes sense, what the Developer Console does is check if its usual skin is available, and if it isn't, falls back to whatever skin is present in the main app. So you would expect to see one failed request to get a resource before it backs off to use your app skin.

As far as the Hibernate thing, that's quite weird. What's this:

at com.juve.core.UserDetails.<init>(UserDetails.java:191) [classes/:?]

Do you have a DataSource called something like "user" and is this a class attached to it? And is it a Hibernate DataSource?

This looks like some code in the CompressionFilter that tries to look up user-specific information. It looks like it's misfiring and trying to load one of your app DataSources, but it's still unclear how that could lead to a Hibernate load, unless your UserDetails DS is a Hibernate DS.

Announcement

seemingly unharmful server errors with 13.1

Comment

Comment

Comment