Re: Connection pooling in java

janaka priyadarshana wrote:
> hi all..
>
> i am tring to use connection pool with postgresql..but it give an
> Exception when it is going to execute the line following.
> InitialContext().rebind("DataSource", source)
>
>
> the cord is as follow.
>
>
>
> Jdbc3PoolingDataSource source = new Jdbc3PoolingDataSource();
> source.setDataSourceName("A Data Source");
> source.setServerName("localhost");
> source.setDatabaseName("mmsc");
> source.setUser("janaka");
> source.setPassword("1234");
> source.setMaxConnections(10);
> try {
> new InitialContext().rebind("DataSource", source);
> }
> catch (NamingException ex) {
> System.out.println(ex.getMessage());
> ex.printStackTrace();
> }
>
>
>
>
> the given exception is as follow....
>
>
> javax.naming.NoInitialContextException : Need to specify class name in
> environment or system property, or as an applet parameter, or in an
> application resource file: java.naming.factory.initial

It's telling you what the problem is right there: you haven't supplied
sufficient information to construct an initial context. Specifically,
it wants you to tell it what class to use for java.naming.factory.initial.

What is your runtime platform? How you bind resources into JNDI is
determined by your runtime platform. Furthermore, many if not most
platforms provide a means to pool connections. Both JBoss and Tomcat
do, so constructing a pooled connection in those environments is as
simple as defining them in a configuration file, then looking them up in
your code.

--
Guy Rouillier