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