Skip to Main Content

Java and JavaScript in the Database

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!

Hello ! Is there any way to create custom Scheduled jobs.

Anurag19Oct 2 2021

I am trying to develop an API to manage incomplete orders (which were meant to be processed after a successful payment but didnt) and later complete them periodically. Went through the documentation about Scheduled jobs but its for Shoppers/users.

Comments

that's your default temp folder

once you pick a directory to open or save to, that will be the new default, with a list of running directories down the left

Glen Conway

Dear Puzzled,

If you want the File -> Open dialog's Location drop-down list to default to a specific directory, just add this to your sqldeveloper installation's sqldeveloper.conf file:

AddVMOption -Djava.io.tmpdir=<desired_directory>

Not sure if other features use java.io.tmpdir, so there may be unexpected side-effects.

EdStevens

thatJeffSmith-Oracle wrote:

that's your default temp folder

once you pick a directory to open or save to, that will be the new default, with a list of running directories down the left

Nope.  It still defaults to the temp dirctory, forcing me to navigate to where the scripts are saved.

EdStevens

Nope.  It still defaults to the temp dirctory, forcing me to navigate to where the scripts are saved.  And yes, I did restart SQL Dev after modifying the conf file.

I have now backed out the change.

Answer

19.1 on a mac

SQL Worksheet

Open .. navigates to a random folder, opens file.

Hits open dialog again.

I'm starting at same random folder from just previous go.

Are you not seeing the same, or perhaps you're doing something differently?

The default place to look for scripts has no connection to where SQLDev looks to open or save files to.

Marked as Answer by EdStevens · Sep 27 2020
EdStevens

Ah, that works - within a SQL Dev session.  I was expecting persistence, such that the next time I open SQL Dev, then 'file > open' would default back to my chosen location.  I do see that it saved the location as a 'recent' in the list on the left, and that will suffice.  Thanks for the help.

Glen Conway

Glad to see you are satisfied with the default behavior that @"thatJeffSmith-Oracle" described.  As for overriding java.io.tmpdir, it definitely works for me if I have an open worksheet.

With no worksheet open then, yes, the Open dialog's Location selector defaults to something even worse than AppData\Local\Temp.

Cheers

1 - 7

Post Details

Added on Oct 2 2021
2 comments
50 views