I’ve been playing around with Weblogic 10 recently, as I wanted to see what the new platform offered over and above the old ones. In the past, I’ve never had the opportunity to install the sample apps and spend the time getting familiar with them, so this time, I installed Weblogic on my development PC and started working with the MedRec sample.
Like any good techie, my first task was to add myself as a patient, with a fictitious SSN number (123456789 is always a pretty good bet!). This was accepted without any complaints or challenges from either the application server or the Pointbase database. Imagine my surprise then, when I started looking at the C# client and tried to search on this new SSN, only to be told that it couldn’t return anything due to having MULTIPLE RECORDS!!!
Is it just me? Surely, any programmer worth their salt will either set constraints on the database or if that’s not available (any comments from Pointbase experts out there?) then it should be validated in code before committing! Come on guys – it’s not hard!
Wrestling with Pointbase
Anyway, the point of this post wasn’t to berate the MedRec programmers (who’ve done a great job in producing a well thought-out application for learning the concepts behind J2EE) but to provide some vital information regarding Pointbase…
Clearly, for me to progress with my investigations, I needed to be able to take a look at the data table with the duplicate SSN. Had I been working with virtually any other database, I’d have known where to get the correct tools to browse the data and to submit ad-hoc SQL queries. Pointbase, on the other hand, was new to me!
After much digging, I finally found the script to start the console (it’s in BEA_HOME\wlserver_10.0\common\eval\pointbase\tools and it’s called ‘startPointBaseConsole.cmd’) only to be presented with connection settings that I couldn’t find documented!
So, for anyone else struggling to find the same information, here’s what you need (assuming Pointbase is running…):
Driver: com.pointbase.jdbc.jdbcUniversalDriver
URL: jdbc:pointbase:server://localhost/demo
User: medrec
Password: medrec
Hope this help!
No related posts.
