liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission.

JIRA | Björn Engel | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Running Liquibase 3.0.2 on Informix fails. The same execution with Liquibase 2.0.5 works... jdbc-url: jdbc:informix-sqli://<server>:<port>/<database>:INFORMIXSERVER=<informix-server>;DB_LOCALE=en_us.utf8;GL_DATE=Y4MD-;DBDATE=Y4MD-; INFO 17.07.13 10:42:liquibase: Successfully released change log lock SEVERE 17.07.13 10:42:liquibase: Unable to release lock: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission. [ERROR] java.sql.SQLException: Database not found or no system permission. liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission. at liquibase.snapshot.jvm.TableSnapshotGenerator.snapshotObject(TableSnapshotGenerator.java:45) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:59) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:75) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:128) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:139) at liquibase.snapshot.SnapshotGeneratorFactory.getDatabaseChangeLogTable(SnapshotGeneratorFactory.java:146) at liquibase.database.core.InformixDatabase.checkDatabaseChangeLogTable(InformixDatabase.java:191) at liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:602) at liquibase.Liquibase.forceReleaseLocks(Liquibase.java:640) at org.liquibase.maven.plugins.AbstractLiquibaseMojo.cleanup(AbstractLiquibaseMojo.java:475) at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:331) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59) at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156) at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196) at org.apache.maven.cli.MavenCli.main(MavenCli.java:141) 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:597) at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) Caused by: java.sql.SQLException: Database not found or no system permission. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397) at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3244) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3553) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2380) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2295) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1434) at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:205) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1228) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:243) at com.informix.jdbc.IfxDatabaseMetaData.getTables(IfxDatabaseMetaData.java:2967) at liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getTables(JdbcDatabaseSnapshot.java:173) at liquibase.snapshot.jvm.TableSnapshotGenerator.snapshotObject(TableSnapshotGenerator.java:33) ... 44 more Caused by: java.sql.SQLException: ISAM error: no record found. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3558) ... 54 more

    JIRA | 4 years ago | Björn Engel
    liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission.
  2. 0

    Running Liquibase 3.0.2 on Informix fails. The same execution with Liquibase 2.0.5 works... jdbc-url: jdbc:informix-sqli://<server>:<port>/<database>:INFORMIXSERVER=<informix-server>;DB_LOCALE=en_us.utf8;GL_DATE=Y4MD-;DBDATE=Y4MD-; INFO 17.07.13 10:42:liquibase: Successfully released change log lock SEVERE 17.07.13 10:42:liquibase: Unable to release lock: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission. [ERROR] java.sql.SQLException: Database not found or no system permission. liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission. at liquibase.snapshot.jvm.TableSnapshotGenerator.snapshotObject(TableSnapshotGenerator.java:45) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:59) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:75) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:128) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:139) at liquibase.snapshot.SnapshotGeneratorFactory.getDatabaseChangeLogTable(SnapshotGeneratorFactory.java:146) at liquibase.database.core.InformixDatabase.checkDatabaseChangeLogTable(InformixDatabase.java:191) at liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:602) at liquibase.Liquibase.forceReleaseLocks(Liquibase.java:640) at org.liquibase.maven.plugins.AbstractLiquibaseMojo.cleanup(AbstractLiquibaseMojo.java:475) at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:331) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59) at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156) at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196) at org.apache.maven.cli.MavenCli.main(MavenCli.java:141) 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:597) at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) Caused by: java.sql.SQLException: Database not found or no system permission. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397) at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3244) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3553) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2380) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2295) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1434) at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:205) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1228) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:243) at com.informix.jdbc.IfxDatabaseMetaData.getTables(IfxDatabaseMetaData.java:2967) at liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getTables(JdbcDatabaseSnapshot.java:173) at liquibase.snapshot.jvm.TableSnapshotGenerator.snapshotObject(TableSnapshotGenerator.java:33) ... 44 more Caused by: java.sql.SQLException: ISAM error: no record found. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3558) ... 54 more

    JIRA | 4 years ago | Björn Engel
    liquibase.exception.DatabaseException: java.sql.SQLException: Database not found or no system permission.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Informix: Error - Code set not supported

    schemaspy | 1 decade ago | rkraeutle
    java.sql.SQLException: Encoding or code set not supported.
  5. 0

    JPA Transactions on Informix

    Stack Overflow | 4 years ago | Alejandro Hdez. Angeles
    java.sql.SQLException: Transactions not supported Error Code: -79744 Query: DataModifyQuery(sql="update tg_proteccion_cv set i_eq_validados=?, i_eq_a_protegidos=? where v_id_proteccion=? and v_cve_cliente=?")

    10 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ISAM error: no record found.

      at com.informix.util.IfxErrMsg.getSQLException()
    2. com.informix.util
      IfxErrMsg.getSQLException
      1. com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397)
      1 frame
    3. com.informix.jdbc
      IfxDatabaseMetaData.getTables
      1. com.informix.jdbc.IfxSqli.E(IfxSqli.java:3558)
      2. com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2380)
      3. com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2295)
      4. com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461)
      5. com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1434)
      6. com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:205)
      7. com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1228)
      8. com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:243)
      9. com.informix.jdbc.IfxDatabaseMetaData.getTables(IfxDatabaseMetaData.java:2967)
      9 frames
    4. Liquibase Core
      Liquibase.forceReleaseLocks
      1. liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getTables(JdbcDatabaseSnapshot.java:173)
      2. liquibase.snapshot.jvm.TableSnapshotGenerator.snapshotObject(TableSnapshotGenerator.java:33)
      3. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:59)
      4. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      5. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      6. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      7. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      8. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      9. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      10. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      11. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      12. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      13. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      14. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      15. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:62)
      16. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
      17. liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:75)
      18. liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:128)
      19. liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:139)
      20. liquibase.snapshot.SnapshotGeneratorFactory.getDatabaseChangeLogTable(SnapshotGeneratorFactory.java:146)
      21. liquibase.database.core.InformixDatabase.checkDatabaseChangeLogTable(InformixDatabase.java:191)
      22. liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:602)
      23. liquibase.Liquibase.forceReleaseLocks(Liquibase.java:640)
      23 frames
    5. org.liquibase.maven
      AbstractLiquibaseMojo.execute
      1. org.liquibase.maven.plugins.AbstractLiquibaseMojo.cleanup(AbstractLiquibaseMojo.java:475)
      2. org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:331)
      2 frames
    6. Maven Plugin
      DefaultBuildPluginManager.executeMojo
      1. org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
      1 frame
    7. Maven Core
      DefaultMaven.execute
      1. org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
      2. org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
      3. org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
      4. org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
      5. org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
      6. org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
      7. org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
      8. org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
      9. org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
      9 frames
    8. M3 Interceptor
      MavenCli.main
      1. org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
      2. org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
      3. org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
      3 frames
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    10. Plexus
      Launcher.main
      1. org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
      2. org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
      3. org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
      4. org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
      4 frames