Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Embedded mode on Windows 7 doesn't work [JDBC504] #540

Closed
firebird-automations opened this issue Jul 18, 2017 · 4 comments
Closed

Embedded mode on Windows 7 doesn't work [JDBC504] #540

firebird-automations opened this issue Jul 18, 2017 · 4 comments

Comments

@firebird-automations
Copy link

Submitted by: Beto Neto (betoneto.tbo)

I'm trying to use the Firebird 32 bits embedded on a Windows 7 x64. On Windows 10 PRO x64 it works, but the same distribution of my application doesn't run on Windows 7 Professional.

JDBC URL: jdbc:firebirdsql:embedded:c:/app/db/db.fdb?encoding=ISO8859_1

This is the stack:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from DATABASECHANGELOGLOCK: GDS Exception. 335544352. no permission for read/select access to TABLE DATABASECHANGELOGLOCK
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1583) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:296) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1081) ~[spring-context-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:856) ~[spring-context-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) ~[spring-context-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) ~[spring-boot-1.4.2.RELEASE.jar!/:1.4.2.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:761) ~[spring-boot-1.4.2.RELEASE.jar!/:1.4.2.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:371) ~[spring-boot-1.4.2.RELEASE.jar!/:1.4.2.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-1.4.2.RELEASE.jar!/:1.4.2.RELEASE]
at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:134) [spring-boot-1.4.2.RELEASE.jar!/:1.4.2.RELEASE]
at br.com.jjw.besser.pdv.BesserPdvApplication.initContext(BesserPdvApplication.java:291) [classes!/:1.0.0.0]
at br.com.jjw.besser.pdv.BesserPdvApplication$1.call(BesserPdvApplication.java:121) [classes!/:1.0.0.0]
at br.com.jjw.besser.pdv.BesserPdvApplication$1.call(BesserPdvApplication.java:1) [classes!/:1.0.0.0]
at javafx.concurrent.Task$TaskCallable.call(Task.java:1423) [jfxrt.jar:na]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_131]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_131]
Caused by: liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from DATABASECHANGELOGLOCK: GDS Exception. 335544352. no permission for read/select access to TABLE DATABASECHANGELOGLOCK
at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:242) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:170) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.Liquibase.update(Liquibase.java:196) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.Liquibase.update(Liquibase.java:192) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:431) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:388) ~[liquibase-core-3.5.3.jar!/:na]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1642) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1579) ~[spring-beans-4.3.4.RELEASE.jar!/:4.3.4.RELEASE]
... 22 common frames omitted
Caused by: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from DATABASECHANGELOGLOCK: GDS Exception. 335544352. no permission for read/select access to TABLE DATABASECHANGELOGLOCK
at liquibase.lockservice.StandardLockService.isDatabaseChangeLogLockTableInitialized(StandardLockService.java:137) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.lockservice.StandardLockService.init(StandardLockService.java:110) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:206) ~[liquibase-core-3.5.3.jar!/:na]
... 29 common frames omitted
Caused by: liquibase.exception.DatabaseException: Error executing SQL select count(*) from DATABASECHANGELOGLOCK: GDS Exception. 335544352. no permission for read/select access to TABLE DATABASECHANGELOGLOCK
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:68) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:126) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:134) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:142) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:157) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.queryForInt(JdbcExecutor.java:178) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.queryForInt(JdbcExecutor.java:173) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.lockservice.StandardLockService.isDatabaseChangeLogLockTableInitialized(StandardLockService.java:134) ~[liquibase-core-3.5.3.jar!/:na]
... 31 common frames omitted
Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544352. no permission for read/select access to TABLE DATABASECHANGELOGLOCK
at org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:216) ~[jaybird-jdk18-2.2.13.jar!/:2.2.13-JDK_1.8 (build: tag=v2.2.13 date=201704101408)]
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327) ~[c3p0-0.9.5.2.jar!/:0.9.5.2]
at liquibase.executor.jvm.JdbcExecutor$QueryStatementCallback.doInStatement(JdbcExecutor.java:345) ~[liquibase-core-3.5.3.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[liquibase-core-3.5.3.jar!/:na]
... 38 common frames omitted
Caused by: org.firebirdsql.gds.GDSException: no permission for read/select access to TABLE DATABASECHANGELOGLOCK
at org.firebirdsql.gds.impl.jni.JniGDSImpl.native_isc_dsql_prepare(Native Method) ~[jaybird-jdk18-2.2.13.jar!/:2.2.13-JDK_1.8 (build: tag=v2.2.13 date=201704101408)]
at org.firebirdsql.gds.impl.jni.BaseGDSImpl.iscDsqlPrepare(BaseGDSImpl.java:574) ~[jaybird-jdk18-2.2.13.jar!/:2.2.13-JDK_1.8 (build: tag=v2.2.13 date=201704101408)]
at org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:216) ~[jaybird-jdk18-2.2.13.jar!/:2.2.13-JDK_1.8 (build: tag=v2.2.13 date=201704101408)]
at org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1393) ~[jaybird-jdk18-2.2.13.jar!/:2.2.13-JDK_1.8 (build: tag=v2.2.13 date=201704101408)]
at org.firebirdsql.jdbc.AbstractStatement.internalExecute(AbstractStatement.java:1375) ~[jaybird-jdk18-2.2.13.jar!/:2.2.13-JDK_1.8 (build: tag=v2.2.13 date=201704101408)]
at org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:208) ~[jaybird-jdk18-2.2.13.jar!/:2.2.13-JDK_1.8 (build: tag=v2.2.13 date=201704101408)]
... 41 common frames omitted

@firebird-automations
Copy link
Author

Commented by: Beto Neto (betoneto.tbo)

Same problem using x64 binaries.

@firebird-automations
Copy link
Author

Commented by: Beto Neto (betoneto.tbo)

Solved by this JDBC503?focusedCommentId=32853&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#⁠action_32853

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

status: Open [ 1 ] => Closed [ 6 ]

resolution: Cannot Reproduce [ 5 ]

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

It would have been more appropriate to post questions about these types of problems on the Firebird-java mailinglist.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants