Telosys Tools

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

Mars (4.5)
Luna (4.4)
Kepler (4.3)
Juno (4.2, 3.8)
Previous to Juno (<=4.1)

Learn more...

Details Group Tabs

Abu Khalid's picture

In Oracle Long, Integer, Byte, Boolean , Float, BigIntiger, BigDecimal all can be stored as NUMBER with scale and precision. There needs a way of telling this tool based on scale an precision map to configurable Java type. Is there a way

Yuri Soloviev's picture

It is magic. Scaffolding makes it perfect

Laurent Guérin's picture

Version 2.1.0 is ready !
See the new features here : http://telosys-tools.blogspot.fr/2014/04/telosys-tools-210-is-available....
New tuturials are also available ( https://sites.google.com/site/telosystutorial/ )
for new targets ( AngularJS, REST, Spring MVC, Spring Data, JPA, etc )

Laurent Guérin's picture

Please do not submit your questions here

Use the forum for any questions : https://moot.it/telosystools

antoine larcher's picture

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>

antoine larcher's picture

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

Sergey Sl's picture

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

Laurent Guérin's picture

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 ) :

Laurent Guérin's picture

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

Laurent Guérin's picture

Since version 2.0.4 templates can be downloaded from GitHub

redwene haddou's picture

Great :)
redwene

Laurent Guérin's picture

This plugin as been presented at Devoxx 2011

See the conference at http://www.devoxx.com/display/DV11/A%20pragmatic%20scaffolding%20approac...

John Mising name's picture

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