/**
* This Method returns the 2D Array which is the list of the Items for the selected WorkOrder of
* the Customer.
*
* @param workorderId - WorkOrder Id Foreign Key of WRK_ORDR_DETS table
* @return Object[][] - 2D Array which is List of the Items for the WorkOrder
*/
public Object[][] getWorkOrderItems(long workorderId) throws RemoteException {
WrkOrdrDets wrkordrdts_obj = new WrkOrdrDets(conn);
RHCCBlgKeys blgkeys_obj = new RHCCBlgKeys(conn);
Vector workorderdetList = wrkordrdts_obj.getProductList(workorderId);
// Hashtable BSysList = (Hashtable) USFEnv.getBillSystems();
BlgSys blgsys = new BlgSys();
Hashtable BSysList = (Hashtable) blgsys.searchBlgSys();
Enumeration BSys = BSysList.keys();
// The 2-Dimensional array to hold the Items Billing System wise.
Object[][] prodList = new Object[BSysList.size()][workorderdetList.size() + 1];
// The Number of Billing Systems are assumed to be equal to the
// Static Load Billing Systems Hashtable size. The Billing Systems will
// be in order starting from 1 and incrementing by one.
for (int i = 0; i < BSysList.size(); i++) {
// Set the 2D array to store the Billing System as the first element
// of each row.
prodList[i][0] = String.valueOf(i + 1);
}
// Loop throught the WorkOrder Items List and place them in the appropriate
// positions in the 2D array.
for (int j = 0; j < workorderdetList.size(); j++) {
// Determine the Billing System of the Product
Vector tmpVector = new Vector();
WrkOrdrDets workorderObj = (WrkOrdrDets) workorderdetList.elementAt(j);
RHCCBlgKeys bkObj =
blgkeys_obj.searchRHCCBlgKeys(((WrkOrdrDets) workorderdetList.elementAt(j)).getRBKID());
int bsid = (new Long(bkObj.getBsId())).intValue();
tmpVector.addElement(bkObj);
tmpVector.addElement(workorderObj);
// Based on the Billing System Id retreived place the Product Object
// in the 2D array.
int k = 1;
while (prodList[bsid - 1][k] != null) {
k = k + 1;
}
prodList[bsid - 1][k] = tmpVector;
}
// Return the 2D array
return prodList;
}
/** Constructor for LDAPQuery. */
public JNDITomcat() throws Exception {
super();
Hashtable<String, String> env = new Hashtable<String, String>();
env.put(Context.INITIAL_CONTEXT_FACTORY, "org.apache.naming.java.javaURLContextFactory");
env.put(Context.PROVIDER_URL, "jndi://nadetrou2:8080/");
// Obtain our environment naming context
Context initCtx = new InitialContext(env);
// Context envCtx = (Context) initCtx.lookup("comp/env");
// Look up our data source
// DataSource datasource = (DataSource)
// initialContext.lookup((String)settings.get(CONNECTION_POOL_NAME));
DataSource ds = (DataSource) initCtx.lookup("/jdbc/vrdb");
// Allocate and use a connection from the pool
Connection conn = ds.getConnection();
System.out.println(conn);
// ... use this connection to access the database ...
conn.close();
// Hashtable env = new Hashtable();
// //env.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
// //env.put(Context.PROVIDER_URL, "t3://192.168.0.55:17001/" );
//
// env.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
// env.put(Context.PROVIDER_URL, "3://127.0.0.1:7001/" );
//
// // env.put(Context.SECURITY_PRINCIPAL, "system");
// // env.put(Context.SECURITY_CREDENTIALS, "12345678");
// System.out.println(env);
// //System.out.println("--A");
// // Create initial context
// DirContext ctx = new InitialDirContext(env);
// exploreNext(0, envCtx, "");
}