• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

date problem not in access but sql server

 
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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).]
 
money grubbing section goes here:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic