Forum:

Oracle/OAS

connectivity to databse through oracle 10g

Greenhorn

Posts: 1

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i made a program using servlets to connect t0 a database.i also used html for querry page. foolowing is my code. its working good with mysqland microsoft access but a system error with oracle 10g

/*
 * mini.java
 *
 * Created on February 14, 2008, 5:24 PM
 */
 
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
/**
 *
 * @author gopal
 * @version
 */
public class mini extends HttpServlet 
{
  public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
  {
      res.setContentType("text/html");
      PrintWriter p=res.getWriter();
      String doctype="<!doctype html public \"-//w3c//dtd html 4.0" + "transitional//en\"\n";
      String title="Sql result";
      p.println(doctype + "<html>\n" + 
                          "<head><title>" + title + "</title></head>\n" +  
                          "<body bgcolor=red><center>\n" + 
                          "<h1><i>Database Result</hl>"); 
      String driver=req.getParameter("driver");
      String url=req.getParameter("url");
      String query=req.getParameter("query");
      show(driver,url,query,p);
      p.println("</center></body></html>");
      
  }
  public void show(String driver,String url,String query,PrintWriter p)
  {
      try
      {
          //load drivers
          Class.forName(driver);
          //eshtablish connection
          Connection c=DriverManager.getConnection(url);
          System.out.println("<<<<<<<<connected>>>>>>>>.");
          //database info
          DatabaseMetaData db=c.getMetaData();
          p.println("<ul>");
          String servername=db.getDatabaseProductName();
          String serverversion=db.getDatabaseProductVersion();
          p.println("<li><b>Database:</b>" + servername + 
                    "<li><b>Version:</b>" + serverversion +
                    "</ul>");
          Statement st=c.createStatement();
          //send query to database and store result
          ResultSet rs=st.executeQuery(query);
          //print result
          p.println("<table border = 1 >");
          ResultSetMetaData rsmd=rs.getMetaData();
          int cc=rsmd.getColumnCount();
          for(int i=1;i<=cc;i++)
              p.println("<th>" + rsmd.getColumnName(i));
          p.println();
          //step through row
          while(rs.next())
          {
              p.println("<tr>");
              for(int i=1;i<=cc;i++)
              {
                  p.println("<td>" + rs.getString(i));
              }   
              p.println();
          }
          p.println("</table>");
          c.close();
               
      }
      catch(ClassNotFoundException e)
      {
          System.out.println("error loading driver" + e);
      }
      catch(SQLException e1)
      {
          System.out.println("error connecting" + e1); 
      }
      catch(Exception e2)
      {
         System.out.println("error with input" + e2);  
      }
  }
}

[ May 31, 2008: Message edited by: Campbell Ritchie ]

Campbell Ritchie

Marshal

Posts: 79701

381

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Don't know, but welcome to JavaRanch

I have edited your post with code tags and "disable smilies" to improve legibility.
I think people would be better able to help if you post the exact text of the error message.

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

Nareshreddy Kola

Greenhorn

Posts: 6

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Since you are using Oracle, why don't you just use an Oracle JDBC driver?

Kola.Nareshreddy

Rajat Bhatnagar

Greenhorn

Posts: 22

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

A lot of things to tell here

1. Use a type4 java driver.
2. Instead of blatantly pasting your code mention where do you think you might be going wrong.

3. Dont't just code..Think and code.

I am sending you the Code for oracle connectivity.
Just make sure that you have the oracle jars in your classpath while trying to run it.
Also change the UserName,Password and Other details in the Connection string.

package databaseAccessPrograms;
 
import java.sql.*;
import oracle.jdbc.*;
import oracle.jdbc.driver.*;
/*
 * Class illustrating Database connection with Oracle Database
 * Author : Rajat Bhatnagar
 * Website : <a href="http://guideofgreatness.googlepages.com/" target="_blank" rel="nofollow">http://guideofgreatness.googlepages.com/</a>
 */
public class type4Driver {
public static void main(String[] args) {
Connection conn =null;

try {Class.forName("oracle.jdbc.driver.OracleDriver"); }

catch(ClassNotFoundException e){
 System.out.println("Unable to load Driver");
}

try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn = DriverManager.getConnection("jdbc :o racle:thin:@<DATABASE>:1521:enr9i","<USERNAME>","<PASSWORD>");
 
Statement stmt = conn.createStatement( );
ResultSet rset = stmt.executeQuery("select sysdate from dual");
while(rset.next( )) {
System.out.println(rset.getString(1));
}
rset.close( );
stmt.close( );
conn.close( ); }

catch(SQLException se){
se.printStackTrace();

}
finally{
try{
if(conn!=null){
conn.close();
}
}catch(SQLException e){
e.printStackTrace();
}
}
}
}

[edit]Disable smilies. CR[/edit]
[ June 04, 2008: Message edited by: Campbell Ritchie ]

Regards<br />Rajat Bhatnagar<br /><a href="http://guideofgreatness.googlepages.com" target="_blank" rel="nofollow">http://guideofgreatness.googlepages.com</a>;

Rajat Bhatnagar

Greenhorn

Posts: 22

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I think i pasted the wrong version of code here.

just ignore the

Part

Regards<br />Rajat Bhatnagar<br /><a href="http://guideofgreatness.googlepages.com" target="_blank" rel="nofollow">http://guideofgreatness.googlepages.com</a>;

I'm just a poor boy, I need no sympathy, because I'm easy come, easy go, little high, little low, little ad

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser