i have set properties for my connection pool to:
URL jdbc:mysql://localhost:3306/p2p
user root
password mypass
so i can ping db from GUI with success. But when i had restarted my server i got this exception:
[#|2009-02-07T10:43:05.906+0100|WARNING|sun-appserver9.1|javax.enterprise.system.stream.err|_ThreadID=17;_ThreadName=pool-1-thread-11;_RequestID=7096fd74-b1bc-4dfb-ac30-059028066559;|java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2822)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:777)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3216)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1147)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2595)
at com.mysql.jdbc.Connection.<init>(Connection.java:1509)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at pl.karolik.michal.db.KomunikacjaDB.<init>(KomunikacjaDB.java:37)
at pl.karolik.michal.db.KomunikacjaDB.getBaza(KomunikacjaDB.java:53)
at pl.karolik.michal.serwer.WlaczSerwerServlet.<init>(WlaczSerwerServlet.java:19)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:355)
at java.lang.Class.newInstance(Class.java:308)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1132)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1007)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4808)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:5196)
at com.sun.enterprise.web.WebModule.start(WebModule.java:326)
at com.sun.enterprise.web.LifecycleStarter.doRun(LifecycleStarter.java:58)
at com.sun.appserv.management.util.misc.RunnableBase.runSync(RunnableBase.java:304)
at com.sun.appserv.management.util.misc.RunnableBase.run(RunnableBase.java:341)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
|#]
dunno why because password is good for sure.
[Message sent by forum member 'freeq1986' (freeq1986)]
http://forums.java.net/jive/thread.jspa?messageID=330651