u can also use JSQLConnect ..
Dwld the trial version from http://www.j-netdirect.com/Downloads.htm
Thanks
Bhu1
-----Original Message-----
From: Shi Zili [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 07, 2002 5:29 PM
To: JDJList
Subject: [jdjlist] Re: sql Date
It is better for you to download one Type 4 SQL Server JDBC driver from
microsoft
http://www.microsoft.com/sql/downloads/default.asp
please pay attention to the usage of this JDBC driver .
----- Original Message -----
From: "Emmanuel Eze" <[EMAIL PROTECTED]>
To: "JDJList" <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 8:12 PM
Subject: [jdjlist] Re: sql Date
> I get the error message when i use the prepared statement:
> [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
>
> I am connecting to an MS SQL Server 2000 using JDBC-ODBC brige.
>
> -----Original Message-----
> From: Shi Zili [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 07, 2002 11:29 AM
> To: JDJList
> Subject: [jdjlist] Re: sql Date
>
>
> Use method prepareStatement of Class Connection to create statement
instead
> of createStatement
>
> PreparedStatement pstmt = con.prepareStatement("INSERT INTO
> LOG(logtime,event) values (?,?)");
> > java.sql.Date sqlDate = new java.sql.Date(birthday.getTime());
> String message = ....;
>
> after you can pass sqlDate as parameter to the statement through method
> setDate
>
> pstmt.setDate(1, sqlDate );
> pstmt.setString(2, message );
>
> Now,
> pstmt.executeUpdate();
>
> to insert this record to table
>
>
>
> > java.sql.Date sqlDate = new java.sql.Date(birthday.getTime());
> >
> > and to pass it as parameter of the setDate(java.sql.Date) method
> >
> > ----- Original Message -----
> > From: "Emmanuel Eze" <[EMAIL PROTECTED]>
> > To: "JDJList" <[EMAIL PROTECTED]>
> > Sent: Tuesday, May 07, 2002 11:03 AM
> > Subject: [jdjlist] sql Date
> >
> >
> > > Hi all,
> > >
> > > Can somebody pls tell me how I can insert a Date type into a database
> > table
> > > with a Date datatype?
> > >
> > > I have the year, month, and day as interger values. I need to convert
> > these
> > > values into an sql Date object so I can now insert the Date object
into
> > the
> > > table, right?
> > >
> > > I have the folllowing code:
> > > Calendar cbirthday = null;
> > > java.util.sql birthday = null;
> > > .
> > > .
> > > .
> > > cbirthday = Calendar.getInstance();
> > > cbirthday.set(Integer.parseInt(year), Integer.parseInt(month),
> > > Integer.parseInt(day));
> > > birthday = cbirthday.getTime();
> > >
> > > This last statement throws a cast exception! Even when I chnage it
to:
> > > birthday = (java.sql.Date) cbirthday.getTime();
> > >
> > > Pls tell me what I'm doing wrongly.
> > >
> > > Emma
> > >
> > >
> > > To change your membership options, refer to:
> > > http://www.sys-con.com/java/list.cfm
> > >
> >
> >
> > To change your membership options, refer to:
> > http://www.sys-con.com/java/list.cfm
> >
> >
> >
>
>
>
> To change your membership options, refer to:
> http://www.sys-con.com/java/list.cfm
>
>
> To change your membership options, refer to:
> http://www.sys-con.com/java/list.cfm
>
>
>
To change your membership options, refer to:
http://www.sys-con.com/java/list.cfm
http://www.sys-con.com/java/list.cfm
