liming0101

@liming0101

liming0101 暂无简介

贡献度

周一
周四
周日
三月
四月
五月
六月
七月
八月
九月
十月
十一月
十二月
一月
二月

最近一年贡献:13 次

最长连续贡献:2 日

最近连续贡献:1 日

贡献度的统计数据包括代码提交、创建任务 / Pull Request、合并 Pull Request,其中代码提交的次数需本地配置的 git 邮箱是 Gitee 帐号已确认绑定的才会被统计。

动态 (访客只能浏览公开仓库的动态)

2024年
2024-12-25

试过了,不行,完全没有剪映的那种丝滑

展开更多 收起
2024-12-22
2024年
2024-07-02
2024年
2024-04-03
2024年
2024-01-20
2023年
2023-11-21
2023年
2023-10-20
2023年
2023-09-12
2023-09-06
2023年
2023-08-25
2023-08-24
2023年
2023-06-30

这样不行的,程序每次运行都要判断数据库是否初始化了,如果表存在,把表删除,里面的数据也没有了,这不是想要的效果。

展开更多 收起
2023-06-29
2023-06-28

你好,代码是这样的

输入图片说明

这是详细错误

Hibernate: 
    select
        n1_0.id,
        n1_0.nfs_apponit,
        n1_0.create_time,
        n1_0.nfs_desc,
        n1_0.nfs_loop,
        n1_0.nfs_name,
        n1_0.nfs_path,
        n1_0.nfs_rw,
        n1_0.nfs_size,
        n1_0.nfs_sync,
        n1_0.nfs_unit 
    from
        core_nfs n1_0 offset ? rows fetch first ? rows only
2023-06-28 14:54:15 [HikariPool-1 connection adder] INFO  org.opengauss.core.v3.ConnectionFactoryImpl -[192.168.153.151:1785/192.168.161.208:26000] Connection is established. ID: d7f6b058-ec4b-43e8-babc-696424d2cc8a
2023-06-28 14:54:15 [HikariPool-1 connection adder] INFO  org.opengauss.core.v3.ConnectionFactoryImpl -Connect complete. ID: d7f6b058-ec4b-43e8-babc-696424d2cc8a
2023-06-28 14:54:15 [HikariPool-1 connection adder] INFO  org.opengauss.core.v3.ConnectionFactoryImpl -[a27add26-782b-44d1-9b50-eb5665946e0e] Try to connect. IP: 192.168.161.208:26000
2023-06-28 14:54:16 [main] WARN  org.hibernate.engine.jdbc.spi.SqlExceptionHelper -SQL Error: 0, SQLState: 42601
2023-06-28 14:54:16 [main] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper -[192.168.153.151:1779/192.168.161.208:26000] ERROR: syntax error at or near "$2"
  位置:206
Exception in thread "main" org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select n1_0.id,n1_0.nfs_apponit,n1_0.create_time,n1_0.nfs_desc,n1_0.nfs_loop,n1_0.nfs_name,n1_0.nfs_path,n1_0.nfs_rw,n1_0.nfs_size,n1_0.nfs_sync,n1_0.nfs_unit from core_nfs n1_0 offset ? rows fetch first ? rows only]; SQL [n/a]
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:257)
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:233)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:550)
	at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
	at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:152)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:163)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
	at jdk.proxy2/jdk.proxy2.$Proxy122.findAll(Unknown Source)
	at com.tpy.servicegs.NfsGsService.test(NfsGsService.java:76)
	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:343)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:699)
	at com.tpy.servicegs.NfsGsService$$SpringCGLIB$$0.test(<generated>)
	at com.tpy.WebApplication.main(WebApplication.java:36)
Caused by: org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [select n1_0.id,n1_0.nfs_apponit,n1_0.create_time,n1_0.nfs_desc,n1_0.nfs_loop,n1_0.nfs_name,n1_0.nfs_path,n1_0.nfs_rw,n1_0.nfs_size,n1_0.nfs_sync,n1_0.nfs_unit from core_nfs n1_0 offset ? rows fetch first ? rows only]
	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:89)
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
	at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:253)
	at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:146)
	at org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.advanceNext(JdbcValuesResultSetImpl.java:205)
	at org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.processNext(JdbcValuesResultSetImpl.java:85)
	at org.hibernate.sql.results.jdbc.internal.AbstractJdbcValues.next(AbstractJdbcValues.java:29)
	at org.hibernate.sql.results.internal.RowProcessingStateStandardImpl.next(RowProcessingStateStandardImpl.java:88)
	at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:197)
	at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33)
	at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:443)
	at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:166)
	at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:91)
	at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31)
	at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.lambda$new$0(ConcreteSqmSelectQueryPlan.java:113)
	at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:335)
	at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:276)
	at org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:571)
	at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:363)
	at org.hibernate.query.sqm.internal.QuerySqmImpl.list(QuerySqmImpl.java:1073)
	at org.hibernate.query.Query.getResultList(Query.java:94)
	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.readPage(SimpleJpaRepository.java:689)
	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:471)
	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:448)
	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.data.repository.core.support.RepositoryMethodInvoker$RepositoryFragmentMethodInvoker.lambda$new$0(RepositoryMethodInvoker.java:288)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:136)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:120)
	at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:516)
	at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:285)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:628)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:168)
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:143)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:77)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
	... 16 more
Caused by: org.opengauss.util.PSQLException: [192.168.153.151:1779/192.168.161.208:26000] ERROR: syntax error at or near "$2"
  位置:206
	at org.opengauss.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2901)
	at org.opengauss.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2630)
	at org.opengauss.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:362)
	at org.opengauss.jdbc.PgStatement.runQueryExecutor(PgStatement.java:561)
	at org.opengauss.jdbc.PgStatement.executeInternal(PgStatement.java:538)
	at org.opengauss.jdbc.PgStatement.execute(PgStatement.java:396)
	at org.opengauss.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:157)
	at org.opengauss.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:113)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
	at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:217)
	... 58 more
2023-06-28 14:54:16 [HikariPool-1 connection adder] INFO  org.opengauss.core.v3.ConnectionFactoryImpl -[192.168.153.151:1788/192.168.161.208:26000] Connection is established. ID: a27add26-782b-44d1-9b50-eb5665946e0e
2023-06-28 14:54:16 [HikariPool-1 connection adder] INFO  org.opengauss.core.v3.ConnectionFactoryImpl -Connect complete. ID: a27add26-782b-44d1-9b50-eb5665946e0e

配置

输入图片说明

 <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>3.0.2</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>


<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.opengauss</groupId>
            <artifactId>opengauss-jdbc</artifactId>
            <version>5.0.0</version>
        </dependency>
        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>42.5.4</version>
        </dependency>
展开更多 收起

搜索帮助