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