Hi, I am implenting a project on Library Management System(Web application). I have a form as New User Registration Form in which user enters his/her information.There is one field as DateOfBirth which takes input as string(i.e date of birth of the user).Now I am extracting this inputs in Servlet. My aim is to insert these inputs in a user table.I am using SQL Server 2000. I am using Prepared Statement for Insert query.I convert the date of birth which is in string to java.sql.Date object using the following code:-
The JDBC/ODBC driver does not provide a complete set of JDBC 2.0 features so this example must result in a call that is not supported in the driver. You could try using the Microsoft JDBC driver or the JDTS driver. They should provide better performance as well.
Just a suggestion - Try it out with DATETIME in SQL Server and java.sql.Timestamp in Java once.
Joined: Mar 28, 2007
Hi, Thankyou for your replies.Now the problem is solved.Now i am using different Driver i.e sql driver(Type4).Now again some problems comes out.When the user enter Date in String form ,i convert that date in java.sql.date using the following function: