Java Solutions: 2021

Saturday, December 11, 2021

Use the Speak to read aloud your Microsoft Office document - Listen to your Word document

If you would like to know how your Word document sounds, you may follow the steps below to let the Speak read your Microsoft Word document to you.

A. Add Speak to the Quick Access Toolbar

1. Click on the Custom Quick Access Toolbar located in the top-left corner of the Work editor and select More Commands.

2. In the popped-up window, select All Commands from the left, scroll down to select Speak, click the Add button to add Speak to the Customize Quick Access Toolbar on the right side, and click the OK button at the bottom.

3. Check that the Speak selected text icon displays in the top-right corner.

B. Select the text you want to hear and click the Speak to let it read the text aloud.

Monday, December 6, 2021

Solved - java.sql.SQLException: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

The issue occurs when the archivlogs or backups ocupy too much space. You can follow the steps below to remove some of the files.

1. Login to your system as the oracle user.

2. Type rman on the command line and hit the enter.

[oracle@linux]$> rman

3. Connect to the target database.

RMAN> connect target

4. Delete the backups or obsolete backups.

RMAN> delete obsolete;

or delete all backups:

RMAN> delete backup;

5. Remove archive logs.

RMAN> delete force copy of archivelog all;

6. RMAN> exit

Wednesday, November 24, 2021

Solved - Your camera has been occupied by other apps, please release the privilege and try again

If you get the message while turning on the video at a Zoom meeting, you may fix it following the steps below.

1. Click Start and select Settings.

2. Click on the Apps to open the Apps & Features window.

3. Click on the Camera to show the Advanced options.

4. Click on the Advanced options to open the Camera window. Scroll down and click on the Reset button to reset the camera.

5. Restart your computer.

Friday, November 5, 2021

Solved - unrecognized project; missing plug-in

After I cloned a web service project, I got a "unrecognized project; missing plug-in" message when I was trying to open it in NetBeans.

I fixed it by installing the Java EE base plug-in by following the steps below.

1. Click the Tools in the top menu of Apache NetBeans IDE and select Plugins.

2. Select the Available Plugins tab in the pop-up Plugins window.

3. Right click on the Java EE base plug-in and install it.

Before you install the Java EE base plug-in, check the nbproject/project.xml file to confirm that the type is <type>org.netbeans.modules.web.project</type>

Sunday, May 2, 2021

Solved - The group policy setting for bitlocker startup options are in conflict and cannot be applied

To fix this problem:

1. Click at the Window icon at the bottom-left corner of your PC, and type regedit. Then, open the regedit window.

2. Delete all the entries in the HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\FVE directory except the first Default entry.

3. Restart your computer.

-----------------------------------------------------------------------------------------------------------------

If you have ever asked the questions below, you will benefit from reading this book.
What is the meaning of life?
Why do I have to suffer?
How can I have the life I like to have?
How can I be the person I want to be?
How can I have good and harmonious relations with others?

What is the true meaning of spiritual practice? Check it out here.

Cannot save to USB drive without BitLocker encryption - Windows

After you insert a USB drive to your computer, the following message pops up.

Since you don't want the drive to be read-only, you select to encrypt the drive. Then, the follow message shows up.

So, you click the Cancel button. Upon you are trying to save a file on the USB drive, it shows the following message.

To fix this problem:

1. Click at the Window icon at the bottom-left corner of your PC, and type regedit. Then, open the regedit window.

2. Delete all the entries in the HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\FVE directory except the first Default entry.

3. Restart your computer.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Monday, April 19, 2021

how to set the default java platform in NetBeans

1. Open the netbeans.conf file located in C:\Program Files\netbeans 11.0\etc directory.

2. Search the file for netbeans_jdkhome.

3. Change the value of the netbeans_jdkhome to the desired java path and save the change.

4. Restart the NetBeans IDE.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Thursday, April 15, 2021

Not copying library C:\MyProjects\ImportantProject , it's a directory.

When I was doing a Clean and Build on the ImportantProject in NetBeans, I got the following messages in the Output.

Created dir: C:\MyProjects\ImportantPorject\build

Updating property file: C:\MyProjects\ImportantPorject\build\built-jar.properties

Created dir: C:\MyProjects\ImportantPorject\build\classes

Created dir: C:\MyProjects\ImportantPorject\build\empty

Created dir: C:\MyProjects\ImportantPorject\build\generated-sources\ap-source-output

Compiling 35 source files to C:\MyProjects\ImportantPorject\build\classes

Copying 21 files to C:\MyProjects\ImportantPorject\build\classes

compile:

Copying 1 file to C:\MyProjects\ImportantPorject\build

Not copying library C:\MyProjects\JRx30 , it's a directory.

Copy libraries to C:\MyProjects\Vendors\lib.

When I expanded the ImportantProject and then the Libraries folder, I saw that the C:\MyProjects\ImportantPorject had been part of the libraries.

After removing the C:\MyProjects\ImportantPorject from the libraries, the red line of message disappeared.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Tuesday, April 13, 2021

ORA-03113: end-of-file on communication channel

When you were trying to start the Oracle database, you had the following on your screen.

SQL> STARTUP

ORACLE instance started.

Total System Global Area 6442450944 bytes

Fixed Size 2938792 bytes

Variable Size 1224738904 bytes

Database Buffers 5200936960 bytes

Redo Buffers 13836288 bytes

ORA-03113: end-of-file on communication channel

Process ID: 13761

Session ID: 237 Serial number: 2961

To fix this problem, first check if it was due to no free memory available for the database. Run the command free -g as the root user.

[root@testMachine]# free -g

total used free shared buff/cache available

Mem: 3 0 2 0 0 2

Swap: 3 3 0

If it is necessary, remove some of the old log files in the directory of $ORACLE_BASE/diag.

Reboot the linux machine to release the memory occupied by processes.

Restart the database.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Monday, March 8, 2021

CrystalReports: ORA-01840: input value not long enough for date format

Error opening CustomerInfo report.

Unexpected database connector error

ORA-01840: input value not long enough for date format

The above error will happen if a date field in the database has a NULL value.

You can fix it by either changing your SQL to replace the NULL value with a valid date value such as using the function nvl(fieldName, ValidDate), or making the date field in the database not null.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Tuesday, February 2, 2021

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

When you were trying to connect to your Oracle database, you received the following errors.

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3640
Additional information: 2007875791
Process ID: 0
Session ID: 0 Serial number: 0

Here are the steps to fix it.

SQL>sqlplus /NOLOG
SQL> connect / as sysdba;
SQL> SHUTDOWN IMMEDIATE

You may get the error message again.

       ERROR:
        ORA-01034: ORACLE not available
       ORA-27101: shared memory realm does not exist
       Linux-x86_64 Error: 2: No such file or directory
       Additional information: 3640
       Additional information: 2007875791
       Process ID: 0
       Session ID: 0 Serial number: 0
SQL> STARTUP
ORACLE instance started.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Saturday, January 23, 2021

400 Bad Request / request header or cookie too large / nginx

You see this error display on your web browser when you are navigating to some site.

To fix it, you need to delete the cookies specific to the website your trying to open.

In Chrome, click the three verticle dots on the top-right corner and select Settings.

Scroll down to the Privacy and security section and click on the Cookies and other site data.

In the new window, click on See all cookies and site data

Find your website, open it and remove all the cookies.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Friday, January 15, 2021

sftp in Java

The code below shows how to transfer a file from one machine to another via sftp.

Session session = null;
ChannelSftp sftp = null;

try {
JSch jsch = new JSch();
session = jsch.getSession(username, remoteIPAddress);
session.setPassword(password);
session.setConfig("StrictHostKeyChecking", "no");
session.connect();

com.jcraft.jsch.Channel channel = session.openChannel("sftp");
channel.connect();
sftp = (ChannelSftp) channel;

//Get a file from a remote machine
String path = sftp.pwd(); //remote path

//If the file is located in a different directory, switch to that directory
sftp.cd("<the path>");
sftp.get("<the file>", "<local directory where you want the file to be>");

//Send a file to a remote machine
sftp.lcd("<local directory that has the file>");
sftp.put("<file name>", ".");
sftp.exit();
sftp.disconnect();
session.disconnect():

} catch (JSchException je) {
Log.instance().error(je);
System.out.println("Failed to restart rx30css for the store.");
}

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Execute multiple commands one after another in Java

Let's say you want to execute the commands below on a remote Linux machine using a java program to restart program A.

cd /home/projectA
/home/projectA/stopProgramA
/home/projectA/startProgramA

You can use the code below to get them done.

JSch jsch = new JSch();
session = jsch.getSession(username, remoteIPAddress);
session.setPassword(password);
session.setConfig("StrictHostKeyChecking", "no");
session.connect();

ChannelExec channelExec = (ChannelExec) session.openChannel("exec");
channelExec.setCommand("cd /home/projectA && /home/projectA/stopProgramA && /home/projectA/startProgramA");

channelExec.setErrStream(System.err);
channelExec.connect();

TimeUnit.SECONDS.sleep(10);
channelExec.disconnect();
channelExec = null;

session.disconnect();

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.