hi! Is it possible to replace part of all the the information between the brackets in the following line: con=DriverManager.getConnection("jdbc: oracle:thin@ott46:1521:d10h", "inv_read", "invdev1"); I would need to keep all the connection information, or at least the username and password, in a seperate property file and read the information from there when needed. How do I do this? Thanks, Annette
Yes, except it should be stmt=connection.createStatement(); In our implementation, the connectoToDatabase() method is in a shared class that can be used by anyone who needs JDBC access. That is why we are using a database properties file.