How to upload text files into MaxDB Database instances using Java? - Part 1

[Former Member]

How to upload text files into MaxDB Database instances using Java? - Part 1

This is a simple weblog which explains how text files can be inserted into MaxDB database instances. Although this is a simple operation but it is a mandatory and most required feature for any Database server. MySQL server has special datatypes like blob to store the file contents, but like MaxDB uses the existing datatypes like LONG, VARCHAR to store the same, with a slight modification. The modification is nothing but setting the code type as BYTE.

Create a BYTE type field

The files can be uploaded to a field that has the code type as BYTE. The below image shows a sample table with a field for storing a file content.



Next any text file can be uploaded into that field which will not exceed the size alloted. For huge files use the LONG data type with the same code type. In this weblog the below shown sample text file will be uploaded into the MaxDB database.

JDBC Program to upload file

Then a java program is to be developed that will upload the file into the database. Here the steps to be followed are
1. Declare a file reader to get the contents of the file.
2. Declare a byte variable to store the contents of the file.
3. Insert the byte data into the database.

JDBC Program to upload file

/* * InsertFileToMaxDB.java * * Created on June 15, 2005, 5:46 PM * * Programmed By : Kathirvel Balakrishnan * Vertical      : Enterprise Application Solutions - SAP * Company       : Wipro Technologies * Description   : Insert image into MaxDB Database */package com.myimageprogram;import java.io.*;import java.sql.*;import java.util.*;public class InsertFileToMaxDB {        String ImgFile = "d:/mm02data.txt";        /** Creates a new instance of InsertImage */    public InsertFileToMaxDB() {    }        public void insertFile() throws Exception {                System.out.println("Before DataBase Connection ");        PreparedStatement pst = null;                try {            // Declaring the connection parameters            String  Server = "localhost",Database="TEST",User="DBADMIN",Password="maxdb";                        // Establishing a connection             Connection con = DriverManager.getConnection("jdbc:sapdb://" + Server + "/" +  Database, User, Password);                        // Preparing the query to be executed            pst = con.prepareStatement("insert into addimage values(?,?,?)");                        // Setting the actual values in the query            pst.setString(1,"1");            pst.setString(2,"File1");            FileInputStream fis=new FileInputStream(ImgFile);            byte[] b= new byte[fis.available()+1];            fis.read(b);            pst.setBytes(3,b);            pst.execute();            System.out.println("File Stored Successfully");                        // Closing the connection parameters            con.close();            pst.close();        } catch(Exception e) {            // Prints if any exception is raised            System.out.println(" Problem : "+e);        }    }        public static void main(String args[]) throws Exception {        try {            // This is where we load the driver            Class.forName("com.sap.dbtech.jdbc.DriverSapDB");            System.out.println("The Driver has been loaded");        } catch (ClassNotFoundException e) {            // Prints if any exception is raised            System.out.println("Unable to load Driver Class");            return;        }                InsertFileToMaxDB Img = new InsertFileToMaxDB();                // Calling the add image method        Img.insertFile();    }}

Executing Queries and Result

Checking the uploaded

A simple check for the uploaded file using SQLSTUDIO.



This is a very simple weblog. Hope this was useful to you.