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