[How to] How to call a function defined in the package

The following sql is to call a function defined in the package

declare

  outVal number;
begin
   -- Call the function
   outVal := mypackage.myfunction (100);
end;

Howto: Find the biggest value in the column

This article teaches you how to get the biggest value in the columns in the same table.

It could be done by the built-in function GREATEST

However, it does not work when there are null values in the column.

You may use NVL function as a work around.

[Resolved] Ping Connection Pool failed for XXX Class name is wrong or classpath is not set for : com.mysql.jdbc.jdbc2.optional.MysqlDataSource

Tried to setup the connection pool for mysql in Glassfish today. The following error occurs when I tried to ping the connection pool.

Error Message
Ping Connection Pool failed for XXX Class name is wrong or classpath is not set for : com.mysql.jdbc.jdbc2.optional.MysqlDataSource Please check the server.log for more details.

Solution
1. Download Connector / J
http://dev.mysql.com/downloads/connector/j/

2. Put it in the glassfish's lib folder

3. Restart the server

4. Ping Successfully!

MySQL, Glassfish 4, Connection Pool Setup

Java compiler level does not match the version of the installed Java project facet.

Created a dynamic web project and set GlassFish 4.0 as the testing server.  The following error occured:

Java compiler level does not match the version of the installed Java project facet.

Solution:
1. Right click and choose Quick Fix

2. Change Java compiler level to 1.7

3. Done!

[RESOLVED] java.lang.ClassNotFoundException org.springframework.web.servlet.DispatcherServlet Spring MVC3 Maven Eclipse

The following error occurs when deploying app to the testing machine, using Eclipse + Spring MVC 3 + Maven.

java.lang.ClassNotFoundException org.springframework.web.servlet.DispatcherServlet

Solution:
1. Right Click the project -> Properties

2. Go to Deployment Assembly

3. Click Add

4. Select Java Build Path Entries

5. Click "Maven Dependencies"

 

6. Click OK

7. Done and deploy again without error.

[RESOLVED] org.apache.jasper.JasperException: PWC6345: There is an error in invoking javac. A full JDK (not just JRE) is required

Tried to run some jsp pages in eclipse with Glassfish 4 server.  The following error occurs:

org.apache.jasper.JasperException: PWC6345: There is an error in invoking javac.  A full JDK (not just JRE) is required

Solution:
You have to choose jdk when you are configure the server runtime.

 

HTTP Status 500 - Internal Server Error
GlassFish Server Open Source Edition 4.0

Install Hibernate in Eclipse

The Hibernate plugin for Eclipse can be found in the following path:

http://download.jboss.org/jbosstools/updates/stable/

Installation:
1. Click "Help" -> "Install New Software"

2. Type the URL above to "Work With" and filter by keyword "hibernate"
http://download.jboss.org/jbosstools/updates/stable/

3. Select all items and click "Next"

4. Accept....

5. Click "OK" for the installation

6. Restart the Eclipse..

7. Done.. and check..

Windows Azure: Storage account xxx has 1 container(s) which have an active image and/or disk artifacts. Ensure those artifacts are removed from the image repository before deleting this storage account.

System returns the following error when deleting the "STORAGE" and results in the following error:

Storage account xxx has 1 container(s) which have an active image and/or disk artifacts. Ensure those artifacts are removed from the image repository before deleting this storage account.


Solution:

:

It is because some disks are still existed in Azure, you must delete all of them before removing the "STORAGE"

How to disable Java in Chrome Browser (Security)

U.S. warns on Java software as security concerns escalate
Extracted from Reuters
(Reuters) - The U.S. Department of Homeland Security urged computer users to disable Oracle Corp's Java software, amplifying security experts' prior warnings to hundreds of millions of consumers and businesses that use it to surf the Web.
http://www.reuters.com/article/2013/01/11/us-java-security-idUSBRE90A0S320130111


How to disable Java Plugin in Chrome


1. Open the chrome browser, and type chrome://plugins/ in the URL

2. Search Java in the list

3. Click Disable