0
Trying to create a web application where users in different time zones will access it. How do I set up the DB and application to handle this I am using Oracle 11g and Java EE?
Wiki User
∙ 7y ago
All access is relative to the local time zone of the server, so you simply record the local time. Knowing the server's time zone allows you determine how many hours behind or in front of UTC you are and knowing the user's time zone allows you to do the same for the user, thus you can calculate the time difference by subtracting one from the other.
For example, suppose the server is in Los Angeles, USA and the user is in Rome, Italy. Los Angeles is UTC -8 while Rome is UTC +1, so the time difference is 9 hours in total, such that Rome is 9 hours ahead of Los Angeles. So if a user accesses the server at 10:00 Los Angeles time, it would have been 19:00 in Rome.
As another example, suppose the server is in Helsinki, Finland (UTC +2), and the user is in Toronto, Canada (UTC -5). The time difference is 7 hours, such that Toronto is 7 hours behind Helsinki. So an access at 10:00 in Helsinki occurred at 03:00 in Toronto.
Wiki User
∙ 7y ago
Wiki User
∙ 7y agoIf by "this" you mean handling the different time zones, I would suggest you convert all times to some standard time; a good option for this is UTC.
Add your answer:
Earn +20 pts
What is the difference between oracle and visual basic which one is the best suited for backup database system?
Oracle is a RDBMS software, means, Oracle holds the database (data created/updated using application). Visual basic is tool to develop applications & this is from Microsoft. You can write programs/application to access the data from the RDBMS like Oracle, Microsoft SQL Server, etc. Since the functionality differs (i.e. Oracle = RDBMS & Visual basic =Application development Tool) for the two software applications, "which one is the best" can not be answered.
List some dbms and rdms software?
The name of few DBMS are FOXPRO, MS-ACCESS, SQL Server, My SQL, ORACLE, etc.
What is definition of front end tool and back end tool?
Front end tools: are the tools which are used to design the user interface of the application Example Visual basic, .Net,Java,C,C++ etc.Back End tools: are the tools which are used to design data base(storage design) of the application Example SQL,Ms-Access,Oracle,DB2,SyBase etc.
How do you deal with installing Java Access Bridge?
So, I followed every instruction in oracle, yet when I try to install a program(which needs access bridge) it gives me this error: java.awt.AWTError: Assistive Technology not found: com.sun.java.accessibility.AccessBridge I did absolutely EVERYTHING in the oracle site about 5 times. Still won't work. Anyone can help?
Why toplevel class cannot be private?
it can access in entire application.
Which is perfect backend for asp.net application?
Ms Sql, Oracle, Ms Access
What is the most commonly used database application?
Oracle, MS SQL Server, Informix, Sybase, DB2, MySQL And for "toy" applications, MS Access.
What is the difference between oracle and visual basic which one is the best suited for backup database system?
Oracle is a RDBMS software, means, Oracle holds the database (data created/updated using application). Visual basic is tool to develop applications & this is from Microsoft. You can write programs/application to access the data from the RDBMS like Oracle, Microsoft SQL Server, etc. Since the functionality differs (i.e. Oracle = RDBMS & Visual basic =Application development Tool) for the two software applications, "which one is the best" can not be answered.
How can I access important data through a rich internet application if my Internet connection is down?
One can access important data through a rich internet application if their connection is down by using software from the Oracle website. They have this software available in their downloads section.
What has the author James J Hobuss written?
James J. Hobuss has written: 'Application development with PowerBuilder' -- subject(s): Application software, PowerBuilder 'Building Access Web sites' -- subject(s): Design, Microsoft Access, Web sites 'Building Oracle Websites' -- subject(s): Database design, Design, Internet programming, Oracle (Computer file), Web sites 'Application development center' -- subject(s): Development, Application software, Computer software
What are the differences between Access and Oracle?
The difference between Access and Oracle is Access has minimum security features and you can create a small to medium sized database. Oracle has NY security, which allows you to determine who can or can not get access to your data. Access you can't add too many users without it getting slow, and Oracle allows you to add thousands if you want to.
Is Excel a true database system like Access and Oracle?
No. Microsoft Excel is an accounting worksheet application, not a database. Microsoft Access is a small, simple, but capable, individual-user database application, and Oracle is among the largest of Enterprise-class database applications, and can accommodate the needs of gigantic corporations.
What are examples of database packages?
oracle, access,
List out the dbms softwares?
*Altibase *Oracle * SQL server * Fox Pro * MS-Access * Sequel-Pro(mac)
Examples of database packages?
MySQL, Oracle, MS Access, MS-SQL, pretty much any software that is related or its sole purpose is for databases is a database package.
How do I create a form which will then upload to a database that I can access in Microsoft Access?
Have your form's input insert into a database (SQL, Oracle, etc) then access that database through Access's ODBC connection.
Which database object provide fast access to data in the rows of table oracle?
index
