by sparkiemark » Fri Jan 10, 2014 8:54 pm
Looks like a great tool, but I am having trouble connecting to MoneyDB. I downloaded your mth_derby.jar driver, and added it to 'Classpath'.
When I create a new Connection / Database:
DataSource Type: Database JDBC Connection
Name: MoneyDB
JDBC Driver: org.apache.derby.jdbc.EmbeddedDriver (THIS DRIVER DOES NOT EXIST IN THE LIST)
JDBC URL: jdbc:derby:/Users/********/Documents/*********/yemon/MyMoney/moneyDB
Checked into the "How_to_create_a_custom_Tax_report_in_My_Money#Some_common_problems_that_you_may_encounter_while_connecting_to_database_from_iReport", typed in "org.apache.derby.jdbc.EmbeddedDriver" as the JDBC Driver as the article suggested. Removed 'All Users", from my MyMoney, so it is no longer password protected.
However, cannot get a connection to the database. Typical, never, never, ever works the first time!
When I attempt a 'Test', regardless of just having to remove all password protection from MyMoney database, I still get prompted for a password. I choose blank <OK> as there is no database password set (the result of following the steps above to get rid of it), and then I get:
Exception
Message:
java.sql.SQLException: Failed to start database '/Users/*********/Documents/********/yemon/MyMoney/moneyDB' with class loader com.jaspersoft.ireport.designer.IRURLClassLoader@1bfc9484, see the next exception for details.
Level:
SEVERE
Stack Trace:
Failed to start database '/Users/********/Documents/********/yemon/MyMoney/moneyDB' with class loader com.jaspersoft.ireport.designer.IRURLClassLoader@1bfc9484, see the next exception for details.
yadda, yadda, jadda....
What am I missing here. I have followed the instructions to a tee, and obviously a step has been left out!
Many thanks in advance for your assistance.