473,221 Members | 1,722 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,221 software developers and data experts.

Protocol violation, Bigger than maximum error

4
Hi

The highlighted below is the sample code I used for calling my stored procedure.

Callable statement cstmt = conn.prepareCall( BEGIN STOREDPROCNAME(?,?,?);END;);
ArrayDescriptor arrayDescriptor = new ArrayDescriptor(Name of type,cstmt.getConnection());
ARRAY acctList = new ARRAY(arrayDescriptor,conn, flrList.toArray());

cstmt.setInt(1,10);
cstmt.setArray(2, acctList);
cstmt.registerOutParameter(3, OracleTypes.CURSOR);
cstmt.execute(); // --->error here

************************************************** *************************************
The following is the log of the error ...

2007-07-09 10:24:29,718 ERROR - ExecuteThread: '24' for queue: 'weblogic.kernel.Default'::System Error
java.sql.SQLException: Bigger type length than Maximum
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.check_error(Datab aseError.java:885)
at oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMA REngine.java:2231)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMA REngine.java:1048)
at oracle.jdbc.driver.T4CTTIdcb.receiveCommon(T4CTTId cb.java:112)
at oracle.jdbc.driver.T4CTTIdcb.receiveFromRefCursor( T4CTTIdcb.java:104)
at oracle.jdbc.driver.T4CResultSetAccessor.unmarshalO neRow(T4CResultSetAccessor.java:165)
at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.j ava:785)
at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.j ava:702)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 527)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4 CCallableStatement.java:180)
at oracle.jdbc.driver.T4CCallableStatement.execute_fo r_rows(T4CCallableStatement.java:783)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1027)
at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:2885)
at oracle.jdbc.driver.OraclePreparedStatement.execute (OraclePreparedStatement.java:2976)
at oracle.jdbc.driver.OracleCallableStatement.execute (OracleCallableStatement.java:4103)
at com.hallmark.marketing.stores.persistenceEntities. StorePO.getRunSettings(StorePO.java:2600)
at com.hallmark.marketing.stores.businessServices.Sto reService.getRunSettings(StoreService.java:957)
at com.hallmark.smart.simulation.controller.simulatio n.SimulationReviewEditLoadAction.doWork(Simulation ReviewEditLoadAction.java:155)
at com.hallmark.common.controller.ServController.hand leActionClass(ServController.java:936)
at com.hallmark.common.controller.ServController.proc essURIMap(ServController.java:1105)
at com.hallmark.common.controller.ServController.proc essRequest(ServController.java:173)
at com.hallmark.common.controller.ServController.doGe t(ServController.java:464)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.run(WebAppServletContext.java :6722)
at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.inv okeServlet(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execu te(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:178)

java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.check_error(Datab aseError.java:885)
at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Oco mmoncall.java:133)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnect ion.java:385)
at oracle.jdbc.driver.PhysicalConnection.close(Physic alConnection.java:1036)
at com.hallmark.common.util.JDBCConnectionFactory.fre eResources(JDBCConnectionFactory.java:791)
at com.hallmark.marketing.stores.persistenceEntities. StorePO.getRunSettings(StorePO.java:2714)
at com.hallmark.marketing.stores.businessServices.Sto reService.getRunSettings(StoreService.java:957)
at com.hallmark.smart.simulation.controller.simulatio n.SimulationReviewEditLoadAction.doWork(Simulation ReviewEditLoadAction.java:155)
at com.hallmark.common.controller.ServController.hand leActionClass(ServController.java:936)
at com.hallmark.common.controller.ServController.proc essURIMap(ServController.java:1105)
at com.hallmark.common.controller.ServController.proc essRequest(ServController.java:173)
at com.hallmark.common.controller.ServController.doGe t(ServController.java:464)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.run(WebAppServletContext.java :6722)
at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.inv okeServlet(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execu te(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:178)
************************************************** ****
Anybody faced similar situation?
Jul 9 '07 #1
6 5612
r035198x
13,262 8TB
Hi

The highlighted below is the sample code I used for calling my stored procedure.

Callable statement cstmt = conn.prepareCall( BEGIN STOREDPROCNAME(?,?,?);END;);
ArrayDescriptor arrayDescriptor = new ArrayDescriptor(Name of type,cstmt.getConnection());
ARRAY acctList = new ARRAY(arrayDescriptor,conn, flrList.toArray());

cstmt.setInt(1,10);
cstmt.setArray(2, acctList);
cstmt.registerOutParameter(3, OracleTypes.CURSOR);
cstmt.execute(); // --->error here

************************************************** *************************************
The following is the log of the error ...

2007-07-09 10:24:29,718 ERROR - ExecuteThread: '24' for queue: 'weblogic.kernel.Default'::System Error
java.sql.SQLException: Bigger type length than Maximum
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.check_error(Datab aseError.java:885)
at oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMA REngine.java:2231)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMA REngine.java:1048)
at oracle.jdbc.driver.T4CTTIdcb.receiveCommon(T4CTTId cb.java:112)
at oracle.jdbc.driver.T4CTTIdcb.receiveFromRefCursor( T4CTTIdcb.java:104)
at oracle.jdbc.driver.T4CResultSetAccessor.unmarshalO neRow(T4CResultSetAccessor.java:165)
at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.j ava:785)
at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.j ava:702)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 527)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4 CCallableStatement.java:180)
at oracle.jdbc.driver.T4CCallableStatement.execute_fo r_rows(T4CCallableStatement.java:783)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1027)
at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:2885)
at oracle.jdbc.driver.OraclePreparedStatement.execute (OraclePreparedStatement.java:2976)
at oracle.jdbc.driver.OracleCallableStatement.execute (OracleCallableStatement.java:4103)
at com.hallmark.marketing.stores.persistenceEntities. StorePO.getRunSettings(StorePO.java:2600)
at com.hallmark.marketing.stores.businessServices.Sto reService.getRunSettings(StoreService.java:957)
at com.hallmark.smart.simulation.controller.simulatio n.SimulationReviewEditLoadAction.doWork(Simulation ReviewEditLoadAction.java:155)
at com.hallmark.common.controller.ServController.hand leActionClass(ServController.java:936)
at com.hallmark.common.controller.ServController.proc essURIMap(ServController.java:1105)
at com.hallmark.common.controller.ServController.proc essRequest(ServController.java:173)
at com.hallmark.common.controller.ServController.doGe t(ServController.java:464)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.run(WebAppServletContext.java :6722)
at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.inv okeServlet(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execu te(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:178)

java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.check_error(Datab aseError.java:885)
at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Oco mmoncall.java:133)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnect ion.java:385)
at oracle.jdbc.driver.PhysicalConnection.close(Physic alConnection.java:1036)
at com.hallmark.common.util.JDBCConnectionFactory.fre eResources(JDBCConnectionFactory.java:791)
at com.hallmark.marketing.stores.persistenceEntities. StorePO.getRunSettings(StorePO.java:2714)
at com.hallmark.marketing.stores.businessServices.Sto reService.getRunSettings(StoreService.java:957)
at com.hallmark.smart.simulation.controller.simulatio n.SimulationReviewEditLoadAction.doWork(Simulation ReviewEditLoadAction.java:155)
at com.hallmark.common.controller.ServController.hand leActionClass(ServController.java:936)
at com.hallmark.common.controller.ServController.proc essURIMap(ServController.java:1105)
at com.hallmark.common.controller.ServController.proc essRequest(ServController.java:173)
at com.hallmark.common.controller.ServController.doGe t(ServController.java:464)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run(ServletStubImpl.java:1006)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.run(WebAppServletContext.java :6722)
at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.inv okeServlet(WebAppServletContext.java:3764)
at weblogic.servlet.internal.ServletRequestImpl.execu te(ServletRequestImpl.java:2644)
at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:178)
************************************************** ****
Anybody faced similar situation?
I suppose there are others who have faced it before. The statck trace tells you exactly what the problem is. See the line that says "Bigger type length than Maximum"
Jul 10 '07 #2
praveen2gupta
201 100+
Hi
make following change then try.
1. Origional Line
Callable statement cstmt = conn.prepareCall( BEGIN STOREDPROCNAME(?,?,?);END;);

Name of procedure is Missing , See following Sample
CallableStatement pstmt = conn.prepareCall("{call p_highest_ paid_emp(?,?,?,?)}");


2. Origional Line cstmt.execute();

Replace or Try with

cstmt.executeQuery();
or
cstmt.executeUpdate();

Post your results
Jul 10 '07 #3
meru
4
I suppose there are others who have faced it before. The statck trace tells you exactly what the problem is. See the line that says "Bigger type length than Maximum"
Its the very basics to go through stack trace and trying to find out what error it is before posting it in a forum.

This works perfectly well from weblogic domain in my local system but fails in the weblogic domain on the actual application machine... I read about some drivers issue related to Oracle 10g and wanted to know if anybody in here had faced something like that.
Jul 10 '07 #4
r035198x
13,262 8TB
Its the very basics to go through stack trace and trying to find out what error it is before posting it in a forum.

This works perfectly well from weblogic domain in my local system but fails in the weblogic domain on the actual application machine... I read about some drivers issue related to Oracle 10g and wanted to know if anybody in here had faced something like that.

Well you had not stated that in your first post and I believe it is a vital information in this case.
Jul 10 '07 #5
r035198x
13,262 8TB
Well you had not stated that in your first post and I believe it is a vital information in this case.
Oh and uh, which Oracle version are you using?
I hope you're using classes12.zip for the driver.
Jul 10 '07 #6
Oh and uh, which Oracle version are you using?
I hope you're using classes12.zip for the driver.

I am also facing the same problem, it works in the weblogic server on my machine but fails to work in a weblogic server in a Unix machine

I included all the jar files in the classpath of weblogic also during the startWeblogic.sh

Please Help
Aug 8 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Henrik | last post by:
Hi, I am trying to read some industrial webservers using the HTTP/CGI webequest like this: wrs = (HttpWebRequest)WebRequest.Create(HTTP/CGI-string); mwst = (HttpWebResponse wrs.GetResponse();...
1
by: ATS | last post by:
ERR - WebClient.DownloadData returns "protocol violation" Please help, I'm getting a "protocol violation" from a site that is working perfectly fine when I issue WebClient.DownloadData as...
0
by: Helen | last post by:
Hi, I am trying to use a .Net WebClient object to read data from a url, but I am getting the following error: System.Net.HttpWebRequest.CheckFinalStatus()...
1
by: Dan W. | last post by:
Does anyone have any experience with this problem. I am trying to post about 20 fields of information to another server using System.Net.WebClient.UploadData. This works fine for some servers but...
7
by: Tom | last post by:
Hello all: I have a method that does a POST to a secured website using HttpWebRequest. It worked when logging in the site, but it failed with an HTTP prococol violation error when it is used to...
1
by: Khadim | last post by:
I m using HTTWebResponse which is running smoothly on my system which is behing a proxy server. When I run the application with Live IP it gives "HTTP Protocol violation error" I can't use...
0
by: Kris Mattheus | last post by:
A little background: I've been using web services successfully for a while now. My web server is a Windows CE 4.2 device and my client is a windows C# application created with Visual Studio 2003....
3
by: Scott McDermott | last post by:
I have an application that is making an HTTP request with HttpWebRequest.GetRequest. Unless I set 'httpWebRequest useUnsafeHeaderParsing="true"' in the web.config, I get a 'The server committed a...
0
by: oriol.ardevol | last post by:
Hi, I have an asp.net application that connects through an HttpWebRequest object to a ISAPI dll in a server. This isapi dll has some different method calls. What I do is calling the different...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.