On Nov 12, 2012, at 10:55 PM, S Ahmed 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).
Have you tried using 127.0.0.1 or the IP address of the machine? Perhaps something is not right in your /etc/hosts file and it is unable to lookup localhost. > > 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 > <snip> > > 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 Seems like the root cause is that a connection cannot be made to the server. Double check your credentials. Also, how are you testing from the terminal? Can you run "telnet localhost 3306"? Dan --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
