How to add a Data Source on Oracle 11G Weblogic with JDeveloper 11gR2

Stics Post in JDeveloper, oracle，Tags: ,
25 September 2013
0

To add a Data Source from JDeveloper:

  1. View > Application Server Navigator
  2. Application Servers > IntegratedWebLogicServer
  3. R-click > Launch Administrative Console…
    -that should be i.e. like “http://127.0.0.1:7101/console/login/LoginForm.jsp”
  4. Login with user/password
  5. From Domain Structure open Services > select Data Sources
  6. New > Generic Data Source
  7. Specify the connection properties:
  • Name: MyConnectionDS (or whatever you defined in your Java app data source)
  • JNDI Name: comp/env/jdbc/MyConnectionDS or jdbc/PoliceConnectionDS
  • Database Type: Oracle
  • > Next
  • Database Driver: Oracle’s Driver (thin) for Instance Connections (versions 9.0.1 or later)
  • > Next
  • Supports Global Transactions
  • One-phase commit
  • > Next
  • Type in: Database Name, Host Name, Port, Database User Name, Password
  • > Next
  • Test Database Connection screen > click Test Your Configuration
  • if “Connection test succeeded.”, click Finish

Your new data source should be ready to use for local server run/debug.

 

 

 

 

How to check a Hard Disk’s health status

Stics Post in command line, windowz，Tags: ,
02 July 2013
1

You can check the health of your hard disk by using a command in Windows (S.M.A.R.T.).

  1. Start a cmd window
  2. wmic
  3. diskdrive get status

This should output the following result:

status
ok
ok

 

How to create a simple Backup script using windows HTA

Stics Post in html, Scripts, windowz，
10 June 2013
0

Prerequisites:

  • a notepad (I recommend: notepad++)
  • some HTML knowledge
  1. Start a simple HTML page and add the following as the main structure: 
    <head>
<title>Backup Reminder</title>
<HTA:APPLICATION
APPLICATIONNAME="Backup Reminder"
ID="myware"
VERSION="1.0"
CAPTION="yes"
BORDER="normal"
SYSTEMMENU="yes"
MAXIMIZEBUTTON="no"
MINIMIZEBUTTON="no"
ICON="gumware.ico"
SCROLL="no"
SCROLLFLAT="yes"
SINGLEINSTANCE="yes"
CONTEXTMENU="yes"/><style>
img{border: 0px}
input{color: blue; background-color: white; font-variant:small-caps;
font-family: Arial,Helvetica,sans-serif; border: 1px solid blue}
H1,H2,H3,H4,H5,H6,P,BODY,UL{font-family: Arial, Helvetica, sans-serif}
</style>
</head>

    More »

How to create a multiboot USB with XBoot 1.0 b14

Stics Post in technical, utilities, windowz，Tags: ,
23 May 2013
0
  1. Repartition and format the USB: Primary volume, 4k cluster size (default), FAT32 format.
  2. XBoot requires dot.NET Framework 4.0 installed on the system it will be run off
  3. Download a copy of XBoot 1.0 beta 14 and run it, not install required!
  4. Download your favourite ISO distros and drag-n-drop them on the XBoot “Drag-n-drop Box”
    (each one will prompt you what type of boot-loader it needs, major distros are listed and if not
    you should choose ISO file -iso/scan parameter for Linux distros and GrubForDOS iso emulation
    for Windows distros)
  5. Click on “Create USB”
  6. Select the USB from the list of drives and set boot-loader to Syslinux
  7. After a few minutes the drive will be ready

If you need to update an ISO already added, just drag the updated ISO to XBoot (keep same name as
previous entry) and Create USB without the boot-loader. This may be a bit messy sometimes but is doable to some extent. Most of the times you will have your menu changed, but you could edit it after the iso omport.

Notes:

  • You can use the internal QEMU emulator to check your USB or even better boot directly from a PC
  • You can also check this out for installing and using a permanent emulator for booting USBs
  • I have found that XBoot acts a bit weird on a 64bit Windows, at least surely Windows 8

How to make Firefox search from the address bar

Stics Post in tips-n-tricks，Tags: , ,
21 March 2013
0

1. Type the following in the address bar:

about:config

2. In the search field type:

keyword

Result:
keyword.URL
keyword.enabled

3. Double-click “keyword.enabled” to be set to false.

4. Double-click the “keyword.URL” to set your source search engine:

Bing: http://www.bing.com/search?q

 

Restart Firefox and enjoy searching from the address bar!

Create a Data Generator using sequence and a loop in Oracle DB

Stics Post in oracle, oracle pl/sql, Scripts，Tags: ,
01 March 2013
0

Create a sequence (i.e. “tmp” starting with 10001) to be used in statements:

CREATE SEQUENCE TMP
START WITH 10001
MAXVALUE 9999999999999999999999
MINVALUE 1

Enter the following in a DB-Tool editor:

begin
FOR Lcntr IN 1..10000
LOOP
insert into customer (surname, forname, some_id, some_field)
values ('SN' || tmp.nextval, 'FN' || tmp.nextval, 123456, 'abcdef');
END LOOP;
commit;
end;

Output should be something like this:

SN50076,FN50076,123456,abcdef
SN50077,FN50077,123456,abcdef
SN50078,FN50078,123456,abcdef
SN50079,FN50079,123456,abcdef
SN50080,FN50080,123456,abcdef
SN50081,FN50081,123456,abcdef

How to create a bootable usb to install Windows X

Stics Post in command line, windowz，Tags: ,
01 March 2013
0

Firstly, insert your USB  (WARNING: the following steps will erase ALL DATA on selected USB!!).

Open a cmd prompt and type “diskpart” to start the partitioning program:

list disk # <-- to list the disks on the system

# Disk ### Status Size Free Dyn Gpt
# -------- ------------- ------- ------- --- ---
# Disk 0 Online 931 GB 3072 KB
# Disk 1 Online 1944 MB 0 B
# Disk 2 Online 7498 MB 0 B <-- this will be our selected disk

select disk 2

# Disk 2 is now the selected disk.

clean

# DiskPart succeeded in cleaning the disk.

create primary partition

# DiskPart succeeded in creating the specified partition.

select partition 1

# Partition 1 is now the selected partition.

active # <-- make the partition active

# DiskPart marked the current partition as active.

format fs=ntfs quick

assign # <-- assign a letter to the drive

# DiskPart successfully assigned the drive letter or mount point.

Your drive is now ready to copy a loaded iso DVD of your version of Windows.

 

JMS error when running/debugging ADF application with JDev (10g)

Stics Post in JDeveloper, oracle ADF，Tags: ,
27 February 2013
0

If you get the following or similar error:

OC4J – (SEVERE) Failed to set the internal configuration of the OC4J JMS Server with: XMLJMSServerConfig (jms.xml)

You may need to delete all contents within the “persistence” folder:

jdev10.1.3.5.adf\jdev\system\oracle.j2ee.10.1.3.43.6\embedded-oc4j\persistence\

How to Factory Restore the system for various PC models

Stics Post in technical，Tags:
01 February 2013
0

Lenovo S10 : Lenovo OneKey Rescue System v7.0

  1. Press the “OneKey Recovery” button on right side of display (like and upside-down U)
  2. Click on “OneKey Recovery” icon on screen
  3. Choose “Restore from initial backup” and click “Next”
    WARNING: ALL YOUR DATA/PARTITIONS WILL BE ERASED!
  4. Click “Start”

Dell Inspiron N5110 : Dell DataSafe

  1. Press the F8 while booting the PC to get you to the windows “Advanced Boot Screen”
  2. Choose language and an administrator user and click Next to continue
  3. Click on “Dell DataSafe Restore and Emergency Backup”
  4. Choose “Select other System Backup and more options” and click “Next”
  5. Choose “Restore my Computer” and click “Next”
  6. Select the “Factory Image” from the list and click “Next”
  7. Choose “Restore without preserving new or changed files” and click “Next”
  8. Choose “Yes, continue”
    WARNING: ALL YOUR DATA/PARTITIONS WILL BE ERASED!
  9. Click “Next”
12345 Next Last