Create
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Community resources
Community resources
Community resources
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
Jonas Andersson
Rising Star 
June 22, 2016 edited Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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.
Was this helpful?
Thanks!
Community showcase
Atlassian Community Events
Copyright © 2025 Atlassian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.