Poonam Kadu

Hi Friends,

I have declared a UDT(User Defined Types) say CustomType in SQL server 2008.I m using this Data type as an IN parameter for a Stored
procedure.I want to call this procedure from a java class.
To do this i have done the following:
created a class called CustomType which implements SQLData

public class CustomType implements SQLData { String name ; int year ; String sql_type = "CustomType_t"; public String getSQLTypeName() throws SQLException { return sql_type; } public void readSQL(SQLInput arg0, String type) throws SQLException { sql_type = type; name = arg0.readString() ; year = arg0.readInt() ; } public void writeSQL(SQLOutput arg0) throws SQLException { arg0.writeString(name) ; arg0.writeInt(year) ; } }

My main java class looks like this:
public class Proc2Test { public static void main(String[] args) { msmsqlTest() ; } public static void msmsqlTest() { Connection con = null ; CallableStatement cStatement = null ; ResultSet rs = null ; String url = "jdbc:sqlserver://localhost:1433;databaseName=testDB;username=abc;password=xyz"; String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; try { Class.forName(driver); con = DriverManager.getConnection(url); java.util.Map map = con.getTypeMap(); map.put("CustomType", Class.forName("com..test.CustomType")); con.setTypeMap(map); cStatement = con.prepareCall("{call abc2(?,?)}") ; CustomType x = new CustomType() ; x.name = "ABC" ; x.year = 20 ; cStatement.setObject("para1", x, java.sql.Types.OTHER); cStatement.registerOutParameter(2,Types.INTEGER) ; rs = cStatement.executeQuery(); } catch(Exception ex) { ex.printStackTrace() ; } } }

when i run this code i get the following exception:

com.microsoft.sqlserver.jdbc.SQLServerException: This operation is not supported.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.NotImplemented(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.setTypeMap(Unknown Source)
at com.mindcraft.test.Proc2Test.msmsqlTest(Proc2Test.java:97)
at com.mindcraft.test.Proc2Test.main(Proc2Test.java:22)



This exception occurs at con.setTypeMap(map)


My problem is how do i call a store proc of SQL server, whose input parameter is a custom Database type?
How do i map the a pojo with custom database type of SQL server 2008 and send that to the stored proc ?
Does sql server 2008 jdbc driver implement Connection.setTypeMap() method?


cheers,
Poonam.

Hi ,
Using Struts pager,index and logic iterate tags i could display a collection ,along with page navigation links at the top in a jsp.
how do i display page navigation links above and below a collection using Struts paging tags ?

cheers,
Poonam

Hi Friends,
A couple of weeks back i written some code to send email using smtp.gmail.com .And it was working fine
But now when i executed the same code it throws the following exception :

Exception in thread "main" org.springframework.mail.MailSendException: Mail server connection failed; nested exception is javax.mail.MessagingException: Unknown SMTP host: smtp.gmail.com;
nested exception is:
java.net.UnknownHostException: smtp.gmail.com
at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:419)
at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:342)
at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:357)
at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:346)
at com.mcs.mailer.SpringMailer.sendMail(SpringMailer.java:66)
at com.mcs.mailer.EmailCompTest.main(EmailCompTest.java:20)
Caused by: javax.mail.MessagingException: Unknown SMTP host: smtp.gmail.com;
nested exception is:
java.net.UnknownHostException: smtp.gmail.com


I have set the following properties :
<property name="host" value="smtp.gmail.com"/>
<!-- smtp.mail.yahoo.com-->
<property name="port" value="587"/>

when i did nslookup i got this
>nslookup smtp.gmail.com
DNS request timed out.
timeout was 2 seconds.
*** Can't find server name for address 121.242.180.190: Timed out
DNS request timed out.
timeout was 2 seconds.
*** Can't find server name for address 121.242.180.211: Timed out
*** Default servers are not available
Server: UnKnown
Address: 121.242.180.190

DNS request timed out.
timeout was 2 seconds.
DNS request timed out.
timeout was 2 seconds.
*** Request to UnKnown timed-out

What could be the possible problem?I mean is there something wrong with the 'smtp.gmail.com' or some network settings like firewall or something....
Please advice.

Cheers,
Poonam.

Hi Guys,
Thanks for your quick response,but its still not working
I am posting a simplified version of my problem:

struts-config.xml
<?xml version="1.0" encoding="UTF-8" ?> <struts-config> <form-beans> <form-bean name="TestForm2" type="TestForm2"/> </form-beans> <action-mappings> <action input="/" name="TestForm1" path="/TestCheck1" scope="session" type="TestAction1"> <forward name="checkBox" path="/testcheck.jsp"/> </action> <action input="/" name="TestForm1" path="/TestCheck2" scope="session" type="TestAction2"> <forward name="checkBox2" path="/testcheck.jsp"/> </action> </action-mappings> <controller processorClass="org.apache.struts.tiles.TilesRequestProcessor"/> <message-resources parameter="com/myapp/struts/ApplicationResource"/> </struts-config>

ActionForm1.java
public class TestForm1 extends org.apache.struts.action.ActionForm { private boolean checkTest; public boolean getCheckTest() { return checkTest; } public void setCheckTest(boolean checkTest) { this.checkTest = checkTest; } public TestForm1() { super(); // TODO Auto-generated constructor stub } public ActionErrors validate(ActionMapping mapping, HttpServletRequest request) { ActionErrors errors = new ActionErrors(); return errors; } }

TestAction1.java
public class TestAction1 extends org.apache.struts.action.Action { private final static String SUCCESS = "checkBox"; public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { TestForm1 frm = (TestForm1) form ; frm.setCheckTest(true);//setting the checkTest value to true return mapping.findForward(SUCCESS); } }

testcheck.jsp
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> </head> <body> <h2>Hello World!</h2> <html:form action="/TestCheck2.do"> <html:checkbox property="checkTest" name="TestForm1"/> <html:submit/> </html:form> </body> </html>


TestAction2.java
public class TestAction2 extends org.apache.struts.action.Action { /* forward name="success" path="" */ private final static String SUCCESS = "checkBox2"; public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { TestForm1 frm = (TestForm1) form ; System.out.println("------"+frm.getCheckTest()) ;//if I uncheck the checkbox in testcheck.jsp this should display ------false; but it displays ------true return mapping.findForward(SUCCESS); } }

The entry point is type /TestCheck1.do in the browser it invokes TestAction1.java action,populates TestForm1.java and forwards the request to testcheck.jsp.Inside testcheck.jsp ,when the user hits submit button it invokes TestAction2.java Action.TestForm1.java is in session scope and has been tied to both the Action classes.


Hope this example will make my problem more clear.
Thanks,
Poonam

Hi Guys,
Thanks for your quick response,but its still not working
I am posting a simplified version of my problem:

struts-config.xml
<?xml version="1.0" encoding="UTF-8" ?> <struts-config> <form-beans> <form-bean name="TestForm2" type="TestForm2"/> </form-beans> <action-mappings> <action input="/" name="TestForm1" path="/TestCheck1" scope="session" type="TestAction1"> <forward name="checkBox" path="/testcheck.jsp"/> </action> <action input="/" name="TestForm1" path="/TestCheck2" scope="session" type="TestAction2"> <forward name="checkBox2" path="/testcheck.jsp"/> </action> </action-mappings> <controller processorClass="org.apache.struts.tiles.TilesRequestProcessor"/> <message-resources parameter="com/myapp/struts/ApplicationResource"/> </struts-config>

ActionForm1.java
public class TestForm1 extends org.apache.struts.action.ActionForm { private boolean checkTest; public boolean getCheckTest() { return checkTest; } public void setCheckTest(boolean checkTest) { this.checkTest = checkTest; } public TestForm1() { super(); // TODO Auto-generated constructor stub } public ActionErrors validate(ActionMapping mapping, HttpServletRequest request) { ActionErrors errors = new ActionErrors(); return errors; } }

TestAction1.java
public class TestAction1 extends org.apache.struts.action.Action { private final static String SUCCESS = "checkBox"; public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { TestForm1 frm = (TestForm1) form ; frm.setCheckTest(true);//setting the checkTest value to true return mapping.findForward(SUCCESS); } }

testcheck.jsp
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> </head> <body> <h2>Hello World!</h2> <html:form action="/TestCheck2.do"> <html:checkbox property="checkTest" name="TestForm1"/> <html:submit/> </html:form> </body> </html>


TestAction2.java
public class TestAction2 extends org.apache.struts.action.Action { /* forward name="success" path="" */ private final static String SUCCESS = "checkBox2"; public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { TestForm1 frm = (TestForm1) form ; System.out.println("------"+frm.getCheckTest()) ;//if I uncheck the checkbox in testcheck.jsp this should display ------false; but it displays ------true return mapping.findForward(SUCCESS); } }

The entry point is type /TestCheck1.do in the browser it invokes TestAction1.java action,populates TestForm1.java and forwards the request to testcheck.jsp.Inside testcheck.jsp ,when the user hits submit button it invokes TestAction2.java Action.TestForm1.java is in session scope and has been tied to both the Action classes.


Hope this example will make my problem more clear.
Thanks,
Poonam

Hi,
I guess its not the same problem.i dont get any null values in the next action...but i get values which were displayed before the next action was invoked.I don't know how to capture the checkbox checked/unchecked value in the boolean variable email,sms in basic element of the collection property of the formbean.
Thanks,
Poonam

Hi David,
Yes it does displays the way i want ...it looks something like a table with its last two cols as checkboxes.The checkboxes are checked/unchecked using the values from the formbean property.But when i check /uncheck and click on submit , it shows the old values of the checkbox in the new Action class . Why doesn't it show the updated values?
Sorry for the unnecesary code included.

Thanks,
Poonam

Hi Friends,
I have been facing this problem since a couple of days...
I have a FormBean whose one the property is a collection of a type of objects.Using the formbean , logic:iterate and html:checkbox i could display the content in the jsp... but in the same jsp when the user changes the checboxes (check/uncheck) ...the values don't reflect in the next action..Also my form bean is in session scope...

<%-- Document : ListMemberAlerts Created on : Aug 19, 2010, 6:13:12 PM Author : Poonam --%> <%@page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean" %> <%@ taglib uri="http://struts.apache.org/tags-html" prefix="html" %> <%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>SubscribedCategoryList</title> </head> <body> <html:form action="saveMemberAlerts.do"> <h1>Hello World!</h1> <table border="1" > <tr class="white_heading"> <td ><strong>Subscribe to Alerts </strong></td> </tr> <tr> <td ><table border="0" class="black_txt"> <tr> <td></td> <td ></td> <td></td> <td></td> </tr> <tr> <td > </td> <td ><strong>Categories</strong></td> <td > </td> <td ><strong>Mode</strong></td> </tr> <tr> <td></td> <td ></td> <td></td> <td></td> </tr> <logic:present name="ListMemberAlertsForm"><%System.out.println("Form Present");%></logic:present> <logic:present name="ListMemberAlertsForm" property="memberAlertList"> <bean:define id="temp_memberAlertList" name="ListMemberAlertsForm" property="memberAlertList" scope="session" type="java.util.ArrayList"/> <% System.out.println("checking size of temp_categoryList"); System.out.println("temp_memberAlertList.size() :"+temp_memberAlertList.size()); %> </logic:present> <%System.out.println("--------1");%> <c:set var="i" value="1"/> <%System.out.println("--------2");%> <%int i =0;%> <c:set var="coreCat" value="${ListMemberAlertsForm.coreCategories}" scope="session" /> <logic:present name="ListMemberAlertsForm"><%System.out.println("Form Present");%></logic:present> [u]<logic:iterate name="ListMemberAlertsForm" property="memberAlertList" id="category" type="com.mcsl.commons.Category" indexId="index" >[/u] <%-- <c:forEach items="${ListMemberAlertsForm.memberAlertList}" var="disCat">--%> <% i++;%> <tr> <%System.out.println("--------inside foreach");%> <td > </td> <td > ${category.categoryName}</td> <td > </td> <c:out value="${(coreCat[index].email)}"/> <c:if test="${(coreCat[index].email==true)}" > <c:if test="${(category.modeID==1)||(category.modeID==3)}"> <c:out value="${category.email}"/> <td >[u]<html:checkbox property="email" name="category" indexed="true" value="true" >[/u] </html:checkbox> Email    </c:if> <c:if test="${(category.modeID==0)}"> <td ><html:checkbox property="email" name="category" indexed="true" value="true" ></html:checkbox> Email    </c:if> </c:if> <c:if test="${coreCat[index].email==false}" > <td ><html:checkbox property="email" name="category" disabled="true"></html:checkbox> Email    </c:if> <c:if test="${coreCat[index].sms==true}" > <c:if test="${(category.modeID==2)||(category.modeID==3)}" > <html:checkbox property="sms" name="category" indexed="true" value="true"></html:checkbox> SMS </td> </c:if> <c:if test="${(category.modeID==0)}" > <html:checkbox property="sms" name="category" indexed="true" value="true"></html:checkbox> SMS </td> </c:if> </c:if> <c:if test="${coreCat[index].sms==false}" > <html:checkbox property="sms" name="category" disabled="true"></html:checkbox> SMS </td> </c:if> </tr> <tr> <td></td> <td ></td> <td></td> <td></td> </tr> <%-- </c:forEach>--%> </logic:iterate> <tr> <td></td> <td ></td> <td></td> <td></td> </tr> <tr> <td > </td> <td > </td> <td > </td> <td > </td> </tr> <tr> <html:submit /> <td ><img /></td> </tr> <tr> <td ></td> <td ></td> <td ></td> <td><html:checkbox property="test" name="ListMemberAlertsForm" ></html:checkbox></td> </tr> </table></td> </tr> </table> </html:form> </body> </html>




I am expecting this to happen:
when the user checks/unchecks ...the email/sms property inside the Category bean which is the basic element of the memberAlertList ArrayList (and memberAlertList is a property of the form bean ListMemberAlertsForm) should get set...

Please advice ...

Thanks and regards
Poonam.

Hi,
Will
VelocityEngineUtils.mergeTemplateIntoString(velocityEngine, "com/mcs/mailer/registration-confirmation.vm", model) work if the vm file contains an image.

Thanks,
Poonam .

Hi Jeanne,
I guess it's not prohibitting to send external mails because using my org's mailid i can send mail to gmail mailID's.
correct me if i am wrong..
Thanks,
Poonam.

Hi Mukhi,
Its not a web application so i will not be able to use ServletContext .I 've tried almost all options for the path of the image file but none worked . The html text content is visible but the image is not...

Thanks,
Poonam

In the .vm file i have referenced the image file as src="/EmailCompo/src/com/mcs/mailer/img123.jpg"

Thanks
Poonam.

Hi,
I have the following problem:
I've used Velocity to create email templates.In one of these templates i've text + image(inline) content.In the received email the text is visible but the image is not.I guess there is some issue with the path to the image file,but couldn't figure it out.My .vm file look something like this:

registration-confirmation.vm

# in the com/mcs/mailer <html> <body> <h3>Hi ${user.userName}, welcome to the Chipping Sodbury On-the-Hill message boards!</h3> <div> Your EMAIL address is <a href="mailto:${user.emailAddress}" rel="nofollow">${user.emailAddress}</a>. This is IMAGE [b]<img ></img>[/b] </div> </body> </html>
Also following is addtional information :
EmailCompo is the name of my application

image file location is :EmailTest/src/com/mcs/mailer/img123.jpg

vm file location : EmailTest/src/com/mcs/mailer/reg-con.vm

Cheers,
Poonam

Hi Friends,
i've succeeded in sending emails using spring framework email component, within my organisation's email id's.But what are the additional points i need to take care of if i have to send a mail to say a gmail id?I got the following error when i tried to send mail from my org's id to my gmail id.

Failed message 1:
javax.mail.SendFailedException: Invalid Addresses;
nested exception is:
com.sun.mail.smtp.SMTPAddressFailedException: 554 Relay rejected for policy reasons.

please advice.

cheers,
Poonam

HI,
I was trying out a simple example of isErrorPage and errorPage ...follwing is the code

TestJSP1.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" errorPage="ErrorHandler.jsp" pageEncoding="UTF-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <%int i= 0; if (i==0) { throw new Exception(); } %> Hello World </body> </html>


ErrorHandler.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" isErrorPage="true" pageEncoding="UTF-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> Sorry there was an error.Please try again!!!! <% System.out.println("exception----") ; %> </body> </html>

When i execute TestJSP1.jsp for the first time ,it seems as if the exception is not thrown and Hello World is printed...then when i refresh the same page, exception is thrown and 'Sorry there was an error.Please try again!!!' is printed...Why didn't TestJSP1.jsp throw an exception when executed for the first time itself?

cheers,
Poonam.