Open Software, Open

Bear this in mind that whenever you use Oracle DON'T use Microsoft provided Driver. Always go for the one provided by Oracle itself e.g. "oracle odbc driver" Next is instead of using the following:        Class.forName ( "sun.jdbc.odbc.JdbcOdbcDriver" );        String url = " jdbc:odbc:thin@localhost:1521:orcl "; You can also use       Class.forName (" oracle.jdbc.driver.OracleDriver ");       String url = " jdbc:oracle:thin@localhost:1521:orcl "; As far as the Datasource name is concerned, the default datasource name is                  beq-local.world   PS:Oracle is bit tough when it comes to running server on Windows box. Anyway the best pair for both Oracle and Windows is "Oracle 8.0.5 for Windows NT" and "Windows NT 4.0 Server" respectively. Also the old Oracle Developer works qui...

Whenever accessing Database I would highly recommend that you maintain a  table cache  of your own inside the program and traverse through the table within that cache.   Better not to use ResultSet and replace it with your own  Data Structure . There are two reasons why this technique should be followed.  First  a ResultSet contains mostly redundant info as well and it occupies space in memory for all the time.  Secondly  most of the time ResultSet if bounded with Database itself and causing delay for extremely large tables, because of the rule of Thumb that HardDisk seek time is much greater than memory access time.   A custom data structure (a structure or class) can be very easy to implement since the table entries obtained from the ResultSet are mostly parsed as Strings.   We can use any of  java.util.Vector  or  java.util.ArrayList . The  ArrayList  class is also available in C# under  Syst...