Re: java.sql.SQLException: Io exception: Got minus one from a read call



Hi,

Progress since then, but still cannot connect to Oracle:
JDEVELOPER 10.1.3 With Oracle 10g express

Cannot see why, I cannot conect to Oracle?????

Thanks

clive

//
error message:
<%
//Using the request object to extract input values of registration page

String title = request.getParameter("title");
String link = request.getParameter("link");
String descp = request.getParameter("descp");

Connection con = null;
try {
//Load the class file for the driver
Class.forName("oracle.jdbc.driverOracleDriver");
//Establish a connection with the ODBC datasource
con =
DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:XE","sa","");
//The prepared statement to insert values in the table at runtime
PreparedStatement st=con.prepareStatement("insert into rsstb (title,
link, descprition) values (?, ?, ?)");
//The statement to insert appropriate values into the registration
table
st.setString(1, title);
st.setString(2, link);
st.setString(3, descp);
st.executeUpdate();
}
finally {
try {
if (con != null) {
// Close the connection
con.close();
}
}

.



Relevant Pages

  • RE: ADO.Net Connection Pooling Problem with Oracle
    ... the CLR is releasing the connection to your database. ... the number of database sessions in Oracle seem to ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
    ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
    ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connecting to ODBC DB at startup
    ... Creating an Oracle connection in an independent object ... Dim cnConn As ADODB.Connection ... Dim strDB As String ...
    (comp.databases.ms-access)
  • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
    ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
    (microsoft.public.dotnet.languages.csharp)