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 !
It's because Telosys cannot found your JDBC driver. You just have to add the DB2 JDBC driver Jar in your classpath or in the "TelosysTools/lib" folder.
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.
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.
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
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
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 ?
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
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
Reviews Sign in to post reviews
It works fine (used for
Submitted by Jack Paterno on Thu, 2018-10-25 05:12
It works fine (used for Python generation with DSL model)
Version 3.0.0 is now available
Submitted by Laurent Guérin on Tue, 2018-04-10 05:13
Version 3.0.0 works with 2 kinds of models : database model and DSL model
db2 driver problem
Submitted by Yılmaz Ay on Wed, 2016-09-21 08:11
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
Re: db2 driver problem
Submitted by Laurent Guérin on Fri, 2017-02-24 12:52
It's because Telosys cannot found your JDBC driver. You just have to add the DB2 JDBC driver Jar in your classpath or in the "TelosysTools/lib" folder.
db2 driver problem
Submitted by Laurent Guérin on Fri, 2016-09-23 11:47
Please use the forum for this kind of question : https://muut.com/telosystools
db2 driver problem
Submitted by Laurent Guérin on Fri, 2016-09-23 11:45
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.
db2 driver problem (further clarification)
Submitted by Yılmaz Ay on Wed, 2016-09-21 09:35
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.
generate repository error
Submitted by Mauro Fugante on Sun, 2016-07-03 06:22
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
install failue
Submitted by Hl Chen on Sat, 2015-12-26 05:23
Unable to connect to repository
Connection timed out: connect
Oracle JPA Number to Java Type mapping
Submitted by Abu Khalid on Wed, 2015-04-22 11:04
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
Telosys Tools version 2.1.1 is ready
Submitted by Laurent Guérin on Wed, 2015-03-04 05:23
What's new ? See the blog :
http://telosys-tools.blogspot.fr/2015/03/telosys-tools-ver-211-whats-new...
Great
Submitted by Yuri Soloviev on Thu, 2014-05-15 04:14
It is magic. Scaffolding makes it perfect
Telosys Tools version 2.1.0 is available
Submitted by Laurent Guérin on Wed, 2014-04-02 09:58
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 )
Telosys Tools version 2.0.6
Submitted by Laurent Guérin on Fri, 2013-09-27 07:35
What's new ?
http://telosys-tools.blogspot.fr/2013/09/telosys-tools-v206-whatsnew.html
Telosys Tools Forum
Submitted by Laurent Guérin on Thu, 2013-07-11 08:45
Please do not submit your questions here
Use the forum for any questions : https://moot.it/telosystools
Generation error with an Oracle database
Submitted by Antoine Larcher on Tue, 2013-07-09 11:41
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
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" >
SQLException using Oracle
Submitted by Antoine Larcher on Tue, 2013-07-09 11:03
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
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" >
Thanks for your help.
Antoine Larcher
Can't get tables from Oracle DB
Submitted by Sergey Sl on Sat, 2013-05-04 07:34
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
Submitted by Laurent Guérin on Tue, 2013-05-14 12:48
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
Submitted by Laurent Guérin on Tue, 2013-05-14 12:49
Templates sharing with GitHub
Submitted by Laurent Guérin on Wed, 2013-04-24 03:37
Since version 2.0.4 templates can be downloaded from GitHub
Great !!
Submitted by Redwene Haddou on Fri, 2013-03-08 04:28
Great :)
redwene
Demo at Devoxx 2011
Submitted by Laurent Guérin on Fri, 2012-01-13 08:04
This plugin as been presented at Devoxx 2011
See the conference at http://www.devoxx.com/display/DV11/A%20pragmatic%20scaffolding%20approac...
It works in a few minutes
Submitted by John Thomson on Thu, 2011-12-22 11:17
Very efficient.
This plugin with the framework StarterKit allows to generate the repository and finally the application code in a few minutes...