utilities
Class DataSourceUtilities

java.lang.Object
  extended by utilities.DataSourceUtilities

public class DataSourceUtilities
extends java.lang.Object


Field Summary
static java.lang.String NUM_PARS
           
static java.lang.String SCHEMA
           
static java.lang.String STMT
           
 
Constructor Summary
DataSourceUtilities()
           
DataSourceUtilities(it.eng.spagobi.tools.datasource.bo.IDataSource ds)
           
 
Method Summary
 boolean executeUpdateQuery(java.util.LinkedHashMap<java.lang.String,java.lang.Object> params, org.json.JSONObject metaParams)
          This method execute an update query on a generic db with Spago instructions.
 java.util.HashMap getAttributesAsMap(it.eng.spago.base.SourceBean request)
          This method gets all request parameters and define an hashmap object
 it.eng.spago.dbaccess.sql.DataConnection getDataConnection(java.sql.Connection con)
          Creates a Spago DataConnection object starting from a sql connection.
static java.lang.String getJdbcTypeClass(java.sql.ResultSetMetaData rsmd, int t)
           
 java.util.Vector readFields(java.lang.String query)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

SCHEMA

public static java.lang.String SCHEMA

STMT

public static java.lang.String STMT

NUM_PARS

public static java.lang.String NUM_PARS
Constructor Detail

DataSourceUtilities

public DataSourceUtilities()

DataSourceUtilities

public DataSourceUtilities(it.eng.spagobi.tools.datasource.bo.IDataSource ds)
Method Detail

getAttributesAsMap

public java.util.HashMap getAttributesAsMap(it.eng.spago.base.SourceBean request)
This method gets all request parameters and define an hashmap object

Parameters:
request - the sourcebean with the request
Returns:
the hashmap with all parameters

executeUpdateQuery

public boolean executeUpdateQuery(java.util.LinkedHashMap<java.lang.String,java.lang.Object> params,
                                  org.json.JSONObject metaParams)
                           throws java.lang.Throwable,
                                  java.lang.Exception
This method execute an update query on a generic db with Spago instructions.

Parameters:
the - hashmap with all parameters
Returns:
a boolean value with the response of the operation.
Throws:
java.lang.Throwable
java.lang.Exception

getDataConnection

public it.eng.spago.dbaccess.sql.DataConnection getDataConnection(java.sql.Connection con)
                                                           throws it.eng.spago.error.EMFInternalError
Creates a Spago DataConnection object starting from a sql connection.

Parameters:
con - Connection to the export database
Returns:
The Spago DataConnection Object
Throws:
it.eng.spago.error.EMFInternalError - the EMF internal error

readFields

public java.util.Vector readFields(java.lang.String query)
                            throws java.lang.Exception
Throws:
java.lang.Exception

getJdbcTypeClass

public static java.lang.String getJdbcTypeClass(java.sql.ResultSetMetaData rsmd,
                                                int t)