package myapp.server.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import myapp.client.common.ApplicationException;

import com.google.gwt.user.server.rpc.RemoteServiceServlet;

public class BaseService extends RemoteServiceServlet
{
      Connection connection=null;

      public Connection getConnection()
      throws SQLException, ApplicationException
      {

    	  if (connection==null)
    	  {
    		  String database = "jdbc:oracle:thin:@localhost:1521:YOURDB";
    		  String username = "todo";
    		  String password = "todo";

    		  // Load the Oracle JDBC driver
    		  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

    		  // Connect to the database
    		  connection =
    			  DriverManager.getConnection ( database, username, password );

    		  if (connection==null) throw new ApplicationException("Could not acquire connection!");
    	  }
    	  return connection;
      }
    
    public void returnConnection( Connection c )
    throws SQLException
    {
        // thanks for returning, but I won't do anything with it now
    }
    
    public void dropConnection( Connection c )
    throws SQLException
    {
        // note: ignoring the 'c' argument!
        if (connection!=null);
        {
            connection.close();;
            connection=null;
        }
        
    }
    
}