[JBoss Getting Started Documentation] - beginner- sqlexception with hsqldb
by jboss_dev
I am trying to use hsqldb in jboss-4.0.5.GA .I tried the following small jdbc code .
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
class JDBC_test
{
public static void main(String args[])
{
Connection conn=null;
Statement select=null;
try
{
Class.forName("org.hsqldb.jdbcDriver");
System.out.println("Driver loaded...");
}
catch(Exception e)
{
System.out.println("Failed to load hsql driver.");
return;
}
try
{
conn = DriverManager.getConnection("jdbc:hsqldb:file:db/anu","sa","");
System.out.println("connected to hsql..");
select = conn.createStatement();
System.out.println("after create statement..");
}
catch(Exception e) {System.out.println("create statement failed");}
try
{
ResultSet result = select.executeQuery("SELECT custid,firstname FROM customer_details");
System.out.println("Got results:");
while (result.next())
{ // process results one row at a time
int key = result.getInt(1);
String val = result.getString(2);
System.out.println("key = " + key);
System.out.println("val = " + val);
}
} catch (Exception e) {
e.printStackTrace();}
finally
{
if(conn!=null)
{
try { conn.close(); }
catch(Exception e){e.printStackTrace();}
}
}
}
}
I have a table customer_details created with few columns in the stand alone mode.
But I am getting the following error while running the code
Driver loaded...
connected to hsql..
after create statement..
java.sql.SQLException: Table not found in statement [SELECT custid,firstname FRO
M customer_details]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at JDBC_test.main(JDBC_test.java:36)
Can anyone help me out with this error?
thanks and regards,
java_dev.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4099965#4099965
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4099965
18Â years, 6Â months
[Management, JMX/JBoss] - JMX notifications
by alfred.rsa
I am having difficulty in getting notifications to work
I have 2 MBeans and one must dispatch and the other receive notifications.
The dispatcher extends ServiceMBeanSupport (and also uses the @Service annotation). It send by creating a notification and sending it with:
Notification notification = new Notification("BFLO_EVENT", this, getNextNotificationSequenceNumber(), "TEST MESSAGE");
sendNotification(notification);
The receiver extends ListenerServiceMBeanSupport and overrides handleNotification2.
Now in the startService method I try to subscribe to notifications by using various versions of subscribe(), but the handleNotification2 method is never called. (I am trying to subscribe dynamically without config files)
Can someone please show me where im going wrong?
Regards
Alfred
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4099963#4099963
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4099963
18Â years, 6Â months
[JBoss Seam] - Seam, Drools, and Load Testing
by sradford
Hi,
I've just done some very quick and simple load testing of Seam 2 CR2 application and have identified 2 issues as we ramp up the number of users:
1. If the ramp up is quick, the securityRules component does not get instantiated resulting in an NPE (for the current and ALL subsequent users!):
16:48:39,125 ERROR [SeamPhaseListener] uncaught exception
javax.el.ELException: java.lang.NullPointerException
at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:332)
at org.jboss.el.parser.AstFunction.getValue(AstFunction.java:84)
at org.jboss.el.parser.AstOr.getValue(AstOr.java:21)
at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at org.jboss.seam.core.Expressions$1.getValue(Expressions.java:112)
at org.jboss.seam.security.Identity.evaluateExpression(Identity.java:606)
at org.jboss.seam.security.Identity.checkRestriction(Identity.java:215)
at org.jboss.seam.navigation.Page.checkPermission(Page.java:218)
at org.jboss.seam.navigation.Page.preRender(Page.java:238)
at org.jboss.seam.navigation.Pages.preRender(Pages.java:309)
at org.jboss.seam.jsf.SeamPhaseListener.preRenderPage(SeamPhaseListener.java:544)
at org.jboss.seam.jsf.SeamPhaseListener.beforeRenderResponse(SeamPhaseListener.java:455)
at org.jboss.seam.jsf.SeamPhaseListener.beforeServletPhase(SeamPhaseListener.java:146)
at org.jboss.seam.jsf.SeamPhaseListener.beforePhase(SeamPhaseListener.java:116)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:222)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:44)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)
at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:150)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at org.jboss.seam.security.RuleBasedIdentity.hasRole(RuleBasedIdentity.java:162)
at org.jboss.seam.security.SecurityFunctions.hasRole(SecurityFunctions.java:12)
at sun.reflect.GeneratedMethodAccessor853.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:328)
... 53 more
2. If we have a slow ramp up to avoid the NPE above intermittently we get AuthorizationExceptions (when they should not be thrown) which seem to only ocurr on Class/Method restrictions (rather than xhtml tag expressions):
javax.faces.FacesException: javax.el.ELException: /user/index.xhtml @21,99 value="#{searchUserAction.statusOptions}": Error reading 'statusOptions' on type org.javassist.tmp.java.lang.Object_$$_javassist_6
at javax.faces.component.UIOutput.getValue(UIOutput.java:176)
at com.sun.faces.renderkit.html_basic.MenuRenderer.getCurrentSelectedValues(MenuRenderer.java:624)
at com.sun.faces.renderkit.html_basic.SelectManyCheckboxListRenderer.renderOption(SelectManyCheckboxListRenderer.java:265)
at com.sun.faces.renderkit.html_basic.SelectManyCheckboxListRenderer.encodeEnd(SelectManyCheckboxListRenderer.java:146)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:836)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:279)
at com.sun.faces.renderkit.html_basic.GroupRenderer.encodeChildren(GroupRenderer.java:117)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)
at javax.faces.render.Renderer.encodeChildren(Renderer.java:137)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)
at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:592)
at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:108)
at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:216)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:44)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)
at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:150)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: javax.el.ELException: /user/index.xhtml @21,99 value="#{searchtUserAction.statusOptions}": Error reading 'statusOptions' on type org.javassi
st.tmp.java.lang.Object_$$_javassist_6
at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
at javax.faces.component.UIOutput.getValue(UIOutput.java:173)
... 56 more
Caused by: org.jboss.seam.security.AuthorizationException: Authorization check failed for expression [#{s:hasPermission('user','search',null)}]
at org.jboss.seam.security.Identity.checkRestriction(Identity.java:227)
at org.jboss.seam.security.SecurityInterceptor.aroundInvoke(SecurityInterceptor.java:38)
at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
at org.jboss.seam.ejb.RemoveInterceptor.aroundInvoke(RemoveInterceptor.java:41)
at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:106)
at org.jboss.seam.intercept.ClientSideInterceptor.invoke(ClientSideInterceptor.java:54)
at org.javassist.tmp.java.lang.Object_$$_javassist_6.getStatusOptions(Object_$$_javassist_6.java)
at sun.reflect.GeneratedMethodAccessor501.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
at org.jboss.el.parser.AstPropertySuffix.getValue(AstPropertySuffix.java:53)
at org.jboss.el.parser.AstValue.getValue(AstValue.java:67)
at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
... 57 more
Any ideas / pointers to resolve these issues?
Are we likely to be doing something wrong or is this a Seam / Drools problem?
Thanks and regards.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4099961#4099961
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4099961
18Â years, 6Â months
[JBoss Seam] - Re: Writing SeamTests with Seam 2.0.0. CR2 - What's Changed?
by bsmithjj
oh yes, one rant - if a specific version of testng is required, then what happened to the days when frameworks listed out their depedencies including versions? Has listing depedencies gone the way of documentation? ;-)
from an old version of hibernate:
| ant.jar (1.5.3)
| - Ant core
| - buildtime
|
| c3p0.jar (0.8.3)
| - C3P0 JDBC connection pool
| - runtime, optional
|
| cglib2.jar (2.0rc1)
| - CGLIB bytecode generator
| - runtime, required
|
| commons-collections.jar (2.1)
| - runtime, required
|
| commons-dbcp.jar (1.1)
| - runtime, optional
|
| commons-lang.jar (1.0.1)
| - runtime, optional (required by JCS)
|
| commons-logging.jar (1.0.3)
| - runtime, required
|
| commons-pool.jar (1.1)
| - runtime, optional
|
| concurrent.jar
| - runtime, optional (required by TreeCache)
|
| connector.jar
| - Standard JCA API
| - runtime, optional
|
| dom4j.jar (1.4)
| - XML configuration & mapping parser
| - runtime, required
|
| ehcache.jar (0.6)
| - EHCache cache
| - runtime, optional
|
| hibernate2.jar (2.0)
| - Hibernate core
| - runtime, required
|
| jaas.jar
| - Standard JAAS API
| - runtime, optional (required by JCA)
|
| jboss-cache.jar (CVS-11.12.03)
| - TreeCache clustered cache
| - runtime, optional
|
| jboss-common.jar
| - runtime, optional (required by TreeCache)
|
| jboss-jmx.jar
| - runtime, optional (required by TreeCache)
|
| jboss-system.jar
| - runtime, optional (required by TreeCache)
|
| jcs.jar (1.0-dev)
| - JCS cache
| - runtime, optional (deprecated)
|
| jdbc2_0-stdext.jar
| - Standard JDBC APIs
| - runtime, required for standalone operation (outside application server)
|
| jgroups.jar (2.2)
| - JGroups multicast library
| - runtime, optional (required by replicated caches)
|
| jta.jar
| - Standard JTA API
| - runtime, required for standalone operation (outside application server)
|
| junit.jar (3.8.1)
| - JUnit test framework
| - buildtime
|
| odmg.jar (3.0)
| - ODMG API 3.0
| - runtime, required
|
| optional.jar (1.5.3)
| - Ant optional tasks
| - buildtime
|
| oscache.jar (2.0)
| - OpenSymphony OSCache
| - runtime, optional
|
| proxool.jar (0.7.2)
| - Proxool JDBC connection pool
| - runtime, optional
|
| swarmcache.jar (1.0rc2)
| - SwarmCache replicated cache
| - runtime, optional
|
| xalan.jar (2.4.0)
| - XSLT processor
| - runtime, required
|
| xerces.jar (2.4.0)
| - SAX parser
| - runtime, some SAX parser is required
|
| xml-apis.jar
| - Standard JAXP API
| - runtime, some SAX parser is required
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4099944#4099944
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4099944
18Â years, 6Â months