[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mdbtools-dev
Subject:    [mdb-dev] java and mdbtools: is it possible?
From:       Gerson Souza <d34th_4v3ng3r () yahoo ! com ! br>
Date:       2003-07-28 3:04:30
[Download RAW message or body]

Hi all!

I have the following problem: a web application in a
Java / Tomcat / Linux environment. This application is
feed by .mdb files, weekly.

After searching (a lot) on web how I could read these
files, I found your project. Howerver, I'm having
several doubts in using its odbc features.

First I install unixodbc and configure it like this:

ODBC.INI: 
... 
[MyDB] 
Description = MyDB 
Driver = MDBToolsODBC 
Database = /home/gsouza/MyDB.mdb 
Servername = localhost 
UserName = 
Password = 
Port = 5432 

ODBCINST.INI: 

[MDBToolsODBC] 
Description = MDB Tools ODBC drivers 
Driver = /usr/local/lib/libmdbodbc.so.0 
Setup = 
FileUsage = 1 
CPTimeout = 
CPReuse = 
 
Then, i installed rpms of mdbtools.

After that, I did some test using mdb-* utils and It
worked ok.

Finally, I begun my first java test, using jdbcOdbc
bridge, to access the .mdb: 

import java.sql.*;
class TestDB
{
  public static void main (String args[])
  {
    String url = "jdbc:odbc:MyDB";
    try
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection conn = DriverManager.getConnection
(url, "", "");
      .........


It compiles without problems, but at runtime it throws
a NullPointerException on DriverManager.getConnection
method.

So I tried the dns-less way, like:

String url = "DRIVER={MDB Tools ODBC drivers};
DBQ=/home/gsouza/MyDB.mdb" 

String url = "DRIVER={MDBToolsODBC};
DBQ=/home/gsouza/MyDB.mdb"

String url = "DRIVER={/usr/local/lib/libmdbodbc.so.0};
DBQ=/home/gsouza/MyDB.mdb"

   
Nevertheless, none worked.
Thus, if anyone that have been successful in java +
mdbtools figure out what I'm doing wrong I'd
appreciate.

Thank you.

P.S.: I'm sorry cause of grammar errors. I'm not an
english native speaker.







_______________________________________________________________________
Conheça o novo Cadê? - Mais rápido, mais fácil e mais preciso.
Toda a web, 42 milhões de páginas brasileiras e nova busca por imagens!
http://www.cade.com.br


-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
mdbtools-dev mailing list
mdbtools-dev@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
[prev in list] [next in list] [prev in thread] [next in thread]