You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "alina joshi (JIRA)" <ji...@apache.org> on 2010/12/03 16:43:11 UTC

[jira] Created: (DBCP-349) Insert clob or blob with oracle connection crashes software

Insert clob or blob with oracle connection crashes software 
------------------------------------------------------------

                 Key: DBCP-349
                 URL: https://issues.apache.org/jira/browse/DBCP-349
             Project: Commons Dbcp
          Issue Type: Bug
    Affects Versions: 1.3
         Environment: windows XP , JDK 1.6, oracle 10g, oracle driver 10.2.0.2
            Reporter: alina joshi
            Priority: Critical


 1> tomcat 6.0.26 has tomcat-dbcp.jar that works completely fine. 

 2> tomcat 6.0.28, tomcat 6.0.29, tomcat 5.0.30, tomcat 5.0.31 has tomcat-dbcp.jar file that doesn't work and throws following error :

java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection
        at oracle.sql.CLOB.createTemporary(CLOB.java:754)
        at oracle.sql.CLOB.createTemporary(CLOB.java:716)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

Would like to know if there was any changes to the commons dbcp package for tomcat version 6.0.29?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (DBCP-349) Insert clob or blob with oracle connection crashes software

Posted by "alina joshi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DBCP-349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

alina joshi closed DBCP-349.
----------------------------

    Resolution: Fixed

> Insert clob or blob with oracle connection crashes software 
> ------------------------------------------------------------
>
>                 Key: DBCP-349
>                 URL: https://issues.apache.org/jira/browse/DBCP-349
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.3
>         Environment: windows XP , JDK 1.6, oracle 10g, oracle driver 10.2.0.2
>            Reporter: alina joshi
>            Priority: Critical
>             Fix For: 1.3.1, 1.4.1
>
>
>  1> tomcat 6.0.26 has tomcat-dbcp.jar that works completely fine. 
>  2> tomcat 6.0.28, tomcat 6.0.29, tomcat 5.0.30, tomcat 5.0.31 has tomcat-dbcp.jar file that doesn't work and throws following error :
> java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection
>         at oracle.sql.CLOB.createTemporary(CLOB.java:754)
>         at oracle.sql.CLOB.createTemporary(CLOB.java:716)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> Would like to know if there was any changes to the commons dbcp package for tomcat version 6.0.29?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] [Commented] (DBCP-349) Insert clob or blob with oracle connection crashes software

Posted by "alina joshi (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DBCP-349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13017611#comment-13017611 ] 

alina joshi commented on DBCP-349:
----------------------------------

I have closed this issue as I got an email message from you stating it was fixed in DBCP 1.3.1  version.



> Insert clob or blob with oracle connection crashes software 
> ------------------------------------------------------------
>
>                 Key: DBCP-349
>                 URL: https://issues.apache.org/jira/browse/DBCP-349
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.3
>         Environment: windows XP , JDK 1.6, oracle 10g, oracle driver 10.2.0.2
>            Reporter: alina joshi
>            Priority: Critical
>             Fix For: 1.3.1, 1.4.1
>
>
>  1> tomcat 6.0.26 has tomcat-dbcp.jar that works completely fine. 
>  2> tomcat 6.0.28, tomcat 6.0.29, tomcat 5.0.30, tomcat 5.0.31 has tomcat-dbcp.jar file that doesn't work and throws following error :
> java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection
>         at oracle.sql.CLOB.createTemporary(CLOB.java:754)
>         at oracle.sql.CLOB.createTemporary(CLOB.java:716)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> Would like to know if there was any changes to the commons dbcp package for tomcat version 6.0.29?

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Updated: (DBCP-349) Insert clob or blob with oracle connection crashes software

Posted by "Phil Steitz (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DBCP-349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Phil Steitz updated DBCP-349:
-----------------------------

    Fix Version/s: 1.4.1
                   1.3.1

> Insert clob or blob with oracle connection crashes software 
> ------------------------------------------------------------
>
>                 Key: DBCP-349
>                 URL: https://issues.apache.org/jira/browse/DBCP-349
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.3
>         Environment: windows XP , JDK 1.6, oracle 10g, oracle driver 10.2.0.2
>            Reporter: alina joshi
>            Priority: Critical
>             Fix For: 1.3.1, 1.4.1
>
>
>  1> tomcat 6.0.26 has tomcat-dbcp.jar that works completely fine. 
>  2> tomcat 6.0.28, tomcat 6.0.29, tomcat 5.0.30, tomcat 5.0.31 has tomcat-dbcp.jar file that doesn't work and throws following error :
> java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection
>         at oracle.sql.CLOB.createTemporary(CLOB.java:754)
>         at oracle.sql.CLOB.createTemporary(CLOB.java:716)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> Would like to know if there was any changes to the commons dbcp package for tomcat version 6.0.29?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] [Commented] (DBCP-349) Insert clob or blob with oracle connection crashes software

Posted by "Thomas WERMESTER (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DBCP-349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13403990#comment-13403990 ] 

Thomas WERMESTER commented on DBCP-349:
---------------------------------------

Hi, same problem appear on new release tomcat 6 => version 6.0.35
                
> Insert clob or blob with oracle connection crashes software 
> ------------------------------------------------------------
>
>                 Key: DBCP-349
>                 URL: https://issues.apache.org/jira/browse/DBCP-349
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.3
>         Environment: windows XP , JDK 1.6, oracle 10g, oracle driver 10.2.0.2
>            Reporter: alina joshi
>            Priority: Critical
>             Fix For: 1.3.1, 1.4.1
>
>
>  1> tomcat 6.0.26 has tomcat-dbcp.jar that works completely fine. 
>  2> tomcat 6.0.28, tomcat 6.0.29, tomcat 5.0.30, tomcat 5.0.31 has tomcat-dbcp.jar file that doesn't work and throws following error :
> java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection
>         at oracle.sql.CLOB.createTemporary(CLOB.java:754)
>         at oracle.sql.CLOB.createTemporary(CLOB.java:716)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> Would like to know if there was any changes to the commons dbcp package for tomcat version 6.0.29?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (DBCP-349) Insert clob or blob with oracle connection crashes software

Posted by "Phil Steitz (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DBCP-349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13017602#comment-13017602 ] 

Phil Steitz commented on DBCP-349:
----------------------------------

You are correct that there were no DBCP commits on this issue.  It was closed by the original reporter.  Status should have been INVALID or NOT_A_PROBLEM since there was no fix applied.  Feel free to reopen.

> Insert clob or blob with oracle connection crashes software 
> ------------------------------------------------------------
>
>                 Key: DBCP-349
>                 URL: https://issues.apache.org/jira/browse/DBCP-349
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.3
>         Environment: windows XP , JDK 1.6, oracle 10g, oracle driver 10.2.0.2
>            Reporter: alina joshi
>            Priority: Critical
>             Fix For: 1.3.1, 1.4.1
>
>
>  1> tomcat 6.0.26 has tomcat-dbcp.jar that works completely fine. 
>  2> tomcat 6.0.28, tomcat 6.0.29, tomcat 5.0.30, tomcat 5.0.31 has tomcat-dbcp.jar file that doesn't work and throws following error :
> java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection
>         at oracle.sql.CLOB.createTemporary(CLOB.java:754)
>         at oracle.sql.CLOB.createTemporary(CLOB.java:716)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> Would like to know if there was any changes to the commons dbcp package for tomcat version 6.0.29?

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (DBCP-349) Insert clob or blob with oracle connection crashes software

Posted by "Renaud Bruyeron (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DBCP-349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13016856#comment-13016856 ] 

Renaud Bruyeron commented on DBCP-349:
--------------------------------------


Is this really fixed? I looked into the SVN logs and cannot find the relevant commits.

> Insert clob or blob with oracle connection crashes software 
> ------------------------------------------------------------
>
>                 Key: DBCP-349
>                 URL: https://issues.apache.org/jira/browse/DBCP-349
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.3
>         Environment: windows XP , JDK 1.6, oracle 10g, oracle driver 10.2.0.2
>            Reporter: alina joshi
>            Priority: Critical
>             Fix For: 1.3.1, 1.4.1
>
>
>  1> tomcat 6.0.26 has tomcat-dbcp.jar that works completely fine. 
>  2> tomcat 6.0.28, tomcat 6.0.29, tomcat 5.0.30, tomcat 5.0.31 has tomcat-dbcp.jar file that doesn't work and throws following error :
> java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection
>         at oracle.sql.CLOB.createTemporary(CLOB.java:754)
>         at oracle.sql.CLOB.createTemporary(CLOB.java:716)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> Would like to know if there was any changes to the commons dbcp package for tomcat version 6.0.29?

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (DBCP-349) Insert clob or blob with oracle connection crashes software

Posted by "Renaud Bruyeron (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DBCP-349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13404921#comment-13404921 ] 

Renaud Bruyeron commented on DBCP-349:
--------------------------------------


FYI, the stacktrace is missing the top of the stack, but in our case (a spring/hibernate application) there is a workaround at the application level: one must use CommonsDbcpNativeJdbcExtractor instead of SimpleNativeJdbcExtractor.
                
> Insert clob or blob with oracle connection crashes software 
> ------------------------------------------------------------
>
>                 Key: DBCP-349
>                 URL: https://issues.apache.org/jira/browse/DBCP-349
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.3
>         Environment: windows XP , JDK 1.6, oracle 10g, oracle driver 10.2.0.2
>            Reporter: alina joshi
>            Priority: Critical
>             Fix For: 1.3.1, 1.4.1
>
>
>  1> tomcat 6.0.26 has tomcat-dbcp.jar that works completely fine. 
>  2> tomcat 6.0.28, tomcat 6.0.29, tomcat 5.0.30, tomcat 5.0.31 has tomcat-dbcp.jar file that doesn't work and throws following error :
> java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection
>         at oracle.sql.CLOB.createTemporary(CLOB.java:754)
>         at oracle.sql.CLOB.createTemporary(CLOB.java:716)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> Would like to know if there was any changes to the commons dbcp package for tomcat version 6.0.29?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Reopened] (DBCP-349) Insert clob or blob with oracle connection crashes software

Posted by "Phil Steitz (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DBCP-349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Phil Steitz reopened DBCP-349:
------------------------------


Sorry, Alina.  I see what happened now.  I changed the "fix version" to 1.3.1/1.4.1 and that generated an email to you telling you about the issue status change.  When we update the "fix version" we are just indicating that we plan to fix the bug in that version, not necessarily that we have already fixed it.  Thanks for the bug report and sorry I misinterpreted the close action.

Thanks, Renaud for pointing out that it had been closed without a committed fix.

Patches, of course welcome!

> Insert clob or blob with oracle connection crashes software 
> ------------------------------------------------------------
>
>                 Key: DBCP-349
>                 URL: https://issues.apache.org/jira/browse/DBCP-349
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.3
>         Environment: windows XP , JDK 1.6, oracle 10g, oracle driver 10.2.0.2
>            Reporter: alina joshi
>            Priority: Critical
>             Fix For: 1.3.1, 1.4.1
>
>
>  1> tomcat 6.0.26 has tomcat-dbcp.jar that works completely fine. 
>  2> tomcat 6.0.28, tomcat 6.0.29, tomcat 5.0.30, tomcat 5.0.31 has tomcat-dbcp.jar file that doesn't work and throws following error :
> java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolableConnection cannot be cast to oracle.jdbc.OracleConnection
>         at oracle.sql.CLOB.createTemporary(CLOB.java:754)
>         at oracle.sql.CLOB.createTemporary(CLOB.java:716)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> Would like to know if there was any changes to the commons dbcp package for tomcat version 6.0.29?

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira