• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

newbie J2EE Database Server question

 
Steven Marco
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In the old J2EE 1.4 there's a Pointbase Console where I can execute SQL commands like creating tables. Does anyone know where this went in J2EE 5 or how I can do the same thing? Thanks!
 
Jeroen T Wenting
Ranch Hand
Posts: 1847
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
that's weird because there's no Pointbase database in 1.4, there's Derby (unless maybe they switched between Pointbase and Derby in a minor version and you have an old version).
Derby does not have a user interface of any kind, only a JDBC driver.
 
Steven Marco
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am reading the book "Beginning J2EE 1.4" by Apress, it says all I have to do is download J2EE 1.4 SDK and in its directory there is a place to "Start Pointbase" console. So this is probably the old version.
 
Jeroen T Wenting
Ranch Hand
Posts: 1847
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hmm, What version of the appserver are they referring to?
The 8.2 appserver comes with Derby.
Probably the 8.0 or 8.1 included Pointbase, Derby itself is rather new.
 
marc weber
Sheriff
Posts: 11343
Java Mac Safari
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to the JDBC forum.
 
Peter Rooke
Ranch Hand
Posts: 851
1
Java Linux Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you are using Derby (and not pointbase) then the ij command will open up a console from where you can enter SQL commands. Also if you cannot find enough documentation on Derby, then look at the Cloudscape manuals.
[ September 04, 2006: Message edited by: Peter Rooke ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic