Page History

...

1. Start the server and Launch the Administrative Console using the URL http://localhost:8080/console.
2. Enter default username and password.
3. In the welcome page, Under Embedded DB, Select DB Manager.
   
   
   
   
   
   
4. On the next page create a database userdbs and Select create.
   
   
   
   
   
   
5. Once done you can see the userdbs database listed in DB Viewer portlet under Databases. This confirms that the database has been successfully created.
   
   
   
   
   
   
6. As shown in the figure under Use DB, select userdbs from the dropdown box.
   
   
   
   
   
   
7. Run the query as shown in the figure. This query will create table PICTURES with the columns name and pic.
   \\\
   Image Added
   
   
   

   Code Block
   title CreateTable.sql borderStyle solid
   create table pictures(name varchar(32) not null primary key, pic blob(16M));