This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

Soln to BMP

Posted by Rajiv on June 21, 2001 at 5:10 AM

> IN EJB Bean Managed Persistence, I want to use MS-ACCESS database( not Cloudscape) using sun.jdbc.odbc.JdbcOdbcDriver driver.How can I go ahead with this,Please give all steps.

> DO REPLY

> Thankx
> Harendra

HI Harendra

I am attaching this code for the getConnection Method for the BMP Bean

private Connection getConnection() throws SQLException
{
InitialContext initCtx = null;
try
{
initCtx = new InitialContext();
DataSource ds = (javax.sql.DataSource)
initCtx.lookup("weblogic.jdbc.jts.oraclePool");
System.out.println("Pool found");
return ds.getConnection();
}
catch(NamingException ne)
{
log("UNABLE to get a connection from oraclePool!");
throw new EJBException(ne);
}
finally
{
try
{
if(initCtx != null) initCtx.close();
}
catch(NamingException ne)
{
log("Error closing context: " + ne);
throw new EJBException(ne);
}
}
}

In the above code
"initCtx.lookup("weblogic.jdbc.jts.accessPool");"

this line is actually doing the job getting the connection pool

You set this in the weblogic properties file search for

#weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.demoPool=demoPool

and replace it with

weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.accessPool=demoPool

demopool is the name of ur Access connection pool name.which u can write by changing the demo pool in th properties file.

weblogic.jdbc.connectionPool.demoPool=\
url=jdbc:odbc:demo,\
driver=COM.cloudscape.core.JDBCDriver,\
initialCapacity=1,\
maxCapacity=2,\
capacityIncrement=1,\
props=user=none;password=none;server=none

where in the url demo is the odbc driver name set for MS Access BD.

i hope this would be sufficient and would solve ur doubt

• Access MS-Access Database daccu July 29, 2001 at 3:21 AM (2)
  • jdbc uday October 20, 2001 at 1:25 AM (0)
  • Access MS-Access Database james thomas September 09, 2001 at 11:56 AM (0)