I am using Tersus for the first time. After doing the tutorial, the first thing I wanted to do was to get Tersus working MySQL.
I created a database vwh with a table "databases" and 2 records
I put the jdbc for mysql in:
C:\Program Files\Tersus Visual Programming Platform\jre\lib\ext\mysql-connector-java-3.1.14-bin.jar
And created a Configuration.xml in the Project Home:
C:\Documents and Settings\Holke.Visser\workspace\test\Configuration.xml
with the following contents:
The problem I am facing is that I the data does not show up in my application and I get the error:
"A processing error has ocurred.Error in SQL query: Details: SQL: "Select DBS_ID, DBS_NAME from databases" values:
The generated query does indeed give an error when executed in Squirrel.
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'databases' at line 1
If the tablename is prefixed with the schema/database name vwh the query executes fine in Squirrel.
In Tersus I tried prefixing the Database Record Element Name with vwh. No error occurs but the page in the browser shows an empty recordset.
When I execute trace then I see:
SQL Database List/Action/Action/Find/_run Executing statement: 'SELECT DBS_ID, DBS_NAME FROM vwh_databases' values:
Where does the underscore come from ???
Also the importing structure form database gives shows no tables. I can select the datasource jdbc/Main, The Catolog Name gives me no popup, the schema Name gives me a popup but no options to choose from.
Is there anyone who can tell me what is happening ? Any help would be appreciated.
For best results, use the Firefox browser..