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]