hibernate not support decode

本文介绍了一种在不使用decode函数的情况下实现特定功能的方法,通过使用to_char函数,为日期操作提供了一种新的解决方案。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

这样的功能不用decode函数也能解决。可以使用to_char。

 

registerFunction("dateadd", new StandardSQLFunction("dateadd", Hibernate.TIMESTAMP));

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invok (NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.i voke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:34 ) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473 Caused by: org.apache.catalina.LifecycleException: 鏃犳硶鍚姩缁勪欢[St ndardEngine[Catalina].StandardHost[localhost].StandardContext[/KuCun2]] at org.apache.catalina.util.LifecycleBase.handleSubClassExceptio (LifecycleBase.java:440) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.ja a:198) at org.apache.catalina.core.ContainerBase.addChildInternal(Conta nerBase.java:717) ... 37 more Caused by: org.springframework.beans.factory.BeanCreationException: Erro creating bean with name 'entityManagerFactory' defined in class path resource org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class] Invocation of init method failed; nested exception is javax.persistence.Persis enceException: [PersistenceUnit: default] Unable to build Hibernate SessionFact ry; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to open JDBC Connection for DDL execution at org.springframework.beans.factory.support.AbstractAutowireCap bleBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1799) at org.springframework.beans.factory.support.AbstractAutowireCap bleBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) at org.springframework.beans.factory.support.AbstractAutowireCap bleBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) at org.springframework.beans.factory.support.AbstractBeanFactory lambda$doGetBean$0(AbstractBeanFactory.java:324) at org.springframework.beans.factory.support.DefaultSingletonBea Registry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory doGetBean(AbstractBeanFactory.java:322) at org.springframework.beans.factory.support.AbstractBeanFactory getBean(AbstractBeanFactory.java:202) at org.springframework.context.support.AbstractApplicationContex .getBean(AbstractApplicationContext.java:1109) at org.springframework.context.support.AbstractApplicationContex .finishBeanFactoryInitialization(AbstractApplicationContext.java:869) at org.springframework.context.support.AbstractApplicationContex .refresh(AbstractApplicationContext.java:551) at org.springframework.boot.web.servlet.context.ServletWebServer pplicationContext.refresh(ServletWebServerApplicationContext.java:143) at org.springframework.boot.SpringApplication.refresh(SpringAppl cation.java:755) at org.springframework.boot.SpringApplication.refresh(SpringAppl cation.java:747) at org.springframework.boot.SpringApplication.refreshContext(Spr ngApplication.java:402) at org.springframework.boot.SpringApplication.run(SpringApplicat on.java:312) at org.springframework.boot.web.servlet.support.SpringBootServle Initializer.run(SpringBootServletInitializer.java:173) at org.springframework.boot.web.servlet.support.SpringBootServle Initializer.createRootApplicationContext(SpringBootServletInitializer.java:153) at org.springframework.boot.web.servlet.support.SpringBootServle Initializer.onStartup(SpringBootServletInitializer.java:95) at org.springframework.web.SpringServletContainerInitializer.onS artup(SpringServletContainerInitializer.java:172) at org.apache.catalina.core.StandardContext.startInternal(Standa dContext.java:5128) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.ja a:183) ... 38 more Caused by: javax.persistence.PersistenceException: [PersistenceUnit: def ult] Unable to build Hibernate SessionFactory; nested exception is org.hibernat .exception.JDBCConnectionException: Unable to open JDBC Connection for DDL exec tion at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean. uildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:403) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean. fterPropertiesSet(AbstractEntityManagerFactoryBean.java:378) at org.springframework.orm.jpa.LocalContainerEntityManagerFactor Bean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) at org.springframework.beans.factory.support.AbstractAutowireCap bleBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1858) at org.springframework.beans.factory.support.AbstractAutowireCap bleBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1795) ... 58 more Caused by: org.hibernate.exception.JDBCConnectionException: Unable to op n JDBC Connection for DDL execution at org.hibernate.exception.internal.SQLStateConversionDelegate.c nvert(SQLStateConversionDelegate.java:112) at org.hibernate.exception.internal.StandardSQLExceptionConverte .convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlE ceptionHelper.java:113) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlE ceptionHelper.java:99) at org.hibernate.resource.transaction.backend.jdbc.internal.DdlT ansactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaI pl.java:69) at org.hibernate.tool.schema.internal.exec.ImprovedExtractionCon extImpl.getJdbcConnection(ImprovedExtractionContextImpl.java:60) at org.hibernate.tool.schema.internal.exec.ImprovedExtractionCon extImpl.getJdbcDatabaseMetaData(ImprovedExtractionContextImpl.java:67) at org.hibernate.tool.schema.extract.internal.InformationExtract rJdbcDatabaseMetaDataImpl.getTables(InformationExtractorJdbcDatabaseMetaDataImp .java:333) at org.hibernate.tool.schema.extract.internal.DatabaseInformatio Impl.getTablesInformation(DatabaseInformationImpl.java:120) at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl. erformTablesMigration(GroupedSchemaMigratorImpl.java:65) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.per ormMigration(AbstractSchemaMigrator.java:207) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doM gration(AbstractSchemaMigrator.java:114) at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator performDatabaseAction(SchemaManagementToolCoordinator.java:184) at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator process(SchemaManagementToolCoordinator.java:73) at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFacto yImpl.java:318) at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(S ssionFactoryBuilderImpl.java:468) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderIm l.build(EntityManagerFactoryBuilderImpl.java:1259) at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersiste ceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistencePro ider.java:58) at org.springframework.orm.jpa.LocalContainerEntityManagerFactor Bean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.ja a:365) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean. uildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) ... 62 more Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communi ations link failure he last packet sent successfully to the server was 0 milliseconds ago. The driv r has not received any packets from the server. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsExc ption(SQLError.java:175) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateEx eption(SQLExceptionsMapping.java:64) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.j va:825) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:4 6) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.j va:239) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegistering river.java:188) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverD taSource.java:138) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:3 8) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:20 ) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool. ava:477) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.ja a:560) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSo rce.java:112) at org.hibernate.engine.jdbc.connections.internal.DatasourceConn ctionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiat r$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitia or.java:180) at org.hibernate.resource.transaction.backend.jdbc.internal.DdlT ansactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaI pl.java:43) ... 77 more Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communicat ons link failure he last packet sent successfully to the server was 0 milliseconds ago. The driv r has not received any packets from the server. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl. ewInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl. ewInstance(NativeConstructorAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorI pl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Construct r.java:490) at com.mysql.cj.exceptions.ExceptionFactory.createException(Exce tionFactory.java:62) at com.mysql.cj.exceptions.ExceptionFactory.createException(Exce tionFactory.java:105) at com.mysql.cj.exceptions.ExceptionFactory.createException(Exce tionFactory.java:150) at com.mysql.cj.exceptions.ExceptionFactory.createCommunications xception(ExceptionFactory.java:166) at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection NativeProtocol.java:379) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect( ativeAuthenticationProvider.java:206) at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol java:1430) at com.mysql.cj.NativeSession.connect(NativeSession.java:134) at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(Connection mpl.java:945) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.j va:815) ... 90 more Caused by: javax.net.ssl.SSLHandshakeException: NotBefore: Fri Jun 27 18 58:12 CST 2025 at java.base/sun.security.ssl.Alert.createSSLException(Alert.jav :128) at java.base/sun.security.ssl.TransportContext.fatal(TransportCo text.java:321) at java.base/sun.security.ssl.TransportContext.fatal(TransportCo text.java:264) at java.base/sun.security.ssl.TransportContext.fatal(TransportCo text.java:259) at java.base/sun.security.ssl.CertificateMessage$T13CertificateC nsumer.checkServerCerts(CertificateMessage.java:1329) at java.base/sun.security.ssl.CertificateMessage$T13CertificateC nsumer.onConsumeCertificate(CertificateMessage.java:1204) at java.base/sun.security.ssl.CertificateMessage$T13CertificateC nsumer.consume(CertificateMessage.java:1151) at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake. ava:392) at java.base/sun.security.ssl.HandshakeContext.dispatch(Handshak Context.java:444) at java.base/sun.security.ssl.HandshakeContext.dispatch(Handshak Context.java:421) at java.base/sun.security.ssl.TransportContext.dispatch(Transpor Context.java:178) at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.j va:164) at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl java:1152) at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord( SLSocketImpl.java:1063) at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSo ketImpl.java:402) at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(Ex ortControlled.java:347) at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandsha e(StandardSocketFactory.java:191) at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHand hake(NativeSocketConnection.java:101) at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection NativeProtocol.java:370) ... 95 more Caused by: java.security.cert.CertificateNotYetValidException: NotBefore Fri Jun 27 18:58:12 CST 2025 at java.base/sun.security.x509.CertificateValidity.valid(Certifi ateValidity.java:270) at java.base/sun.security.x509.X509CertImpl.checkValidity(X509Ce tImpl.java:687) at java.base/sun.security.x509.X509CertImpl.checkValidity(X509Ce tImpl.java:660) at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrappe .checkServerTrusted(ExportControlled.java:392) at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkS rverTrusted(SSLContextImpl.java:1509) at java.base/sun.security.ssl.CertificateMessage$T13CertificateC nsumer.checkServerCerts(CertificateMessage.java:1313) ... 109 more 3-Jun-2012 02:43:37.673 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyWAR web搴旂敤绋嬪簭瀛樻。鏂囦欢[D:\apache-tomcat-9.0.37\webapps\KuCun2.war] 鐨勯儴缃插凡鍦╗34,866]ms鍐呭畬鎴? 3-Jun-2012 02:43:37.673 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyDirectory 鎶妛eb 搴旂敤绋嬪簭閮ㄧ讲鍒扮洰褰?[D:\apache-tomcat-9.0.37\webapps docs] 3-Jun-2012 02:43:37.829 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyDirectory Web搴旂敤绋嬪簭鐩綍[D:\apache-tomcat-9.0.37\webapps\docs]鐨勯儴 缃插凡鍦╗156]姣鍐呭畬鎴? 3-Jun-2012 02:43:37.829 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyDirectory 鎶妛eb 搴旂敤绋嬪簭閮ㄧ讲鍒扮洰褰?[D:\apache-tomcat-9.0.37\webapps examples] 3-Jun-2012 02:43:39.826 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyDirectory Web搴旂敤绋嬪簭鐩綍[D:\apache-tomcat-9.0.37\webapps\examples]鐨 勯儴缃插凡鍦╗1,997]姣鍐呭畬鎴? 3-Jun-2012 02:43:39.842 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyDirectory 鎶妛eb 搴旂敤绋嬪簭閮ㄧ讲鍒扮洰褰?[D:\apache-tomcat-9.0.37\webapps host-manager] 3-Jun-2012 02:43:39.982 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyDirectory Web搴旂敤绋嬪簭鐩綍[D:\apache-tomcat-9.0.37\webapps\host-manager 鐨勯儴缃插凡鍦╗140]姣鍐呭畬鎴? 3-Jun-2012 02:43:39.982 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyDirectory 鎶妛eb 搴旂敤绋嬪簭閮ㄧ讲鍒扮洰褰?[D:\apache-tomcat-9.0.37\webapps manager] 3-Jun-2012 02:43:40.091 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyDirectory Web搴旂敤绋嬪簭鐩綍[D:\apache-tomcat-9.0.37\webapps\manager]鐨勯 儴缃插凡鍦╗109]姣鍐呭畬鎴? 3-Jun-2012 02:43:40.091 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyDirectory 鎶妛eb 搴旂敤绋嬪簭閮ㄧ讲鍒扮洰褰?[D:\apache-tomcat-9.0.37\webapps ROOT] 3-Jun-2012 02:43:40.138 淇℃伅 [main] org.apache.catalina.startup.HostConfig.de loyDirectory Web搴旂敤绋嬪簭鐩綍[D:\apache-tomcat-9.0.37\webapps\ROOT]鐨勯儴 缃插凡鍦╗47]姣鍐呭畬鎴? 3-Jun-2012 02:43:40.154 淇℃伅 [main] org.apache.coyote.AbstractProtocol.start 寮€濮嬪崗璁鐞嗗彞鏌刐"http-nio-8080"] 3-Jun-2012 02:43:40.200 淇℃伅 [main] org.apache.coyote.AbstractProtocol.start 寮€濮嬪崗璁鐞嗗彞鏌刐"https-jsse-nio-8443"] 3-Jun-2012 02:43:40.216 淇℃伅 [main] org.apache.catalina.startup.Catalina.star [37875]姣鍚庢湇鍔″櫒鍚姩
最新发布
07-18
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值