Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> java.sql.SQLException: Protocol violation (help needed)
I am getting the following error message:
java.sql.SQLException: Protocol violation at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:391) etc.....
The code used for connecting is as follows:
// Load the Oracle JDBC Driver and register it.
DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());
// Define the data source for the driver String sourceURL = "(DESCRIPTION=(ADDRESS=(HOST="+sServer+")"+
"(PROTOCOL=tcp)(PORT="+sPortNo+"))"+"(CONNECT_DATA=(SID="+sSID+")))";
Connection dbConnection = DriverManager.getConnection(sProtocol +
":@",sUsername,sPassword);
Statement statement = dbConnection.createStatement();
ResultSet rMbrData =
statement.executeQuery("SELECTMBR_INDIVIDUAL_MEMBERSHIPS.INDM_BILCODT_CD,
" +
"MBR_INDIVIDUAL_MEMBERSHIPS.INDM_PAID_DATE " +
"FROM MBR_MB_CUSTOMERS INNER JOIN " +
"MBR_INDIVIDUAL_MEMBERSHIPS ON MBR_MB_CUSTOMERS.CUSTOMER_ID =
MBR_INDIVIDUAL_MEMBERSHIPS.INDM_CUST_IM_ID " +
"WHERE ((MBR_MB_CUSTOMERS.CUSTOMER_NUMBER)='" + sMemberNo + "')");
if( dbConnection != null )
dbConnection.close();
Any idea what the problem is? I am totally stumped. Any help appreciated,
Thanks in advance,
Ran Received on Wed Oct 10 2001 - 09:14:32 CDT