Caused by: java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;

This question is in reference to Atlassian Documentation: Retrieving the JIRA Administrator via HSQLDB

Need help please to resolve issue in JIRA? 

I'm also getting this when I browse to our internal JIRA homepage:

HTTP status 500 - could not determine database type. (error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE])

 

****************
JIRA starting...
****************
2016-06-21 19:33:05,175 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger] 
___ Environment _____________________________
     JIRA Build                                    : 6.3.13#6344-sha1:62d2b41c1ddfd5b5a56568898407231b0d9c17cb
     Build Date                                    : Wed Jan 07 00:00:00 NZDT 2015
     JIRA Installation Type                        : Standalone
     Application Server                            : Apache Tomcat/7.0.55 - Servlet API 3.0
     Java Version                                  : 1.8.0_11 - Oracle Corporation
     Current Working Directory                     : C:\Program Files\Atlassian\JIRA
     Maximum Allowable Memory                      : 683MB
     Total Memory                                  : 470MB
     Free Memory                                   : 364MB
     Used Memory                                   : 106MB
     Memory Pool: Code Cache                       : Code Cache: init = 2555904(2496K) used = 11455552(11187K) committed = 11534336(11264K) max = 251658240(245760K)
     Memory Pool: Metaspace                        : Metaspace: init = 0(0K) used = 17807448(17390K) committed = 18350080(17920K) max = -1(-1K)
     Memory Pool: Compressed Class Space           : Compressed Class Space: init = 0(0K) used = 2151904(2101K) committed = 2359296(2304K) max = 1073741824(1048576K)
     Memory Pool: PS Eden Space                    : PS Eden Space: init = 524288(512K) used = 32960624(32188K) committed = 183500800(179200K) max = 185073664(180736K)
     Memory Pool: PS Survivor Space                : PS Survivor Space: init = 524288(512K) used = 17798224(17381K) committed = 42467328(41472K) max = 42467328(41472K)
     Memory Pool: PS Old Gen                       : PS Old Gen: init = 266862592(260608K) used = 59721456(58321K) committed = 266862592(260608K) max = 536870912(524288K)
     JVM Input Arguments                           : -Djava.awt.headless=true -Datlassian.standalone=JIRA -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Dmail.mime.decodeparameters=true -Dorg.dom4j.factory=com.atlassian.core.xml.InterningDocumentFactory -Dcatalina.home=C:\Program Files\Atlassian\JIRA -Dcatalina.base=C:\Program Files\Atlassian\JIRA -Djava.endorsed.dirs=C:\Program Files\Atlassian\JIRA\endorsed -Djava.io.tmpdir=C:\Program Files\Atlassian\JIRA\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Program Files\Atlassian\JIRA\conf\logging.properties -XX:MaxPermSize=384m exit -Xms256m -Xmx768m
     Java Compatibility Information                : JIRA version = 6.3.13, Java Version = 1.8.0_11
___ Java System Properties ________________
     atlassian.standalone                          : JIRA
     awt.toolkit                                   : sun.awt.windows.WToolkit
     catalina.base                                 : C:\Program Files\Atlassian\JIRA
     catalina.home                                 : C:\Program Files\Atlassian\JIRA
     catalina.useNaming                            : true
     common.loader                                 : ${catalina.base}/lib,
                                                     ${catalina.base}/lib/*.jar,
                                                     ${catalina.home}/lib,
                                                     ${catalina.home}/lib/*.jar
     file.encoding                                 : Cp1252
     file.encoding.pkg                             : sun.io
     java.awt.graphicsenv                          : sun.awt.Win32GraphicsEnvironment
     java.awt.headless                             : true
     java.awt.printerjob                           : sun.awt.windows.WPrinterJob
     java.class.version                            : 52.0
     java.home                                     : C:\PROGRA~1\ATLASS~2\JIRA\jre
     java.io.tmpdir                                : C:\Program Files\Atlassian\JIRA\temp
     java.naming.factory.initial                   : org.apache.naming.java.javaURLContextFactory
     java.naming.factory.url.pkgs                  : org.apache.naming
     java.runtime.name                             : Java(TM) SE Runtime Environment
     java.runtime.version                          : 1.8.0_11-b12
     java.specification.name                       : Java Platform API Specification
     java.specification.vendor                     : Oracle Corporation
     java.specification.version                    : 1.8
     java.util.logging.config.file                 : C:\Program Files\Atlassian\JIRA\conf\logging.properties
     java.util.logging.manager                     : org.apache.juli.ClassLoaderLogManager
     java.vendor                                   : Oracle Corporation
     java.vendor.url                               : http://java.oracle.com/
     java.vendor.url.bug                           : http://bugreport.sun.com/bugreport/
     java.version                                  : 1.8.0_11
     java.vm.info                                  : mixed mode
     java.vm.name                                  : Java HotSpot(TM) 64-Bit Server VM
     java.vm.specification.name                    : Java Virtual Machine Specification
     java.vm.specification.vendor                  : Oracle Corporation
     java.vm.specification.version                 : 1.8
     java.vm.vendor                                : Oracle Corporation
     java.vm.version                               : 25.11-b03
     mail.mime.decodeparameters                    : true
     org.apache.catalina.startup.ContextConfig.jarsToSkip : 
     org.apache.catalina.startup.TldConfig.jarsToSkip : tomcat7-websocket.jar
     org.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER : true
     org.dom4j.factory                             : com.atlassian.core.xml.InterningDocumentFactory
     os.arch                                       : amd64
     os.name                                       : Windows Server 2012
     os.version                                    : 6.2
     package.access                                : sun.,
                                                     org.apache.catalina.,
                                                     org.apache.coyote.,
                                                     org.apache.jasper.,
                                                     org.apache.naming.resources.,
                                                     org.apache.tomcat.
     package.definition                            : sun.,
                                                     java.,
                                                     org.apache.catalina.,
                                                     org.apache.coyote.,
                                                     org.apache.jasper.,
                                                     org.apache.naming.,
                                                     org.apache.tomcat.
     server.loader                                 : 
     shared.loader                                 : 
     sun.arch.data.model                           : 64
     sun.boot.library.path                         : C:\PROGRA~1\ATLASS~2\JIRA\jre\bin
     sun.cpu.endian                                : little
     sun.cpu.isalist                               : amd64
     sun.desktop                                   : windows
     sun.io.unicode.encoding                       : UnicodeLittle
     sun.jnu.encoding                              : Cp1252
     sun.management.compiler                       : HotSpot 64-Bit Tiered Compilers
     sun.os.patch.level                            : 
     tomcat.util.buf.StringCache.byte.enabled      : true
     tomcat.util.scan.DefaultJarScanner.jarsToSkip : bootstrap.jar,
                                                     commons-daemon.jar,
                                                     tomcat-juli.jar,
                                                     annotations-api.jar,
                                                     el-api.jar,
                                                     jsp-api.jar,
                                                     servlet-api.jar,
                                                     websocket-api.jar,
                                                     catalina.jar,
                                                     catalina-ant.jar,
                                                     catalina-ha.jar,
                                                     catalina-tribes.jar,
                                                     jasper.jar,
                                                     jasper-el.jar,
                                                     ecj-*.jar,
                                                     tomcat-api.jar,
                                                     tomcat-util.jar,
                                                     tomcat-coyote.jar,
                                                     tomcat-dbcp.jar,
                                                     tomcat-jni.jar,
                                                     tomcat-spdy.jar,
                                                     tomcat-i18n-en.jar,
                                                     tomcat-i18n-es.jar,
                                                     tomcat-i18n-fr.jar,
                                                     tomcat-i18n-ja.jar,
                                                     tomcat-juli-adapters.jar,
                                                     catalina-jmx-remote.jar,
                                                     catalina-ws.jar,
                                                     tomcat-jdbc.jar,
                                                     tools.jar,
                                                     commons-beanutils*.jar,
                                                     commons-codec*.jar,
                                                     commons-collections*.jar,
                                                     commons-dbcp*.jar,
                                                     commons-digester*.jar,
                                                     commons-fileupload*.jar,
                                                     commons-httpclient*.jar,
                                                     commons-io*.jar,
                                                     commons-lang*.jar,
                                                     commons-logging*.jar,
                                                     commons-math*.jar,
                                                     commons-pool*.jar,
                                                     jstl.jar,
                                                     geronimo-spec-jaxrpc*.jar,
                                                     wsdl4j*.jar,
                                                     ant.jar,
                                                     ant-junit*.jar,
                                                     aspectj*.jar,
                                                     jmx.jar,
                                                     h2*.jar,
                                                     hibernate*.jar,
                                                     httpclient*.jar,
                                                     jmx-tools.jar,
                                                     jta*.jar,
                                                     log4j.jar,
                                                     log4j-1*.jar,
                                                     mail*.jar,
                                                     slf4j*.jar,
                                                     xercesImpl.jar,
                                                     xmlParserAPIs.jar,
                                                     xml-apis.jar,
                                                     junit.jar,
                                                     junit-*.jar,
                                                     hamcrest*.jar,
                                                     org.hamcrest*.jar,
                                                     ant-launcher.jar,
                                                     cobertura-*.jar,
                                                     asm-*.jar,
                                                     dom4j-*.jar,
                                                     icu4j-*.jar,
                                                     jaxen-*.jar,
                                                     jdom-*.jar,
                                                     jetty-*.jar,
                                                     oro-*.jar,
                                                     servlet-api-*.jar,
                                                     tagsoup-*.jar,
                                                     xmlParserAPIs-*.jar,
                                                     xom-*.jar
     user.country                                  : NZ
     user.dir                                      : C:\Program Files\Atlassian\JIRA
     user.home                                     : C:\Windows\system32\config\systemprofile
     user.language                                 : en
     user.name                                     : BLIZZARD$
     user.script                                   : 
     user.timezone                                 : Pacific/Auckland
     user.variant                                  : 
2016-06-21 19:33:05,581 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraHomeStartupCheck] The jira.home directory 'C:\Program Files\Atlassian\Application Data\JIRA' is validated and locked for exclusive use by this instance.
2016-06-21 19:33:05,597 localhost-startStop-1 INFO      [jira.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from C:\Program Files\Atlassian\Application Data\JIRA\dbconfig.xml
2016-06-21 19:33:05,800 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2016-06-21 19:33:05,800 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
2016-06-21 19:33:06,441 localhost-startStop-1 ERROR      [atlassian.jira.startup.LauncherContextListener] Unable to start JIRA due to Java Error.
com.google.common.util.concurrent.ExecutionError: java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2232)
	at com.google.common.cache.LocalCache.get(LocalCache.java:3970)
	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
	at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4834)
	at com.google.common.cache.LocalCache$LocalManualCache.getUnchecked(LocalCache.java:4839)
	at org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:105)
	at com.atlassian.core.ofbiz.CoreFactory.getGenericDelegator(CoreFactory.java:38)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.configureOfbiz(DatabaseConfigurationManagerImpl.java:237)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:321)
	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:220)
	at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:109)
	at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:32)
	at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:81)
	at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34)
	at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:76)
	at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:71)  <+5> (StandardContext.java:4992) (StandardContext.java:5490) (LifecycleBase.java:150) (ContainerBase.java:1575) (ContainerBase.java:1565)
	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: java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:1134)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:110)
	at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)
	at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)
	at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:101)
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
	at org.ofbiz.core.entity.ConnectionFactory$1.getConnection(ConnectionFactory.java:52)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:132)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:903)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:166)
	at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:144)
	at org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1342)
	at org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:270)
	at org.ofbiz.core.entity.GenericDelegator.initialiseAndCheckDatabase(GenericDelegator.java:236)
	at org.ofbiz.core.entity.GenericDelegator.<init>(GenericDelegator.java:167)
	at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:91)
	at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:88)
	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3573)
	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2350)
	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2313)
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2228)
	... 24 more
2016-06-21 19:33:06,566 localhost-startStop-1 INFO      [atlassian.jira.startup.DefaultJiraLauncher] Stopping launchers
2016-06-22 10:57:36,393 localhost-startStop-1 INFO      [atlassian.jira.startup.JiraStartupLogger]

 

 

1 answer

This widget could not be displayed.

Search for dbconfig.xml and check what it contains.. By the sound you have just lost the environmental variable, or the path to the application server changed (renamed folder, moved drive)?

Did you do anything weird before this happened?

I never ran JIRA on Windows, so not sure how to troubleshot it, but this is a great start.

 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

48 views 2 2
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you