Sajida:
I've just had the same issue come up with the different databases that our
Expresso framework supports - it ran into the date/time issue on DB2 and
Oracle. We solved it by having a parameter/setup value that specifies the
data type to use for "datetime" (it's DATE(0) on Oracle, for example) and
the format to use for date/time values for the database.
Hope that's helpful
Mike
Javacorporate Ltd
http://www.javacorporate.com
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's
> Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
> Sajida Kalsoom
> Sent: Saturday, September 25, 1999 10:43 AM
> To: [EMAIL PROTECTED]
> Subject: Re: how to connect servlets with database through odbc
> onlinux/solaris
>
>
> Dragomir D,
>
> I appreciate your help. I have no problem in porting my
> software on any of
> the operating system linux , solaris, nt and any of the
> database oracle
> mysql sqlserver access but problem that i am facing is in
> date type field. Date format is different on each database such as in
> oracle in order to insert datetime we have to provide mask like that
>
> to_date('09/11/1999 00:00:00', 'DD/MM/YYYY hh:mi:ss')
>
> in mysql date format is yyyy/mm/dd
>
> where as in sqlserver date format is mm/dd/yyyy
>
> there are so many templetes in my software that use datetime
> info its very
> difficult to change them and keep upto date for each
> database. thats the
> reason for using odbc connection.
> I want to get rid of this do you have any idea .
>
> ----- Original Message -----
> From: Dr. Dragomir D. Dimitrijevic <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, September 25, 1999 10:41 AM
> Subject: Re: how to connect servlets with database through odbc
> onlinux/solaris
>
>
> Here is a killer approach to develop/deploy servlet/database
> apps. Works like charm and I sincerely recommend it.
>
> My last project http://www.e-bank.co.yu was developed
> in the dollowing environment:
> PRODUCTION: Linux on Intel, Apache server, Oracle 8 database.
> DEVELOPMENT: NT, Apache, MS-Access database through
> JDBC-ODBC bridge (had some troubles with Bill Gates-like bugs ;-) ;-))
> DEMO ENVIRONMENT for chasing customers: Win 95
> laptop, JSDK 2.1 servlet runner, MS-Access
>
> You can download JDBC-ODBC bridge from Sun, and Oracle
> Java drivers from Oracle. If you run Oracle on NT, go to
> Oracle directly, not through ODBC. I've heard some
> people measured and ODBC slows down stuff dramatically.
> Also Java driver that use native code are faster than pure
> java version of
> the
> Oracle driver.
>
> NOW, how to switch quicly between platforms and databases?
> Have something in your servlet like:
>
> public class MyServlet extends HttpServlet
> {
> private String dbDriver;
> private String dbURL;
> private String dbUID;
> private String dbPWD;
>
> public void init( ServletConfig config )
> throws ServletException
> {
> super.init( config );
>
> dbDriver = getInitParameter("driver");
> dbURL = getInitParameter("url");
> dbUID = getInitParameter("uid");
> dbPWD = getInitParameter("pwd");
>
> try
> {
> Class.forName( dbDriver );
> }
> catch ( ClassNotFoundException e )
> {
> throw new UnavailableException( this, e.getMessage() );
> }
> }
>
>
> private Connection connect()
> throws SQLException
> {
> return DriverManager.getConnection( dbURL,dbUID, dbPWD );
> }
> }
>
> By changing drivers in the initialization file, you
> switch between database types.
> Trust me, portability was great. Java at its best.
>
> Cheers
>
> Dragomir Dimitrijevic
>
> P.S. Don't even think of putting MS-Access in the production
> environment if you are using JDBC-ODBC bridge. MS-Access
> ODBC driver is not thread safe. Don't know how things work
> with Access bridge.
> ----------
> From: Sajida Kalsoom[SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, September 25, 1999 01:04 PM
> To: [EMAIL PROTECTED]
> Subject: how to connect servlets with database through odbc
> onlinux/solaris
>
> <<File: ATT00000.html>>
> Hello Users,
>
> I am working on linux and solaris 7 intel/sparc , i want
> that my servlets
> connect with database on oracle/mysql server through odbc is
> there any thing
> in solaris/linux like 32bit odbc in winnt. I some body knows
> please tell me
>
> regards
> sajida
>
> ______________________________________________________________
> _____________
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
> http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ______________________________________________________________
> _____________
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
> http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
