DB2 SSH 报错

浮云若水 2014-07-11 12:19:32

由于项目开始时是用的oracle数据库开发的，现在项目要用DB2，现在在本机测试，试着把驱动包什么的换成DB2的
数据库用的是SAMPLE这个，安装DB2时创建的样本实例数据库，用户名密码也是安装时创建的 db2admin 密码admin
不知道是不是我配置有问题，还是我使用的样本数据库有问题。有用过DB2的大神求教。

配置文件



driverClassName=com.ibm.db2.jcc.DB2Driver 

url=jdbc\:db2\://127.0.0.1\:50000/SAMPLE 

username=db2admin

password=admin

hibernate.dialect=org.hibernate.dialect.DB2Dialect

hibernate.show_sql=true

hibernate.hbm2ddl.auto=update

hibernate.cache.use_second_level_cache=true

hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider

Dao实现层代码



public CmcsUser findByUser(CmcsUser cmccUser) {



		if (cmccUser != null) {

			StringBuffer hql = new StringBuffer();

			hql.append("  from CmcsUser  u where u.UserName ='")

					.append(cmccUser.getUserName()).append("'")

					.append(" and PassWord ='").append(cmccUser.getPassWord())

					.append("'");

			Query query =null;

			try {

				query = getSession().createQuery(hql.toString());//debug 这里catch到了异常，但是不知道为啥控制台不打印

			} catch (Exception e) {

				e.printStackTrace();

			}

			List ls=new ArrayList();

			try {

				ls = query.list();

			} catch (Exception e) {//到这里才打印异常信息，下面的异常信息就是这里打印的

				e.printStackTrace();

				// TODO: handle exception

			}

			if (ls.size() > 0) {

				return (CmcsUser) query.list().get(0);

			}

		}

		return null;

	}

...全文

366 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

浮云若水 2014-07-11

打赏
举报

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:897)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:919)
	at java.lang.Thread.run(Thread.java:736)
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.CMCS_USER, DRIVER=3.66.46
	at com.ibm.db2.jcc.am.dd.a(dd.java:741)
	at com.ibm.db2.jcc.am.dd.a(dd.java:60)

	at com.ibm.db2.jcc.am.dd.a(dd.java:127)
	at com.ibm.db2.jcc.am.oo.c(oo.java:2763)

	at com.ibm.db2.jcc.am.oo.d(oo.java:2751)
	at com.ibm.db2.jcc.am.oo.a(oo.java:2200)
	at com.ibm.db2.jcc.am.po.a(po.java:7379)
	at com.ibm.db2.jcc.t4.ab.h(ab.java:141)
	at com.ibm.db2.jcc.t4.ab.b(ab.java:41)

	at com.ibm.db2.jcc.t4.o.a(o.java:32)
	at com.ibm.db2.jcc.t4.tb.i(tb.java:145)
	at com.ibm.db2.jcc.am.oo.ib(oo.java:2169)

	at com.ibm.db2.jcc.am.po.tc(po.java:3547)
	at com.ibm.db2.jcc.am.po.b(po.java:4345)
	at com.ibm.db2.jcc.am.po.gc(po.java:739)

	at com.ibm.db2.jcc.am.po.executeQuery(po.java:708)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)

	at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
	at org.hibernate.loader.Loader.doQuery(Loader.java:697)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
	at org.hibernate.loader.Loader.doList(Loader.java:2232)
	... 93 more

浮云若水 2014-07-11

打赏
举报

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at java.lang.reflect.Method.invoke(Method.java:611)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)

	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:142)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:166)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at com.cmcc.commons.LoginInterceptor.intercept(LoginInterceptor.java:23)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:485)
	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)

浮云若水 2014-07-11

打赏
举报


Hibernate: select cmcsuser0_.PID as PID2_, cmcsuser0_.PASSWORD as PASSWORD2_, cmcsuser0_.USER_NAME as USER3_2_, cmcsuser0_.NEW_TIME as NEW4_2_, cmcsuser0_.TEL as TEL2_, cmcsuser0_.Update_TIME as Update6_2_ from CMCS_USER cmcsuser0_ where cmcsuser0_.USER_NAME='admin' and cmcsuser0_.PASSWORD='1234'
[ERROR] 2014-07-11 12:09:06,812(2263359) --> [http-apr-8080-exec-3] org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:101): DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.CMCS_USER, DRIVER=3.66.46  
[ERROR] 2014-07-11 12:09:06,812(2263359) --> [http-apr-8080-exec-3] org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:101): DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.CMCS_USER, DRIVER=3.66.46  
[ERROR] 2014-07-11 12:09:06,812(2263359) --> [http-apr-8080-exec-3] org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:101): DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;DB2ADMIN.CMCS_USER, DRIVER=3.66.46  
org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2235)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
	at org.hibernate.loader.Loader.list(Loader.java:2124)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at com.cmcc.dao.impl.UserDaoImpl.findByUser(UserDaoImpl.java:136)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at java.lang.reflect.Method.invoke(Method.java:611)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy29.findByUser(Unknown Source)

	at com.cmcc.service.Impl.UserServiceImpl.login(UserServiceImpl.java:41)
	at com.cmcc.action.LoginAction.login(LoginAction.java:44)

浮云若水 2014-07-11

打赏
举报

引用 4 楼 zaxer 的回复:

<property name="hibernate.default_schema"> 这个配了吗

schema 难道不就是 db2admin 吗？


@Entity
@Table(name="CMCS_USER",schema="db2admin")

EggItayi 2014-07-11

打赏
举报

<property name="hibernate.default_schema"> 这个配了吗

在编译DB2的时候报错的代码翻译，在ssh中控制台报错你可以很快的查找出错误代码对应的意思。

JDiy是一个超轻量级的java极速开发框架，内置一个建站平台(不用写代码，生成后台管理界面)，有了JDiy，您无需再折腾其它庞大的框架(如SSH) JDiy同时支持javaEE/WEB和javaSE开发环境 JDiy利用本地化Locale,中文显示...

【课程全部章节可以免费学习啦！】本课程为SQL入门教程，面向SQL...本课程基于最新SQL标准，全面讲解六种主流数据库的SQL语句实现与差异，包括：Oracle、MySQL、SQL Server、PostgreSQL、Db2 以及 SQLite 。

一直对mysql情有独钟,最近搞开发,数据库就采用db2.. 这里我深有感觉..我用的是db2 版本是8.X.. 最开始以为很简单..结果搞了一晚上才出来... 我是用hibernate连接数据库...安装完db2之后不用网上找java驱动包,在...

在使用ssh-copy-id的时候最有可能碰到的一个问题就是ssh报错： /usr/bin/ssh-copy-id: ERROR: No identities found 下面将我配置的给大家贴上然后再说这个报错 1、 [postgres@db1 ~]$ ssh-keyg

Web 开发

81,092

社区成员

341,716

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章