Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Error: connect to Derby jazz 4 DB , BIRT

Questions
Tags
Users
Badges
Rafael Rodriguez Montes
(230●14●130●258) retagged
May 16 '13, 3:49 a.m.
 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

0 votes

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

1 answer
8,536 views
0 votes

Accepted answer

Permanent link
Krzysztof Kaźmierczyk
(7.5k●4●80●103) 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

1 vote

Comments
Rafael Rodriguez Montes
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
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 log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 11,108
× 7,623
× 324

Question asked: May 16 '13, 12:59 a.m.

Question was seen: 8,536 times

Last updated: May 16 '13, 12:34 p.m.

Confirmation Cancel Confirm