direct JDBC connection in java

Direct JDBC Connection to the database.

java.sql.Statement stmt = null;
ResultSet rs = null;
PreparedStatement ps = null;
List result = null;
try {

Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@mfn2asff4:10005:APPRDEV";
java.sql.Connection conn = DriverManager.getConnection(url,
"sgrtdbo", "sgrt123dbo");
stmt = conn.createStatement();
// TODO Auto-generated method stub
String maxDateInfo="select (max(To_Date(dateinfo,'DD MON YYYY HH24:MI:SS'))) as maxdate from srgt_metrics";
ResultSet resultSet=stmt.executeQuery(maxDateInfo);
while(resultSet.next()){
String maxDateFromDB=resultSet.getString(1);
System.out.println("Max date retrieved from the database is :"+maxDateFromDB);
}
}catch(Exception e){

System.out.println("IN Excepiton e");
e.printStackTrace();
}

Date Formattin in Java.

Things to remember for Simple Date FOrmatting


Letter Date or Time Component Presentation Examples
G Era designator Text AD
y Year Year 1996; 96
M Month in year Month July; Jul; 07
w Week in year Number 27
W Week in month Number 2
D Day in year Number 189
d Day in month Number 10
F Day of week in month Number 2
E Day in week Text Tuesday; Tue
a Am/pm marker Text PM
H Hour in day (0-23) Number 0
k Hour in day (1-24) Number 24
K Hour in am/pm (0-11) Number 0
h Hour in am/pm (1-12) Number 12
m Minute in hour Number 30
s Second in minute Number 55
S Millisecond Number 978
z Time zone General time zone Pacific Standard Time; PST; GMT-08:00
Z Time zone RFC 822 time zone -0800


For Addtional Processing use the following:
Date and Time Pattern Result
"yyyy.MM.dd G 'at' HH:mm:ss z" 2001.07.04 AD at 12:08:56 PDT
"EEE, MMM d, ''yy" Wed, Jul 4, '01
"h:mm a" 12:08 PM
"hh 'o''clock' a, zzzz" 12 o'clock PM, Pacific Daylight Time
"K:mm a, z" 0:08 PM, PDT
"yyyyy.MMMMM.dd GGG hh:mm aaa" 02001.July.04 AD 12:08 PM
"EEE, d MMM yyyy HH:mm:ss Z" Wed, 4 Jul 2001 12:08:56 -0700
"yyMMddHHmmssZ" 010704120856-0700



Sample Code for conversion:

String datefromTable="2/22/2007 6:46:15 PM";
SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy KK:mm:ss aaa");

SimpleDateFormat sdf2= new SimpleDateFormat("dd MMM yyyy hh:mm:ss");

String fromFile="23 Feb 2007 12:21:12";

java.util.Date d=null;
java.util.Date d2=null;
try{
d=sdf.parse(datefromTable);
d2=sdf2.parse(fromFile);
}catch(Exception e){

e.printStackTrace();
}


System.out.println("Compare Dates : "+d.compareTo(d2));

Converting Strings to Dates in Java

grrrr.. it took me a long time to realize there is a way of doing it. :)

Here is how u make dates from Strings in java.


String datefromTable="23 Feb 2007 13:23:43";
SimpleDateFormat sdf = new SimpleDateFormat("dd MMM yyyy hh:mm:ss");

String fromFile="22 Feb 2007 13:23:43";

java.util.Date d=null;
java.util.Date d2=null;
try{
d=sdf.parse(datefromTable);
d2=sdf.parse(fromFile);
}catch(Exception e){

e.printStackTrace();
}

System.out.println("Compare Dates : "+d.compareTo(d2));
System.out.println("Date value is :"+d);

Major advantage of doing this is you can you java's built in compare to method to compare dates and process accordingly hehe.. lazy to write my own comare to method for strings :)

Deployment descriptor "web.xml" is malformed.

<[Application: 'C:\bea\user_projects\domains\CClearDomain\applications', Module: 'srgt']: Deployment descriptor "web.xml" is malformed. Check against the DTD: org.xml.sax.SAXParseException: The content of element type "web-app" must match "(icon?,display-name?,description?,distributable?,context-param*,filter*,filter-mapping*,listener*,servlet*,servlet-mapping*,session-config?,mime-mapping*,welcome-file-list?,error-page*,taglib*,resource-env-ref*,resource-ref*,security-constraint*,login-config?,security-role*,env-entry*,ejb-ref*,ejb-local-ref*)". (line 68, column 11).>


U see this error because the order of elements in ur web.xml is different from the dtd its using
ex: UR web.xml shud comply with http://java.sun.com/dtd/web-app_2_3.dtd so if any of the ordering is different you will see the above error.




SRGT


com.jpmchase.srgt.interceptor.SrgtSessionListener






action

org.apache.struts.action.ActionServlet


config
/WEB-INF/struts-config.xml


debug
3


detail
3

2






action
*.do



450



java.lang.Exception
/pages/SrgtError.jsp



java.lang.RuntimeException
/pages/SrgtError.jsp

invoking a url with query parameters

here is how you invoke a url with query parameters


http://localhost:7001/srgt/actions/proposalDetails.do?action=displayView&operURL=yes&proposalId=1230


all the variables set here are your form variables. So in this case proposalDetaislForms shud contain these vars defined

action

operURL

proposalId etc