Amar Jee

Sorry, typo in the post.
I'm trying role1/tomcat as user/pwd (this is not working ).
Using tomcat 6.0.20.

I've configured my webapp to use BASIC authentication.
When attempting to access http://localhost:8080/DBTest/ I do get a popup asking for user/pwd.
On submitting the user/pwd as role1/password, it is not accepted and the popup keeps reappearing.
Below are the web.xml and tomcat-users.xml

web.xml
-----------------
<security-constraint> <web-resource-collection> <url-pattern>/*</url-pattern> </web-resource-collection> <auth-constraint> <role-name>role1</role-name> </auth-constraint> </security-constraint> <login-config> <auth-method>BASIC</auth-method> <realm-name>Tomcat Manager Application</realm-name> </login-config> <security-role> <role-name>role1</role-name> </security-role> <servlet> <servlet-name>testme</servlet-name> <servlet-class>TestServletExample</servlet-class> </servlet> <servlet-mapping> <servlet-name>testme</servlet-name> <url-pattern>/*</url-pattern> </servlet-mapping>

tomcat-users.xml
------------------------------
<role rolename="role1"/> <user username="role1" password="tomcat" roles="role1"/>

I've a few existing tables which have an id and version as PK.
This is mainly to keep track of all the updates.
Following are the problems I faced:
1. version can't be a part of composite-id.
2. if version is outside the composite-id, its not part of the PK and will not let me insert another version (due to PK violation).
3. envers wasn't helpful as it creates a seperate AUD table wheras I want the versioning in the same table.
Any ideas/suggestions would be greatly be appreciated

Hi,
I want to dynamically populate a java bean which has non primitive members, from a map.
By dynamically, I mean, I should be able to loop on the properties (as, the javabean type will be know at runtime) and set them based on key in the map.
I tried achieving the same using BeanUtilsBean.populate(), but it did not work.
For example, if the bean structure is as follows, I want to be able to populate Wrapper (its members) based on the map below the code snippet.
public class Wrapper{ private Person person; private Address address; //getters and setters } public class Person{ String name; int age; //getters and setters } public class Address{ String flatNumber; String street; String city; //getters and setters }
-------------------------
Key | Value
-------------------------
name | Tim
age | 29
faltNumber | 307
street | 78
city | NY

Sure. Thanks!
Oct 23, 2010 7:11:29 AM net.sf.jxls.reader.XLSReaderImpl readSheet INFO: Processing sheet Sheet1 Exception in thread "main" java.lang.NullPointerException at net.sf.jxls.reader.XLSForEachBlockReaderImpl.createNewCollectionItem(XLSForEachBlockReaderImpl.java:67) at net.sf.jxls.reader.XLSForEachBlockReaderImpl.read(XLSForEachBlockReaderImpl.java:43) at net.sf.jxls.reader.XLSSheetReaderImpl.read(XLSSheetReaderImpl.java:25) at net.sf.jxls.reader.XLSReaderImpl.readSheet(XLSReaderImpl.java:45) at net.sf.jxls.reader.XLSReaderImpl.read(XLSReaderImpl.java:31) at RowImport.main(RowImport.java:42)

Hi,
I'm trying to read excel rows to java bean but keep getting it keeps failing with null pointer exception.
Below is the code extract from XLSForEachBlockReaderImpl where itemsCollection comes out to be null.
PFA the xlsx file used for the below code (please replace .txt with .xlsx).
Please advice.

private void createNewCollectionItem(Collection itemsCollection, Map beans) { Object obj = null; try { obj = varType.newInstance(); } catch (Exception e) { String message = "Can't create a new collection item for " + items + ". varType = " + varType.getName(); readStatus.addMessage(new XLSReadMessage(message)); if (!ReaderConfig.getInstance().isSkipErrors()) { readStatus.setStatusOK(false); throw new XLSDataReadException(message, readStatus); } if (log.isWarnEnabled()) { log.warn(message); } } itemsCollection.add(obj); beans.put(var, obj); }

Following are the files I'm using:
RowImport.java
------------------------
public class RowImport { public static void main(String[] args) throws IOException, SAXException, InvalidFormatException{ String xmlConfig = "config.xml"; String dataXLS = "test.xlsx"; InputStream inputXML = new BufferedInputStream(new FileInputStream(xmlConfig)); XLSReader mainReader = ReaderBuilder.buildFromXML( inputXML ); InputStream inputXLS = new BufferedInputStream(new FileInputStream(dataXLS)); IR ir = new IR(); List irs = new ArrayList(); Map beans = new HashMap(); beans.put("IR", ir); XLSReadStatus readStatus = mainReader.read( inputXLS, beans); } }

config.xml
-------------------------
<?xml version="1.0" encoding="ISO-8859-1"?> <workbook> <worksheet name="Sheet1"> <loop startRow="2" endRow="2" items="IR" var="incident" varType="IR"> <section startRow="2" endRow="2"> <mapping row="2" col="0">incident.id</mapping> <!-- mapping row="2" col="3">incident.openDate</mapping --> <mapping row="2" col="6">incident.summary</mapping> </section> <loopbreakcondition> <rowcheck offset="0"> <cellcheck offset="0">""</cellcheck> </rowcheck> </loopbreakcondition> </loop> </worksheet> </workbook>

IR.java
-----------------
import java.util.Collections; import java.util.Date; public class IR{ private int id; private Date openDate; public int getId() { return id; } public void setId(int id) { this.id = id; } public Date getOpenDate() { return openDate; } public void setOpenDate(Date openDate) { this.openDate = openDate; } public String getSummary() { return summary; } public void setSummary(String summary) { this.summary = summary; } private String summary; }