Uncategorized

Expanding Rich tree nodes programmatically

9 Comments / Uncategorized / By

I have found two different methods for expanding nodes in Rich tree  from code, they both take  advantage of component binding and component state. Tree Setup <rich:tree value="#{ourbean.sampleTree}" binding="#{ourbean.sampleTreeBinding}"   var="node" nodeFace="simple" id="someid" > <rich:treeNode type="simple" > <h:outputText value="#{node}"/> </rich:treeNode> </rich:tree><rich:tree value="#{ourbean.sampleTree}" binding="#{ourbean.sampleTreeBinding}" var="node" nodeFace="simple" id="someid" > <rich:treeNode type="simple" > <h:outputText value="#{node}"/> </rich:treeNode> </rich:tree> Only thing to …

Expanding Rich tree nodes programmatically Read More »

Show last executed query SQL Server – Disected

1 Comment / Uncategorized / By

I found this online, without explanation so I will dissect the query and explain what is happening. SELECT deqs.last_execution_time AS [TIME], dest.TEXT AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest ORDER BY deqs.last_execution_time DESCSELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest ORDER BY deqs.last_execution_time …

Show last executed query SQL Server – Disected Read More »

Including spaces/html entities in JSF component output.

1 Comment / Uncategorized / By

Rather a silly problem but a problem nevertheless, including html entities as spaces special charactes etc… causes them to be escaped by the jsf. So something like getSpacedName(){return “Hello   world”;} will be outputed in the pages exactly as we have entered in out method above. On regulat h:outputText we can use ‘escape’ attribute and set it …

Including spaces/html entities in JSF component output. Read More »

Why do I get a java.sql.SQLException: “Unable to get information from SQL Server” when trying to connect to an SQL Server instance?

Leave a Comment / Uncategorized / By

Possible solution 1 I am using jtds driver so I would suggest checkingout their proposed solution first here http://jtds.sourceforge.net/faq.html#instanceGetInfo Possible solution 2 Their solution did not for me so here is what I did : From cmd prompt run sqlcmd -L and make sure that the server you are connecting is listed in the returned …

Why do I get a java.sql.SQLException: “Unable to get information from SQL Server” when trying to connect to an SQL Server instance? Read More »

org.hibernate.HibernateException: The chosen transaction strategy requires access to the JTA TransactionManager

20 Comments / Uncategorized / By

While setting up a simple web app on JBoss 5 using container manager transaction I run into following exception Caused by: org.hibernate.HibernateException: The chosen transaction strategy requires access to the JTA TransactionManager at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:361) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)Caused by: org.hibernate.HibernateException: The chosen transaction strategy requires access to the JTA TransactionManager at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:361) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327) Well after some …

org.hibernate.HibernateException: The chosen transaction strategy requires access to the JTA TransactionManager Read More »

Preventing ViewExpiredException in JSF

37 Comments / Uncategorized / By

When our page is idle for x amount of time the view will expire and throw javax.faces.application.ViewExpiredException to prevent this from happening one solution is to create CustomViewHandler that extends ViewHandler and override restoreView method all the other methods are being delegated to the Parent import java.io.IOException; import javax.faces.FacesException; import javax.faces.application.ViewHandler; import javax.faces.component.UIViewRoot; import javax.faces.context.FacesContext; …

Preventing ViewExpiredException in JSF Read More »

Xpath alternate row colors

Leave a Comment / Uncategorized / By

This XPath expression will let you alternate row colors Alternate Rows <wr:if select="1+count(preceding-sibling::*) mod 2 = 1"> ROW A Color <wr:else/> ROW B Color </wr:if>Alternate Rows <wr:if select="1+count(preceding-sibling::*) mod 2 = 1"> ROW A Color <wr:else/> ROW B Color </wr:if> Example I will provide complete example soon.