Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting quarters with two input date-parameters

748467Jan 22 2010 — edited Feb 8 2010
I have to find a way to get all the quarters between a startdate and an enddate, like 01-04-2009 (startdate) and 31-11-2009 (enddate). An extra condition is to count an extra quarter above the enddate, so the last quarter is 2010-01 (first quarter of 2010).

The desired result will be:

2009-02
2009-03
2009-04
2010-01

The start- and enddate are inputparameters.

How do I get this result?

Comments

User_64CKJ
The matter of the driver being on the run-time class-path of the applet, and its ability to connect to 'home' or remote servers is quite different.

The driver will need to be on the class-path for either. To achieve that, add the mssqlserver.jar to the archive attribute of the applet element.

To connect to a DB on a remote server, the applet would also need to be digitally signed (by you) and accepted (by the end user).
1 person found this helpful
835813
Thanks for you reply,
can you please tell me how to digitally sign the applet
835174
Hope this help:

<object
classid = "clsid:8AD9C840-044E-11D1-B3E9-00805F499D93"
width = 1 height = 1
name = "Application Web Client"
codebase = "http://java.sun.com/j2se/1.4.1/download.html">

<param name = CODEBASE VALUE = "." >
<param name = ARCHIVE VALUE = "myjar1.jar,
sqljdbc4.jar"
<param name = CODE VALUE = "applet.myapplet.class" >
<param name = NAME VALUE = "Application Web Client" >
<param name = "type" VALUE = "application/x-java-applet;version=1.1" >
<param name = CLIENT_INI VALUE = "client.ini">
</object>
Kayaman
832171 wrote:
Hope this help:
codebase = "http://java.sun.com/j2se/1.4.1/download.html">
Nicely done!

If they gave prizes for worthless advice here, you'd definitely get one.
User_64CKJ
..can you please tell me how to digitally sign the applet
See the Generating and Verifying Signatures lesson (http://download.oracle.com/javase/tutorial/security/apisign/index.html) of the Java Tutorial.
User_64CKJ
See also http://stackoverflow.com/questions/4897758/connecting-to-remote-databasemssqlserver-using-applet
803795
I suggest you have your applet talk to a servlet. The servlet actually talks to the database (and holds the userID/password). This way, you aren't embedding the userID/password to the database in the applet where someone might get it and have direct access ot your database (a security concern).

I also suggest you review your design to see if separation of concerns might be a better choice (model view controller (MVC) design).
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 8 2010
Added on Jan 22 2010
18 comments
12,630 views