Try setting up a mysql user with a password that is exactley 8 characters long.
And use that account to access the db. I had the same error and that solved it.
Seems to be a bug in the mysql jdbc.
fanyun wrote:
> Hi,
> I have the following code.
>
> public class Test extends VelocityScreen
> {
> public void doBuildTemplate( RunData data, Context context )
> throws Exception
> {
>
> Criteria criteria = new Criteria();
> Vector custom = TestPeer.doSelect(criteria);
> context.put("custom", custom);
>
> // the context object has already been setup for you!
> context.put ("hello", new String("Welcome To vTradEx"));
>
> }
> }
>
> When I call Test.vm, I get the following error message. Any comment?
>
> ------------------------------------------------------------------------
> Get/Post Data:
> template = Error
>
> The exception is:
> java.sql.SQLException: Communication link failure: Bad handshake
> at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:278)
> at org.gjt.mm.mysql.Connection.(Connection.java:230)
> at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
> at java.sql.DriverManager.getConnection(DriverManager.java:517)
> at java.sql.DriverManager.getConnection(DriverManager.java:177)
> at org.apache.turbine.util.db.adapter.DB.getConnection(DB.java:154)
> at
>org.apache.turbine.util.db.pool.ConnectionPool.getNewConnection(ConnectionPool.java:348)
> at
>org.apache.turbine.util.db.pool.ConnectionPool.getConnection(ConnectionPool.java:273)
> at
>org.apache.turbine.services.db.PoolBrokerService.getConnection(PoolBrokerService.java:285)
> at org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1126)
> at org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:1078)
> at org.apache.turbine.om.peer.BasePeer.doSelect(BasePeer.java:1012)
> at com.vtradex.om.peer.TestTablePeer.doSelect(TestTablePeer.java:86)
> at com.vtradex.om.peer.TestTablePeer.doSelect(TestTablePeer.java:74)
> at com.vtradex.screens.Test.doBuildTemplate(Test.java:30)
> at
>org.apache.turbine.modules.screens.VelocityScreen.doBuildTemplate(VelocityScreen.java:118)
> at
>org.apache.turbine.modules.screens.TemplateScreen.doBuild(TemplateScreen.java:123)
> at org.apache.turbine.modules.Screen.build(Screen.java:100)
> at org.apache.turbine.modules.ScreenLoader.eval(ScreenLoader.java:125)
> at
>org.apache.turbine.modules.layouts.VelocityECSLayout.doBuild(VelocityECSLayout.java:106)
> at org.apache.turbine.modules.Layout.build(Layout.java:93)
> at org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:122)
> at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:170)
> at org.apache.turbine.modules.Page.build(Page.java:92)
> at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:122)
> at org.apache.turbine.Turbine.doGet(Turbine.java:366)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:387)
> at org.apache.tomcat.core.Handler.service(Handler.java:263)
> at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:371)
> at
>org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:786)
> at org.apache.tomcat.core.ContextManager.service(ContextManager.java:732)
> at
>org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
> at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:407)
> at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
> at java.lang.Thread.run(Thread.java:484)
>
> java.sql.SQLException: Communication link failure: Bad handshake
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
--
[EMAIL PROTECTED]
Grabel's Law:
2 is not equal to 3 -- not even for large values of 2.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
