Connecting to mySql database.
1. You need to execute the mysql.sql in BAM_HOME/dbscripts folder.
- Navigate to where you have the above script.
- Login to MySQL as the root user.
- Execute the mysql.sql script.
This will create the BAM database. To connect to the database you need to:
2. Copy the mysql driver to CARBON.
- Navigate to BAM_HOME/repository/components/lib and copy mysql-connector-java-5.1.7-bin.jar.
3. Update BAM_HOME/repository/conf/datasources.properties with your database information. A sample is done below.
Connecting to Oracle database
1. You need to execute the oracle.sql in BAM_HOME/dbscripts folder.
- Login to SQLPlus as a sysdba and create the db user and grant required access.
Now login from the above created user and execute the oracle.sql script
This will create the BAM database. To connect to the database you need to:
2. Copy the mysql driver to CARBON.
- Navigate to BAM_HOME/repository/components/lib and copy ojdbc14.jar.
3. Update BAM_HOME/repository/conf/datasources.properties with your database information. A sample is done below.
1. You need to execute the mysql.sql in BAM_HOME/dbscripts folder.
- Navigate to where you have the above script.
- Login to MySQL as the root user.
mysql -u root -p- give the password at the prompt
- Execute the mysql.sql script.
source mysql.sql
This will create the BAM database. To connect to the database you need to:
2. Copy the mysql driver to CARBON.
- Navigate to BAM_HOME/repository/components/lib and copy mysql-connector-java-5.1.7-bin.jar.
3. Update BAM_HOME/repository/conf/datasources.properties with your database information. A sample is done below.
synapse.datasources=bamMySQL
synapse.datasources.icFactory=com.sun.jndi.rmi.registry.RegistryContextFactory
synapse.datasources.providerPort=2199
synapse.datasources.bamh2.registry=JNDI
synapse.datasources.bamh2.type=BasicDataSource
synapse.datasources.bamh2.driverClassName=com.mysql.jdbc.Driver
synapse.datasources.bamh2.url=jdbc:mysql://localhost:3306/wso2bam_db
synapse.datasources.bamh2.username=wso2bam
synapse.datasources.bamh2.password=wso2bam
synapse.datasources.bamh2.dsName=bam_datasource
synapse.datasources.bamh2.maxActive=100
synapse.datasources.bamh2.maxIdle=20
synapse.datasources.bamh2.maxWait=10000
Connecting to Oracle database
1. You need to execute the oracle.sql in BAM_HOME/dbscripts folder.
- Login to SQLPlus as a sysdba and create the db user and grant required access.
$sqlplus sys as sysdba;
SQL> startup
drop user wso2bam cascade;
Create user wso2bam identified by wso2bam account unlock;
grant connect to wso2bam;
grant create session, dba to wso2bam;
commit;
Now login from the above created user and execute the oracle.sql script
sqlplus wso2bam/wso2bam@10.100.1.10/ORCL
SQL>>@/dbscripts/bam/bam_schema_oracle.sql;
This will create the BAM database. To connect to the database you need to:
2. Copy the mysql driver to CARBON.
- Navigate to BAM_HOME/repository/components/lib and copy ojdbc14.jar.
3. Update BAM_HOME/repository/conf/datasources.properties with your database information. A sample is done below.
synapse.datasources=bamOracle
synapse.datasources.icFactory=com.sun.jndi.rmi.registry.RegistryContextFactory
synapse.datasources.providerPort=2199
synapse.datasources.bamh2.registry=JNDI
synapse.datasources.bamh2.type=BasicDataSource
synapse.datasources.bamh2.driverClassName=oracle.jdbc.driver.OracleDriver
synapse.datasources.bamh2.url=jdbc:oracle:thin:@localhost:1521/wso2bam_db
synapse.datasources.bamh2.username=wso2bam
synapse.datasources.bamh2.password=wso2bam
synapse.datasources.bamh2.dsName=bam_datasource
synapse.datasources.bamh2.maxActive=100
synapse.datasources.bamh2.maxIdle=20
synapse.datasources.bamh2.maxWait=10000
Hiç yorum yok:
Yorum Gönder