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)
Neon (4.6)

Learn more...

Details Group Tabs

ayyilmaz's picture

Hello,
I have just installed telesys eclipse plugin. It looks great.
I followed the tutorials with default db derby.
However, then when I wanted to try it with DB2 it throws error.:
[LOG] ConnectionManager constructor ...
[LOG] DriverLoader constructor ...
[ERROR] DriverLoader constructor : 'libraries' is void !
-----
Exception : org.telosys.tools.commons.TelosysToolsException
Message : DriverLoader constructor : 'libraries' is void !

If someone can help me I will appreciate.

Thanks and Regards

Yılmaz

lmisingnamei8x's picture

Please use the forum for this kind of question : https://muut.com/telosystools

lmisingnamei8x's picture

It’s because Telosys cannot found the DB2 JDBC driver. Telosys tries to load the JDBC driver from the project classpath (if the project is a Java project) and from the “TelosysTools/lib” folder. So just add it in the classpath (or in the pom.xml for a Maven project) or copy the jar file in the “lib” folder. In the “.dbcfg” editor click the button “Show libraries” to check if the jar is in the list.

ayyilmaz's picture

By the way, my telosys version is 2.1.1 and eclipse version is Neon.
Telosys worked fine with derby without any problems.
Then I tried the same steps with a DB2 database.
At the database connection configuration step it failed, I cannot move further.
However, I already created a db2 database connection in the eclipse itself without any problem. (after uploading db2 jdbc drivers of course)
I am looking forward to your suggestions.

Thanks in advance.

mfugante's picture

Telosys 2.1.1 used as eclipse plug-in, with mysql connection (connection tested)
"generate repository" return the error:

Exception org.telosys.tools.common.TelosysException: SQLException

Exception com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the tight syntax to use near'match WHERE 1=0 at line 1

hchen7hy's picture

Unable to connect to repository
Connection timed out: connect

akhalid'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

ysoloviev's picture

It is magic. Scaffolding makes it perfect

lmisingnamei8x'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 )

lmisingnamei8x's picture

Please do not submit your questions here

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

alarcher'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>

alarcher'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

sslipchenko'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

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

lmisingnamei8x's picture

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

lmisingnamei8x's picture

Since version 2.0.4 templates can be downloaded from GitHub

rhaddou's picture

Great :)
redwene

lmisingnamei8x's picture

This plugin as been presented at Devoxx 2011

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

jmisingnamec81's picture

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