MySQL Connection in Eclipse(Install, Connect and Test)

Hello everyone!

I have started a new project in which I am planing to use JSF, Primefaces and DB features. But this time I want to use MySQL instead of Oracle 11g in my project. I posted some entries about Oracle 11g while I was learning about it during the development of previous Java EE projects. I believe switching to and tackling MySQL will do huge benefits. Hope you can find what you have been looking for in this post too!

Intagrating Tomcat to the Eclipse Environment

Hello everbody!

After installing Apache Tomcat and Eclipse, connecting these two is not a big deal. You need to simply follow the following steps. To view my post about how to install Apache Tomcat please go here.

STEP 1

Start Eclipse and go to the tab "Servers". Initially as we have no servers yet, this tab will be empty. Click the link to create a new server as shown below.

Getting Started With JSF - Preparing The Environent and Creating the First JSF Application

Hello everybody!

This post will be something like "Introduction to JSF" :) So if you are new to JSF, I think this is a good place for you to start.

How To Connect Oracle 11g Express Edition to Eclipse

Hello everybody!

Let's see how to connect Oracle 11g Express Edition that we just installed (here is the guide for installaton) to Eclipse.

STEP 1

Download the compatible ojdbc.jar from this link. Put it somewhere on your computer. I placed mine under "C:\ojdbc" folder.

How to Install Oracle 11g Express Edition on Windows

Hello everybody!

You can find a quick step by step guide about installing Oracle 11g Express Edition on Windows here. I hope it is useful for you!

STEP 1

Go to this link to download Oracle 11g Express Edition. First accept the licence agreement and then click on whichever version is compatible with your operating system. I will go with Windows x64.

Oracle Database 11g How To Set "Auto Increment"

Hello everbody!

Setting auto increment property in Oracle 11g is a little bit different from way that I am used to with other databases. There is no such keyword as auto_increment in Oracle 11g. We have to achieve it by using the codes below.

Oracle 11g - A Solution To The Password Will Expire Error - ORA-28002

Hello everbody!

Today I have seen an error which tells me my Oracle 11g database user's password will expire in a day! So I had to sort this out before I did any work with the database. I also decided to write a blog post about the solution. Here we go.. This is the error message I got and here is the solution.

Oracle Database 11g - Creating A New User

Hello everybody!

Creating a new user in Oracle 11g is not too complicated. You just follow these steps below. Before that if you want to have a look at installing Oracle 11g Express Edition on Window just click here.

STEP1 - Connect as a SYSTEM USER

Open SQL command line and type this:
connect / as sysdba

Let's Install and Configure Apache Tomcat on Windows

Hello everybody!

Here is a quick and easy guide for you to install and configure Apache Tomcat on your Windows system. I will try to explain it step by step so that you can follow them easily.

STEP 1

First of all, we need to sure that we have latest versions of jre and jdk installed on our systems. If they are missing on your system, go to http://www.oracle.com/technetwork/java/javase/downloads/index.html to download them. If you want to check my other post about how to check JDK version on your system, you can find it here.