Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

OpenReports-Tomcat-2.0-M2 - cannot login

2006-09-18
2013-04-25
  • Hello,

    I just downloaded the OpenReports-Tomcat-2.0-M2 package and tried to login.  I've installed under C:\openreports-tomcat as specified int he readme, but after typing logging in with admin/admin, it fails with the following error in the DOS box:

    SEVERE: Connections could not be acquired from the underlying database!
    org.efs.openreports.providers.ProviderException: Cannot open connection

    The contents of my cataline file is:
    Sep 18, 2006 6:07:25 PM org.apache.coyote.http11.Http11Protocol init
    INFO: Initializing Coyote HTTP/1.1 on http-8080
    Sep 18, 2006 6:07:25 PM org.apache.catalina.startup.Catalina load
    INFO: Initialization processed in 719 ms
    Sep 18, 2006 6:07:25 PM org.apache.catalina.core.StandardService start
    INFO: Starting service Catalina
    Sep 18, 2006 6:07:25 PM org.apache.catalina.core.StandardEngine start
    INFO: Starting Servlet Engine: Apache Tomcat/5.5.9
    Sep 18, 2006 6:07:25 PM org.apache.catalina.core.StandardHost start
    INFO: XML validation disabled
    Sep 18, 2006 6:07:26 PM org.apache.catalina.startup.HostConfig deployWAR
    INFO: Deploying web application archive openreports.war
    Sep 18, 2006 6:07:35 PM org.displaytag.filter.ResponseOverrideFilter init
    INFO: Filter initialized. Response buffering is enabled
    Sep 18, 2006 6:07:35 PM com.opensymphony.webwork.views.velocity.VelocityManager loadConfiguration
    INFO: Initializing velocity using 'velocity.properties'
    Sep 18, 2006 6:07:35 PM com.opensymphony.webwork.views.velocity.VelocityManager loadConfiguration
    INFO: Initializing velocity using 'velocity.properties'
    Sep 18, 2006 6:07:35 PM com.opensymphony.webwork.dispatcher.ServletDispatcher init
    WARNING: Unable to find 'webwork.multipart.saveDir' property setting. Defaulting to javax.servlet.context.tempdir
    Sep 18, 2006 6:07:35 PM org.hibernate.cfg.Environment <clinit>
    INFO: Hibernate 3.1.3
    Sep 18, 2006 6:07:35 PM org.hibernate.cfg.Environment <clinit>
    INFO: loaded properties from resource hibernate.properties: {hibernate.c3p0.timeout=1800, hibernate.connection.driver_class=org.hsqldb.jdbcDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.c3p0.max_statements=50, hibernate.c3p0.max_size=20, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.c3p0.min_size=5, hibernate.jdbc.batch_size=0, hibernate.connection.username=sa, hibernate.connection.url=jdbc:hsqldb:hsql://127.0.0.1:9001/openreports, hibernate.connection.password=****}
    Sep 18, 2006 6:07:35 PM org.hibernate.cfg.Environment <clinit>
    INFO: using CGLIB reflection optimizer
    Sep 18, 2006 6:07:35 PM org.hibernate.cfg.Environment <clinit>
    INFO: using JDK 1.4 java.sql.Timestamp handling
    Sep 18, 2006 6:07:35 PM org.hibernate.cfg.Configuration configure
    INFO: configuring from resource: /hibernate.cfg.xml
    Sep 18, 2006 6:07:35 PM org.hibernate.cfg.Configuration getConfigurationInputStream
    INFO: Configuration resource: /hibernate.cfg.xml
    Sep 18, 2006 6:07:35 PM org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource: org/efs/openreports/objects/Report.hbm.xml
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.efs.openreports.objects.Report -> REPORT
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindCollection
    INFO: Mapping collection: org.efs.openreports.objects.Report.parameters -> REPORT_PARAMETER_MAP
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource: org/efs/openreports/objects/ReportDataSource.hbm.xml
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.efs.openreports.objects.ReportDataSource -> REPORT_DATASOURCE
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource: org/efs/openreports/objects/ReportGroup.hbm.xml
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.efs.openreports.objects.ReportGroup -> REPORT_GROUP
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindCollection
    INFO: Mapping collection: org.efs.openreports.objects.ReportGroup.reports -> REPORT_GROUP_MAP
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource: org/efs/openreports/objects/ReportParameter.hbm.xml
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.efs.openreports.objects.ReportParameter -> REPORT_PARAMETER
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource: org/efs/openreports/objects/ReportUser.hbm.xml
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.efs.openreports.objects.ReportUser -> REPORT_USER
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindCollection
    INFO: Mapping collection: org.efs.openreports.objects.ReportUser.groups -> USER_GROUP_MAP
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindCollection
    INFO: Mapping collection: org.efs.openreports.objects.ReportUser.alerts -> USER_ALERT_MAP
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindCollection
    INFO: Mapping collection: org.efs.openreports.objects.ReportUser.roles -> USER_SECURITY
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource: org/efs/openreports/objects/ReportLog.hbm.xml
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.efs.openreports.objects.ReportLog -> REPORT_LOG
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource: org/efs/openreports/objects/ReportChart.hbm.xml
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.efs.openreports.objects.ReportChart -> REPORT_CHART
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource: org/efs/openreports/objects/ReportAlert.hbm.xml
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.efs.openreports.objects.ReportAlert -> REPORT_ALERT
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource: org/efs/openreports/objects/ORProperty.hbm.xml
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.efs.openreports.objects.ORProperty -> OR_PROPERTIES
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.Configuration addResource
    INFO: Reading mappings from resource: org/efs/openreports/objects/ReportExportOption.hbm.xml
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
    INFO: Mapping class: org.efs.openreports.objects.ReportExportOption -> REPORT_EXPORT_OPTIONS
    Sep 18, 2006 6:07:36 PM org.hibernate.cfg.Configuration doConfigure
    INFO: Configured SessionFactory: null
    Sep 18, 2006 6:07:36 PM org.hibernate.connection.C3P0ConnectionProvider configure
    INFO: C3P0 using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://127.0.0.1:9001/openreports
    Sep 18, 2006 6:07:36 PM org.hibernate.connection.C3P0ConnectionProvider configure
    INFO: Connection properties: {user=sa, password=****}
    Sep 18, 2006 6:07:36 PM org.hibernate.connection.C3P0ConnectionProvider configure
    INFO: autocommit mode: false
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    WARNING: Could not obtain connection metadata
    java.sql.SQLException: Connections could not be acquired from the underlying database!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:236)
        at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)
        at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
        at org.efs.openreports.providers.HibernateProvider.<init>(HibernateProvider.java:44)
        at org.efs.openreports.dispatcher.ServletDispatcher.init(ServletDispatcher.java:53)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:788)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:677)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:473)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
        at org.apache.catalina.core.StandardService.start(StandardService.java:450)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
    Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)
        ... 33 more
    Sep 18, 2006 6:08:43 PM org.hibernate.dialect.Dialect <init>
    INFO: Using dialect: org.hibernate.dialect.HSQLDialect
    Sep 18, 2006 6:08:43 PM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
    INFO: Using default transaction strategy (direct JDBC transactions)
    Sep 18, 2006 6:08:43 PM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
    INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Automatic flush during beforeCompletion(): disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Automatic session close at end of transaction: disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Scrollable result sets: disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: JDBC3 getGeneratedKeys(): disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Connection release mode: auto
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Default batch fetch size: 1
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Generate SQL with comments: disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Order SQL updates by primary key: disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
    INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
    Sep 18, 2006 6:08:43 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
    INFO: Using ASTQueryTranslatorFactory
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Query language substitutions: {}
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Second-level cache: enabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Query cache: disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory createCacheProvider
    INFO: Cache provider: org.hibernate.cache.EhCacheProvider
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Optimize cache for minimal puts: disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Structured second-level cache entries: disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Statistics: disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Deleted entity synthetic identifier rollback: disabled
    Sep 18, 2006 6:08:43 PM org.hibernate.cfg.SettingsFactory buildSettings
    INFO: Default entity-mode: pojo
    Sep 18, 2006 6:08:43 PM org.hibernate.impl.SessionFactoryImpl <init>
    INFO: building session factory
    Sep 18, 2006 6:08:43 PM net.sf.ehcache.config.ConfigurationFactory parseConfiguration
    WARNING: No configuration found. Configuring ehcache from ehcache-failsafe.xml  found in the classpath: jar:file:/C:/openreports-tomcat/tomcat/webapps/openreports/WEB-INF/lib/ehcache-1.2.1.jar!/ehcache-failsafe.xml
    Sep 18, 2006 6:08:44 PM org.hibernate.impl.SessionFactoryObjectFactory addInstance
    INFO: Not binding factory to JNDI, no JNDI name configured
    Sep 18, 2006 6:08:44 PM org.quartz.core.QuartzScheduler <init>
    INFO: Quartz Scheduler v.1.5.2 created.
    Sep 18, 2006 6:08:44 PM org.quartz.plugins.management.ShutdownHookPlugin initialize
    INFO: Registering Quartz shutdown hook.
    Sep 18, 2006 6:08:44 PM org.quartz.impl.jdbcjobstore.JobStoreSupport initialize
    INFO: Using thread monitor-based data access locking (synchronization).
    Sep 18, 2006 6:08:46 PM org.apache.coyote.http11.Http11Protocol start
    INFO: Starting Coyote HTTP/1.1 on http-8080
    Sep 18, 2006 6:08:46 PM org.apache.jk.common.ChannelSocket init
    INFO: JK: ajp13 listening on /0.0.0.0:8009
    Sep 18, 2006 6:08:46 PM org.apache.jk.server.JkMain start
    INFO: Jk running ID=0 time=0/31  config=null
    Sep 18, 2006 6:08:46 PM org.apache.catalina.storeconfig.StoreLoader load
    INFO: Find registry server-registry.xml at classpath resource
    Sep 18, 2006 6:08:46 PM org.apache.catalina.startup.Catalina start
    INFO: Server startup in 80469 ms
    Sep 18, 2006 6:12:31 PM org.hibernate.util.JDBCExceptionReporter logExceptions
    WARNING: SQL Error: 0, SQLState: null
    Sep 18, 2006 6:12:31 PM org.hibernate.util.JDBCExceptionReporter logExceptions
    SEVERE: Connections could not be acquired from the underlying database!

    Any idea?

    Thanks much,
    Chris Kingsbury

     
    • I should have included the following details:

      OS: Microsoft Windows XP
      JVM: jdk1.5.0_06

       
    • Silly me, I posted this in the wrong forum.  Please ignore and I'll repost in in the correct location.