Smita Tyagi

Greenhorn
+ Follow
since May 09, 2001
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by 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
22 years ago
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
22 years ago
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
22 years ago
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
22 years ago
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
22 years ago
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
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
22 years ago
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