Raja kamatchi

Hi David,

Thanks for your immediate reply..

Actually, the input parameter is variable one..It can have some value or can be null. How can i change the query in prepared statement, based on the input param value ?
can you please advise me. thanks.

Hi,

I am using PreparedStatement for table retrieval. I would need to fetch the records with column value null. Table Column is VARCHAR2 type.

String query = "SELECT * FROM <table_name> WHERE <col_name> = ?";
PreparedStatement ps = c.prepareStatement(query);
ps.clearParameters();
ps.setNull(1, Types.VARCHAR);

ResultSet rs = ps.executeQuery();
while (rs.next()) {
}

Here, if I set null value, like above, for the where condition, it cannot able to fetch the record even though for this column, table value is null.

If I use the query, SELECT * FROM <table_name> WHERE <col_name> is null, it can fetch the record.


Can anyone please help. thanks

Hi

We have a system which interface through CORBA-CORBA (JAVA). CORBA server Objects are deployed in NetDynamics Application Server.
Now we are planning to move Server implementation as EJB to be deployed in WebLogic server. We cannot modify the existing Client interface. Without disturbing the client, How can i create an interface for CORBA(JAVA) to EJB in WebLogic.
Can anyone advise.

Thanks in advance.
-Raja