This same setup works fine locally on my laptop..so it does work :)
On Mon, Nov 12, 2012 at 10:55 PM, S Ahmed <sahmed1...@gmail.com> wrote: > I can't seem to connect to my mysql database from my java code, but I can > do it via terminal using the user and password that is in my spring context > file. > > I also tried modifying it to localhost:3306 but that didn't change > anything (it defaults to 3306). > > Both the application and mysql are on the same server (ec2). > > What can I do to figure out the issue? I'm lost! > > my xml file has: > > <bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource" > destroy-method="close"> > <property name="driverClassName" value="com.mysql.jdbc.Driver"/> > <property name="url" value="jdbc:mysql://localhost/mydb"/> > <property name="username" value="myuser"/> > <property name="password" value="123"/> > > <property name="maxActive" value="100"/> > <property name="maxIdle" value="30"/> > <property name="maxWait" value="1000"/> > <property name="defaultAutoCommit" value="true"/> > <property name="removeAbandoned" value="true"/> > <property name="removeAbandonedTimeout" value="60"/> > > <property name="testOnBorrow" value="true"/> > <property name="validationQuery" value="SELECT 1"/> > > </bean> > > This is the error I am getting: > > Exception in thread "main" > org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get > JDBC Connection; nested exception is > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications > link failure > > The last packet sent successfully to the server was 0 milliseconds ago. > The driver has not received any packets from the server. > at > org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) > at > org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382) > at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) > at > org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464) > at A.data.jdbc.PlanTypeDaoImpl.findAllActive(PlanTypeDaoImpl.java:23) > at > com.just.testing.services.PlanTypeServiceImpl.getPlanTypesMap(PlanTypeServiceImpl.java:33) > at com.just.testing.http.HttpErrorServer.main(HttpErrorServer.java:36) > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: > Communications link failure > > The last packet sent successfully to the server was 0 milliseconds ago. > The driver has not received any packets from the server. > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:532) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at > com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:350) > at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2393) > at > com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2430) > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2215) > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813) > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:532) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334) > at > org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:277) > at > org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:699) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:631) > at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:485) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143) > at > org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116) > at > org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103) > at > org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127) > at > org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) > at > org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) > ... 6 more > Caused by: java.net.ConnectException: Connection refused > at java.net.PlainSocketImpl.socketConnect(Native Method) > at > java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327) > at > java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193) > at > java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180) > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384) > at java.net.Socket.connect(Socket.java:546) > at java.net.Socket.connect(Socket.java:495) > at java.net.Socket.<init>(Socket.java:392) > at java.net.Socket.<init>(Socket.java:235) > at > com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300) > ... 29 more >
