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
Joined: Apr 21, 2006
Posts: 1847
posted
0
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.
42
Steven Marco
Greenhorn
Joined: Jul 23, 2002
Posts: 21
posted
0
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
Joined: Apr 21, 2006
Posts: 1847
posted
0
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.
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 ]