Home.... | log in.... | Pub my question! | Sign-up....

Java-index >> Development Tools >> Java Tools

Sun Java Studio Creator - It;s a bug

From reading this forum I find that the problem I am experiencing is a BUG between SJSC2.1 and Oracle

The suggested solution is to "open the rowset and add CONCUR_READ_ONLY".

How to do this?

I have tried this In bold and italics) with no luck:

private void _init() throws Exception {

personRowSet.setDataSourceName("java:comp/env/jdbc/Traveler");

personRowSet.setCommand("CONCUR_READ_ONLY");

personRowSet.setCommand("SELECT * FROM TRAVELER.PERSON");

personRowSet.setTableName("PERSON");

Thanks..

[564 byte] By [SummerWinea] at [2007-11-26 23:25:30]

«« Sun Java System Directory Server - 'ip' keyword in ACIs
»» Swing - Question about JEditorPane

# 1

Take a look at this thread: http://forum.java.sun.com/thread.jspa?forumID=881&threadID=5058093

Rradhikaa at 2007-7-10 14:32:53 >

top of Java-index,Development Tools,Java Tools...

# 2

also, description of your original problem might get you more response

Rradhikaa at 2007-7-10 14:32:53 >

# 3

I added the code to set concurrency CONCUR_READ_ONLY and that did not work... I think I read somewhere that CONCUR_READ_ONLY is the default anyway..

I am simply using the Databound Components Tutorial and switching from Derby (local XP and Sun AS PE 8.x) to Oracle (remote - Solaris 9 and Oracle 9i (9.2.0.6))

The tutorial runs ok on XP w/derby

The First section of the Application runs ok w/Oracle (remote) i.e., the query that uses the dropdown list component.

It is when I add the "data" table and associated query that fails with the below dump.

I also created a derby and Oracle 9i version of the tutorial "Creating Bookmarkable URLs" and got the same results: works w/Derby does not work with Oracle - remote)

Thanks for looking at this..

Here is the dump:

Exception Handler

Description: An unhandled exception occurred during the execution of the web application. Please review the following stack trace for more information regarding the error.

Exception Details: org.apache.jasper.JasperException

java.sql.SQLException: [sunm][Oracle JDBC Driver]Invalid parameter binding(s).

Possible Source of Error:

Class Name: org.apache.jasper.servlet.JspServletWrapper

File Name: JspServletWrapper.java

Method Name: service

Line Number: 384

Source not available. Information regarding the location of the exception can be identified using the exception stack trace below.

Stack Trace:

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:297)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:247)

javax.servlet.http.HttpServlet.service(HttpServlet.java:860)

sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

java.lang.reflect.Method.invoke(Method.java:585)

org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)

java.security.AccessController.doPrivileged(AccessController.java:-2)

javax.security.auth.Subject.doAsPrivileged(Subject.java:517)

org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)

org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:257)

org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55)

org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:161)

java.security.AccessController.doPrivileged(AccessController.java:-2)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:723)

org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:482)

org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:417)

org.apache.catalina.core.ApplicationDispatcher.access$000(ApplicationDispatcher.java:80)

org.apache.catalina.core.ApplicationDispatcher$PrivilegedForward.run(ApplicationDispatcher.java:95)

java.security.AccessController.doPrivileged(AccessController.java:-2)

org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:313)

com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)

com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)

com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.java:311)

com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:221)

com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)