Curro Amores wrote:
hi:
i want to run jboss in linux and connect to an Ms Access odbc source.
Hmm... I would think twice before trying to run a J2EE application that
reads data from an MS Access database, regardless of operating system.
Have you considered how well Access scales for many users? How about
locking between different simultaneous users? In addition, JBoss runs on
Java, and Java is supposed to be cross-platform. You might want to take
the extra step of porting your database to another DBMS, such as MySQL,
PostgreSQL, or even Oracle (if you have the $$$). If your DBMS must be
all-Microsoft, you can still prepare a SQL-Server and connect to it from
Linux with FreeTDS (http://www.freetds.org/) and ODBC.
I think it doesnt exist odbc driver for Access in Linux. I Have read
something about ODBC-ODBC but i think it is for accessing a mde file
in a windows machine from linux.
In a limited sense, there is a way: MDB Tools
(http://mdbtools.sourceforge.net/). However, SQL/ODBC support is
read-only, last time I checked, and in addition, the emphasis is on
getting data out of MDBs in order to put it in another DBMS, not to use
MDBs in a daily basis.
I have created the bridge with ODBC in wine (using the control pane
with winetools)
Then i have tried to run jboss windows version (run.bat) with wcmd but
i got a message that run.jar file cant not be found.
That is because it is looking for a java.exe, the Windows version of java.
Do i have to install java windows version with wine?
yes
I have tried as well but the installation crashes
Any idea?
If, after what I said about thinking it twice, you *still* need to make
a Windows version of Java run a J2EE with MS-Access inside Wine, then
you might need to 1) install MDAC manually, not via winetools, and 2)
file a bug report with a crash log when installing the Windows version
of Java in Wine.
thanks
Alex Villacís Lasso
