File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Servlets and the fly likes ORA-03114: not connected to ORACLE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "ORA-03114: not connected to ORACLE" Watch "ORA-03114: not connected to ORACLE" New topic
Author

ORA-03114: not connected to ORACLE

Mark Jutras
Greenhorn

Joined: Aug 01, 2001
Posts: 23
I have a Java Stored Procedure which communicates with
WebLogic Server 6, sending an array of data to the doPost()
method. When running the procedure, I'm getting the ORA-03114: not connected to ORACLE error message. Following is the
code, any suggestions on why this is happening, please supply
anything that may cause this. Thanks in advance! I'm not sure
if I have a driver problem, I am using the defaultConnection
in the Java Stored Procedure.
public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws IOException, ServletException
{
ObjectOutputStream orderOutputStream;
ObjectInputStream orderInputStream;
orderHeader currentOrder;
System.out.println("In the doPost method.");
try {
orderInputStream = new ObjectInputStream (req.getInputStream());
Object o1 = orderInputStream.readObject();
currentOrder = (orderHeader) o1;

connect();
Object[] doneOrder = maporderHeader(currentOrder);
System.out.println("Object array length: " + doneOrder.length);
currentOrder = (orderHeader)doneOrder[0];
System.out.println("Number of LineItems: " + currentOrder.getLineItemList().size());
orderOutputStream = new ObjectOutputStream(resp.getOutputStream());
for(int i=0;i < currentOrder.getLineItemList().size();i++)
{
System.out.println("LineItem#: " + i);
lineItem tempLineItem = currentOrder.passLineItem(i);
System.out.println("ErrorStatus: "+tempLineItem.getErrorStatus());
ArrayList tempList = tempLineItem.getLabelList();
System.out.println("LineId: "+tempLineItem.getLineId());
System.out.println("labelRequired:"+tempLineItem.getLabelRequired());
orderOutputStream.writeObject(tempLineItem);
}
orderOutputStream.flush();
} catch (NullPointerException npe) {
System.out.println("NullPointerException: " + npe.getMessage());
} catch (IOException ioe) {
System.out.println("IOException: " + ioe.getMessage());
} catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundException: " + e.getMessage());
} catch (Exception e) {
System.out.println("Exception: " + e.getMessage());
}

} // end doPost() method.
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
A call to Oracle was attempted when no connection was established. Usually this happens because a user´┐Żwritten program has not logged on. It may also happen if communication trouble causes a disconnection. Check whether the database is up and running.
Regards
Beksy
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

What is the code inside the connect() method?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-03114: not connected to ORACLE