Hello,

I haven't looked at your map file yet, but do have the following comments:

1) You do not need to compile the .java files. The compiled files are in
xmldbms20.jar.

2) By default, the samples use the JDBC-ODBC Bridge driver. (This is the
property Driver=sun.jdbc.odbc.JdbcOdbcDriver in db.props.) You will
probably want to change this property to the JDBC driver shipped with
Oracle. You will need to read the documentation for that driver to see
how to enter the user name and password. For example, the driver might
prompt you for them. (You can put them in the db.props file, but this is
not secure.)

3) You are getting an error because the JDBC-ODBC Bridge requires you to
set up an ODBC data source. This error will go away when you set the
driver to the Oracle driver. However, you will need to specify the URL
for your database. See the Oracle JDBC driver documentation for the
format of this URL.

4) You do not need to use MapManager. This is a tool for generating
maps. Since you already have a map, you should use the Transfer tool
(run by transfer.bat in the sample directory) to transfer data.

-- Ron

ask me wrote:

> I needed to transfer the datas in the XML file into Oracle8i, and by
> seraching internet i came across the very helpful site
> http://www.rpbourret.com <http://www.rpbourret.com> . I downloaded the
> xml-dbms version 2.0
>
> Although being new to java , i gone through the readme file and had all
> the classpath set for xmldbms20.jar and xerces.jar and then compiled the
> .java files one by one ,blindly just compiled all the files
>
> Didn't find where to mention the "my database_name " and "drivers"
> ,"userid" and "password"
>
> First of all i started with the samples and am still stuck there...
> And now when i run manage map.props from command promt it gives
>
> C:\xmldbms20alpha3\samples>manage map.props
>
> C:\xmldbms20alpha3\samples>echo off
>
> C:\xmldbms20alpha3\samples>java
> org.xmlmiddleware.xmldbms.tools.MapManager File1=parser.props File2=
> db.props File3=map.props
> java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name
> not found and no default dr
> iver specified
> at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
> at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
> at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3028)
> at
> sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
> at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:171)
> at
> org.xmlmiddleware.db.JDBC1DataSource.createObject(JDBC1DataSource.java:1\
> 00)
> at org.xmlmiddleware.utils.Pool.checkOut(Pool.java:98)
> at
> org.xmlmiddleware.db.ConnectionPool.checkOut(ConnectionPool.java:79)
> at
> org.xmlmiddleware.db.JDBC1DataSource.getConnection(JDBC1DataSource.java:\
> 158)
> at
> org.xmlmiddleware.xmldbms.tools.MapManager.createMapFromDTD(MapManager.j\
> ava:567)
> at
> org.xmlmiddleware.xmldbms.tools.MapManager.dispatch(MapManager.java:407)
> at
> org.xmlmiddleware.xmldbms.tools.MapManager.main(MapManager.java:348)
>
>
>
> I am feeling like a soldier who has the weapon and the will to fight but
> just don't know how to use the weapon. I know it's dumb but that's what
> i feel like. Will you help me out Ron?