Dan, Thanks for your help.
>From the terminal I was very explicit, I did this: >mysql --host localhost --port 3306 --user myuser --password >password: 123 And it worked fine. In my log4net, I believe I set jdbc logs to be ALL or DEBUG (i'll check when I get home), but it didn't output the host and password (just in case it is reading from the wrong file somehow??). On Tue, Nov 13, 2012 at 8:18 AM, Daniel Mikusa <dmik...@vmware.com> wrote: > 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 > >
