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

PostgreSQL Invalid custom schema #1343

Open
beyond007jj opened this issue Jul 24, 2024 · 0 comments
Open

PostgreSQL Invalid custom schema #1343

beyond007jj opened this issue Jul 24, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@beyond007jj
Copy link

beyond007jj commented Jul 24, 2024

Describe the problem
PostgreSQL version: PostgreSQL 15.7
The default currentSchema seems to be 'public', but the custom currentSchema is invalid
An error occurred while running the following code ‘myschema’
`
spring:

  application:
	name: readyset-demo
  datasource:
	driverClassName: org.postgresql.Driver
	url: jdbc:postgresql://sql-proxy:5433/mydb?currentSchema=myschema&stringtype=unspecified
	username: pguser
	password: xxxxxx
	hikari:
#      connection-init-sql: SET search_path TO myschema

`

mybatis insert table 'student', error message:
`
org.springframework.jdbc.BadSqlGrammarException:

Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: relation "student" does not exist

The error may exist in com/xxx/xxx/readyset/demo/dao/StudentDao.java (best guess)

The error may involve com.xxx.xxx.readyset.demo.dao.StudentDao.insert-Inline

The error occurred while setting parameters

SQL: INSERT INTO student ( id, name, age ) VALUES ( ?, ?, ? )

Cause: org.postgresql.util.PSQLException: ERROR: relation "student" does not exist

; bad SQL grammar []

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:246)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:107)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
at jdk.proxy2/jdk.proxy2.$Proxy65.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at jdk.proxy2/jdk.proxy2.$Proxy68.insert(Unknown Source)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
at jdk.proxy2/jdk.proxy2.$Proxy69.insert(Unknown Source)
at com.baomidou.mybatisplus.extension.service.IService.save(IService.java:61)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:716)
at com.xxx.xxx.readyset.demo.service.impl.StudentServiceImpl$$SpringCGLIB$$0.save(<generated>)
at com.xxx.xxx.readyset.demo.StudentServiceTest.insertTest(StudentServiceTest.java:37)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)

`

but,If the comment 'connection-init-sql' is opened, it can be queried normally.

@beyond007jj beyond007jj added the bug Something isn't working label Jul 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant