Oracle 11g connectivity with java in Netbeans 7.1

Question

I have successfully connected my Oracle 11g XEdatabase with java in Netbeans 7.1.

Class.forName("oracle.jdbc.OracleDriver");
System.out.println("DRIVER LOADED!");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system", "acpsa") ;
System.out.println("CONNECTION ESTABLISHED!");

Now I want to access a table employee(fname,lname,ssn), retrieving all records and displaying them.

When I add this code:

Statement stmt;
stmt=(Statement)conn.createStatement();
String qq = "select fname,ssn from employee where lname='tank';";
ResultSet rs = (ResultSet)stmt.executeQuery(qq);
while(rs.next()){
    System.out.println(rs.getString("fname") + "\t" + rs.getString("ssn"));
}

I get the following error:

Error :java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

This might be due to the fact the we can't access multiple rows in oracle.

How can I access the employee table in Java?

BalusC · Accepted Answer · 2012-03-22 04:27:46Z

4

Remove the semicolon from the query.

String qq = "select fname,ssn from employee where lname='tank'";

By the way, all those casts (Statement) and (ResultSet) are unnecessary.

answered Mar 22, 2012 at 4:27

BalusC

1.1m377 gold badges3.7k silver badges3.6k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle 11g connectivity with java in Netbeans 7.1

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related