[#5860] - JavaDB tJavaDBInput not working correctly

Category:
Bug report
Priority:
Normal
Status:
Assigned
Project: Severity:
Major
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

I'm having a weird problem. I'm making a temporary embedded database using the embedded Apache Derby tJavaDBOutput functions. I use the URL jdbc:derby:/home/ttrostel/Desktop/myETL/data;create=true

The database is created just fine .... data seems to be inserted into tables .... I can scan the schema and see that the columns and rows are correct ... but

when I try to use the tJavaDBInput with the same URL I get an error which tells me "org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)"

It looks like when using input components and the Embedded database the software generator is using the wrong form as shown here:

java.lang.Class
.forName("org.apache.derby.jdbc.EmbeddedDriver");

when it should really be doing the same thing it does when doing the output job as shown here:

Class.forName(jdbcDriver_tJavaDBOutput_1).newInstance();

This is running on

"Jaspersoft ETL"

Version: 5.0.2
Build id: r78327-20120331-1108

ttrostel's picture
Joined: Aug 5 2012 - 3:05pm
Last seen: 10 years 6 months ago
Feedback