Smita Tyagi

Hello Raj,
I am sorry that I am not helping you in any way but I want to ask you how have you downloaded txt file using JSP?
Thanks in advance
Smita

Hello Johnson,
If you don't want the user to cmake change to your DB why don't you show data in XML sheets?
Smita

Hello Anitha,
Actually I had taken lots of mock tests befors exams that also comprised of the Maha Anna mock exams. They are just to giv you an idea of the exam Q. You better try as many tests as you can. I am very sorry that I am not providing you very explicit answer but it is true that you should try as many papers as possible.
Smita

Hello David,
As far as I know using cookies is one way of storing data in a session. Even if a browser has disabled cookies it mustn't effect session.
Smita

Thanks Bartender

Hello Flornce,
You are going to get null values until you assign values to your checkboxes as
someval = request.checkboxvalue;
out.println("<input type=checkbox name="+checkBoxName+" value = "+someval+">" );
try this it must work.
Smita

Hello Dhiraj,
You must put a database name after the @ sign in the connection URL.You can use either the fully specified SQL*net syntax or a short cut syntax as <host>:<port>:<sid>.
Smita

Hello Sachin,
You can use a prepared statement like this:
PreparedStatement stat = myConn.prepareStatement("Select name from table where (joining_date between ? and ?)");
stat.setString(1,beginingDate);
stat.setString(2,endDate);
you try this and let me know whether it works.
Smita

Hello rk t,
First of all same connection can be used for more than one queries so you can count out that reason for the error. Secondly I tried to reach the link you have given but in vain it is not working. It gives me misspelled URL exception.
Smita

Thanks Jane

Hello Supriya,
Well most of my friends and even I have followed mainly two books i.e. Philip Heller(Java Certifiaction) and Barry Boone (Java 2 Certification). These two books explicilty have been written according to the certification exam. Believe me the example questions in these two books provide very good practice for exam. Also you can use Khalid Mughal for references and only as help book along with these. All this I am telling you according to my experience only. So you better look these books.
And as far as mock tests are concerned the html links provided by Mukherjee are very good.
Thanks for your offer of help to me.
Bye
Smita

Hello Rajesh,
Try by giving action as OUT only rather than IN OUT.
Smita

Hi Everybody,
Don't waste your time I have found the solution it was typo mistake on my part.

For the following code---------
import java.sql.*;
public class MyDBTest
{
Connection myConn = null;
MyDBTest()
{
try {
Class.forName("sun.jbc.odbc.JdbcOdbcDriver");
myConn = DriverManager.getConnection("jdbc dbc:CatalogSalesSystem","sa","");
}
catch(ClassNotFoundException exp){}
catch(SQLException exp){}
}
public void processMe(int i, String str, float sal){
try{
System.out.println("*");
CallableStatement callStat = myConn.prepareCall(" {call myProcedure(?,?,?)}");
System.out.println("*);
callStat.setInt(1 , i);
callStat.setString(2 , str);
callStat.setFloat(3 , sal);
int in = callStat.executeUpdate();
}
catch(SQLException exp){
System.out.println(exp);
}
}
public static void main(String[] args)
{
MyDBTest myDB = new MyDBTest();
myDB.processMe(22,"Soni",2000);
}
}
CREATE PROCEDURE myProcedure @empId int, @empName varchar(20), @empSal float AS
begin transaction
insert into tabCheck(EmpId,EmpName,EmpSalary) VALUES (@empID,@empName,@empSal)
commit

return
I am geting
*
java.lang.NullPointerException
Would anybody help me in finding the problem???
Thanks in advance

Hello Raj,
Would you send me the code where you are trying this. I will try my best to help.
Smita