| Line 15... |
Line 15... |
| 15 |
' -----------------------------------------------------
|
15 |
' -----------------------------------------------------
|
| 16 |
%>
|
16 |
%>
|
| 17 |
<%
|
17 |
<%
|
| 18 |
' -- DATABASE CONNECTIONS -----------------------------
|
18 |
' -- DATABASE CONNECTIONS -----------------------------
|
| 19 |
'Set OraSession = CreateObject("OracleInProcServer.XOraSession")
|
19 |
'Set OraSession = CreateObject("OracleInProcServer.XOraSession")
|
| 20 |
'OraSession.CreateDatabasePool 1,10,100, Application("TNS_NAME"), Application("DEPLOYMENT_MANAGER_LOGIN"), 0
|
20 |
'OraSession.CreateDatabasePool 1,10,100, Application("TNS_NAME"), Application("DEPLOYMENT_MANAGER_LOGIN"), 0
|
| 21 |
'Set OraDatabase = OraSession.GetDatabaseFromPool(10)
|
21 |
'Set OraDatabase = OraSession.GetDatabaseFromPool(10)
|
| 22 |
|
22 |
|
| 23 |
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
|
23 |
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
|
| 24 |
Set OraDatabase = OraSession.OpenDatabase( Application("TNS_NAME"), Application("DEPLOYMENT_MANAGER_LOGIN"), Cint(0))
|
24 |
Set OraDatabase = OraSession.OpenDatabase( Application("TNS_NAME"), Application("DEPLOYMENT_MANAGER_LOGIN"), Cint(0))
|
| 25 |
|
25 |
|
| 26 |
'-- ClearQuest Connection
|
26 |
'-- ClearQuest Connection
|
| 27 |
Const CQ_CONN = "Provider=sqloledb;Data Source=auperatcm04;Initial Catalog=master;User Id=release_manager;Password=release_manager"
|
27 |
Const CQ_CONN = "Provider=sqloledb;Data Source=auperatcm04;Initial Catalog=master;User Id=release_manager;Password=release_manager"
|
| - |
|
28 |
'-- JIRA Connection
|
| - |
|
29 |
Const JIRA_conn = "Provider=sqloledb;Data Source=auperatcm04;Initial Catalog=JIRA_341;User Id=jirauser;Password=jirauser"
|
| 28 |
' -----------------------------------------------------
|
30 |
' -----------------------------------------------------
|
| 29 |
%>
|
31 |
%>
|
| 30 |
<%
|
32 |
<%
|
| 31 |
' -- CONFIGURATIONS -----------------------------------
|
33 |
' -- CONFIGURATIONS -----------------------------------
|
| 32 |
Const APPLICATION_ID = 1 ' Stored in Deployment Manager, [APPLICATIONS] table
|
34 |
Const APPLICATION_ID = 1 ' Stored in Deployment Manager, [APPLICATIONS] table
|
| 33 |
APP_ROOT = Server.MapPath(".")
|
35 |
APP_ROOT = Server.MapPath(".")
|
| 34 |
TNS_NAME = Application("TNS_NAME") '"RELEASEM"
|
36 |
TNS_NAME = Application("TNS_NAME") '"RELEASEM"
|
| 35 |
DB_AUTHENTICATION = Application("DEPLOYMENT_MANAGER_LOGIN") '"release_manager_devl/release_manager_devl" ' DEVL schema
|
37 |
DB_AUTHENTICATION = Application("DEPLOYMENT_MANAGER_LOGIN") '"release_manager_devl/release_manager_devl" ' DEVL schema
|
| 36 |
QUERIES_PATH = APP_ROOT &"\queries"
|
38 |
QUERIES_PATH = APP_ROOT &"\queries"
|
| 37 |
scriptName = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 )
|
39 |
scriptName = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 )
|
| 38 |
rootPath = Left( Server.MapPath( scriptName ), InStrRev(Server.MapPath( scriptName ), "\") )
|
40 |
rootPath = Left( Server.MapPath( scriptName ), InStrRev(Server.MapPath( scriptName ), "\") )
|
| 39 |
Const ADMIN_EMAIL = "releasem@erggroup.com"
|
41 |
Const ADMIN_EMAIL = "releasem@erggroup.com"
|
| Line 110... |
Line 112... |
| 110 |
const ORATYPE_VARRAY = 247
|
112 |
const ORATYPE_VARRAY = 247
|
| 111 |
const ORATYPE_TABLE = 248
|
113 |
const ORATYPE_TABLE = 248
|
| 112 |
const ORATYPE_CURSOR = 102
|
114 |
const ORATYPE_CURSOR = 102
|
| 113 |
|
115 |
|
| 114 |
|
116 |
|
| 115 |
const ORAPARM_INPUT=1
|
117 |
const ORAPARM_INPUT=1
|
| 116 |
const ORAPARM_OUTPUT=2
|
118 |
const ORAPARM_OUTPUT=2
|
| 117 |
const ORAPARM_BOTH=3
|
119 |
const ORAPARM_BOTH=3
|
| 118 |
|
120 |
|
| 119 |
const ORADYN_DEFAULT=&H0&
|
121 |
const ORADYN_DEFAULT=&H0&
|
| 120 |
' -----------------------------------------------------
|
122 |
' -----------------------------------------------------
|
| 121 |
%>
|
123 |
%>
|