GBase 8s
安装配置
问答

hibernate连接数据库报错

发表于2025-02-10 18:31:3979次浏览5个评论

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

【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

 

 

评论

登录后才可以发表评论
用户头像
wty发表于 1年前
at com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1328) ~[druid-1.1.6.jar:1.1.6]
druid连接池验证连接用SQL语法错误,找到配置,改成SELECT 1 FROM DUAL
最佳回答
GBase用户26255发表于 1年前
@wty:感谢,已解决
用户头像
levvel发表于 7个月前
我看好你哟!
曾云林发表于 2个月前
好问题啊。
ljt98发表于 2个月前
等待有缘人解答。