It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,785

question asked: Aug 08 '09, 4:23 p.m.
question was seen: 4,097 times
last updated: Aug 08 '09, 4:23 p.m.

Related questions

FAQ - How this Forum works

Initialize Derby Database?

0
Jon Machtynger (11●1●1) | asked Aug 08 '09, 4:23 p.m.
Hi,

I've been playing with RTC 2.0 and now want to scrap the content in there and start from scratch. I don't want to archive anything and have it lying around.

How do I do this?

Thanks

Jon

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Christophe Elek (2.9k●1●30●21) | answered Aug 08 '09, 10:54 p.m.
JAZZ DEVELOPER
jonm@uk.ibm-dot-com.no-spam.invalid (jonm) wrote in news:h5knn5$okn$1
@localhost.localdomain:

How do I do this?

repotools -createtables

should do it (by dropping and recreating the tables and data)

--
Christophe Elek
Jazz L3
IBM Software Group - Rational
0
permanent link
Jon Machtynger (11●1●1) | answered Aug 09 '09, 10:53 a.m.
Thanks Christophe.

I dropped the tables, and recreated them. Your answer helped immensley, but I was tripped up a little because the command is case sensitive (createTables).

One interesting thing you might want to look at is that although I have now initialized the database and it is empty... I can still log on with my old username. The user by the way is *not* listed as a user. I didn't need to log in as ADMIN at all. Seems like a bug somewhere, but I'm not sure where. I have bounced the server, but perhaps clearing the cache could help.

If this is required, it seems to be a bug and possible a security issue.

Thanks very much again

Jon


jonm@uk.ibm-dot-com.no-spam.invalid (jonm) wrote in news:h5knn5$okn$1
@localhost.localdomain:

How do I do this?

repotools -createtables

should do it (by dropping and recreating the tables and data)

--
Christophe Elek
Jazz L3
IBM Software Group - Rational
0
permanent link
Mervyn Keene (171●17●7) | answered Aug 09 '09, 12:10 p.m.
jonm wrote:
One interesting thing you might want to look at is that although I
have now initialized the database and it is empty... I can still log
on with my old username. The user by the way is *not* listed as a
user. I didn't need to log in as ADMIN at all. Seems like a bug
somewhere, but I'm not sure where. I have bounced the server, but
perhaps clearing the cache could help.

If this is required, it seems to be a bug and possible a security
issue.

If you're using Tomcat as the app server, your "user database" is held
in the text file tomcat-users.xml, not in Derby. You may need to
manually edit that file and clip out the users, or just copy in an
original version.

MK
0
permanent link
Jon Machtynger (11●1●1) | answered Aug 10 '09, 1:50 p.m.
Genius

Thanks again


jonm wrote:
One interesting thing you might want to look at is that although I
have now initialized the database and it is empty... I can still log
on with my old username. The user by the way is *not* listed as a
user. I didn't need to log in as ADMIN at all. Seems like a bug
somewhere, but I'm not sure where. I have bounced the server, but
perhaps clearing the cache could help.

If this is required, it seems to be a bug and possible a security
issue.

If you're using Tomcat as the app server, your "user database" is held
in the text file tomcat-users.xml, not in Derby. You may need to
manually edit that file and clip out the users, or just copy in an
original version.

MK

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.