Problem in importing excel with date/ timestamp field using oracle sql-developer

I tried to upload file in excel file to the sqldeveloper and faced problem date is null or invalid format


below is the steps how to solve it

Local Variable vs Instance Variable

What is the difference between instance variable and local variable?

How to Send Email Notification In TRAC System

you can Get the notification by small configuration in the trac.ini

trac.ini is found in your project that has been created by the trac system

search by  [notification]

Change the logo of the project #TRAC

Hi Dears,

here will find an easy steps to change the logo and Title of the home page of the TRAC project.

you all will know that it's found in the trac.ini file, which is in the new project.

Open Source Bug Tracking System

Hi,

I was trying to find any opensource system that Allow to Track the tickets and Assigning the taskes

I had searched alot and found many resources

but the most professional one was BugZilla and Mantis but it is recommended to be installed on lunix OS (ubuntu for EX)

Change Date format d/m/yyyy in Birt Reporting Tool

I am working now in some reporting tasks , and found that Birt one of the most popular  open source Reporting tool with full integration with Java,

But I found a little problem in solving a small issues , like Changing the view Date

below are some basic steps will help you to change the view simply .

Change the orientation in Birt reporting tools to Landscape and portrait

I am just joined the Birt reporting tool, one of the most popular reporting tools in java , and open source too,

using the help I could developed the report and deployed it on the web and Export it to PDF and EXCEL in easy way and few steps .

the problems come when I want to change the orientation from portrait to landscape

I had search alot , I think that my BIRT version wasn't new enough , it only support from the IDE to make the view Fixed layout or Auto Layout

then 

HOW TO SOLVE IT :

what is SSL , https ?

SSL stands for Secure Sockets Layer. It is a protocol which creates a secure connection between a client and the server over which to send information.

SSL works by using a cryptographic system that uses two keys to encrypt data. The first key is a private or secret key, only known to the recipient of the message. The second key is a public key, known to everyone. Netscape Navigator and Internet Explorer both support SSL and many websites use the protocol to obtain confidential user information, such as credit card numbers.

As a general rule, you can tell whether a URL requires an SSL connection if it begins with “https” instead of “http”.
A valid SSL Certificate is an assurance that information which you will share on this site, will be sent in an encrypted, safe way.

An SSL Certificate will contain information on the domain name, its owner and the physical location of the owner and the validity dates of the certificate. SSL Certificates are thus a useful tool in determining whether websites are trustworthy or not. Many online shoppers will not risk buying items on a non-secure site.



More Reference :

• How SSL works tutorial - with HTTPS example
• SSL Certificate Explained  
• what is HTTPS ?

SAX / DOM / STAX

here is a small comparison between SAX, DOM and STAX

╔══════════════════════════════════════╦═════════════════════════╦═════════════════════════╦═══════════════════════╦═══════════════════════════╗
║          JAXP API Property           ║          StAX           ║           SAX           ║          DOM          ║           TrAX            ║
╠══════════════════════════════════════╬═════════════════════════╬═════════════════════════╬═══════════════════════╬═══════════════════════════╣
║ API Style                            ║ Pull events; streaming  ║ Push events; streaming  ║ In memory tree based  ║ XSLT Rule based templates ║
║ Ease of Use                          ║ High                    ║ Medium                  ║ High                  ║ Medium                    ║
║ XPath Capability                     ║ No                      ║ No                      ║ Yes                   ║ Yes                       ║
║ CPU and Memory Utilization           ║ Good                    ║ Good                    ║ Depends               ║ Depends                   ║
║ Forward Only                         ║ Yes                     ║ Yes                     ║ No                    ║ No                        ║
║ Reading                              ║ Yes                     ║ Yes                     ║ Yes                   ║ Yes                       ║
║ Writing                              ║ Yes                     ║ No                      ║ Yes                   ║ Yes                       ║
║ Create, Read, Update, Delete (CRUD)  ║ No                      ║ No                      ║ Yes                   ║ No                        ║
╚══════════════════════════════════════╩═════════════════════════╩═════════════════════════╩═══════════════════════╩═══════════════════════════╝

there are different approaches for parsing an xml source. You should select proper approach for your needs. You may choose one of these:

• DOM - Document Object Model,
• SAX - Simple API for XML,
• StAX – Streaming API for XML

Let’s discuss each one.

The "Reference" reference is not defined by the implementation. #Solving #SCA #RSA #RDA

when you are trying to make a components and composites in SCA using RAD ,

you will found that there are an error due to the naming in Reference in the compost file.

how to add “Server view” in Eclipse / RSA Rational Software Architect ?

I had installed my RSA 

while I was working , I wanted to configure my web-sphere server , so I searched over to Server view "windows --> show view --> servers"

and they didn't show up !!

How to configure proxy settings in eclipse

Often times, Eclipse IDE may need access to the Internet for some plugins install and update. If your computer is behind a proxy server

then you need to handle the proxy of in the Eclipse to go throw the internet

What is GWT ? Why we want to use GWT ?

GWT :

Google Web Toolkit (GWT) is an open source Java software development framework that makes writing AJAX applications easy.

Named Native Query Vs Native Query Vs HQL / JPQL

there are some missing up with understanding the difference between the Native Named Query and Native Query and HQL , and a lot of headache about the the performance issue in using them.

How can we make a Empty interface ?

we can make an empty interface that to call it and make that configuration to the Compiler to take care about how to deal with the class that implement that interface.

What is SQL Injection ? how to prevent my website from it?

What is SQL Injection

• SQL Injection is a type of web application security vulnerability in which an attacker is able to submit a database SQL command which is executed by a web application, exposing the back-end database. 

Tomcat version 6.0 only supports J2EE 1.2, 1.3, 1.4, and Java EE 5 Web modules

I had this problem when I was adding my new server(Tomcat 6), While I was configured an old server (Tomcat 7) for the same project

Difference between Database and Data Source ?

A data source is simply something your program relies on to get data. A database is a kind of data source that persists data to some digitized form. Other data sources include files, services, etc — these all provide data to your programs.

which is better to Packaging EJB in JavaEE 6 WAR vs EAR ?

An important motivation for having EJB beans in a separate JAR is for the age old separation of business logic and view logic. Since EJBs are supposed to concentrate solely on business logic, it makes sense to put them into a separate module. This is exactly what the

What is the difference between EJB2 and EJB3?

EJB2 vs EJB3

EJB (Enterprise JavaBeans) is a Java API (Application Programming Interface) found within Java EE (Java Platform, Enterprise Edition) specification. EJB describes an architectural model for the development of enterprise applications. This is a managed server-side model that is able to capture the business logic of the enterprise application. IBM is EJB’s original creator who developed it in 1997. Sun Microsystems adopted it in 1999.

Before the introduction of EJB, it was found that solutions to problems found in back-end business code were frequently re-implemented by the programmers. As a result, EJB was introduced to address these common problems such as persistence, transactional integrity and security. EJB provides standard ways to handle these back end problems, by specifying how the application server should process transactions, integrate with JPA (Java Persistence API) services, handle concurrency control, handle JMS (Java Message Service) Events, resolve naming issues with JNDI (Java Naming and Directory Interface), develop secure programs with JCE (Java Cryptography Extension) and JAAS (Java Authentication and Authorization Service), deploy components, communicate remotely with RMI-IIOP (Java Remote Method Invocation interface over the Internet Inter-Orb Protocol), develop web services, invoke asynchronous methods and use the Timer service.