Reading properties files in Spring

1. Inject to properties file in Spring Bean using PropertyPlaceholderConfigurer

bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    
        classpath:com/foo/jdbc.properties
    

2. Use the injected properties in your bean class. Here taking example of dataSource.

    ${jdbc.driverClassName}"/>
    ${jdbc.url}"/>
    ${jdbc.username}"/>
    ${jdbc.password}"/>

3. The Content of properties file is below 

The actual values come from another file in the standard Java Properties format:

jdbc.driverClassName=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql://production:9002
jdbc.username=sa
jdbc.password=root

Fetching create table script of Oracle Tables

spool off
/
-----Open file to dump the output of procedure
spool table_struct_data.txt
/

set serveroutput on
/
declare
       l_data varchar2(10000);
       l_clob clob;
begin
----------select the DDL script of table using GET_DDL Oracle Library
       select DBMS_METADATA.GET_DDL('TABLE','MASTER_TAB') into
l_clob from DUAL;
       l_data := dbms_lob.substr( l_clob, 4245, 1 );
       dbms_output.put_line( l_data);

end;
/
spool off


open the file table_struct_data.txt . It will contain the create script of table MASTER_TAB

Exporting mysql Database to .sql file

Exporting DB 
Taking dump of all tables of a Database. For Example - DB name is development_studio

C:\>mysqldump --single-transaction -u sanjeev -p development_Studio > dump.sql
Enter password: *******

--single-transaction option is above command make sure that taking dump does not give TABLE LOCK error. For example

>mysqldump  -u sanjeev -p development_Studio > dump.sql
Enter password: *******
mysqldump: Got error: 1044: Access denied for user 'sanjeev'@'localhost' to database 'development_studio' when using LOCK TABLES


Another option is to grant LOCK TABLES to your user:
c:\>mysql -u root -p

mysql> GRANT SELECT,LOCK TABLES ON DBNAME.* TO 'username'@'localhost';