In the code below, I use a parameterized PreparedStatement to access an Oracle database. If I set the parameter with setInt, it works fine. If I use setLong, I don't get any records, and no error. ...
http://www.experts-exchange.com/Programming/Languages/Java/Q_20067896.html
Zones:
JavaDate Answered: 07/12/2003 Grade: A Views: 0
index.jsp
=============================================
<%
session.putValue("USER_INT_KEY", "INVALID");
session.putValue("option_chosen", "gen_rev");
%>
<HTML>
<HEAD>
<TITLE></TITLE>
</HEA...
http://www.experts-exchange.com/Programming/Languages/Java/Q_20195947.html
Zones:
JavaDate Answered: 10/22/2001 Grade: A Views: 0
i am using preparedstatement, and i wish to use LIKE in my sql.
selectUserEmailStrLg = "select login_memid, login_email, login_memtype from login where login_email like '%?%' "+
...
http://www.experts-exchange.com/Programming/Languages/Java/Q_20580763.html
Zones:
JavaDate Answered: 04/10/2003 Grade: A Views: 0
I have a statement I'd like to prepare that includes an IN clause. Say... I want to find all orders IN (?), where ? is an unknown number of order ids. Is this possible with PreparedStatements, or...
http://www.experts-exchange.com/Programming/Languages/Java/Q_20805427.html
Zones:
JavaDate Answered: 11/21/2003 Grade: A Views: 114
Dear all,
i have this code. What i intended to do is get the user's date, dd/MM/yyyy and based on this user's entried date, i wish to retrieve all the data in the same month with it...
this is m...
http://www.experts-exchange.com/Programming/Languages/Java/J2EE/JSP/Q_20810676.html
Zones:
JSPDate Answered: 11/28/2003 Grade: A Views: 0
I have created a prepared statement and run the query. The query is successfully run but no results are returned when there are results that match the criteria in the db.
PreparedStatement sta...
http://www.experts-exchange.com/Programming/Misc/Q_21271874.html
Zones:
ProgrammingDate Answered: 01/13/2005 Grade: B Views: 0
Hi,
Please kindly assist
1. what is PreparedStatement ps ; ?
2. what is setString(1, name); ?
3. what is ps.executeUpdate(); ?
related to JSP and database
Thanks.
http://www.experts-exchange.com/Programming/Languages/Java/Q_21604047.html
Zones:
JavaDate Answered: 10/22/2005 Grade: A Views: 0
Hi,
I have a prepared statement on an in query - something like this
select * from customers where id in ?
I want to pass a string like "1,2,3" to the setXXX function. The problem being th...
http://www.experts-exchange.com/Programming/Languages/Java/Q_21842021.html
Zones:
JavaDate Answered: 06/16/2006 Grade: A Views: 0
i get this error,my problem is with auto increment in oracle.
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracl...
http://www.experts-exchange.com/Programming/Languages/Java/Q_21906548.html
Zones:
JavaDate Answered: 07/03/2006 Grade: A Views: 0
How usefull is it in cases where you open a connection, execute a statement and close the connection (and hence the prepared statement as well).
I think its only usefull when you are using the...
http://www.experts-exchange.com/Programming/Languages/Java/Q_21941144.html
Zones:
JavaDate Answered: 09/15/2006 Grade: A Views: 5
