hibernate连接数据库报错
为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【GBase版本】:8s
【操作系统】:win10
【CPU】:Intel(R) Core(TM) i7-5500U CPU @ 2.40GHz 2.39 GHz
【问题描述】*:
使用java语言 项目启动时hibernate连接数据库报错
JDBC版本:
gbasedbtjdbc_3.5.1_3X2_1.jar
hibernate-4.3.11_GBase8s-2.0.1a2_2_v0.9.4.jar
hibernate版本:
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-entitymanager</artifactId>
<version>4.3.11.Final</version>
</dependency>
报错信息:(其中ip配置好了,用dbvisualizer可以连接上可以正常使用)
2025-02-10 18:23:38 - init datasource error, url: jdbc:gbasedbt-sqli://<ip>:9088/gbasedb:GBASEDBTSERVER=gbaseserver;DB_LOCALE=zh_CN.utf8;CLIENT_LOCALE=zh_CN.utf8;NEWCODESET=UTF8,utf8,57372;GL_USEGLU=1;
java.sql.SQLException: 发生语法错误。
at com.gbasedbt.util.IfxErrMsg.getSQLException(IfxErrMsg.java:409) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.gbasedbt.jdbc.IfxSqli.a(IfxSqli.java:3577) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.gbasedbt.jdbc.IfxSqli.D(IfxSqli.java:3857) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.gbasedbt.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2747) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.gbasedbt.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2672) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.gbasedbt.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1616) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.gbasedbt.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1543) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.gbasedbt.jdbc.IfxResultSet.a(IfxResultSet.java:217) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.gbasedbt.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1253) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.gbasedbt.jdbc.IfxStatement.executeQuery(IfxStatement.java:330) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.alibaba.druid.filter.FilterChainImpl.statement_executeQuery(FilterChainImpl.java:2473) ~[druid-1.1.6.jar:1.1.6]
at com.alibaba.druid.filter.FilterAdapter.statement_executeQuery(FilterAdapter.java:2503) ~[druid-1.1.6.jar:1.1.6]
at com.alibaba.druid.filter.FilterEventAdapter.statement_executeQuery(FilterEventAdapter.java:302) ~[druid-1.1.6.jar:1.1.6]
at com.alibaba.druid.filter.FilterChainImpl.statement_executeQuery(FilterChainImpl.java:2470) ~[druid-1.1.6.jar:1.1.6]
at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeQuery(StatementProxyImpl.java:221) ~[druid-1.1.6.jar:1.1.6]
at com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1328) ~[druid-1.1.6.jar:1.1.6]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1585) ~[druid-1.1.6.jar:1.1.6]
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:854) [druid-1.1.6.jar:1.1.6]
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1221) [druid-1.1.6.jar:1.1.6]
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1217) [druid-1.1.6.jar:1.1.6]
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:90) [druid-1.1.6.jar:1.1.6]
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcServicesImpl.java:279) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:124) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425) [hibernate-core-4.3.11.Final.jar:4.3.11.Final]
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849) [hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]
at magicsoft.base.database.hibernate.HibernateEntityManagerFactoryBuilderImpl.build(HibernateEntityManagerFactoryBuilderImpl.java:25) [bm-base-1.0-SNAPSHOT.jar:na]
at magicsoft.base.database.DatabaseUtils.getEntityManagerFactory(DatabaseUtils.java:118) [bm-base-1.0-SNAPSHOT.jar:na]
at magicsoft.base.database.DatabaseUtils.createEntityManager(DatabaseUtils.java:82) [bm-base-1.0-SNAPSHOT.jar:na]
at magicsoft.base.database.DatabaseAutoInitializer.synchronizeByScript(DatabaseAutoInitializer.java:120) [bm-base-1.0-SNAPSHOT.jar:na]
at magicsoft.base.database.DatabaseAutoInitializer.synchronize(DatabaseAutoInitializer.java:49) [bm-base-1.0-SNAPSHOT.jar:na]
at magicsoft.base.Activator.activate(Activator.java:42) [bm-base-1.0-SNAPSHOT.jar:na]
at magicsoft.jersey.MyServletContextListener.contextInitialized(MyServletContextListener.java:49) [bm-jersey-1.0-SNAPSHOT.jar:na]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4685) [catalina.jar:9.0.27]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5146) [catalina.jar:9.0.27]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.27]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384) [catalina.jar:9.0.27]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374) [catalina.jar:9.0.27]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_201]
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.27]
at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) [na:1.8.0_201]
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909) [catalina.jar:9.0.27]
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841) [catalina.jar:9.0.27]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.27]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384) [catalina.jar:9.0.27]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374) [catalina.jar:9.0.27]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_201]
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.27]
at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) [na:1.8.0_201]
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909) [catalina.jar:9.0.27]
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262) [catalina.jar:9.0.27]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.27]
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421) [catalina.jar:9.0.27]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.27]
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930) [catalina.jar:9.0.27]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.27]
at org.apache.catalina.startup.Catalina.start(Catalina.java:633) [catalina.jar:9.0.27]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_201]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_201]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_201]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_201]
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:344) [bootstrap.jar:9.0.27]
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:475) [bootstrap.jar:9.0.27]
Caused by: java.sql.SQLException: null
at com.gbasedbt.util.IfxErrMsg.getSQLException(IfxErrMsg.java:409) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
at com.gbasedbt.jdbc.IfxSqli.D(IfxSqli.java:3862) ~[gbasedbtjdbc-3.5.1_3X2_1.jar:3.5.1_3X2_1_6a17fd]
... 67 common frames omitted
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25052
- 42023-09-25浏览数:18521
- 52020-05-11浏览数:17526
druid连接池验证连接用SQL语法错误,找到配置,改成SELECT 1 FROM DUAL