Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

date problem not in access but sql server

 
kajal sharma
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear java guru's

When I try to insert records in Access97 ---> no problem
but when I enter records in MS sql server then I got the following runtime exception
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
---------------------------------mycode---------------------------------------

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
java.util.Date xdate=sdf.parse(a2);
//java.sql.Date date=java.sql.Date.valueOf(a2);//I even try this but same exception
//System.out.println(date);
System.out.println(new java.sql.Date(xdate.getTime()));//2000-12-09
PreparedStatement updater = myConnection.prepareStatement("update FormA set age= ? ,"+
" cough= ? "
+ " where sitesrno= ? ");
updater.setInt(1,Integer.parseInt(a4));
updater.setString(2,a7);

updater.setDate(3,new java.sql.Date(xdate.getTime()));
updater.setInt(4,Integer.parseInt(s));

int updateCount = updater.executeUpdate();
updater.clearParameters();

any suggestions
kajal
 
kajal sharma
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear java guru,

when I tried timestamp as this
{ts '1999-11-11 00:00:00.000000000'}
I got the following run time exception
java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff
If i use time stamp as
1999-11-11 00:00:00.000000000
now exception is
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid argument value
I am setting time stamp as
String ydate=a2+" 00:00:00.000000000";
updater.setTimestamp(3,Timestamp.valueOf(ydate));
What is the right ways to use timestamp
kajal
[This message has been edited by kajal sharma (edited March 20, 2001).]
[This message has been edited by kajal sharma (edited March 20, 2001).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic