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:


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


This is running on 

"Jaspersoft ETL"

Version: 5.0.2
Build id: r78327-20120331-1108

I'd go in and fix the software maybe ... but where is it to repair?

Thanks in advance!
ttrostel's picture
Joined: Aug 5 2012 - 3:05pm
Last seen: 10 years 10 months ago

0 Answers:

No answers yet