Bigger type length than Maximum
807601Jan 27 2008 — edited Jan 27 2008Hello I am new to Java,
I am creating a simple web page to connect to oracle database using Java/JSP .. when I executed against Oracle 9i on my localhost it works fine , when I tried with Oracle 10 on the AIX server I am getting a "Bigger type length than Maximum" and null file error.This is a simple select statement.
Please see below the server log message.. Your help and suggestions is highly appreciated.
Thank you very much
26550 [#|2008-01-25T10:17:16.772-0500|INFO|IS5.1.3|javax.enterprise.system.stream.out|_ThreadID=22; ThreadName=http18001-Processor3;|
26551 [QAD_ENTITY, QAD_ACCT_CC_SUBACCT_XREF, QAD_ACCT_TRANSTYPE_XREF]|#]
26552
26553 [#|2008-01-25T10:17:28.209-0500|INFO|IS5.1.3|javax.enterprise.system.stream.out|_ThreadID=22; ThreadName=http18001-Processor3;|
26554 ================QAD_ENTITY======================|#]
26555
26556 [#|2008-01-25T10:17:28.210-0500|INFO|IS5.1.3|javax.enterprise.system.stream.out|_ThreadID=22; ThreadName=http18001-Processor3;|
26557 ========|||||||||||======== ORDER BY BU,OPLOC,QAD_ENTITY,QAD_DOMAIN,QAD_BU======================|#]
26558
26559 [#|2008-01-25T10:17:28.210-0500|INFO|IS5.1.3|javax.enterprise.system.stream.out|_ThreadID=22; ThreadName=http18001-Processor3;|
26560 ========|||||||||||========BU,OPLOC,QAD_ENTITY,QAD_ENTITY_DESC,QAD_DOMAIN,QAD_BU,DATETIME,USERID======================|#]
26561
26562 [#|2008-01-25T10:17:28.298-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26563 java.sql.SQLException: Bigger type length than Maximum|#]
26564
26565 [#|2008-01-25T10:17:28.298-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26566 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)|#]
26567
26568 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26569 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)|#]
26570
26571 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26572 at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:884)|#]
26573
26574 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26575 at oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMAREngine.java:2230)|#]
26576
26577 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26578 at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMAREngine.java:1047)|#]
26579
26580 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26581 at oracle.jdbc.driver.T4CTTIdcb.receiveCommon(T4CTTIdcb.java:111)|#]
26582
26583 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26584 at oracle.jdbc.driver.T4CTTIdcb.receiveFromRefCursor(T4CTTIdcb.java:103)|#]
26585
26586 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26587 at oracle.jdbc.driver.T4CResultSetAccessor.unmarshalOneRow(T4CResultSetAccessor.java:165)|#]
26588
26589 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26590 at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:787)|#]
26591
26592 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26593 at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:704)|#]
26594
26595 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26596 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:526)|#]
26597
26598 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26599 at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:179)|#]
26600
26601 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26602 at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:779)|#]
26603
26604 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26605 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1027)|#]
26606
26607 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26608 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2887)|#]
26609
26610 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26611 at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2978)|#]
26612
26613 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26614 at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4102)|#]
26615
26616 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26617 at Oracle_Connectivity.selectPagewise_TableContent(Oracle_Connectivity.java:177)|#]
26618
26619 [#|2008-01-25T10:17:28.299-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26620 at TableViewContent.doGet(TableViewContent.java:187)|#]
26621
26622 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26623 at TableViewContent.doPost(TableViewContent.java:240)|#]
26624
26625 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26626 at javax.servlet.http.HttpServlet.service(HttpServlet.java:768)|#]
26627
26628 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26629 at javax.servlet.http.HttpServlet.service(HttpServlet.java:861)|#]
26630
26631 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26632 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)|#]
26633
26634 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26635 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)|#]
26636
26637 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26638 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)|#]
26639
26640 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26641 at java.lang.reflect.Method.invoke(Method.java:615)|#]
26642
26643 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26644 at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:289)|#]
26645
26646 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26647 at java.security.AccessController.doPrivileged(AccessController.java:275)|#]
26648
26649 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26650 at javax.security.auth.Subject.doAsPrivileged(Subject.java:727)|#]
26651
26652 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26653 at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:318)|#]
26654
26655 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26656 at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:205)|#]
26657
26658 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26659 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)|#]
26660
26661 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26662 at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:102)|#]
26663
26664 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26665 at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:192)|#]
26666
26667 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26668 at java.security.AccessController.doPrivileged(AccessController.java:242)|#]
26669
26670 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26671 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)|#]
26672
26673 [#|2008-01-25T10:17:28.300-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26674 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:263)|#]
26675
26676 [#|2008-01-25T10:17:28.301-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26677 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:156)|#]
26678
26679 [#|2008-01-25T10:17:28.301-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26680 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:569)|#]
26681
26682 [#|2008-01-25T10:17:28.301-0500|WARNING|IS5.1.3|javax.enterprise.system.stream.err|_ThreadID=22; ThreadName=http18001-Processor3;|
26683 at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:261)|#]