plz tell me ,
how to interact with ms-access using type 4 driver
plz send className,url of type for driver.
plz send links ,it requries any software to connect the ms-access using type 4 driver
|
Connecting to the Database
className: com.hxtt.sql.access.AccessDriver
HXTT Access is a pure Java driver which needn't MS Access or ODBC, and can run on Linux/Uninx.
1.jdbc url: jdbc:access:///c:/mdbffiles/Northwind.mdb
insert into aTableName (columnName1,...) values(value11,...)
2.jdbc url: jdbc:access:////sys/data/mdbffiles/
insert into Northwind.aTableName (columnName1,...) values(value11,...)
|
i get the error like:
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause:
java.sql.SQLException: No suitable driver
my server.xml code:
type="javax.sql.DataSource"/>
factory
org.apache.commons.dbcp.BasicDataSourceFactory
driverClassName
sun.jdbc.odbc.JdbcOdbcDriver
url
jdbc:odbc:ebsi
maxActive
20
maxIdle
10
maxWait
-1
my web.xml:
Oracle Datasource example
jdbc/myaccess
javax.sql.DataSource
Container
my class:
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myaccess");
con = ds.getConnection();
|
>driverClassName:sun.jdbc.odbc.JdbcOdbcDriver
>url: jdbc:odbc:ebsi
You should change those setting. Please read How to set up HXTT Access with Tomcat4.1 as PoolableConnection?.
|
where to download type4 driver(ms-access) software to interact with ms-acces.
plz how set classpath and all procedures.
|
HXTT Access is the only type 4 driver for MS Access. You can download it from HXTT Access. You can more about classpath in Installation
|