Telosys Tools 2.1.0

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

Learn more...

Details Group Tabs

It is magic. Scaffolding makes it perfect

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 )

Please do not submit your questions here

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

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>

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

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

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

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

Since version 2.0.4 templates can be downloaded from GitHub

Great :)
redwene

This plugin as been presented at Devoxx 2011

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

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