I am just trying to make connection to unixODBC using jdbcOdbc Bridge: public class HomePage extends WebPage { public HomePage(final PageParameters parameters) { Connection con = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; // Connect with a url string con = DriverManager.getConnection("jdbc:odbc:mdbtest;"); List<String> strgLst = new ArrayList<String>(); strgLst.add("Connection ok."); add(getLst(strgLst)); con.close(); } catch (SQLException e) { add(getErrLst("SQLException:", e)); } catch (Exception e) { add(getErrLst("Exception:", e)); } }
private ListView<String> getErrLst(String firstMsg, Exception e){ StackTraceElement[] err; List<String> errStrg = new ArrayList<String>(); err = e.getStackTrace(); errStrg.add(firstMsg); errStrg.add(e.getMessage()); for (int i = 0; i<err.length;i++){ errStrg.add(err[i].toString()); } return getLst(errStrg); } private ListView<String> getLst(List<String> strgLst){ ListView<String> listview = new ListView<String>("listview", strgLst) { protected void populateItem(ListItem<String> item) { item.add(new Label("message", item.getModel())); } }; return listview; } } Running on Windows with Jetty I get: Connection ok. Running on Ubuntu 9.10 with Tomcat 6 I get: SQLException: General error sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6986) sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114) sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073) sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323) sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174) java.sql.DriverManager.getConnection(DriverManager.java:582) java.sql.DriverManager.getConnection(DriverManager.java:207) wicketqs.HomePage.<init>(HomePage.java:42) sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) java.lang.reflect.Constructor.newInstance(Constructor.java:513) org.apache.wicket.session.DefaultPageFactory.createPage(DefaultPageFactory.java:188) org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:65) org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.newPage(BookmarkablePageRequestTarget.java:298) org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.getPage(BookmarkablePageRequestTarget.java:320) org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.processEvents(BookmarkablePageRequestTarget.java:234) org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92) org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250) org.apache.wicket.RequestCycle.step(RequestCycle.java:1329) org.apache.wicket.RequestCycle.steps(RequestCycle.java:1428) org.apache.wicket.RequestCycle.request(RequestCycle.java:545) org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:479) org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:312) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) java.lang.Thread.run(Thread.java:662) Running on Ubuntu as Standalone Java class (without Wicket) I get: Connection ok. > Am 24. Februar 2012 14:13 schrieb Martin Grigorov <mgrigo...@apache.org>: > > "It doesn't work" doesn't say much about the problem ... >> Give more details >> >> On Fri, Feb 24, 2012 at 2:06 PM, Alex <zeita...@googlemail.com> wrote: >> > Dear All, >> > Does anybody have experience in using unixODBC with Wicket and Tomcat? >> It >> > is possible to establish connection with jetty. But it does not work >> with >> > Tomcat under Ubuntu. Stand alone java class (without using wicket) is >> > working under Ubuntu fine. >> > Any help would be highly appreciated. >> > Alex >> >> >> >> -- >> Martin Grigorov >> jWeekend >> Training, Consulting, Development >> http://jWeekend.com >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org >> For additional commands, e-mail: users-h...@wicket.apache.org >> >> >