Telosys Tools 2.1.0

Bookmark and Share
Update site

Add this URL to your Eclipse Installation to reach this Solution's Update Site.
Learn more...

Details Group Tabs

Reviews

Login  to post comments.

Generation error with an Oracle database

Unfortunately, I get a SQL error when generating the repository with an Oracle Database.

"Cannot generate. Exception org.telosys.tools.commons.TelosysToolsException : SQLException
Exception java.sql.SQLDataException : ORA-01424 : missing or illegal character following the escape character"

=> Do you know if I can get a log with the generated SQL in order to understand where this syntax error may come from ?

Thanks very much.

Here is my configuration :

- Telosys Tools 2.0.4
- Oracle 11.2.0.3.0
- ojdbc6.jar

<!-- ============================================ -->
<!-- ORACLE 8i, 9i, 10g, 11g -->
<!-- ============================================ -->
<!-- The JDBC Driver is in "ojdbc14.jar" or "ojdbc5.jar (JDK 1.5) or "ojdbc6.jar" (JDK 1.6)
( or "classes12.jar" or "classes12.zip" for 8i ) -->

<db id = "0"
name = "Oracle - TelosysBookStore DB"
driver = "oracle.jdbc.driver.OracleDriver"
url = "jdbc:oracle:thin:sonar/sonar@192.168.2.53:1521:XE"
isolationLevel = "TRANSACTION_READ_COMMITTED"
poolSize = "3" >
<property name="user" value="sonar" />
<property name="password" value="sonar" />
<metadata catalog="!" schema="SONAR" table-name-pattern="%" table-types="TABLE VIEW " />
</db>

SQLException using Oracle

Unfortunately, generating the repository with an Oracle configuration generates the following error :
"Cannot generate. Exception org.telosys.tools.commons.TelosysToolsException : SQLException
Exception java.sql.SQLDataException : ORA-01424 : missing or illegal character following the escape character"

Here is my configuration :
Telosys Tools 2.0.4
Oracle jdbc driver : ojdbc6.jar

Thanks for your help.

Antoine Larcher

Can't get tables from Oracle DB

Submitted by Sergey Sl on

Unfortunately, getting metadata doesn't work for Oracle Db.
Tried to use it in eclipse helios (Win 7).
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

MetaData with Oracle

Yes, it works with Oracle, you just have to specify "!" (means null) for the catalog

Example for the "HR" demo database in Oracle XE (in .dbcfg file ) :

Example

<metadata catalog="!" schema="HR" .... />

Templates sharing with GitHub

Since version 2.0.4 templates can be downloaded from GitHub

Great !!

Great :)
redwene

It works in a few minutes

Submitted by John on

Very efficient.
This plugin with the framework StarterKit allows to generate the repository and finally the application code in a few minutes...