Hi
The highlighted below is the sample code I used for calling my stored procedure.
Callable statement cstmt = conn.prepareCal l( BEGIN STOREDPROCNAME( ?,?,?);END;);
ArrayDescriptor arrayDescriptor = new ArrayDescriptor (Name of type,cstmt.getC onnection());
ARRAY acctList = new ARRAY(arrayDesc riptor,conn, flrList.toArray ());
cstmt.setInt(1, 10);
cstmt.setArray( 2, acctList);
cstmt.registerO utParameter(3, OracleTypes.CUR SOR);
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.kerne l.Default'::Sys tem Error
java.sql.SQLExc eption: Bigger type length than Maximum
at oracle.jdbc.dri ver.DatabaseErr or.throwSqlExce ption(DatabaseE rror.java:125)
at oracle.jdbc.dri ver.DatabaseErr or.throwSqlExce ption(DatabaseE rror.java:162)
at oracle.jdbc.dri ver.DatabaseErr or.check_error( DatabaseError.j ava:885)
at oracle.jdbc.dri ver.T4CMAREngin e.buffer2Value( T4CMAREngine.ja va:2231)
at oracle.jdbc.dri ver.T4CMAREngin e.unmarshalUB2( T4CMAREngine.ja va:1048)
at oracle.jdbc.dri ver.T4CTTIdcb.r eceiveCommon(T4 CTTIdcb.java:11 2)
at oracle.jdbc.dri ver.T4CTTIdcb.r eceiveFromRefCu rsor(T4CTTIdcb. java:104)
at oracle.jdbc.dri ver.T4CResultSe tAccessor.unmar shalOneRow(T4CR esultSetAccesso r.java:165)
at oracle.jdbc.dri ver.T4CTTIrxd.u nmarshal(T4CTTI rxd.java:785)
at oracle.jdbc.dri ver.T4CTTIrxd.u nmarshal(T4CTTI rxd.java:702)
at oracle.jdbc.dri ver.T4C8Oall.re ceive(T4C8Oall. java:527)
at oracle.jdbc.dri ver.T4CCallable Statement.doOal l8(T4CCallableS tatement.java:1 80)
at oracle.jdbc.dri ver.T4CCallable Statement.execu te_for_rows(T4C CallableStateme nt.java:783)
at oracle.jdbc.dri ver.OracleState ment.doExecuteW ithTimeout(Orac leStatement.jav a:1027)
at oracle.jdbc.dri ver.OraclePrepa redStatement.ex ecuteInternal(O raclePreparedSt atement.java:28 85)
at oracle.jdbc.dri ver.OraclePrepa redStatement.ex ecute(OraclePre paredStatement. java:2976)
at oracle.jdbc.dri ver.OracleCalla bleStatement.ex ecute(OracleCal lableStatement. java:4103)
at com.hallmark.ma rketing.stores. persistenceEnti ties.StorePO.ge tRunSettings(St orePO.java:2600 )
at com.hallmark.ma rketing.stores. businessService s.StoreService. getRunSettings( StoreService.ja va:957)
at com.hallmark.sm art.simulation. controller.simu lation.Simulati onReviewEditLoa dAction.doWork( SimulationRevie wEditLoadAction .java:155)
at com.hallmark.co mmon.controller .ServController .handleActionCl ass(ServControl ler.java:936)
at com.hallmark.co mmon.controller .ServController .processURIMap( ServController. java:1105)
at com.hallmark.co mmon.controller .ServController .processRequest (ServController .java:173)
at com.hallmark.co mmon.controller .ServController .doGet(ServCont roller.java:464 )
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:740)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
at weblogic.servle t.internal.Serv letStubImpl$Ser vletInvocationA ction.run(Servl etStubImpl.java :1006)
at weblogic.servle t.internal.Serv letStubImpl.inv okeServlet(Serv letStubImpl.jav a:419)
at weblogic.servle t.internal.Serv letStubImpl.inv okeServlet(Serv letStubImpl.jav a:315)
at weblogic.servle t.internal.WebA ppServletContex t$ServletInvoca tionAction.run( WebAppServletCo ntext.java:6722 )
at weblogic.securi ty.acl.internal .AuthenticatedS ubject.doAs(Aut henticatedSubje ct.java:321)
at weblogic.securi ty.service.Secu rityManager.run As(SecurityMana ger.java:121)
at weblogic.servle t.internal.WebA ppServletContex t.invokeServlet (WebAppServletC ontext.java:376 4)
at weblogic.servle t.internal.Serv letRequestImpl. execute(Servlet RequestImpl.jav a:2644)
at weblogic.kernel .ExecuteThread. execute(Execute Thread.java:219 )
at weblogic.kernel .ExecuteThread. run(ExecuteThre ad.java:178)
java.sql.SQLExc eption: Protocol violation
at oracle.jdbc.dri ver.DatabaseErr or.throwSqlExce ption(DatabaseE rror.java:125)
at oracle.jdbc.dri ver.DatabaseErr or.throwSqlExce ption(DatabaseE rror.java:162)
at oracle.jdbc.dri ver.DatabaseErr or.check_error( DatabaseError.j ava:885)
at oracle.jdbc.dri ver.T4C7Ocommon call.receive(T4 C7Ocommoncall.j ava:133)
at oracle.jdbc.dri ver.T4CConnecti on.logoff(T4CCo nnection.java:3 85)
at oracle.jdbc.dri ver.PhysicalCon nection.close(P hysicalConnecti on.java:1036)
at com.hallmark.co mmon.util.JDBCC onnectionFactor y.freeResources (JDBCConnection Factory.java:79 1)
at com.hallmark.ma rketing.stores. persistenceEnti ties.StorePO.ge tRunSettings(St orePO.java:2714 )
at com.hallmark.ma rketing.stores. businessService s.StoreService. getRunSettings( StoreService.ja va:957)
at com.hallmark.sm art.simulation. controller.simu lation.Simulati onReviewEditLoa dAction.doWork( SimulationRevie wEditLoadAction .java:155)
at com.hallmark.co mmon.controller .ServController .handleActionCl ass(ServControl ler.java:936)
at com.hallmark.co mmon.controller .ServController .processURIMap( ServController. java:1105)
at com.hallmark.co mmon.controller .ServController .processRequest (ServController .java:173)
at com.hallmark.co mmon.controller .ServController .doGet(ServCont roller.java:464 )
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:740)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
at weblogic.servle t.internal.Serv letStubImpl$Ser vletInvocationA ction.run(Servl etStubImpl.java :1006)
at weblogic.servle t.internal.Serv letStubImpl.inv okeServlet(Serv letStubImpl.jav a:419)
at weblogic.servle t.internal.Serv letStubImpl.inv okeServlet(Serv letStubImpl.jav a:315)
at weblogic.servle t.internal.WebA ppServletContex t$ServletInvoca tionAction.run( WebAppServletCo ntext.java:6722 )
at weblogic.securi ty.acl.internal .AuthenticatedS ubject.doAs(Aut henticatedSubje ct.java:321)
at weblogic.securi ty.service.Secu rityManager.run As(SecurityMana ger.java:121)
at weblogic.servle t.internal.WebA ppServletContex t.invokeServlet (WebAppServletC ontext.java:376 4)
at weblogic.servle t.internal.Serv letRequestImpl. execute(Servlet RequestImpl.jav a:2644)
at weblogic.kernel .ExecuteThread. execute(Execute Thread.java:219 )
at weblogic.kernel .ExecuteThread. run(ExecuteThre ad.java:178)
*************** *************** *************** *********
Anybody faced similar situation?
6  5644 
Hi
The highlighted below is the sample code I used for calling my stored procedure.
Callable statement cstmt = conn.prepareCal l( BEGIN STOREDPROCNAME( ?,?,?);END;);
ArrayDescriptor arrayDescriptor = new ArrayDescriptor (Name of type,cstmt.getC onnection());
ARRAY acctList = new ARRAY(arrayDesc riptor,conn, flrList.toArray ());
cstmt.setInt(1, 10);
cstmt.setArray( 2, acctList);
cstmt.registerO utParameter(3, OracleTypes.CUR SOR);
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.kerne l.Default'::Sys tem Error
java.sql.SQLExc eption: Bigger type length than Maximum
at oracle.jdbc.dri ver.DatabaseErr or.throwSqlExce ption(DatabaseE rror.java:125)
at oracle.jdbc.dri ver.DatabaseErr or.throwSqlExce ption(DatabaseE rror.java:162)
at oracle.jdbc.dri ver.DatabaseErr or.check_error( DatabaseError.j ava:885)
at oracle.jdbc.dri ver.T4CMAREngin e.buffer2Value( T4CMAREngine.ja va:2231)
at oracle.jdbc.dri ver.T4CMAREngin e.unmarshalUB2( T4CMAREngine.ja va:1048)
at oracle.jdbc.dri ver.T4CTTIdcb.r eceiveCommon(T4 CTTIdcb.java:11 2)
at oracle.jdbc.dri ver.T4CTTIdcb.r eceiveFromRefCu rsor(T4CTTIdcb. java:104)
at oracle.jdbc.dri ver.T4CResultSe tAccessor.unmar shalOneRow(T4CR esultSetAccesso r.java:165)
at oracle.jdbc.dri ver.T4CTTIrxd.u nmarshal(T4CTTI rxd.java:785)
at oracle.jdbc.dri ver.T4CTTIrxd.u nmarshal(T4CTTI rxd.java:702)
at oracle.jdbc.dri ver.T4C8Oall.re ceive(T4C8Oall. java:527)
at oracle.jdbc.dri ver.T4CCallable Statement.doOal l8(T4CCallableS tatement.java:1 80)
at oracle.jdbc.dri ver.T4CCallable Statement.execu te_for_rows(T4C CallableStateme nt.java:783)
at oracle.jdbc.dri ver.OracleState ment.doExecuteW ithTimeout(Orac leStatement.jav a:1027)
at oracle.jdbc.dri ver.OraclePrepa redStatement.ex ecuteInternal(O raclePreparedSt atement.java:28 85)
at oracle.jdbc.dri ver.OraclePrepa redStatement.ex ecute(OraclePre paredStatement. java:2976)
at oracle.jdbc.dri ver.OracleCalla bleStatement.ex ecute(OracleCal lableStatement. java:4103)
at com.hallmark.ma rketing.stores. persistenceEnti ties.StorePO.ge tRunSettings(St orePO.java:2600 )
at com.hallmark.ma rketing.stores. businessService s.StoreService. getRunSettings( StoreService.ja va:957)
at com.hallmark.sm art.simulation. controller.simu lation.Simulati onReviewEditLoa dAction.doWork( SimulationRevie wEditLoadAction .java:155)
at com.hallmark.co mmon.controller .ServController .handleActionCl ass(ServControl ler.java:936)
at com.hallmark.co mmon.controller .ServController .processURIMap( ServController. java:1105)
at com.hallmark.co mmon.controller .ServController .processRequest (ServController .java:173)
at com.hallmark.co mmon.controller .ServController .doGet(ServCont roller.java:464 )
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:740)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
at weblogic.servle t.internal.Serv letStubImpl$Ser vletInvocationA ction.run(Servl etStubImpl.java :1006)
at weblogic.servle t.internal.Serv letStubImpl.inv okeServlet(Serv letStubImpl.jav a:419)
at weblogic.servle t.internal.Serv letStubImpl.inv okeServlet(Serv letStubImpl.jav a:315)
at weblogic.servle t.internal.WebA ppServletContex t$ServletInvoca tionAction.run( WebAppServletCo ntext.java:6722 )
at weblogic.securi ty.acl.internal .AuthenticatedS ubject.doAs(Aut henticatedSubje ct.java:321)
at weblogic.securi ty.service.Secu rityManager.run As(SecurityMana ger.java:121)
at weblogic.servle t.internal.WebA ppServletContex t.invokeServlet (WebAppServletC ontext.java:376 4)
at weblogic.servle t.internal.Serv letRequestImpl. execute(Servlet RequestImpl.jav a:2644)
at weblogic.kernel .ExecuteThread. execute(Execute Thread.java:219 )
at weblogic.kernel .ExecuteThread. run(ExecuteThre ad.java:178)
java.sql.SQLExc eption: Protocol violation
at oracle.jdbc.dri ver.DatabaseErr or.throwSqlExce ption(DatabaseE rror.java:125)
at oracle.jdbc.dri ver.DatabaseErr or.throwSqlExce ption(DatabaseE rror.java:162)
at oracle.jdbc.dri ver.DatabaseErr or.check_error( DatabaseError.j ava:885)
at oracle.jdbc.dri ver.T4C7Ocommon call.receive(T4 C7Ocommoncall.j ava:133)
at oracle.jdbc.dri ver.T4CConnecti on.logoff(T4CCo nnection.java:3 85)
at oracle.jdbc.dri ver.PhysicalCon nection.close(P hysicalConnecti on.java:1036)
at com.hallmark.co mmon.util.JDBCC onnectionFactor y.freeResources (JDBCConnection Factory.java:79 1)
at com.hallmark.ma rketing.stores. persistenceEnti ties.StorePO.ge tRunSettings(St orePO.java:2714 )
at com.hallmark.ma rketing.stores. businessService s.StoreService. getRunSettings( StoreService.ja va:957)
at com.hallmark.sm art.simulation. controller.simu lation.Simulati onReviewEditLoa dAction.doWork( SimulationRevie wEditLoadAction .java:155)
at com.hallmark.co mmon.controller .ServController .handleActionCl ass(ServControl ler.java:936)
at com.hallmark.co mmon.controller .ServController .processURIMap( ServController. java:1105)
at com.hallmark.co mmon.controller .ServController .processRequest (ServController .java:173)
at com.hallmark.co mmon.controller .ServController .doGet(ServCont roller.java:464 )
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:740)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
at weblogic.servle t.internal.Serv letStubImpl$Ser vletInvocationA ction.run(Servl etStubImpl.java :1006)
at weblogic.servle t.internal.Serv letStubImpl.inv okeServlet(Serv letStubImpl.jav a:419)
at weblogic.servle t.internal.Serv letStubImpl.inv okeServlet(Serv letStubImpl.jav a:315)
at weblogic.servle t.internal.WebA ppServletContex t$ServletInvoca tionAction.run( WebAppServletCo ntext.java:6722 )
at weblogic.securi ty.acl.internal .AuthenticatedS ubject.doAs(Aut henticatedSubje ct.java:321)
at weblogic.securi ty.service.Secu rityManager.run As(SecurityMana ger.java:121)
at weblogic.servle t.internal.WebA ppServletContex t.invokeServlet (WebAppServletC ontext.java:376 4)
at weblogic.servle t.internal.Serv letRequestImpl. execute(Servlet RequestImpl.jav a:2644)
at weblogic.kernel .ExecuteThread. execute(Execute Thread.java:219 )
at weblogic.kernel .ExecuteThread. run(ExecuteThre ad.java: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"
Hi
make following change then try.
1. Origional Line
Callable statement cstmt = conn.prepareCal l( BEGIN STOREDPROCNAME( ?,?,?);END;);
Name of procedure is Missing , See following Sample
CallableStateme nt pstmt = conn.prepareCal l("{call p_highest_ paid_emp(?,?,?, ?)}");
2. Origional Line cstmt.execute() ;
Replace or Try with
cstmt.executeQu ery();
or
cstmt.executeUp date();
Post your results
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.
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.
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.
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.s h
Please Help
Sign in to post your reply or Sign up for a free account.
Similar topics | |
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();
str = mwst.GetResponseStream();
This usually works fine but on some servers i get:
|
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 such:
WebClient WebClient_Temp = new WebClient();
byte zbyteTemp = WebClient_Temp.DownloadData
(
|
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()
System.Net.HttpWebRequest.EndGetResponse(IAsyncResult
asyncResult)
System.Net.HttpWebRequest.GetResponse()
System.Net.WebClient.OpenRead(String address)
|
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 one
in particular is causing the exception "The underlying connection was
closed: The server committed an HTTP protocol violation" to be thrown.
I found a post that said to add a config file with the following....
<configuration>...
|
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 retrieve a report.
Error: The underlying connection was closed: The server committed an HTTP
protocol violation.
I have tried to the set useUnsafeHeaderParsing to true in the app config
| | |
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 'useUnsafeHeaderParsing' because it is not recognized by
framework without sp3.
I have urlencoded my data... its a simple get method with no complexity
|
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. My web server has both
NTLM and Basic authentication. By providing the Credentials for my web service call, my
application can access the web service without any problems.
The problem:
I recently created a new application with Visual Studio...
|
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 protocol violation. Section=ResponseStatusLine' error.
Here is an example of the session that generates the error:
--- snip ---
GET <someURLHTTP/1.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 methods of the isapi with
HttpWebRequest with GET protocol like:
http://<server>/APIWeb/<isapi>.dll?<method>?<parameter1>=<parameter1_value>&<parameter2>=<parameter2_value>&...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |
