aspose file tools*
The moose likes BEA/Weblogic and the fly likes weblogic with MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "weblogic with MS Access" Watch "weblogic with MS Access" New topic
Author

weblogic with MS Access

Ramesh Naapa Sekhar
Greenhorn

Joined: Jun 29, 2001
Posts: 9
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


SCJP, OCMJEA
jon boydell
Greenhorn

Joined: Jul 04, 2001
Posts: 15
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

Joined: Jun 25, 2001
Posts: 16051
    
  21

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.


Customer surveys are for companies who didn't pay proper attention to begin with.
Ramesh Naapa Sekhar
Greenhorn

Joined: Jun 29, 2001
Posts: 9
thank you jon boydell and Tim Holloway for your suggessions.
Xavier Arockiaraj
Greenhorn

Joined: Dec 20, 2001
Posts: 2
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

Joined: Dec 20, 2001
Posts: 2
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: weblogic with MS Access