Thread: Applications to Database

Connection of Java applications to Database

Can anybody give me information about connection of java application to database and what are the thing should be available to construct this project. I would like to use oracle database and for oracle which type of driver would be used. I don’t know which driver is use for java application. Which kind of driver possible used for various java applications?

Try the following code for Connection of Java applications to Database, it uses JDBC driver for connection.


import java.sql.*;
class javatooracle
{
public static void main (String args []) throws SQLException
{
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

Connection con = DriverManager.getConnection
("jdbcracle:thin:@hostname:1526:mydb", "Hr", "Hr");
// @IP address ortname:databaseID, userid,password

Statement stmt = con.createStatement();
ResultSet rset = stmt.executeQuery("select * from SYS.V_$VERSION");
while (rset.next())
System.out.println (rset.getString(1));
stmt.close();
}
}

JServer:

The oracle record helps to the java programmer a tool JServer hasten or which speeds up the code execution of java applications.

Configuring JServer:

1. Make sure, your instance must be started with more than 20M
of java_pool_size and 50M for shared_pool_size space for this configuration

2. Run the $ORACLE_HOME/javavm/install/initjvm.sql file as well as the sys account.

3. Type the statement given below:

SQL> GRANT JAVAUSERPRIV TO SCOTT;

Now "scott" user can use this advantage to run the script regarding JVM and follow the "Oracle Migrations Guide" to understand more about this.