Error: connect to Derby jazz 4 DB , BIRT
![]()
Rafael Rodriguez Montes (230●13●130●258)
| asked May 16 '13, 12:59 a.m.
retagged May 16 '13, 3:49 a.m. by Krzysztof Kaźmierczyk (7.5k●4●80●103)
Hi,
I'm trying to connect directly to DB using Derby (default jazz db) , the reason, I need to create custom reports (custom queries using SQL), but, when I try to connect, I got this error:
![]()
Thank you
|
Accepted answer
![]()
Hello Rafael,
You should not try connecting directly to SQL database when trying to create custom report. A good place to start researching would be: http://wiki.eclipse.org/BIRT/FAQ/Data_Access#Supported_Data_Sources Let me know if it helps for you. Best regards, Krzysztof Kazmierczyk Rafael Rodriguez Montes selected this answer as the correct answer
Comments Hi Kriz,
For clarify, I want to connect directly to Derby, and use SQL language for create custom queries and generate Reports, because when I try to connect using Jazz connector, I don't have enable this feature, I can do simple filters only but not
advanced queries. so which is the best way for get this feature?.
Thank You!
I appreciate your help.
Hello Rafael,
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
You need to scroll down to find the last "Caused By" message in the error.
It is probably because the database is already in use by RTC.
Derby does not allow multiple connections to a single database, so to access it you would need to stop RTC.
(I'm may not be using the the terminology quite right, hopefully you get the idea)
You will probably see something like this near the bottom of the error:
SQLSTATE: XSDB6Another instance of Derby may have already booted the database