connect to oracle from java

[ahmadian]

Hi,

I am tring to connect to oracle via java code,
I want to use a connection to oracle so i can build a database or use an already build database.

the thing is:
1- i don't know how to build a database with a table in oracle
2- i tried to get a connection with the following code:

try
{
java.sql.DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
conn = java.sql.DriverManager.getConnection("jdbc:oracle: thin:@localhost","ahmadian","pouya");
System.out.println("Connected to database!");
}
catch (java.sql.SQLException ex)
{
javax.swing.JOptionPane.showMessageDialog
(null,ex,"pouya: Failed to connect with database",javax.swing.JOptionPane.ERROR_MESSAGE);
}

but i get an error saying:
Java.sqlSQLException.listener refused the connection with the following error: ORA-12514, TNS: listener dose not currently know of service requested in connect descriptor
the connection descriptor used by the client was: local host

3- could some one answer me this: if you want to connect to oracle via NetBeans and you don't know anything about oracle what should you do, step by step with complete description neede for a 6 years old!!

I would be really thankful if any one can answer me.

Pouya.

[Tolls]

Java.sqlSQLException.listener refused the connection with the following error: ORA-12514, TNS: listener dose not currently know of service requested in connect descriptor
the connection descriptor used by the client was: local host

Fairly self descriptive. It's looking for an Oracle database called localhost, which it can't find. Have you got Oracle up and running somewhere that you're trying to connect to?

3- could some one answer me this: if you want to connect to oracle via NetBeans and you don't know anything about oracle what should you do, step by step with complete description neede for a 6 years old!!

I would be really thankful if any one can answer me.

Pouya.

No idea, I'm afraid. Oracle do reasonable walkthroughs, so they may have one.

[ahmadian]

Hi,

Thank you so much for your reply, i was completely hopeless until your hint helped me.
Now I got a new error as fallow:

java.SQLException: Io exception: The Network Adapteer could not establish the connection.

any more hints? hopefully?!

pouya.

[Tolls]

Hi,

Thank you so much for your reply, i was completely hopeless until your hint helped me.
Now I got a new error as fallow:

java.SQLException: Io exception: The Network Adapteer could not establish the connection.

any more hints? hopefully?!

pouya.

Still looks like the connection is wrong somewhere. Either the name you're giving, or the port, or the db server isn't up and running. Something along those lines. Try and SQL*Plus onto the db, or tnsping it, from the box your Java is running on.

[ak88]

You better try to use dsn and then try whether it is working or not
I think it will give a better solution

[Steve11235]

First, are you sure you have an Oracle database running on your local system? You can get Oracle from their Web site and install it. Second, you have to create a database, tables, etc., before you can connect to it.

[Muntasir]

package DBM;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import java.lang.ClassNotFoundException;

public class OracleJDBC {

public static void main(String[] argv) {

System.out.println("-------- Oracle JDBC Connection Testing ------");

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

} catch (ClassNotFoundException e) {

System.out.println("Where is your Oracle JDBC Driver?");
e.printStackTrace();
return;

}

System.out.println("Oracle JDBC Driver Registered!");

Connection connection = null;

try {

connection = DriverManager.getConnection("jdbc:oracle:thin:@XYZ .asiapacific.hpqcorp.net:1521:orcl", "Username","password");

} catch (SQLException e) {

System.out.println("Connection Failed! Check output console");
e.printStackTrace();
return;

}

if (connection != null) {
System.out.println("You made it, take control your database now!");
} else {
System.out.println("Failed to make connection!");
}
}

}

[doWhile]

@Muntasir, please don'r resurrect a 4 year old post. Thread locked.