Strange problem help

[adeeb alexander]

Hi all.
I want to retrieve a column from DB. I have done as usual, i don't get the output. Look at the code. I get the out put if i give the value directly in the query i.e('adeeb'). If i try to set the String using preparedStatement. There is no output

    
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","scott","tiger");
					   	ps = conn.prepareStatement("SELECT * FROM users WHERE username='adeeb' ",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
					   	rs=ps.executeQuery();
					   	while(rs.next())
					   	{
					   		//dbpass = rs.getString(1);
					   		System.out.println("pass="+rs.getString("passwd"));
					   	}

The code when i used to set the string is here:

    
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","scott","tiger");
					   	ps = conn.prepareStatement("SELECT * FROM users WHERE username=?",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
					  	ps.setString(1,"adeeb");
					   	rs=ps.executeQuery();
					   	while(rs.next())
					   	{
					   		//dbpass = rs.getString(1);
					   		System.out.println("pass="+rs.getString("passwd"));
					   	}

Somebody please help me out i can't understand whats happening.


Thanks and regards
alexander

[Scott Selikoff]

It's a long shot, but it could be character encoding. In general, though, these two should return the same results I'd do some more general debugging. Grab a debug driver that outputs SQL queries and/or turn on query monitoring so that you can see what's being executed on the server.