Deploying oba-watchdog-webapp failing

48 views
Skip to first unread message

Aaron Brethorst

unread,
Jan 2, 2025, 2:02:59 AMJan 2
to onebusaway-developers
Hey folks - I'm trying to get the onebusaway-watchdog-webapp project running alongside an otherwise fully-functioning OBA deployment (tdf-webapp/api-webapp), but I'm running into a problem.

Specifically, I'm following the instructions Sheldon wrote up here about 8 years ago: https://github.com/OneBusAway/onebusaway-application-modules/wiki/OneBusAway-Watchdog

and I am seeing an issue with Hibernate on deployment, which seems to suggest I'm not properly configuring Hibernate, but copy and pasting a fully functional config from the oba-api-webapp data-sources.xml file into the oba-watchdog-webapp.xml still doesn't work. — see the very end of the email for the error logs...

Any suggestions?

thanks,
Aaron

oba_app          | 22:53:54.328 [localhost-startStop-1] ERROR org.springframework.web.context.ContextLoader - Context initialization failed

oba_app          | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [org/onebusaway/container/application-context-hibernate.xml]: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

oba_app          | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1799) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:878) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) ~[spring-context-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:401) ~[spring-web-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:292) ~[spring-web-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103) ~[spring-web-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4441) ~[catalina.jar:8.5.100]

oba_app          | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4899) ~[catalina.jar:8.5.100]

oba_app          | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) ~[catalina.jar:8.5.100]

oba_app          | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:710) ~[catalina.jar:8.5.100]

oba_app          | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:687) ~[catalina.jar:8.5.100]

oba_app          | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:660) ~[catalina.jar:8.5.100]

oba_app          | at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1176) ~[catalina.jar:8.5.100]

oba_app          | at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1889) ~[catalina.jar:8.5.100]

oba_app          | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) ~[?:?]

oba_app          | at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]

oba_app          | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]

oba_app          | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]

oba_app          | at java.lang.Thread.run(Thread.java:829) ~[?:?]

oba_app          | Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:275) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:176) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:118) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:473) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:84) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:689) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.springframework.orm.hibernate5.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:616) ~[spring-orm-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.orm.hibernate5.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:600) ~[spring-orm-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1858) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1795) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | ... 25 more

oba_app          | Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

oba_app          | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.determineDialect(DialectFactoryImpl.java:100) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:54) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:137) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:176) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:118) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:473) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:84) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:689) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]

oba_app          | at org.springframework.orm.hibernate5.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:616) ~[spring-orm-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.orm.hibernate5.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:600) ~[spring-orm-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1858) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1795) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]

oba_app          | ... 25 more

oba_app          | 01-Jan-2025 22:53:54.332 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file


Vicente Pérez

unread,
Jan 2, 2025, 1:37:53 PMJan 2
to onebusaway...@googlegroups.com
Hi Aron,

It is quite difficult to me to say why whit just this stacktrace. I think that it might be the database version or the hibernate dialect.  "Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set.”

Best regards
Vicente

--
You received this message because you are subscribed to the Google Groups "onebusaway-developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to onebusaway-devel...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/onebusaway-developers/b3317e96-5a53-41f7-b5ad-b67cea6b55c9n%40googlegroups.com.

Aaron Brethorst

unread,
Jan 2, 2025, 3:08:53 PMJan 2
to onebusaway...@googlegroups.com, onebusaway...@googlegroups.com
Hi Vicente - I think you’re exactly right: it’s definitely a database configuration issue. Unfortunately, I’m not sure how to configure the DB correctly within the data-sources.xml file nor can I find any examples of configuring it online. 

Sent from my iPhone

On Jan 2, 2025, at 10:37 AM, Vicente Pérez <vsp...@gmail.com> wrote:

Hi Aron,

Vicente Pérez

unread,
Jan 2, 2025, 5:48:37 PMJan 2
to onebusaway...@googlegroups.com
Have you tried something like  

<property name="hibernateProperties">
        <util:map>
            <entry key="hibernate.hbm2ddl.auto" value="update" />
            <entry key="hibernate.show_sql" value="true" />
            <entry key="hibernate.dialect">
                <jee:jndi-lookup jndi-name="java:comp/env/jdbc/dialect" />
            </entry>
        </util:map>
    </property>
as a property of datasouce?

DataSource should be like this:
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="org.hsqldb.jdbcDriver" />
    <property name="url" value="jdbc:hsqldb:file:${bundlePath}/org_onebusaway_transit_data" />
    <property name="username" value="sa" />
    <property name="password" value="" />
 </bean>


To view this discussion visit https://groups.google.com/d/msgid/onebusaway-developers/2ABC4FBC-F14B-4467-90E4-BD9F4884E629%40brethorsting.com.
Reply all
Reply to author
Forward
0 new messages