Zolf
asked on
Java Date
Hello there,
i am trying to insert some dates in my db. i try this,but i get error cannot find symbol.
u.setLastAccessTime(Date.v
cheers
zolf
Assumed that setLastAccessTime() is a method which accepts
java.uti.Date
If you give some details about database that would be useful
java.uti.Date
If you give some details about database that would be useful
ASKER
thanks a lot.
by the way i am using a block of code from a book. in the book it shows the code like this. i have never seen java code written in parentesis.like i have shown in the code below.is this new feature of java or something.am i missing something
public static void main(String args[]) {
HibernateUtil.recreateDatabase();
Session session = HibernateUtil.beginTransaction();
{
User u = new User();
u.setLoginName("mj");
u.setPassword("abc123");
u.setEmailAddress("mj@mcnz.com");
u.setVerified(false);
u.setLastAccessTime(new java.util.Date());
u.setRegistrationDate(new GregorianCalendar(2006,01,01));
session.saveOrUpdate(u);
}{
User u = new User();
u.setLoginName("mario");
u.setPassword("pass");
u.setEmailAddress("mario@scja.ca");
u.setVerified(true);
u.setLastAccessTime(Date.valueOf("2008-1-1"));
u.setRegistrationDate(new GregorianCalendar(2007,01,01));
session.saveOrUpdate(u);
}{
User u = new User();
u.setLoginName("sk8trgrl");
u.setPassword("password");
u.setEmailAddress("avril@scja.com");
u.setVerified(false);
u.setLastAccessTime(new java.util.Date());
u.setRegistrationDate(new GregorianCalendar(2008,01,01));
session.saveOrUpdate(u);
}
{
User u = new User();
u.setLoginName("ridley");
u.setPassword("mypassword");
u.setEmailAddress("getbent@scja.ca");
u.setVerified(true);
u.setLastAccessTime(new java.util.Date());
u.setLastAccessTime(Date.valueOf("2006-10-5"));
u.setRegistrationDate(new GregorianCalendar(2006,5,11));
session.saveOrUpdate(u);
}
http://download.oracle.com/javase/1.4.2/docs/api/java/sql/Date.html#valueOf%28java.lang.String%29
I guess java.sql.Date.valueOf((("1
should work
You see Date is ambiguous there are two classes java.uti.Dtae and java.sql.Date
and sql Date does have this method taking this format
and sql Date does have this method taking this format
You see in your code tehy explicuitly wrie java.util.Date
in other cases where Date is without java.util they probably omply java.sql.Date, as they have this sql.Date
in the import on top
in other cases where Date is without java.util they probably omply java.sql.Date, as they have this sql.Date
in the import on top
ASKER
SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-
Date dd = f.parse(("1999-7-26", new ParsePosition(0)));
i get error saying ) expected??i have checked and the brackets seems to be ok
try add java.uti.Dtae instead of Date
SimpleDateFormat f = new SimpleDateFormat("yyyy-MM- dd");
java.uti.Date dd = f.parse(("1999-7-26", new ParsePosition(0)));
SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-
java.uti.Date dd = f.parse(("1999-7-26", new ParsePosition(0)));
ASKER
yes you were correct.java.sql.date solved the issue.can you please throw some light on those bracket thing which i mentioned in the code
This code exactly worked for me
SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd");
Date dd = f.parse("1999-7-26", new ParsePosition(0));
System.out.println(dd);
You had two many parentheses in parsing
I'm not sure, waht you mean - there are
soem extra braces there ?
As long as they are matching and the scope of variables are consistent you can put braces, I believe
soem extra braces there ?
As long as they are matching and the scope of variables are consistent you can put braces, I believe
ASKER
i mean this
09/05/11 11:34 AM, ID: 35718026
You don't need a DateFormat, the code you already have will work fine
And if you do want to use DateFormat the code you need is shown here
http://helpdesk.objects.com.au/java/how-do-i-parse-a-java-string-that-specifies-a-date
http://helpdesk.objects.com.au/java/how-do-i-parse-a-java-string-that-specifies-a-date
Please, explain what you mean by this:
"
i mean this
09/05/11 11:34 AM, ID: 35718026
"
these arer parenthese ()
these are brackets []
these are braces {}
waht do you mean?
ASKER
i mean braces
ASKER
i am trying to run this code and i get error
http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=09howtousethecriteriaapi
ASKER
this what i am trying to run,but now i get error
Hibernate: insert into Users (emailAddress, lastAccessTime, login_name, password, registrationDate, verified) values (?, ?, ?, ?, ?, ?)
2011-05-09 12:04:12,757 [main] DEBUG IdentifierGeneratorHelper : Natively generated identity: 1
2011-05-09 12:04:12,757 [main] DEBUG AbstractBatcher : about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
Exception in thread "main" java.lang.IllegalArgumentE
at java.sql.Date.valueOf(Date
at com.exam.main.MainUsers.ma
Java Result: 1
BUILD SUCCESSFUL (total time: 1 second)
import com.exam.model.Users;
import java.util.GregorianCalendar;
import org.hibernate.Session;
/**
*
* @author ZAJ
*/
public class MainUsers
{
public static void main(String args[])
{
HibernateUtil.recreateDatabase();
Session session = HibernateUtil.beginTransaction();
{
Users u = new Users();
u.setLoginName("mj");
u.setPassword("abc123");
u.setEmailAddress("mj@mcnz.com");
u.setVerified(false);
u.setLastAccessTime(new java.util.Date());
u.setRegistrationDate(new GregorianCalendar(2006, 01, 01));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("mario");
u.setPassword("pass");
u.setEmailAddress("mario@scja.ca");
u.setVerified(true);
u.setLastAccessTime(java.sql.Date.valueOf("2008-1-1"));
u.setRegistrationDate(new GregorianCalendar(2007, 01, 01));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("sk8trgrl");
u.setPassword("password");
u.setEmailAddress("avril@scja.com");
u.setVerified(false);
u.setLastAccessTime(new java.util.Date());
u.setRegistrationDate(new GregorianCalendar(2008, 01, 01));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("ridley");
u.setPassword("mypassword");
u.setEmailAddress("getbent@scja.ca");
u.setVerified(true);
u.setLastAccessTime(new java.util.Date());
u.setLastAccessTime(java.sql.Date.valueOf("2006-10-5"));
u.setRegistrationDate(new GregorianCalendar(2006, 5, 11));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("kerri");
u.setPassword("pwd");
u.setEmailAddress("sheehan@princessjava.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2007, 12, 12));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("astra");
u.setPassword("pwd");
u.setEmailAddress("rabbit@princessjava.com");
u.setVerified(false);
u.setLastAccessTime(new java.util.Date());
u.setRegistrationDate(new GregorianCalendar());
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("cameron");
u.setPassword("90210");
u.setEmailAddress("me@scwcd.com");
u.setVerified(true);
u.setLastAccessTime(java.sql.Date.valueOf("2008-9-15"));
u.setRegistrationDate(new GregorianCalendar(2008, 8, 12));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("stephen");
u.setPassword("low");
u.setEmailAddress("stanley@pulpjava.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2008, 02, 15));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("che");
u.setPassword("password");
u.setEmailAddress("ernesto@pulpjava.com");
u.setVerified(true);
u.setLastAccessTime(java.sql.Date.valueOf("1999-7-26"));
u.setRegistrationDate(new GregorianCalendar(1999, 3, 9));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("remy");
u.setPassword("password");
u.setEmailAddress("rabbit@scja.com");
u.setVerified(false);
u.setLastAccessTime(new java.util.Date());
u.setRegistrationDate(new GregorianCalendar(2007, 05, 21));
session.saveOrUpdate(u);
}
HibernateUtil.commitTransaction();
}
}
But they can use extra brcase if all variabes are in csope and opebning match closing
it probably add readability in this case
it probably add readability in this case
java.sql.Date.valueOf(Date
http://download.oracle.com/javase/1.4.2/docs/api/java/sql/Date.html#valueOf%28java.lang.String%29
ASKER
so is the code which the author has provided got error in it,since i am running his code
ASKER
i have added string,but still i get error
Look you have nothin inline 73
ASKER
i changed it after that error,but still i get error.here is the new version
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package com.exam.main;
import com.exam.model.Users;
import java.util.GregorianCalendar;
import org.hibernate.Session;
/**
*
* @author ZAJ
*/
public class MainUsers
{
public static void main(String args[])
{
HibernateUtil.recreateDatabase();
Session session = HibernateUtil.beginTransaction();
{
Users u = new Users();
u.setLoginName("mj");
u.setPassword("abc123");
u.setEmailAddress("mj@mcnz.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2006, 01, 01));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("mario");
u.setPassword("pass");
u.setEmailAddress("mario@scja.ca");
u.setVerified(true);
u.setLastAccessTime(java.sql.Date.valueOf("2008-1-1"));
u.setRegistrationDate(new GregorianCalendar(2007, 01, 01));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("sk8trgrl");
u.setPassword("password");
u.setEmailAddress("avril@scja.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2008, 01, 01));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("ridley");
u.setPassword("mypassword");
u.setEmailAddress("getbent@scja.ca");
u.setVerified(true);
//u.setLastAccessTime(new java.util.Date());
u.setLastAccessTime(java.sql.Date.valueOf("2006-10-5"));
u.setRegistrationDate(new GregorianCalendar(2006, 5, 11));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("kerri");
u.setPassword("pwd");
u.setEmailAddress("sheehan@princessjava.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2007, 12, 12));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("astra");
u.setPassword("pwd");
u.setEmailAddress("rabbit@princessjava.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar());
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("cameron");
u.setPassword("90210");
u.setEmailAddress("me@scwcd.com");
u.setVerified(true);
u.setLastAccessTime(java.sql.Date.valueOf("2008-9-15"));
u.setRegistrationDate(new GregorianCalendar(2008, 8, 12));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("stephen");
u.setPassword("low");
u.setEmailAddress("stanley@pulpjava.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2008, 02, 15));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("che");
u.setPassword("password");
u.setEmailAddress("ernesto@pulpjava.com");
u.setVerified(true);
u.setLastAccessTime(java.sql.Date.valueOf("1999-7-26"));
u.setRegistrationDate(new GregorianCalendar(1999, 3, 9));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("remy");
u.setPassword("password");
u.setEmailAddress("rabbit@scja.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2007, 05, 21));
session.saveOrUpdate(u);
}
HibernateUtil.commitTransaction();
}
}
line 73: u.setLastAccessTime(new java.util.Date());
compare with line 83:
u.setLastAccessTime(java.s ql.Date.va lueOf("200 8-9-15"));
and other lines like that
you line 73 iis wromng
compare with line 83:
u.setLastAccessTime(java.s
and other lines like that
you line 73 iis wromng
Where is new error at what line?
ASKER
and here is the erro i get
Exception in thread "main" java.lang.IllegalArgumentE
at java.sql.Date.valueOf(Date
at com.exam.main.MainUsers.ma
Java Result: 1
Don't see, are you sure you pasted the latest version which you are running
73 was inded bad - this 28 maybe I;m not noticing some additional point or comma
try to run once again and post exactly your code
In the worst case you may try to change the order of teese pargraphs
abnd check the line of error - thisometimes helps to spot the misprint
73 was inded bad - this 28 maybe I;m not noticing some additional point or comma
try to run once again and post exactly your code
In the worst case you may try to change the order of teese pargraphs
abnd check the line of error - thisometimes helps to spot the misprint
ASKER
i have changed the line no and ran the file,but still no luck.
Exception in thread "main" java.lang.IllegalArgumentE
at java.sql.Date.valueOf(Date
at com.exam.main.MainUsers.ma
Java Result: 1
BUILD SUCCESSFUL (total time: 2 seconds)
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package com.exam.main;
import com.exam.model.Users;
import java.util.GregorianCalendar;
import org.hibernate.Session;
/**
*
* @author ZAJ
*/
public class MainUsers
{
public static void main(String args[])
{
HibernateUtil.recreateDatabase();
Session session = HibernateUtil.beginTransaction();
{
Users u = new Users();
u.setLoginName("mj");
u.setPassword("abc123");
u.setEmailAddress("mj@mcnz.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2006, 01, 01));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("mario");
u.setPassword("pass");
u.setEmailAddress("mario@scja.ca");
u.setVerified(true);
u.setLastAccessTime(java.sql.Date.valueOf("2008-1-1"));
u.setRegistrationDate(new GregorianCalendar(2007, 01, 01));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("sk8trgrl");
u.setPassword("password");
u.setEmailAddress("avril@scja.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2008, 01, 01));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("ridley");
u.setPassword("mypassword");
u.setEmailAddress("getbent@scja.ca");
u.setVerified(true);
//u.setLastAccessTime(new java.util.Date());
u.setLastAccessTime(java.sql.Date.valueOf("2006-10-5"));
u.setRegistrationDate(new GregorianCalendar(2006, 5, 11));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("kerri");
u.setPassword("pwd");
u.setEmailAddress("sheehan@princessjava.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2007, 12, 12));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("astra");
u.setPassword("pwd");
u.setEmailAddress("rabbit@princessjava.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar());
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("cameron");
u.setPassword("90210");
u.setEmailAddress("me@scwcd.com");
u.setVerified(true);
u.setLastAccessTime(java.sql.Date.valueOf("2008-9-15"));
u.setRegistrationDate(new GregorianCalendar(2008, 8, 12));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("stephen");
u.setPassword("low");
u.setEmailAddress("stanley@pulpjava.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2008, 02, 15));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("che");
u.setPassword("password");
u.setEmailAddress("ernesto@pulpjava.com");
u.setVerified(true);
u.setLastAccessTime(java.sql.Date.valueOf("1999-7-26"));
u.setRegistrationDate(new GregorianCalendar(1999, 3, 9));
session.saveOrUpdate(u);
}
{
Users u = new Users();
u.setLoginName("remy");
u.setPassword("password");
u.setEmailAddress("rabbit@scja.com");
u.setVerified(false);
u.setLastAccessTime(java.sql.Date.valueOf("2008-2-25"));
u.setRegistrationDate(new GregorianCalendar(2007, 05, 21));
session.saveOrUpdate(u);
}
HibernateUtil.commitTransaction();
}
}
ASKER
for_yan:
one thing, this method is of type java.util. so could that be the cause. the books code i am following seems to have error in its code.
@Temporal(TemporalType.TIMESTAMP)
public Date getLastAccessTime()
{
return lastAccessTime;
}
public void setLastAccessTime(Date lastAccessTime)
{
this.lastAccessTime = lastAccessTime;
}
You know wwhat I change to "2008-01-01" and it worked for me
You need 2 digits for mionth
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>u.setLastAccessTime(Date .valueOf(" 1999-7-26" )); should be
u.setLastAccessTime(java.sql.Date.valueOf("1999-07-26"));
I checked it and one digit is gicves exactly that exception
ASKER
cheers
> so is the code which the author has provided got error in it,since i am running his code
not that I can see, why do you think it has an error?
not that I can see, why do you think it has an error?
btw zolf, the missing zero was NOT the reason for your error
java.util.Date dd = f.parse(("1999-7-26", new ParsePosition(0));
u.setLastAccessTime(dd);