• Post Reply Bookmark Topic Watch Topic
  • New Topic

ms access as datasource in wls

 
sachin y deshpande
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I am new to ejb.
i have developed a bean managed entity bean and compiled it(not deployed it yet). I am using wls6.1 for deploying the beans.
i want to create a data source using ms-access. is it possible?
if yes how?
also, can a connection pool be made of the datasource?
if no, is there any way, other than using the standard JDBC API, of doing the same?
Thanks in advance
 
Seetesh Hindlekar
Ranch Hand
Posts: 244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Yes U can. First create a connection pool and then assign a Datasource to this connection pool.
I havent yet tested using any EJB but with a JSP it works just fine.
Create a System DSN
driver=sun.jdbc.odbc.JdbcOdbcDriver
url=jdbc dbc:msaccess
Seetesh
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!