Spring + conexao + jtds

1 resposta
I

Olá Pessoal!

Já fiz varias tentaivas de conexao ao banco e não estou conseguindo. Segue abaixo o código e a mensagem de erro.

beans.xml
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
      <property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" />
      <property name="url" value="jdbc:jtds:sqlserver://192.168.0.135:1433/BancoTres" />      
      <property name="username" value="sa" />
      <property name="password" value="BancoTres01" />
</bean>
public static void main(String[] args) {
    ApplicationContext context = new ClassPathXmlApplicationContext("beans.xml");		
	StudentDAO studentDAO = (StudentDAO) context.getBean("studentDAO");
	Student springForum = new Student(1,"izabel", 37);
	studentDAO.insertForum(springForum);	
	System.out.println(">>>>> insert com sucesso");
}
public class JDBCStudentDAOImpl implements StudentDAO {

private DataSource dataSource;
	
	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
	}

	public void insertForum(Student forum) {
		
	String query = "INSERT INTO student (ID, NAME, AGE) VALUES (?,?,?)";
		
	Connection connection = null;
	PreparedStatement preparedStatement = null;
	try {
		connection = dataSource.getConnection();			
		preparedStatement = connection.prepareStatement(query);			
		preparedStatement.setInt(1, forum.getId());
		preparedStatement.setString(2, forum.getName());
		preparedStatement.setInt(3, forum.getAge());
		
		preparedStatement.execute();
	} catch (SQLException e) {
		e.printStackTrace();
	} finally {
	      try {
				
		if (preparedStatement != null) {
		       preparedStatement.close();
		}
				
		if (connection != null) {
		     connection.close();
		}
	     } catch (SQLException e) {
		e.printStackTrace();
	    }
	}
	}
}
erro:
java.sql.SQLException: Network error IOException: Connection timed out: connect
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:372)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
	at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:283)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:271)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:255)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:236)
	at br.com.bradesco.web.disparo.teste.JDBCStudentDAOImpl.insertForum(JDBCStudentDAOImpl.java:32)
	at br.com.bradesco.web.disparo.teste.Main.main(Main.java:18)
Caused by: java.net.ConnectException: Connection timed out: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:289)
	at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:250)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:297)

Agradeço desde já a ajuda de voces!

1 Resposta

I

Solução:





Criado 16 de julho de 2013
Ultima resposta 16 de jul. de 2013
Respostas 1
Participantes 1