Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes good select statement but does not run in java jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "good select statement but does not run in java jdbc" Watch "good select statement but does not run in java jdbc" New topic
Author

good select statement but does not run in java jdbc

John Nicer
Greenhorn

Joined: Oct 08, 2009
Posts: 8
Hi Geeks,
I wrote a SQL static class so that I can run as follow

String sql="select * from table where name = 'McDonald' "; // (A)

List<Row> list = SQL.query(sql); // (B)

(B) is implemented as follow:

class SQL
{
public static List<Row> query(String sql)
{
Connection con ....
preparedStament = con.getPrepared..

ResultSet result = preparedStatement.executeQuery(sql);

while(result.netx());
....
}

}

Say, the sql statement above works in PL/SQL but it does not work in JDBC, even this code was tested for many other sql statement. Is any pit fall that I encounter? Greatly appreciated.

Javee

The sql statement in PL/SQL works sucessfully and this code works for other SQL statements, too.
But why for one query
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14688
    
  16

It does not work ? What's the error ?


[My Blog]
All roads lead to JavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: good select statement but does not run in java jdbc