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 <[email protected]>:
>
> "It doesn't work" doesn't say much about the problem ...
>> Give more details
>>
>> On Fri, Feb 24, 2012 at 2:06 PM, Alex <[email protected]> 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: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
