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]
