My license for Studio just expired and I’m waiting on a new one (it’s an academic license). Meanwhile, I don’t know how to run the last build of my application because I have been running exclusively via Studio. How can I run the latest build? I’d be running under Win10 and the project uses HSQL and Tomcat. Thanks
Eric
Take a look at doc here
If you only want to start Tomcat with an assembled and functional build, just execute yourapp/deploy/tomcat/bin/startup.bat
In case an exception is raised, probably you would to set JRE_HOME environment variable. Edit yourapp/deploy/tomcat/bin/startenv.bat and add something like this:
set JRE_HOME=C:\Program Files\Java\jre1.8.0_161
… or whereever Java is installed.
Thanks so much. It at least tries to run now. However, I am getting errors that seem to be related to accessing the database (see below). Is there something else I need to start? Thanks - Eric
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version: Apache Tomcat/8.5.14
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server built: Apr 13 2017 12:55:45 UTC
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server number: 8.5.14.0
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Name: Windows 10
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Version: 10.0
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Architecture: amd64
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Java Home: C:\Program Files\Java\jre1.8.0_131
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Version: 1.8.0_131-b11
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Vendor: Oracle Corporation
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_BASE: C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_HOME: C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.util.logging.config.file=C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat\conf\logging.properties
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xmx512m
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dfile.encoding=UTF-8
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dlogback.configurationFile=../conf/logback.xml
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcom.sun.management.jmxremote
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.base=C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.home=C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat
Apr 16, 2018 10:56:58 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.io.tmpdir=C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat\temp
Apr 16, 2018 10:56:58 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.8.0_131\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Python35\;C:\Python35\Scripts\;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Users\esamsta1\AppData\Local\Microsoft\WindowsApps;;.
Apr 16, 2018 10:57:02 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-nio-8080"]
Apr 16, 2018 10:57:03 AM org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
INFO: Using a shared selector for servlet write/read
Apr 16, 2018 10:57:03 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-nio-8009"]
Apr 16, 2018 10:57:03 AM org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
INFO: Using a shared selector for servlet write/read
Apr 16, 2018 10:57:03 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 4631 ms
Apr 16, 2018 10:57:03 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Apr 16, 2018 10:57:03 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/8.5.14
Apr 16, 2018 10:57:03 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat\webapps\app
10:57:05.178 INFO o.atmosphere.cpr.AtmosphereFramework - Installed AtmosphereHandler com.vaadin.server.communication.PushAtmosphereHandler mapped to context-path: /*
10:57:05.178 INFO o.atmosphere.cpr.AtmosphereFramework - Installed the following AtmosphereInterceptor mapped to AtmosphereHandler com.vaadin.server.communication.PushAtmosphereHandler
10:57:05.209 INFO org.atmosphere.util.IOUtils - META-INF/services/org.atmosphere.cpr.AtmosphereFramework not found in class loader
10:57:05.225 INFO o.atmosphere.cpr.AtmosphereFramework - Atmosphere is using org.atmosphere.util.VoidAnnotationProcessor for processing annotation
10:57:05.240 INFO o.atmosphere.cpr.AtmosphereFramework - Installed WebSocketProtocol org.atmosphere.websocket.protocol.SimpleHttpProtocol
10:57:05.256 INFO o.a.container.JSR356AsyncSupport - JSR 356 Mapping path /{path}
10:57:05.271 INFO o.atmosphere.cpr.AtmosphereFramework - Installing Default AtmosphereInterceptors
10:57:05.271 INFO o.atmosphere.cpr.AtmosphereFramework - org.atmosphere.interceptor.CorsInterceptor : CORS Interceptor Support
10:57:05.271 INFO o.atmosphere.cpr.AtmosphereFramework - org.atmosphere.interceptor.CacheHeadersInterceptor : Default Response's Headers Interceptor
10:57:05.287 INFO o.atmosphere.cpr.AtmosphereFramework - org.atmosphere.interceptor.PaddingAtmosphereInterceptor : Browser Padding Interceptor Support
10:57:05.287 INFO o.atmosphere.cpr.AtmosphereFramework - org.atmosphere.interceptor.AndroidAtmosphereInterceptor : Android Interceptor Support
10:57:05.287 INFO o.atmosphere.cpr.AtmosphereFramework - Dropping Interceptor org.atmosphere.interceptor.HeartbeatInterceptor
10:57:05.287 INFO o.atmosphere.cpr.AtmosphereFramework - org.atmosphere.interceptor.SSEAtmosphereInterceptor : SSE Interceptor Support
10:57:05.287 INFO o.atmosphere.cpr.AtmosphereFramework - org.atmosphere.interceptor.JSONPAtmosphereInterceptor : JSONP Interceptor Support
10:57:05.287 INFO o.atmosphere.cpr.AtmosphereFramework - org.atmosphere.interceptor.JavaScriptProtocol : Atmosphere JavaScript Protocol
10:57:05.287 INFO o.atmosphere.cpr.AtmosphereFramework - org.atmosphere.interceptor.WebSocketMessageSuspendInterceptor : org.atmosphere.interceptor.WebSocketMessageSuspendInterceptor
10:57:05.287 INFO o.atmosphere.cpr.AtmosphereFramework - org.atmosphere.interceptor.OnDisconnectInterceptor : Browser disconnection detection
10:57:05.287 INFO o.atmosphere.cpr.AtmosphereFramework - org.atmosphere.interceptor.IdleResourceInterceptor : org.atmosphere.interceptor.IdleResourceInterceptor
10:57:05.287 INFO o.atmosphere.cpr.AtmosphereFramework - Set org.atmosphere.cpr.AtmosphereInterceptor.disableDefaults to disable them.
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Using EndpointMapper class org.atmosphere.util.DefaultEndpointMapper
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Using BroadcasterCache: org.atmosphere.cache.UUIDBroadcasterCache
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Default Broadcaster Class: org.atmosphere.cpr.DefaultBroadcaster
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Broadcaster Polling Wait Time 100
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Shared ExecutorService supported: true
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Messaging Thread Pool Size: Unlimited
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Async I/O Thread Pool Size: 200
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Using BroadcasterFactory: org.atmosphere.cpr.DefaultBroadcasterFactory
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Using WebSocketProcessor: org.atmosphere.websocket.DefaultWebSocketProcessor
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Invoke AtmosphereInterceptor on WebSocket message true
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - HttpSession supported: true
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Atmosphere is using DefaultAtmosphereObjectFactory for dependency injection and object creation
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Atmosphere is using async support: org.atmosphere.container.JSR356AsyncSupport running under container: Apache Tomcat/8.5.14 using javax.servlet/3.0 and jsr356/WebSocket API
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Atmosphere Framework 2.2.9.vaadin2.cuba1 started.
10:57:05.303 INFO o.atmosphere.cpr.AtmosphereFramework - Installed AtmosphereInterceptor Track Message Size Interceptor using | with priority BEFORE_DEFAULT
10:57:05.459 INFO c.h.cuba.core.sys.AppComponents - Using app components: [com.haulmont.cuba, com.haulmont.reports]
10:57:05.506 INFO c.h.c.c.s.AbstractWebAppContextLoader - Loading app properties from classpath:com/aac/clinic/web-app.properties
10:57:05.756 INFO c.h.c.c.s.CubaClassPathXmlApplicationContext - Refreshing com.haulmont.cuba.core.sys.CubaClassPathXmlApplicationContext@506f7f4d: startup date [Mon Apr 16 10:57:05 EDT 2018]; root of context hierarchy
10:57:08.162 INFO c.h.c.c.s.r.d.StaticServerSelector - Server URLs: [http://localhost:8080/app-core/remoting]
10:57:08.178 INFO c.h.c.w.s.r.WebRemoteProxyBeanCreator - Configuring proxy beans for local service invocations: [cuba_LoginService, cuba_ServerInfoService, cuba_UserSettingService, cuba_UserManagementService, cuba_DataService, cuba_ConfigStorageService, cuba_PersistenceManagerService, cuba_LockService, cuba_UserSessionService, cuba_FoldersService, cuba_EmailService, cuba_FileStorageService, cuba_EntitySnapshotService, cuba_UniqueNumbersService, cuba_LocalizedMessageService, cuba_ResourceService, cuba_ScheduledTasksService, cuba_EntityLogService, cuba_TestingService, cuba_ObjectsCacheManagerService, cuba_DomainDescriptionService, cuba_RelatedEntitiesService, cuba_EntitySqlGenerationService, cuba_NumberIdService, cuba_QueryResultsService, cuba_DynamicAttributesCacheService, cuba_EntityRestoreService, cuba_LocalFileExchangeService, cuba_EntityImportExportService, cuba_ScreenProfilerService, cuba_ServerTokenStore, cuba_IdpService, cuba_ConstraintLocalizationService]
10:57:08.194 INFO c.h.c.w.s.r.WebRemoteProxyBeanCreator - Configuring proxy beans for local service invocations: [report_ReportService, report_ReportWizardService]
10:57:08.194 INFO c.h.c.w.s.r.WebRemoteProxyBeanCreator - Configuring proxy beans for local service invocations: [clinic_RemoveVisitService, clinic_CopyOTMService]
10:57:09.022 INFO c.h.chile.core.datatypes.Datatypes - Can't find /datatypes.xml, using default datatypes settings
10:57:10.303 INFO c.h.c.c.s.CubaThreadPoolTaskScheduler - Initializing ExecutorService 'scheduler'
10:57:10.710 INFO c.h.cuba.core.sys.jmx.MBeanExporter - Registering beans for JMX exposure: [app.cuba:type=ConfigStorage, app.cuba:type=CachingFacade, app.cuba:type=FileUploading, app.cuba:type=JmxNodeIdentifier, app.cuba:type=JmxLogControl, app.cuba:type=ClassLoaderManager, app.cuba:type=StatisticsCounter]
10:57:10.772 INFO c.h.c.c.s.AbstractWebAppContextLoader - AppContext initialized
10:57:10.866 INFO c.h.c.web.sys.CubaDispatcherServlet - FrameworkServlet 'dispatcher': initialization started
10:57:10.881 INFO c.h.c.c.s.CubaXmlWebApplicationContext - Refreshing WebApplicationContext for namespace 'dispatcher-servlet': startup date [Mon Apr 16 10:57:10 EDT 2018]; parent: com.haulmont.cuba.core.sys.CubaClassPathXmlApplicationContext@506f7f4d
10:57:13.397 INFO c.h.c.web.sys.CubaDispatcherServlet - FrameworkServlet 'dispatcher': initialization completed in 2531 ms
10:57:13.397 INFO c.h.restapi.sys.CubaRestApiServlet - FrameworkServlet 'rest_api': initialization started
10:57:13.397 INFO c.h.c.c.s.CubaXmlWebApplicationContext - Refreshing WebApplicationContext for namespace 'rest_api-servlet': startup date [Mon Apr 16 10:57:13 EDT 2018]; parent: com.haulmont.cuba.core.sys.CubaClassPathXmlApplicationContext@506f7f4d
10:57:14.648 INFO c.h.restapi.sys.CubaRestApiServlet - FrameworkServlet 'rest_api': initialization completed in 1251 ms
Apr 16, 2018 10:57:14 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat\webapps\app has finished in 11,533 ms
Apr 16, 2018 10:57:14 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat\webapps\app-core
10:57:14.866 INFO c.h.cuba.core.sys.AppComponents - Using app components: [com.haulmont.cuba, com.haulmont.reports]
10:57:14.882 INFO c.h.c.c.s.AbstractWebAppContextLoader - Loading app properties from classpath:com/aac/clinic/app.properties
10:57:14.882 INFO c.h.cuba.core.sys.AppContextLoader - DbmsType of the main database is set to hsql
10:57:15.007 INFO c.h.c.c.s.p.PersistenceConfigProcessor - Creating file C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat\work\app-core\persistence.xml
10:57:15.132 INFO c.h.c.c.s.p.PersistenceConfigProcessor - Creating file C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat\work\app-core\asnc-persistence.xml
10:57:15.148 INFO c.h.c.c.s.CubaCoreApplicationContext - Refreshing com.haulmont.cuba.core.sys.CubaCoreApplicationContext@46051e4b: startup date [Mon Apr 16 10:57:15 EDT 2018]; root of context hierarchy
10:57:18.929 INFO c.h.chile.core.datatypes.Datatypes - Can't find /datatypes.xml, using default datatypes settings
10:57:20.992 INFO c.h.c.c.s.CubaThreadPoolTaskScheduler - Initializing ExecutorService 'scheduler'
10:57:21.555 INFO c.h.cuba.core.sys.jmx.MBeanExporter - Registering beans for JMX exposure: [app-core.cuba:type=PersistenceManager, app-core.cuba:type=ConfigStorage, app-core.cuba:type=UserSessions, app-core.cuba:type=UniqueNumbers, app-core.cuba:type=Emailer, app-core.cuba:type=EntityLog, app-core.cuba:type=FileStorage, app-core.cuba:type=LockManager, app-core.cuba:type=CachingFacade, app-core.cuba:type=ClusterManager, app-core.cuba:type=ScriptingManager, app-core.cuba:type=ServerInfo, app-core.cuba:type=Scheduling, app-core.cuba:type=ObjectsCacheManager, app-core.cuba:type=PasswordEncryptionSupport, app-core.cuba:type=JmxNodeIdentifier, app-core.cuba:type=JmxLogControl, app-core.cuba:type=ClassLoaderManager, app-core.cuba:type=StatisticsCounter, app-core.cuba:type=BruteForceProtection, app-core.cuba:type=QueryCacheSupport, app-core.cuba:type=IdpSessions]
10:57:21.695 INFO c.h.cuba.core.sys.jmx.MBeanExporter - Registering beans for JMX exposure: [app-core.reports:type=CubaOfficeIntegration, app-core.reports:type=ReportImportExport, app-core.reports:type=ReportingMigrator]
10:57:22.836 ERROR c.h.c.c.s.AbstractWebAppContextLoader - Error initializing application
java.lang.RuntimeException:
===================================================================
ERROR: Cannot check database. See the stacktrace below for details.
===================================================================
at com.haulmont.cuba.core.sys.AppContextLoader.checkDatabase(AppContextLoader.java:145)
at com.haulmont.cuba.core.sys.AppContextLoader.afterInitAppContext(AppContextLoader.java:109)
at com.haulmont.cuba.core.sys.AbstractWebAppContextLoader.contextInitialized(AbstractWebAppContextLoader.java:73)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1107)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1841)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.haulmont.cuba.core.sys.DbInitializationException: Error connecting to database: Cannot create PoolableConnectionFactory (java.net.ConnectException: Connection refused: connect)
at com.haulmont.cuba.core.sys.dbupdate.DbUpdaterEngine.dbInitialized(DbUpdaterEngine.java:172)
at com.haulmont.cuba.core.sys.AppContextLoader.checkDatabase(AppContextLoader.java:126)
... 15 common frames omitted
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (java.net.ConnectException: Connection refused: connect)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2303)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2043)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1543)
at com.haulmont.cuba.core.sys.jdbc.ProxyDataSource.getConnection(ProxyDataSource.java:35)
at com.haulmont.cuba.core.sys.dbupdate.DbUpdaterEngine.dbInitialized(DbUpdaterEngine.java:154)
... 16 common frames omitted
Caused by: java.sql.SQLTransientConnectionException: java.net.ConnectException: Connection refused: connect
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
at org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:257)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2313)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2299)
... 20 common frames omitted
Caused by: org.hsqldb.HsqlException: java.net.ConnectException: Connection refused: connect
at org.hsqldb.ClientConnection.openConnection(Unknown Source)
at org.hsqldb.ClientConnection.initConnection(Unknown Source)
at org.hsqldb.ClientConnection.<init>(Unknown Source)
... 27 common frames omitted
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.hsqldb.server.HsqlSocketFactory.createSocket(Unknown Source)
... 30 common frames omitted
10:57:22.836 INFO c.h.c.c.s.CubaCoreApplicationContext - Closing com.haulmont.cuba.core.sys.CubaCoreApplicationContext@46051e4b: startup date [Mon Apr 16 10:57:15 EDT 2018]; root of context hierarchy
10:57:22.836 INFO c.h.c.c.s.CubaThreadPoolTaskScheduler - Shutting down ExecutorService 'scheduler'
Apr 16, 2018 10:57:22 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: One or more listeners failed to start. Full details will be found in the appropriate container log file
Apr 16, 2018 10:57:22 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/app-core] startup failed due to previous errors
Apr 16, 2018 10:57:22 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\Users\esamsta1\Desktop\Clinic 2.0 Dev\deploy\tomcat\webapps\app-core has finished in 8,220 ms
Apr 16, 2018 10:57:22 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-nio-8080"]
Apr 16, 2018 10:57:22 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-nio-8009"]
Apr 16, 2018 10:57:22 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 19888 ms
check if exists yourapp\deploy\tomcat\conf\app\local.app.properties
If not, create it and add two lines
cuba.webHostName = localhost
cuba.webAppUrl = http://localhost:8080/app
Copy this file to yourapp\deploy\tomcat\conf\app-core\local.app.properties and add a third line
cuba.automaticDatabaseUpdate=true
Be aware that database exists (even if it’s empty without tables).Configure dbconnection context.xml file
yourapp\deploy\tomcat\webapps\app-core\META-INF\context.xml
Should contain something like this:
<Context> <Manager pathname=""/> <Resource driverClassName="org.hsqldb.jdbc.JDBCDriver" maxIdle="2" maxTotal="20" maxWaitMillis="5000" name="jdbc/CubaDS" password="" type="javax.sql.DataSource" url="jdbc:hsqldb:hsql://localhost/databasename" username="sa"/> </Context>
where databasename is the name of your database.
Hi,
The exception might occur when the application is started but the HSQL server is not running.
When you open the project in Studio it starts the HSQLDB engine.
Without Studio you can start it using Gradle. Define the startDb task in build.gradle and launch it.
configure(coreModule) {
task startDb(type: CubaHsqlStart) {
dbName = 'sales'
}
...