• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

weblogic with MS Access

 
Ramesh Naapa Sekhar
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi.
can we use MicroSoft Access Database with weblogic5.1.0 to get the connection pooling.if so how can we edit the weblogic properties file.please help me.
thanks in advance.
ramesh
 
jon boydell
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yeah,
Set up an ODBC DSN to point to the access databse. Get hold of the jdbc-odbc bridge (still included in the jdk). Set up the weblogic pool properties to use the bridge driver and point to the DSN you set up. Then either:
a) create a datasource and use jndi to access the pool from your client code
b) use the pool driver in your client close
jon
 
Tim Holloway
Saloon Keeper
Posts: 18300
56
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually, MS Access is NOT a good DBMS to use with WebLogic. The jdbc-odbc bridge isn't threadsafe. For that reason, FoxPro is also not a good choice.
 
Ramesh Naapa Sekhar
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thank you jon boydell and Tim Holloway for your suggessions.
 
Xavier Arockiaraj
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by naapasekhar ramesh:
hi.
can we use MicroSoft Access Database with weblogic5.1.0 to get the connection pooling.if so how can we edit the weblogic properties file.please help me.
thanks in advance.
ramesh

I am also facing the same problem
Xavier
 
Xavier Arockiaraj
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am also trying to connect to Ms-Access database. But I don't know how to set up the weblogic.properties file entries.
Actually I created a dsn called mytestdsn. I made the following entries.
weblogic.jdbc.connectionPool.demoPool=\
url=jdbc dbc:mytestdsn,\
driver=sun.jdbc.odbc.JdbcOdbcDriver,\
initialCapacity=1,\
maxCapacity=2,\
capacityIncrement=1,\
props=user=none;password=none;server=none
weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.demoPool=demoPool
weblogic.allow.reserve.weblogic.jdbc.connectionPool.demoPool=everyone
But I am getting the following error while building the bean.
ERROR: Error from ejbc: Bean provided to WebLogic RDBMS CMP system is invalid.
Please examine the following exceptions for specific problems:
0: An unknown error occurred while parsing the Weblogic CMP RDBMS deployment descriptor. Check that the deployment descript
or contains well-formed and valid XML.
Please suggest what to do.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic