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:
<Application
name="test"
rootSystem="test/test"
authenticationMethod="None">
<DataSource
name="jdbc/Main"
driverClassName="com.mysql.jdbc.Driver"
username="root"
password="*********"
url="jdbc:mysql://localhost/vwh"
validationQuery=""
/>
</Application>
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
SQLState: 42000
ErrorCode: 1064
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.
Regards
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign