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
No comments:
Post a Comment