...
- Start the server and Launch the Administrative Console using the URL http://localhost:8080/console.
- Enter default username and password.
- In the welcome page, Under Embedded DB, Select DB Manager.
- On the next page create a database userdbs and Select create.
- Once done you can see the userdbs database listed in DB Viewer portlet under Databases. This confirms that the database has been successfully created.
- As shown in the figure under Use DB, select userdbs from the dropdown box.
- Run the userinfo.sql script. Select Run Sql.
Code Block title userinfo.sql borderStyle solid create table userinfo(firstname varchar(20),lastname varchar(20), username varchar(20), password varchar(20), pincode varchar(20), cardno varchar(20))
- To verify the table creation succeeded. Select Application as shown in the figure.
- Next screen suggests the table has been successfully created. To view the contents of the table select VIEW CONTENTS.
- The table is currently empty as shown in the figure.
Creating a datasource using Administrative Console
- Start the server and Launch the Administrative Console using the URL http://localhost:8080/console.
- Enter default username and password.
- Once in the welcome page. In console navigation, Under Services, Select Database Pools.
- On the next screen, Create a new database pool using Geronimo database pool wizard.
- On the next screen give the name as suggested in the figure. This will initiate the process to create a Derby Embedded XA datasource.
- Select the Driver jar and give the database name as userdbs(Remember this is the database we created in the previous step). Rest all fields can be set to default.
- Select Deploy to deploy the connector plan.
- Once done you can see the Database Pool jdbc/userds listed in the available database pools.