Marco writes:
[snip]
> So I have two different solution:
> 1) Ask you to extend tags in finder methods in jaws files in order to =
> support use of MAX, MIN, COUNT, DISTINCT, etc. In this way JBoss shoul =
> offer a way to build the first section of sql statements too!
> I think it should not be an impossible stuff! In this way I could came =
> back to use first statement I wrote with every database I want! Let me =
> know if you agree with me when I say it should be a good improvement. =
> Lat me also know if you need an hand in doing this!
I don't think that would be EJB1.1 compliant...
> 2) Change Database
> I tried to do this but I had this troubles with:
> JDataStore: there's no mapping in defaultjaws.xml;
This is not too hard to rectify. I know nothing about the DB, though.
> Oracle: it's free for developer but hard to install and configure! And I =
> don't have all of this time!
Hehe, I just spent three days trying to recover and Oracle instance on
an NT box which 'lost' a datafile when the RPC mechanism died and had
to be rebooted by the harshest method of all... Grrrr. I hate NT.
OracleLite might be a good option to explore, though.
> DB2: I think its too hudge!!
> PostgreSQL: Does a version for Windows exist?
You can install Postgres on NT, but it's a pain. You need to install
cygwin and a few IPC libraries and then recompile it (I couldn't get
the precompiled binary to work). It works, but it's a bit messy. But
it is a good DB. Check out chapter 6 of:
http://postgresql.readysetnet.com/users-lounge/docs/7.0/admin
HTH!
Tom
--
Tom Cook - Software Operations
"We rarely find that people have good sense unless they agree
with us."
- Francois, Duc de la Rochefoucauld
LISAsoft Pty Ltd - www.lisa.com.au
--------------------------------------------------
38 Greenhill Rd. Level 3, 228 Pitt Street
Wayville, SA, 5034 Sydney, NSW, 2000
Phone: +61 8 8272 1555 Phone: +61 2 9283 0877
Fax: +61 8 8271 1199 Fax: +61 2 9283 0866
--------------------------------------------------
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
