In this section
Creating
a JDBC provider
Creating
a data source and connection pool
Create
J2C security
Connecting
to the database
Creating
a JDBC provider
1. The first step in creating a data
source is to create a JDBC provider.
2. Log in to the Integrated
Solutions Console.
3. In the left pane open Resources
> JDBC and
click JDBC
Providers.
4. In the right pane in Scope select Node=xxx, Server=yyy (where xxx is the name of you node and yyy the name of your server) and click New.
5. In Step 1 select the database type, provider
type, and a non-XA implementation type. For example, Derby, Derby JDBC Provider, and Connection pool data source.
6. Enter a name (for example, Akhil JDBC Driver).
7. Click Next.
8. Click Next
9. A summary is provided in Step
3:
10. Click Finish and Save to save the changes directly to the
master configuration.
11. Specify the Class Path and the
Native Library Path in JDBC
Providers>Akhil JDBC Driver(NOTE: In class path specify the path of both
ojdbc6.jar and classes12.jar separating by the enter )
To create a data source and a
connection pool:
1. In the Integrated Solutions
Console open Resources
> JDBC and
click Data
sources.
2. In the right pane in Scope select Node=xxx, Server=yyy (where xxx is the name of you node and yyy the name of your server) and click New.
3.
In Step
1, give a name to your data source
and enter the JNDI name, (for example, JNDI/AkhilJDBC), otherwise Rule Team Server will
not be able to use the data source click Next
4. In Step 2, select your non-XA JDBC provider
that you created in Creating
a JDBC provider,
and click Next.
5. In Step 3, enter specific database properties
for the data source (URL: jdbc:oracle:thin:@localhost:1521/orcl)
6. In Step 4: Setup security
aliases, click Next to accept the default values
7. Step 5 displays a summary of your settings
8. Click Finish. The connection pool is created and
associated with the data source.
9. Click Save to save the changes directly to the
master configuration.
To create a J2C Security:
It specifies a list of user
identities and passwords for Java(TM) 2 connector security to use
1.
Go
to the Data sources > Akhil JDBC > JAAS - J2C authentication
data and
click New
2. In General Properties field fill the
User ID=<DB user name> and Password =<DB user Password> click Apply and Save the changes
3. Assign the J2C security to the
created data source, so go to Data sources>Akhil
JDBC and in security setting panel
select your newly created alias in Component-managed
authentication alias field
Connecting
to the database
When you have created a data source
and connection pool, you need to test the connection to your database.
To test the connection to your
database:
1. In Data Sources, select the check box next to Akhil
JDBC.
2. Click the Test
Connection button.
3. The status of the connection is
indicated at the top.
