tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Valera Molyakov" <val...@kompan.com.ua>
Subject Re: Urgent : Problems with JDBC Date formats...
Date Tue, 23 Oct 2001 15:02:36 GMT
Hi !

Standart JDBC Date (java.sql.Date) format : "yyy-mm-dd".

----- Original Message -----
From: "Dmitri Colebatch" <dim@bigpond.net.au>
To: "Shah, Chintan V (Chintan)" <cvshah@lucent.com>
Cc: <tomcat-user@jakarta.apache.org>
Sent: Tuesday, October 23, 2001 9:43 AM
Subject: RE: Urgent : Problems with JDBC Date formats...


> In that case perhaps you could try using the SQL TO_DATE function.  I'm
> not sure what the proper syntax for this is, but in Oracle you could use
> something like:
>
> "Select * From <table> WHERE (<dateField> = TO_DATE('2001/01/01',
> 'yyyy/mm/dd'))"
>
> failing that, see if you can change the default date format in the
> database.
>
> hth
> dim
>
>
>
> On Tue, 23 Oct 2001, Shah, Chintan V (Chintan) wrote:
>
> > Thanks for the guidance, but the problem is...my whole application is
> > ready...i'm not using PreparedStatement anywhere... (to be honest, i've
> > never used also...). And my SQL Statements are built dynamically in my
Java
> > Beans depending on the input coming from the users. So, I would prefer a
> > solution, which doesn't force me to make drastic changes in my code...
> >
> > thanks and regards,
> > Chintan
> >
> > -----Original Message-----
> > From: Dmitri Colebatch [mailto:dim@bigpond.net.au]
> > Sent: Tuesday, October 23, 2001 11:11 AM
> > To: 'tomcat-user@jakarta.apache.org'
> > Subject: Re: Urgent : Problems with JDBC Date formats...
> >
> >
> > I cant guarentee that this will work with Access and SQL server, but the
> > proper way to do what you're trying to do is use a PreparedStatement
with
> > setDate(2, new Date(2001, 1, 1)).
> >
> > hth
> > dim
> >
> > On Tue, 23 Oct 2001, Shah, Chintan V (Chintan) wrote:
> >
> > > Hi all,
> > >
> > > This is a very off-topic post (as perhaps it has nothing to do with
> > tomcat),
> > > but I hope people would like to guide me on this..
> > >
> > > I'm using Tomcat 3.2, Apache 1.3.19, Jdk 1.3, Jdbc-Odbc Driver on Win
NT
> > > 4.0.  I want my application to work with both the databases..i.e. with
> > > Ms-Access 2000 and SQL Server 7.0.
> > >
> > > I completed my whole application with Ms-Access, everything working
> > > fine..then I tried with SQL Server 7.0...by exporting databases from
> > > Ms-Access to SQL Server. For most of the parts of my code...which is
> > > interacting with DBs thru JDBC worked fine...except for some
syntactical
> > > changes... but the major problem is with field types of *DATE*.
> > > In Ms-Access, the field type is "Date/Time - short date" and in SQL
server
> > > it is "smalldatetime".
> > >
> > > E.g. SQL Stmt : "Select * From <table> WHERE (<dateField> =
#2001/01/01#)"
> > > gives desired results in MS-Access, but when the DB is SQL Server, it
> > gives
> > > error.
> > >
> > > And the same way, SQL Stmt : "Select * From <table> WHERE (<dateField>
=
> > > '2001/01/01')" gives desired results in SQL Server, but when the DB is
> > > Ms-Access, it gives syntax error, saying that data types mismatch in
> > > criteria expression.
> > >
> > > So, how should I deal with these types of things in my code, to make
it
> > > compatible with Ms-Access and SQL Server as well.
> > >
> > > Your guidance will be a great help for me.
> > >
> > > thanks and regards,
> > > Chintan.
> > >
> >


Mime
View raw message