Connectors and Recordsets

[innovision]

Good day,

I have a Netobjects Connector with some Recordsets.
For some reason that I do not understand, the databases' tables disappear from the connector (leaving just the database icon).
In the connector, the Recordset tag is greyed-out (see the attached image). The odd thing is that the recordset drop down list still remains on the text boxes properties and it works.

My checks.
- I've deleted and try to redo a new connector.
- I've checked (and redid) a new connection.
- MySQL Database (local) is up and running.
- I've tried to connect throughout an ODBC... No luck.
- I'm using xampp to start Apache and MySql and re-started it.
- MySQL Privileges are OK.
- I replaced the actual template with a backup.
- I did reboot the machine, MySQL and Apache.

Note: The same issue happens with all connectors of all pages.

Any help is appreciated
Cheers
Carlos

[rst]

It seems to be that you have lost the connection to your database (ODBC & DIRECT). this happens if you only have Java 8, because Java 8 has no jdbcodbc.dll (Java-ODBC-Bridge). Install an older Java (i.E.Java 7).

Oracle says:
The JDBC-ODBC Bridge allows applications written in the Java programming language to use the JDBC API with many existing ODBC drivers. The Bridge is itself a driver based on JDBC technology ("JDBC driver") that is defined in the class sun.jdbc.odbc.JdbcOdbcDriver. The Bridge defines the JDBC sub-protocol odbc.

The JDBC-ODBC Bridge should be considered a transitional solution; it will be removed in JDK 8. In addition, Oracle does not support the JDBC-ODBC Bridge.

Hope this helps
Stefan

[innovision]

I will try your suggestion
Many thanks Stefan
Carlos

[innovision]

Database is MySQL. Do you think it is about the same problem?
Cheers
Carlos

[rst]

Hi Carlos
Oracle is the current owner of Java - and of course - owner of Oracle database.

In your attached Image "Connector - rssf" on tag Database there is a Option "Import from Connection". Set the checkbox checked and NOF reads the database Schema from your MySQL-database.
If NOF cannot read the database Schema then the Recordset tag is greyed-out in the connector dialog.

The textbox properties with the recordset drop down list and the recordset definitions are stored in the .nod-file.
The connector data and database Schema together with the Publishing Profile names are stored in: C:\Users\<your username>\Documents\NetObjects Fusion 2015\NetObjects System\Profiles\<your language-id>\NetObjects Inc\DBLib\MetaData\Cache.xml
You can read this file with InternetExplorer to see it´s ok.

Stefan

[innovision]

SOLUTION Found
1 - On this directory:
C:\Users\[your user name]\Documents\NetObjects Fusion 2015\NetObjects System\Profiles\enus\NetObjects Inc\DBLib\MetaData\
2 - Rename (or delete) the file cache.zip and replaced it with a backup
My connectors and recordsets were back.
Have a great week-end