asked on

java program to query the database

I was trying following java program
http://www.exampledepot.com/egs/java.sql/CreateResultSet.html

Through java program Below one is working fine.
Statement stmt = connCdms.createStatement();
ResultSet rs1 = stmt.executeQuery("SELECT * FROM table1");

through java program Below one is not working
Statement stmt = connCdms.createStatement();
ResultSet rs1 = stmt.executeQuery("SELECT * FROM table1 col1='PPP' and col2='777'");

When i execute below query in toad on oracle database it returns 4 records. I am missing something. Please advise

SELECT * FROM table1 col1='PPP' and col2='777'

Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance

gudii9

ASKER

do i need to put / or something. please advise

awking00

You're missing the WHERE keyword.

gudii9

ASKER

I am sorry that is typo

I do have where clause as below still does not yield any results from the java program. (works perfect from toad)

SELECT * FROM table1 where col1='PPP' and col2='777'
Please advise

SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gudii9

ASKER

i did commit all is committed data existing for long time. Please advise

ASKER CERTIFIED SOLUTION

awking00

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

awking00

You might also try -
String query = "SELECT * FROM table1 where col1='PPP' and col2='777' ";
PreparedStatement pst = connCdms.prepareStatement(query);
ResultSet rs1 = pst.executeQuery();