Datasouce problem
I recently posted an issue concerning the use of a SQLBase database as a datasource - had no replies to that but I have made some progress.. but still have a problem.
It looks like when you define a new database in the runtime tab, the IDE uses simple JDBC calls to get information about the database - simple and it works just fine, you can view the database tree and everything appears OK.
However, in the designer and at runtime, the system appears to use the javax.sql.DataSource interface to retrieve data - a problem if your chosen JDBC does not implement the interface. - If you drag'n'drop from the database to the pagelayout window, code for the dataprovider is generated - but the data is NOT bound.
I can partially solve the problem (runtime) by defining a new resouce in the config.xml file referencing a dataSourceFactory which in turn creates a datasource object - it appears to work correctly - the new datasource is available at runtime.
However, this does not solve the designtime problem - any ideas please?
