problem in database connection

obedraju · 10-16-2011, 03:20 PM

Hi...
I have run the following code. Everything works on eclipse n netbeans. It shows output on page. But the problem is, i am unable to find any table created on oracle.

Code
-----------------------------------------------------------------
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*;"%>

<%
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc

racle:thin:@loc alhost:1521:XE","system","obedraju");
PreparedStatement ps = con.prepareStatement("create table obedraju(obed varchar2(399))");
System.out.println("Loading driver");
}
catch(Exception s)
{}

%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
Done...
</body>
</html>
-----------------------------------------------------------------

I have downloaded ojdbc14.jar and added to the project.

Can any one help me in getting table created on oracle database.

Thnx...

Proud · 10-16-2011, 04:13 PM

Please put your code in [code] tags to preserve indentation and avoid other forum parsing.
Did you mean localhost to have a space in it?

Your printing of the HTML with "Done..." seems unconditional, it is no indication that the Java was executed or successful. I strongly suggest you don't do utterly nothing when any exception is thrown.

obedraju · 10-17-2011, 12:32 AM

What localhost space?? I mean.. the code is executing perfectly. When it is executed, there should be a table created on database. So my question is, y it is not creating a table on oracle database.

Proud · 10-17-2011, 05:03 AM

The space in

Code:

getConnection("jdbc:oracle:thin:@loc alhost:1521:XE","system","obedraju");

Clearly your code isn't executing perfectly if it's not doing what you expect it to. Again, please edit your original post to put your code in the correct forum tags, and then try not silently consuming any Exception that may occur in the try block you've written.
This

Code:

catch(Exception s)
{}

is very very bad.