It's all about the answers!

Ask a question

Error: connect to Derby jazz 4 DB , BIRT


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

Thank you


Comments
Karl Weinert commented May 16 '13, 12:34 p.m.
JAZZ DEVELOPER

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.3k34391) | 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:
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
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.