Hi*!
I have a Session bean that uses JDBC (not using JNDI resource for Database), I m doing something like...

DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
java.util.Properties connAttr = new java.util.Properties();
connAttr.setProperty("NLS_LANG", "GERMAN_GERMANY.WE8ISO8859P1");

con = DriverManager.getConnection("jdbc:oracle:oci8:"+DB_USER+"/"+DB_PASS+"@"+DB_NAME, connAttr);

I can connect fine. The problem is when i create a select statement that has a german umlaut char. I dont get any results, but if i use Tora for the same SQL statememnt i get a resultset. Can anyone help me with this problem?
Any comments/suggestions are highly appreciated...
Thanks in Advance,
Regards,
Usman.