This discussion is archived
2 Replies Latest reply: Oct 17, 2012 3:47 AM by 905648 RSS

Need help with ORA-03135

905648 Newbie
Currently Being Moderated
Hi all,

I'm using ODP.NET , OracleDataAccess.dll

1. cannot find this server message in the documentation
2. here is the code where this exception occurs:

Dim dataadapter As New OracleDataAdapter(cmd)
dataadapter.ReturnProviderSpecificTypes = False
'dataadapter.SafeMapping.Add("*", GetType(System.String))
dataadapter.MissingMappingAction = MissingMappingAction.Passthrough
'dataadapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
Try

dataadapter.Fill(Dataset1, table)
Catch ex As OracleException
MsgBox(".Fill1 dbAccess: " & ex.Message & " bei Tabelle: " & table & _
Environment.NewLine & "Aufruf: " & strSQL)
conn.Close()
Return False

many thanks for all replies
  • 1. Re: Need help with ORA-03135
    Tridus Journeyer
    Currently Being Moderated
    ORA-03135:
         connection lost contact
    Cause:      1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection.
    Action:      1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora.

    Start with those two and let us know how it goes. :)
  • 2. Re: Need help with ORA-03135
    905648 Newbie
    Currently Being Moderated
    Hello,
    many thanks for Your reply. I don't use properly any timeout parameters.
    Please would You tell me, which changes I have to make in my application.

    You can download my app here:
    http://code.msdn.microsoft.com/Oracle-Dataprovider-for-736ad5af

    regards Ellen

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points