Issues with iBATIS and godaddy shared hosting

[Rory Thomas]

Anyone having trouble, or better yet, success (!), using iBATIS with godaddy shared hosting? I seem to be having an issue.

My setup is working with no problems on my home machine:
Apache Tomcat 5.0
Java 1.5 (compiled as 1.5 to match what is available from GoDaddy)
Struts 1.3.8
ibatis 2.3.4

However, when loaded to my godaddy account, it gets a nullpointer exception when processing the DynaValidatorForm. Through some error checking and testing, I was able to determine that it appears that one of my beans is returning as null. I believe it may have to do with not having the iBATIS jar on the server, even though I have it included in my webapp's build path.

Although the issue could be user error with the database call, I suspect it is because I cannot use iBATIS with godaddy. Has anyone had success with this?

Again, everything works on my home setup, so I'm just trying to figure out if I'm just having trouble getting it up on GoDaddy, or if GoDaddy actually won't allow me to do this (they rarely give straight answers)

In case code helps:

    
SQL MAP xml:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig PUBLIC 
"-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
 
<sqlMapConfig>
<transactionManager type="JDBC" >
<dataSource type="SIMPLE">
<property name="JDBC.Driver"
value="com.mysql.jdbc.Driver"/>
<property name="JDBC.ConnectionURL"
value="jdbc:mysql://p50mysql111.secureserver.net/usernamedb"/>
<property name="JDBC.Username"
value="usernamedb"/>
<property name="JDBC.Password"
value="fakepassword"/>
</dataSource>
</transactionManager>

<sqlMap resource="com/rorycullen/ibatis/PersonInfo.xml" />

</sqlMapConfig>
 
XML file:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC 
"-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="PersonInfo">
<select id="getEmail" parameterClass="string" resultClass="com.rorycullen.PersonInfo">
SELECT
ID as id,
Email as email,
Last_Name as lastName,
First_Name as firstName,
IP_Address as ipAddress,
Salutation as salutation
FROM emails
WHERE Email = #email#
</select>
</sqlMap>
 
Source file for bean:
 
package com.rorycullen;
 
public class PersonInfo implements java.io.Serializable {
private int ID;
private String email;
private String lastName;
private String firstName;
private String ipAddress;
private String salutation;
static final long serialVersionUID = 1L;

public PersonInfo() {}
 <snip> usual getters/setters </snip>
}
 
Struts Action:
package com.rorycullen.struts.actions;
 
import com.rorycullen.ibatis.*;
import com.rorycullen.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.validator.DynaValidatorForm;
 
public class LoginAction extends Action {
public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest req,HttpServletResponse resp)
    {
DynaValidatorForm lf = (DynaValidatorForm)form;
System.out.println("email is " +lf.get("email"));
System.out.println("password is " +lf.get("password"));
IbatisEmailChecker ib = new IbatisEmailChecker();
 
// [B]this is where I get a null PersonInfo object back from my other code[/B]
PersonInfo emailConfirmed = ib.ibatisTest((String)lf.get("email"));
 
// Split lines below in two pieces to find problem
if(emailConfirmed == null) {
return mapping.findForward("failure");
} else {


 
String confirmed = emailConfirmed.getSalutation();
    if (emailConfirmed != null) {
    return mapping.findForward("success");
    } else {
    return mapping.findForward("success");
    }
}
    }
}
 
Method used from IbatisEmailChecker class:
 
public PersonInfo ibatisTest(String emailEntered) {
PersonInfo pi = null;
String resource = "com/rorycullen/ibatis/SqlMapConfig.xml";
//String resource = "com/rorycullen/ibatis/SqlMapConfig-home.xml";
try{
Reader reader = Resources.getResourceAsReader(resource);

SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
 
pi = (PersonInfo) sqlMap.queryForObject("getEmail", emailEntered);
System.out.println("First Name = " + pi.getFirstName());
System.out.println("Last Name = " + pi.getLastName());
System.out.println("ID = " + pi.getID());
} catch (Exception ex) {
System.out.println("Error in IbatisEmailChecker dangit= " + ex);
}
return pi;
} 

Thanks!