It's all about the answers!

Ask a question

Error: connect to Derby jazz 4 DB , BIRT

Rafael Rodriguez Montes (23013126247) | asked May 16 '13, 12:59 a.m.
retagged May 16 '13, 3:49 a.m. by Krzysztof Kaźmierczyk (7.4k375103)
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

Karl Weinert commented 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

Accepted answer

permanent link
Krzysztof Kaźmierczyk (7.4k375103) | answered May 16 '13, 3:48 a.m.
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:

Let me know if it helps for you.

Best regards,
Krzysztof Kazmierczyk
Rafael Rodriguez Montes selected this answer as the correct answer

Rafael Rodriguez Montes commented May 16 '13, 11:38 a.m.

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.

Krzysztof Kaźmierczyk commented May 16 '13, 11:45 a.m.

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.

Your answer

Register or to post 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.