UltraDev/JSP Sybase connection

[bbcameron]

I'm using UltraDev to create JSP pages to connect to a Sybase database through Apache/Tomcat. I can connect to the database and view the table BUT...

I cannot access the table data. I am getting the following Dreamweaver UltraDev error:

A server timeout has occured. Here are the possible reasons.
1. Please make sure that the web server is up and running.
2. Please verify that the ODBC DSN exists on the application server.

My connection configuration is:
Driver: com.sybase.jdbc2.jdbc.SybDriver
URL: jdbc:sybase:Tds:[server: /database]

Any clues?

 

[bbcameron]

Just an FYI:

I contacted Macromedia Support concerning this problem. They were VERY responsive and sent me the extension. Here's the deal:

There is a problem with UltraDev and JDBC connectivity to Sybase using the JConnect driver, which I believe you are using. The problem has been identified and an extension has been put together by our engineers to work around the problem. A TechNote will be available soon explaining the situation.

There are a couple issues with this fix that you should be aware of:

1) Because some optimization code had to be removed to fix the bug, there will be a performance hit when using JDBC database connections with UltraDev. This applies only in the development environment (i.e. during design-time) - there will be no effect on the performance of the Web pages built with UltraDev. This performance hit will only affect
you if you use UltraDev to connect to other databases (e.g. SQL Server or Oracle) via JDBC.

2) This fix cannot be automatically undone.