为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:Linux version 4.19.90-24.4.v2101.ky10.aarch64
【CPU】:ARMv8 CPU
【问题描述】*:
问题一:使用java非springboot hibernate 连接数据库的控制台提示信息是乱码,
DmDialect-for-hibernate4.0.jar
DmJdbcDriver18.jar
Druid-1.0.15.jar
问题二:通过hql链接查询时出现错误提示
------------------问题一:乱码错误提示-----------------------
dm.jdbc.driver.DMException: 缃戠粶閫氫俊寮傚父
at dm.jdbc.driver.DBError.throwException(DBError.java:774)
at dm.jdbc.a.a.init(DBAccess.java:185)
at dm.jdbc.a.a.<init>(DBAccess.java:157)
------------------问题二:hibernate的hql错误信息--------------------------------
2023-06-01 11:30:07,921 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - SQL Error: -2106, SQLState: 22000
2023-06-01 11:30:07,923 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - 绗�1 琛岄檮杩戝嚭鐜伴敊璇�:
鏃犳晥鐨勮〃鎴栬鍥惧悕[SYS_MODULE]
org.hibernate.exception.DataException: could not prepare statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:196)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:160)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1884)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1861)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
at org.hibernate.loader.Loader.doQuery(Loader.java:909)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
at org.hibernate.loader.Loader.doList(Loader.java:2551)
at org.hibernate.loader.Loader.doList(Loader.java:2537)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2367)
at org.hibernate.loader.Loader.list(Loader.java:2362)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:229)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1260)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
select id_code;
--03134283968-20230110-179227-20033 Pack1
您好,这个乱码应该和操作系统字符集关系比较大。第二个而报错,应该是缺少SYS_MODULE这张表。