Using ResourceBundle

[Brian Snyder]

I'm trying to load driver info, URL info, userID info, and password info for my MySQL database by using a ConnectU.properties file that contains:

#PropertiesResourceBundle for Connection Properties
CSDriver=org.gjt.mm.mysql.Driver
CSURL=jdbc:mysql://localhost/test
CSUserID=*****
CSPassword=*******

I trying to get this info from a java file with that contains the following snippet:

import java.sql.*;
import java.util.*;
public class ConnectU
{
  Connection con;
  ResourceBundle rbConnect;
  ResultSet rs;
  ResultSetMetaData rsmd;
  Statement stmt;
  
  String sDriver,
         sDriverKey = "CSDriver",
         sPassword,
         sPasswordKey ="CSPassword",
         sQuery = 
          "SELECT * FROM Coffees " +
          "WHERE Type = 'MoJava'",
         srbName = "ConnectU",            //IT CAN'T FIND THIS PART!!!!!!!!!!!!!!!!!!!!!!!!!
         sURL,
         sURLKey="CSURL",
         sUserID,
         sUserIDKey = "CSUserID";

  public ConnectU()
  {
    try  // get the PropertyResourceBundle
    { 
    rbConnect = ResourceBundle.getBundle( srbName ); // THIS IS WHERE THE ERROR OCCURS
      sDriver   = rbConnect.getString( sDriverKey );
      sPassword = rbConnect.getString( sPasswordKey );
      sURL      = rbConnect.getString( sURLKey );
      sUserID = rbConnect.getString( sUserIDKey );
    }
    catch( MissingResourceException mre )
    {
      System.err.println(
                  "ResourceBundle problem for " + 
                   srbName + ", program ends." );
      System.err.println("Specific error: " + 
                          mre.getMessage() );
      return; // exit on error
    }

I keep getting the error:
Specific Error: Can't find bundle for base name ConectU cal.en_US
which is printed from the above catch statement.
Can someone please explain how the properties file works and how I can get a program to access this file if I need to write a program for a DB in which the user will not need to know the driver location, URL, login, and password? I hope all of this makes sense as I am green in this area.
Thanks in advance, Brian!!!

[Brian Snyder]

I actually answered my own question with thanks to long sun. I didn;t realize you had to actually set the properties using a properties file. Thanks!!

public static Connection getConnection()
            throws SQLException, IOException{ 
Properties props = new Properties();
   String fileName = "MakeDB.properties";
   FileInputStream in = new FileInputStream(fileName);
   props.load(in);
   String drivers = props.getProperty("jdbc.drivers");
if (drivers != null)
   System.setProperty("jdbc.drivers", drivers);
   String url = props.getProperty("jdbc.url");
   String username = props.getProperty("jdbc.username");
   String password = props.getProperty("jdbc.password");
   return
   DriverManager.getConnection(url, username, password);
 }

[Phil Hanna]

I compiled and tested your original code, and it worked fine for me. Are you absolutely sure about the properties file name? It has to be "ConnectU.properties", in the same directory as the .class file (or in the same relative path in a JAR file), otherwise you'll get the error you mention. From the error message, it looks like you tried to load "ConectU.properties", with one "n". Also, if the program is in a package (foo.bar.ConnectU), the getBundle() method must use the full package name prefix ("foo.bar.ConnectU").
So you don't have to explicitly treat the properties file as a java.util.Properties object - it can be a ResourceBundle as well, exactly as you have written it.

------------------
Phil Hanna
Author of :
JSP: The Complete Reference
Instant Java Servlets

[Brian Snyder]

Thanks Phil. I works for me now as well. It must have been a typo. I was also working on that problem at 4:00 AM. I slept on it and the next day, all was well. Sorry for the confusion!!