View RSS Feed

Recent Blogs Posts

  1. Sql

    by , 03-09-2012 at 08:21 PM
    Databases are accessed by usage of a standard language SQL. It is used for the manipulation and also to access the data, in following.
    • MySQL
    • DB2
    • Access
    • Oracle
    • SQL Server
    • Sybase


    The SQL language consist of these language elements:

    • Clauses: Clauses are considered to be the constituent components of queries and statements.
    • Expressions: They can produce tabular data or scalar values which comprises of columns & rows.
    • Predicates: conditions
    ...
    Tags: sql Add / Edit Tags
    Categories
    SQL
  2. Connectiong To MS Access And Fetching Records

    by , 11-08-2011 at 07:37 PM (My Java Tips)
    JDBC (Java Database Connectivity) is designed to allow user to use SQL(Structured Query Language) to query databases. JDBC makes our tasks easy as it handles all low-level concerns about particular database types. It allows you to query an Access database with exactly the same source code as with an Oracle database.

    JDBC is similar to Microsoft's ODBC with the plus point "Platform Independence". To use JDBC, you need to have database driver to communicate with the database. ...
    Tags: jdbc, sql Add / Edit Tags
    Categories
    JDBC
  3. Hibernate logging

    by , 05-21-2011 at 11:36 PM (My Java Tips)
    Hibernate logs various events using Apache commons-logging. Hibernate logs are very interesting to read if you want to do some troubleshooting or performance improvement. Hibernate uses commons-logging service for logging. It actually sends the log to either Log4j or to JDK1.4 logging.

    If you want hibernate to log using Log4j, then put log4j.jar into class path along with log4j.properties. Since log4j has almost become a standard these days, I would advice using that.
    Hibernate ...
    Tags: hql, jdbc, log4j, logging, sql Add / Edit Tags
    Categories
    Hibernate
  4. Create SQL File in Eclipse

    by , 05-21-2011 at 11:03 PM (My Java Tips)
    SQL files can be created manually in any existing eclipse project. It's simple and useful. I'll list the required steps.

    • Open Database Development perspective
    • Select File > New > Other, expand SQL Development, select SQL File, and click Next
    • This will open the New SQL File wizard.
    • To create a new project, click "Create Project" and follow the wizard instructions. Now provide the SQL file name.
    • Select a connection profile type from the Connection profile
    ...
    Tags: eclipse, sql Add / Edit Tags
    Categories
    Eclipse