[Persistence, JBoss/CMP, Hibernate, Database] - Stored procedure calls made easy
by wkudla
Hi!
Since there is a lot of stored procedure invocations in my current project (on Oracle db) I decided to isolate a dedicated component for completing this task.
The project is called JProcedure and being hosted on google code at the moment: http://jprocedure.googlecode.com.
There is some wiki documentation showing how to use the stuff.
The basic concept for this project was to simplify stored procedure invocations from java code (which can be a pain in the *** sometimes) by leveraging java annotations.
The only thing you have to do is annotate a class that represents stored procedure definition and then annotate any method that reflects a stored procedure. For transforming the statement output you will have to write your custom ResultTransformer and that's it.
The engine supports automated caching (which you can turn on and off using annotations) and custom invocation interceptors that allow you to add additional logic before and after a stored procedure call.
Current limitations:
1. There is only Oracle support implemented at the moment, but supporting other db vendors is just a matter of implementing a single StatementBuilder interface.
2. The Connection object is being obtained from JNDI given a DataSource path and does not support caching Datasource object - this will be enchanced to support different ways of obtaining a connection
3. There is no specific exception handling policy (on to do list)
4. No transaction management which means you have to use the component in transactional context or manage transaction yourself (To be done)
The engine works and occured to be extremely handy, hence the decision of open-sourcing it.
If you find few spare minutes and take a look at what has been done so far, I will very much appreciate any positive and negative feedback.
Once again: http://jprocedure.googlecode.com/
Thanks in advance
Wojciech Kudla
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4160961#4160961
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4160961
17 years, 9 months
[Installation, Configuration & DEPLOYMENT] - jmx-console throws ClassNotFoundException
by gjeudy
Hi,
I downloaded jboss-4.2.2-GA.zip and unzipped it, then I copied the contents of 'all' dir into a new server instance dir.
I started this instance with a new port configuration using ServiceBindingManager, ports-03 config.
Now when I access the jmx-console I get the following exception thrown in the server logs:
2008-06-26 14:27:38,787 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/jmx-console].[jsp]] Servlet.service() for servlet jsp threw exc
| eption
| java.lang.NoClassDefFoundError: org/eclipse/jdt/internal/compiler/problem/ProblemReporter
| at org.eclipse.jdt.internal.compiler.Compiler.<init>(Compiler.java:256)
| at org.eclipse.jdt.internal.compiler.Compiler.<init>(Compiler.java:149)
| at org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:399)
| at org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
| at org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
| 2008-06-26 14:27:23,568 DEBUG [org.ajax4jsf.webapp.BaseFilter] Finished request processing total time 2ms for uri: /ReferenceDataManager/a4j_3_2_1-SNAPSHOTorg.
| richfaces.renderkit.html.GradientA/DATB/eAH7..3Tj2v7mAAZZAV3
| 2008-06-26 14:27:35,820 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 30000
| 2008-06-26 14:27:38,787 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/jmx-console].[jsp]] Servlet.service() for servlet jsp threw exc
| eption
| java.lang.NoClassDefFoundError: org/eclipse/jdt/internal/compiler/problem/ProblemReporter
| at org.eclipse.jdt.internal.compiler.Compiler.<init>(Compiler.java:256)
| at org.eclipse.jdt.internal.compiler.Compiler.<init>(Compiler.java:149)
| at org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:399)
| at org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
| at org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
| at org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
| at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
| at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:316)
| at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)
| at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
| 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:127)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
| 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:262)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
| at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
| at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
| at java.lang.Thread.run(Thread.java:595)
|
Has anyone run into similar issues ?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4160952#4160952
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4160952
17 years, 9 months