Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Thursday, 13 October 2016

JSP Servlet Login Logout Register Application MVC Approach - Part 2

Hello everybody!

Welcome to the second part of the post! You can see the Part 1 here. Let's get on with the project.

We can now create all the jsp pages. Some of these pages will be page templates and some of them will be sending form information to the Servlets that we created in the previous post.

Friday, 7 October 2016

JSP Servlet Login Logout Register Application MVC Approach - Part 1

Hello everybody,

I recently developed a basic login logout register application using JSP and Servlets. This time I wanted to use MVC in the project structure. So that the project is easy to handle, extend and change. This will be relatively long post, so I will try to divide it into two or more parts.

Tuesday, 9 August 2016

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!

Wednesday, 22 June 2016

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.

Tuesday, 21 June 2016

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.

Monday, 6 June 2016

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.


Thursday, 2 June 2016

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