Error: connect to Derby jazz 4 DB , BIRT
_9.56.11_p.m..png)
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
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
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,
Definietely we recommend you using Jazz data source.
Anyway the root cause of your original issue is that as default CLM applications use local derby database and connect to it using path on server (not using port). You probably will not be able to connect to this database also due to the fact, that for this type of connection only one application (CLM server) can be connected to the database at the same time.
Comments
Karl Weinert
JAZZ DEVELOPER May 16 '13, 12:34 p.m.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