Bom, estou desde ontem tentando inserir no banco e não consigo...
aí vai o código:
package bd;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import entidade.Contato;
public class SuporteJdbc {
private Connection con;
//construtor
public SuporteJdbc() {
String JDBC_DRIVER = "oracle.jdbc.driver.OracleDriver";
String DB_URL = "jdbc:oracle:thin:@localhost:1521:dese";
String DB_USER = "iplanner";
String DB_PASS = "iplanner";
/*String host = "localhost";
String servicename = "iPlanner-dese";
String user = "iplanner";
String password = "iplanner";*/
try {
//carregando o drive jdbc
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//obter uma conexao
Connection con = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void salvarContato(Contato c) throws Exception{
String sql = "insert into contato (nome,fone) values (?,?)";
try {
PreparedStatement ps =
con.prepareStatement(sql);
ps.setString(1, c.getNome());
ps.setString(2, c.getFone());
ps.execute();
} catch (SQLException e) {
e.printStackTrace();
throw e;
}
}
}
aí eh o erro:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:dese
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:280)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at bd.SuporteJdbc.<init>(SuporteJdbc.java:28)
at servlets.Cadastro.doPost(Cadastro.java:43)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
at java.lang.Thread.run(Unknown Source)
na verdade eu não sei se são erros... por favor me ajudem...
=D
