RE: [JAVA]How to get datatbase connection from lookup to datatsource name in a standalone java application

[Jimmy Emmanual]

1. Bind datasource to a file system context

   try {
      Hashtable env = new Hashtable();
      env.put(Context.INITIAL_CONTEXT_FACTORY,
"com.sun.jndi.fscontext.RefFSContextFactory");
      env.put(Context.PROVIDER_URL, "file:/C:/temp/jndi");

      // create the context
      Context context = new InitialContext(env);     

      // create a DataSource object
      // This is Sybase jconn2.jar
      com.sybase.jdbc2.jdbc.SybDataSource dataSource = new
com.sybase.jdbc2.jdbc.SybDataSource();

      // Set properties
      dataSource.setUser("strutsUser");
      ....
     
      // Bind it to context
      context.rebind("jdbc/GPS", dataSource);
   } catch (Exception e) {
     // whatever....
   }

2. Now you can do look up.
    Context context;

    try {

      // create and store parameters which are used to create the
context
      Hashtable env = new Hashtable();
      env.put(Context.INITIAL_CONTEXT_FACTORY,
"com.sun.jndi.fscontext.RefFSContextFactory");
      env.put(Context.PROVIDER_URL, "file:/C:/temp/jndi");

      // create the context
      context = new InitialContext(env);

      // call method to get DataSource and Connection
      dataSource = (DataSource) context.lookup("jdbc/GPS");
    } catch (Exception e) {
     // whatever....
    } 
  }
 
Jimmy
-----Original Message-----
From: Scott Van Wart [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 24, 2006 5:48 PM
To: Struts Users Mailing List
Subject: Re: [JAVA]How to get datatbase connection from lookup to
datatsource name in a standalone java application

Caroline Jen wrote:
> Context ctx = new InitialContect();
> DataSource ds =
> (DataSource)ctx.lookup("java:com/env/jdbc/DBName");
> Connection con = ds.getConnection();
>   
Right, but that's assuming it's already bound, which is the hard part,
and unless he's running it under OC4J, no such luck...

- Scott

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]