-
1. Re: How to configure MS Access datasource
jonlee Jun 20, 2003 12:53 AM (in response to peich_sun)You can call the datasource name anything you want. For example myaccessdb-ds.xml. JBoss deployment does not care as long as the file ends with -ds.xml and the datasource defined within does not clash with an existing bound JNDI name.
The contents will probably look like this:
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- Generic datasource configuration showing all possibilities -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: generic-ds.xml,v 1.1 2002/07/24 03:27:53 d_jencks Exp $ -->
<local-tx-datasource>
<jndi-name>AccessDS</jndi-name>
<connection-url> jdbc:odbc:dsn-name</connection-url>
<driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
<user-name>x</user-name>
y
</local-tx-datasource>
Substitute your own dsn-name, username and password.
As for your mapping, I guess you can start with MS SQLSERVER as that is pretty close to Access.
Otherwise, you will need to create your own <type-mapping-definition>, probably using a copy of the mapping definition for MS SQLSERVER as your starting point.