Package org.openbravo.database

Interface ConnectionProvider

All Known Implementing Classes:

About, Account, AccountElementValue, ActionButton_Responser, ActionButtonJava_Responser, ApplyModules, AttributeSetInstance, AuditTrailPopup, AUM_ConversionRate, BackgroundProcessClusterConfig, BaseKernelServlet, BatchPaymentExecution, BusinessPartner, BusinessPartnerMultiple, CallAcctServer, CalloutHelper, CashBankOperations, ChangeAudit, CheckCleanCache, CheckOptionalFilterCallout, ComboReloadsProcessHelper, ConnectionProviderImpl, CopyFromGLJournal, CopyFromInvoice, CopyFromOrder, CopyFromSettlement, CPStandAlone, CreateAccountingReport, CreateCashFlowStatement, CreateFrom, CreateRegFactAcct, CreateTaxReport, CreateVatRegisters, DalConnectionProvider, DataSourceServlet, DebtPayment, DefaultExpressionCallout, DelegateConnectionProvider, DeleteClient, DisplayHelp, DisplayJasper, DocTypeMultiple, DownloadReport, DropRegFactAcct, DynamicJS, EditCCPMeasureValues, EmailConfiguration_Port, ErrorConnection, ExecutePayments, ExpenseAPInvoice, ExpenseSOrder, ExportReferenceData, FixedValueExpressionCallout, GeneralAccountingReports, GenerateInvoicesmanual, GenerateShipmentsmanual, GenericTreeServlet, GridConfigurationSequenceNumberCallout, GtinFormat, Heartbeat, HttpBaseServlet, HttpSecureAppServlet, ImageInfo, ImageInfoBLOB, ImportBankFile, ImportBPSet, ImportProductInDiscount, InitialClientSetup, InitialOrgSetup, InsertAcces, InstanceManagement, InstancePurpose, Invoice, InvoiceLine, JavaPackageChecker, JNDIConnectionProvider, JSExecuteCalloutExample, JSExpressionCallout, KernelServlet, Location, Locator, LocatorMultiple, Login, LoginHandler, Logout, MaterialReceiptPending, Menu, MessageJS, MetadataOnTab, MInOutTraceReports, ModuleManagement, Multiphase_dates, OperativeQuantity_To_BaseQuantity, PaymentReport, PoolStatus, PopupLoading, Posted, PriceListCreateAll, PrintController, PrinterReports, PrintInvoices, PrintJR, PrintOrders, PrintPayments, PrintQuotations, PrintShipments, ProcessGoods, ProcessInvoice, ProcessPaymentProposal, ProcessUploadedFile, Product, ProductComplete, ProductMultiple, Project, ProjectClose, ProjectCopyFrom, ProjectMultiple, ProjectSetType, Reconciliation, ReferencedLink, ReportAcctRedirectUtility, ReportAgingBalance, ReportAnnualCertification, ReportAssetDepreciationSchedule, ReportBankJR, ReportBudgetExportExcel, ReportBudgetGenerateExcel, ReportCashflowForecast, ReportCashJR, ReportDebtPayment, ReportDebtPaymentTrack, ReportExpense, ReportGeneralLedger, ReportGeneralLedgerJournal, ReportGeneralLedgerJournalDetail, ReportGuaranteeDateJR, ReportInvoiceCustomerDimensionalAnalysesJR, ReportInvoiceCustomerJR, ReportInvoiceDiscountJR, ReportInvoicesJR, ReportInvoiceVendorDimensionalAnalysesJR, ReportInvoiceVendorJR, ReportMaterialDimensionalAnalysesJR, ReportMaterialTransactionEditionJR, ReportNotPosted, ReportOffer, ReportOrderNotInvoiceJR, ReportOrderNotShipped, ReportParetoProduct, ReportPendingProductionJr, ReportProductionCost, ReportProductionJR, ReportProductionRunJR, ReportProductMovement, ReportProjectBuildingSiteJR, ReportProjectProfitabilityJR, ReportProjectProgress, ReportPurchaseDimensionalAnalysesJR, ReportReconciliation, ReportReconciliationDetail, ReportReconciliationSummary, ReportSalesDimensionalAnalyzeJR, ReportSalesOrderInvoicedJasper, ReportSalesOrderJR, ReportSalesOrderProvidedJR, ReportShipmentDimensionalAnalyzeJR, ReportShipmentEditionJR, ReportShipper, ReportStandardCostJR, ReportTaxInvoiceJR, ReportTaxPaymentJR, ReportTotalProductTemplate, ReportTrialBalance, ReportTrialBalanceDetail, ReportValuationStock, ReportVatRegisterJR, ReportWarehouseControl, ReportWarehousePartnerJR, ReportWorkRequirementDaily, ReportWorkRequirementJR, RequisitionToOrder, RescheduleProcess, RptC_Bpartner, RptC_ProposalJr, RptC_Remittance, RptM_Requisition, RptMA_ProcessPlan, SalesOrder, SalesOrderLine, ScheduleProcess, SE_Amount_Transaction, SE_CalculateExchangeRate, SE_DimensionDocBaseType, SE_DoubtfulDebt_Method, SE_ElementValue_AccountSign, SE_Expense_Amount, SE_Expense_BP_Project, SE_Expense_Product, SE_ExternalPOS_BPartner, SE_FinancialAccount_BSAccounts, SE_GLItem_Transaction, SE_InOut_DocType, SE_InOut_Organization, SE_InOut_Warehouse, SE_Invoice_AccountingDate, SE_Invoice_BPartner, SE_Invoice_BPartnerLocation, SE_Invoice_Organization, SE_Invoice_Project, SE_Invoice_TaxDate, SE_Locator_Activate, SE_Order_BPartner, SE_Order_BPartnerLocation, SE_Order_Organization, SE_Order_Project, SE_Organization_NotTaxDeductable, SE_Payment_BPartner, SE_Payment_FinAccount, SE_Payment_MultiCurrency, SE_Payment_Transaction, SE_PaymentMethod, SE_PaymentMethod_FinAccount, SE_Period_Control, SE_PeriodNo, SE_Pricelist_Active, SE_Project_BPartner, SE_ProjectLine_Value, SE_Proposal_BPartner, SE_RefInventory_RefInvType, SE_Sales_Pricelist, SE_StatementDate_Transaction, SE_Supplier_BPartner, SE_Taxes_Active, SE_TaxRate_Withholding, SE_Trxtype_Transaction, SelectorFieldPropertyCallout, ServletGoBack, SessionActive, ShipmentReceipt, ShipmentReceiptLine, ShowImage, ShowImageLogo, ShowSessionPreferences, ShowSessionVariables, SimpleCallout, SL_AdvPayment_Document, SL_AlertRule_SQL, SL_Asset_Product, SL_Assets, SL_BankDebt_Amount, SL_BankStmt_Amount, SL_BP_Category_Default, SL_BPartnerLocation, SL_Budget_Product, SL_CashJournal_Amounts, SL_CCPMeasure_Group, SL_Charge, SL_Column, SL_Commission_ListDetails, SL_Conversion_Rate, SL_CostAdjustment_DocType, SL_CostcenterEmployee_SalaryCategory, SL_Costing_Currency, SL_CostingRule_FixBackdated, SL_Currency_StdPrecision, SL_Depreciate, SL_GlobalUse_Conversion, SL_GlobalUse_Product, SL_InOut_AccountingDate, SL_InOut_BPartner, SL_InOut_Conversion, SL_InOutLine_Product, SL_Internal_Consumption_Conversion, SL_Internal_Consumption_Product, SL_InvAmtUpd_AmtUnitCost, SL_InvAmtUpd_DocType, SL_InvAmtUpd_ProductRefDate, SL_Inventory_Conversion, SL_Inventory_Locator, SL_Inventory_Product, SL_Invoice_Amt, SL_Invoice_Charge_Tax, SL_Invoice_Conversion, SL_Invoice_DocType, SL_Invoice_Glitem, SL_Invoice_PriceList, SL_Invoice_Product, SL_InvoiceTax_Amt, SL_IsDefault, SL_Journal_MultiAcctSchema, SL_Journal_Period, SL_JournalLineAmt, SL_LandedCost_Cost_Type, SL_LandedCost_DocType, SL_LandedCost_InvoiceLine, SL_LandedCost_Receipt, SL_LegalEntity_Acct, SL_MachineCost, SL_MInOutTraceReports, SL_Module_Minor_Version, SL_ModuleCallout, SL_Movement_Conversion, SL_Movement_Product, SL_Order_Amt, SL_Order_Charge_Tax, SL_Order_Conversion, SL_Order_DocType, SL_Order_PriceList, SL_Order_Product, SL_Order_Tax, SL_Order_UpdateLinesDate, SL_Organization_Info, SL_PC_Case_Product, SL_Preference, SL_Product_Type, SL_ProductCh_Characteristic, SL_Production_Conversion, SL_Production_Product, SL_ProductionPlan_Conversion, SL_ProductionPlan_WRPhase, SL_ProductionPlan_WRPhase_Quantity, SL_ProductPrice_PriceListVersion, SL_Project_Margin, SL_Project_Planned, SL_Project_PriceList, SL_Project_Service, SL_Project_Type, SL_Proposal_Product, SL_RefreshSequenceAndLength, SL_Requisition_BPartner, SL_Requisition_BPartner_PriceList, SL_RequisitionLine_Amt, SL_RequisitionLine_Conversion, SL_RequisitionLine_Product, SL_RequisitionOrder_Order, SL_Reservation, SL_ScheduledMaintenance_Maintenance, SL_SequenceProduct_Conversion, SL_SequenceProduct_Product, SL_SequenceProduct_Product_Attribute, SL_StatusFieldDefaults, SL_TableAudit, SL_TableTab, SL_TaxCategory_Org, SL_User_Name, SL_WorkRequirement_Conversion, SL_WorkRequirement_ProcessPlan, SL_WorkRequirement_StartDate, SL_WRPhase_Sequence, SL_WRPhaseProduct_Product, SL_Year_Validation, SQLExecutor, StaticCommunityBranding, SysInfoCustomAllowed, TabAttachments, TestHeartbeat, Translation, UnscheduleProcess, UpdateMaintenanceScheduled, UpdateReferenceData, UsedByLink, VerticalMenu

public interface ConnectionProvider

Method Summary

Modifier and Type	Method	Description
void	destroy()
CallableStatement	getCallableStatement(String strSql)
CallableStatement	getCallableStatement(String poolName, String strSql)
CallableStatement	getCallableStatement(Connection conn, String strSql)
Connection	getConnection()
PreparedStatement	getPreparedStatement(String strSql)
PreparedStatement	getPreparedStatement(String poolName, String strSql)
PreparedStatement	getPreparedStatement(Connection conn, String strSql)
String	getRDBMS()
Statement	getStatement()
Statement	getStatement(String poolName)
Statement	getStatement(Connection conn)
String	getStatus()
Connection	getTransactionConnection()
void	releaseCallableStatement(CallableStatement callableStatement)
void	releaseCommitConnection(Connection conn)
void	releasePreparedStatement(PreparedStatement preparedStatement)
void	releaseRollbackConnection(Connection conn)
void	releaseStatement(Statement statement)
void	releaseTransactionalPreparedStatement(PreparedStatement preparedStatement)
void	releaseTransactionalStatement(Statement statement)

Method Detail

getConnection

Connection getConnection()
                  throws NoConnectionAvailableException

Throws:

NoConnectionAvailableException

getRDBMS

String getRDBMS()

getTransactionConnection

Connection getTransactionConnection()
                             throws NoConnectionAvailableException,
                                    SQLException

Throws:

NoConnectionAvailableException

SQLException

releaseCommitConnection

void releaseCommitConnection(Connection conn)
                      throws SQLException

Throws:

SQLException

releaseRollbackConnection

void releaseRollbackConnection(Connection conn)
                        throws SQLException

Throws:

SQLException

getPreparedStatement

PreparedStatement getPreparedStatement(String poolName,
                                       String strSql)
                                throws Exception

Throws:

Exception

getPreparedStatement

PreparedStatement getPreparedStatement(String strSql)
                                throws Exception

Throws:

Exception

getPreparedStatement

PreparedStatement getPreparedStatement(Connection conn,
                                       String strSql)
                                throws SQLException

Throws:

SQLException

releasePreparedStatement

void releasePreparedStatement(PreparedStatement preparedStatement)
                       throws SQLException

Throws:

SQLException

getStatement

Statement getStatement(String poolName)
                throws Exception

Throws:

Exception

getStatement

Statement getStatement()
                throws Exception

Throws:

Exception

getStatement

Statement getStatement(Connection conn)
                throws SQLException

Throws:

SQLException

releaseStatement

void releaseStatement(Statement statement)
               throws SQLException

Throws:

SQLException

releaseTransactionalStatement

void releaseTransactionalStatement(Statement statement)
                            throws SQLException

Throws:

SQLException

releaseTransactionalPreparedStatement

void releaseTransactionalPreparedStatement(PreparedStatement preparedStatement)
                                    throws SQLException

Throws:

SQLException

getCallableStatement

CallableStatement getCallableStatement(String poolName,
                                       String strSql)
                                throws Exception

Throws:

Exception

getCallableStatement

CallableStatement getCallableStatement(String strSql)
                                throws Exception

Throws:

Exception

getCallableStatement

CallableStatement getCallableStatement(Connection conn,
                                       String strSql)
                                throws SQLException

Throws:

SQLException

releaseCallableStatement

void releaseCallableStatement(CallableStatement callableStatement)
                       throws SQLException

Throws:

SQLException

destroy

void destroy()
      throws Exception

Throws:

Exception

getStatus

String getStatus()