943,791 Members | Top Members by Rank

Ad:
  • Java Discussion Thread
  • Unsolved
  • Views: 502
  • Java RSS
Mar 31st, 2009
0

java connectivity

Expand Post »
I have to make a database in oracle and connect it with Java. But I'm not able to do so.
Please help.
Similar Threads
Reputation Points: 1
Solved Threads: 0
Light Poster
coolbuddy059 is offline Offline
45 posts
since Aug 2008
Mar 31st, 2009
0

Re: java connectivity

I have to make a database in oracle and connect it with Java. But I'm not able to do so.
Please help.

I want to make a space ship and fly back to my home on Mars, please help me too.
Featured Poster
Reputation Points: 653
Solved Threads: 151
Nearly a Posting Virtuoso
stephen84s is offline Offline
1,316 posts
since Jul 2007
Mar 31st, 2009
0

Re: java connectivity

@coolbuddy059 please provide your current code so we may have look at it and correct it if there is any issue

PS:In the future please provide more info, if you wish to avoid general suggestions such as one by stephen. Secondly we have rule that says "We only give homework help to those who show effort"
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 873
Code tags enforcer
peter_budo is offline Offline
6,656 posts
since Dec 2004
Mar 31st, 2009
0

Re: java connectivity

sorry stephen84s for unclearity in my question,
But the problem is I've crated the database using Oracle8i.But now I don't know what to do next.
Reputation Points: 1
Solved Threads: 0
Light Poster
coolbuddy059 is offline Offline
45 posts
since Aug 2008
Mar 31st, 2009
0

Re: java connectivity

My code is:-

import java.sql.*;

import java.io.*;



public class dbcon{

public static void main(String[] args) {

Connection connection = null;

try {

// Load the JDBC driver

String driverName = "oracle.jdbc.driver.OracleDriver";

Class.forName(driverName);



// Create a connection to the database

//String serverName = "127.0.0.1";

//String portNumber = "1521";

//String sid = "oracle";

String url = "jdbc:oracle:thin//local.server:1521/oracle";

String username = "scott";

String password = "tiger";

connection = DriverManager.getConnection(url, username, password);

System.out.println("***Connected to the database***");

} catch (ClassNotFoundException e) {

// Could not find the database driver

} catch (SQLException e) {

// Could not connect to the database



}

}


The compilation error whichI'm getting is:
The pointer has reached at the end of line while parsing} ->
Reputation Points: 1
Solved Threads: 0
Light Poster
coolbuddy059 is offline Offline
45 posts
since Aug 2008
Mar 31st, 2009
0

Re: java connectivity

As error message states you missing closing bracket "}" on the end of your code. If you check your code you will find that main() was closed, however you did not do same for the class
Last edited by peter_budo; Mar 31st, 2009 at 8:10 am.
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 873
Code tags enforcer
peter_budo is offline Offline
6,656 posts
since Dec 2004
Apr 1st, 2009
1

Re: java connectivity

Peter has already mentioned the cause of your problem, now just wanted to add a few notable things like :-
  1. You never closed your connection, Its important to close your database connection once you are done using it. Preferably put the call to close() inside a finally block, so that your database connection is closed irrespective of whether an SQLException was thrown during your query execution etc.
  2. In the catch block where you have caught your SQLException always print / log the SQL State by calling e.getSQLState(), by comparing the SQL State with your DBMS vendor data example here, you can map out exactly why your query failed.
Last edited by stephen84s; Apr 1st, 2009 at 1:35 am.
Featured Poster
Reputation Points: 653
Solved Threads: 151
Nearly a Posting Virtuoso
stephen84s is offline Offline
1,316 posts
since Jul 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Java Forum Timeline: Java system info
Next Thread in Java Forum Timeline: Send SMS





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC