0

Do Small Talks/2006/June/ZK with Spring DAO and JDBC Error

asked 2010-10-29 01:04:18 +0800

unitcell gravatar image unitcell
28 4

Hi all,

Refer to Small Talks/2006/June/ZK with Spring DAO and JDBC

Do it happens wrong like below message,

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'pos'@'172.16.0.38' (using password: YES))
	org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:219)
	org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:283)
	org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:226)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:89)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
	$Proxy1.findAll(Unknown Source)
	com.potix.task.TaskListWnd.onCreate(TaskListWnd.java:42)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	com.potix.zk.ui.sys.EventProcessingThread.process0(EventProcessingThread.java:395)
	com.potix.zk.ui.sys.EventProcessingThread.run(EventProcessingThread.java:287)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.29 logs.

have copied commons-collections.jar, commons-dbcp.jar and commons-pool.jar to TOMCAT_HOME/common/lib

Thanx.

delete flag offensive retag edit

4 Replies

Sort by ยป oldest newest

answered 2010-10-29 03:34:33 +0800

terrytornado gravatar image terrytornado flag of Germany
9393 3 7 16
http://www.oxitec.de/

updated 2010-10-29 03:35:33 +0800

Access denied for user 'pos'@'172.16.0.38' (using password: YES))

Are you sure that the database is running / right pwd ?

link publish delete flag offensive edit

answered 2010-10-29 03:46:59 +0800

unitcell gravatar image unitcell
28 4

updated 2010-10-29 03:47:29 +0800

It works and can connect it.
like this

link publish delete flag offensive edit

answered 2010-10-29 04:03:34 +0800

terrytornado gravatar image terrytornado flag of Germany
9393 3 7 16
http://www.oxitec.de/

To less informations. Are you working with hibernate ?

$Proxy1.findAll(Unknown Source)

link publish delete flag offensive edit

answered 2010-10-29 04:09:48 +0800

doumdoum gravatar image doumdoum
90 1

The message is relevant enough :

(Access denied for user 'pos'@'172.16.0.38' (using password: YES))

Check your MYSQL configuration: login, password and allowed host

link publish delete flag offensive edit
Your reply
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow

RSS

Stats

Asked: 2010-10-29 01:04:18 +0800

Seen: 374 times

Last updated: Oct 29 '10

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More