Here is the newest version of my data
source and database schema files. I posted this info once before,
but there have been some minor changes,
(thanks to Dirk Ohst), so this is the latest I've got.
If you find any problems or fix
anything, let us know. Also, if you're having problems with InterBase/Client,
make
sure they're both setup and running correctly. I've had some
difficulties getting the services to behave during
installation.
Good luck! Regards,
-arno
Platform/versions:
Win2000, SPI
Orion, 1.3.5
InterClient 1.60 Final Build
(InterClient server running as system service)
DATA SOURCES
<data-source
class="com.evermind.sql.DriverManagerDataSource"
source-location="interbase.interclient.DataSource"
connection-driver="interbase.interclient.Driver"
schema="database-schemas/InterBase.xml"
name="InterBase"
location="jdbc/InterBaseCoreDS"
xa-location="jdbc/xa/InterBaseXADS"
ejb-location="jdbc/InterBaseDS"
username="sysdba"
password="masterkey"
url="jdbc:interbase://localhost/G:/orion/database/InterBase/yourDB.GDB"
inactivity-timeout="30">
</data-source>
SCHEMA: interbase.xml
<database-schema
name="InterBase" not-null="NOT NULL" null="NULL" primary-key="PRIMARY KEY"
max-table-name-lenght="30">
<type-mapping type="java.lang.String"
name="VARCHAR(255)" />
<type-mapping type="int" name="INTEGER"
/>
<type-mapping type="long" name="NUMERIC(20,0)"
/>
<type-mapping type="float" name="FLOAT" />
<type-mapping
type="double" name="DOUBLE PRECISION" />
<type-mapping type="byte"
name="NUMERIC(10,0)" />
<type-mapping type="char" name="CHAR(1)"
/>
<type-mapping type="short" name="SMALLINT" />
<type-mapping
type="boolean" name="NUMERIC(1,0)" />
<type-mapping
type="java.util.Date" name="DATE" />
<type-mapping
type="java.util.Time" name="TIME" />
<type-mapping
type="java.util.TimeStamp" name="TIMESTAMP" />
<type-mapping
type="java.io.InputStrem" name="BLOB" />
<disallowed-field
name="password" />
<disallowed-field name="date"
/>
</database-schema>
Make sure you have these files in
/orion/lib
09/06/2000
01:00p
316,852 interclient-core.jar
09/06/2000
01:00p
29,352 interclient-res.jar
09/06/2000
01:00p
23,565 interclient-utils.jar
09/06/2000
01:00p
369,153 interclient.jar
04/27/2000
01:47p
162,349 RmiJdbc.jar
-----Original
Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Vimal Patel
Sent: Thursday, August 03, 2000 5:44 PM
To:
Orion-Interest
Subject: Re: Win2k Pro. is mess... choosing the right database
product
Can you tell me what data-source settings you have to get
interbase working with orion and the driver version. I can not get it to work
with orion. Also if you could mail the database-schemas for interbase I would
really appreciate it.
Thanks,
Vimal
----- Original Message
-----
From: Arno Grbac
To: Orion-Interest
Sent: Saturday, February 24,
2001 1:08 PM
Subject: RE: Win2k Pro. is mess... choosing the right database
product
It could be that Interbase is a very recent addition to the
open source / freeware bunch. Also, prior to version 6, Interbase was
missing
some essential data types, which made it a bit less approchable. My company is
still evaluating Interbase, but so far
we haven't found any "issues" and are
extremely pleased with the JDBC driver and the performance/features of this
product.
There appears to be an issue setting different character sets
for the JDBC driver in data-sources.xml, but that is probably true
for all
JDBC drivers and setting their extended parameters (it could be a problem with
Orion) and it's not a show stopper for us.
At some point in time, we were
also evaluating mySQL, but (AT THE TIME) it had no transaction support, JDBC
drivers were
in flux and no blobs.
Personally, I believe that
InterBase 6 offers more features then mySQL. Another FREE option appears to come
from SAP
(http://www.sap.com/solutions/technology/sapdb/) I know nothing
about this product, but it comes with a type 4 JDBC
driver and a bunch of
tools. It would be nice to hear from somebody who know more about
it.
-arno
-----Original Message-----
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Randahl Fink Isaksen
Sent: Friday, February 23, 2001 6:27 PM
To:
Orion-Interest
Subject: RE: Win2k Pro. is mess... choosing the right database
product
You are probably right in your asumptions. Might I ask why
you have chosen to go for PostgreSQL? To me it seems a bit too uncertain to have
two pieces of experimental software in one project. Personally I was thinking of
switching to either MySQL or Interbase once my system goes on-line. I have used
Interbase quite a lot, just not with EJBs, and it is totally free and open
source nowadays. I have no experience with MySQL, but as far as I have read on
this list, quite many people are fond of it, and it seems that the use of MySQL
is a question of once needs for transactions (which MySQL does not
support).
I am wondering if anyone is using the prepackaged Hypersonic
database in production... It has not given me any trouble during this
development project... yet... - I would feel MUCH better about using a 10+ years
old well-tested database like Interbase, and I simply do not know why more
people are not using it.
Any comments
anyone?
Randahl
-----Original
Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
Sent: 23. februar 2001 18:39
To:
Orion-Interest
Subject: Re: Win2k Pro. is messing up the DB
Hello
Randahl,
First of all, I appreciate your idea.
Yes, we came to the near
conclusion that it was not orion but it was postgresql.
To tell the truth, I
believe in orion but not very much so in postgresql.
As a matter of fact, we
are using a CVS version of PostgreSQL because
the released version of
postgresql does not yet support the right join sql statement.
To make matters
worse, the Linux JDBC driver was not working properly on the timestamp
field
before I made a modification on the driver. We were totally forgetting all about
this.
Our Windows developers have had no problems with ODBC drivers so far,
out of which
we can guess it is not the DB itself but it is the Linux JDBC
driver.
What are your thoughts?
Once again, thank you very
much.
Simon
----- Original Message
-----
From: Randahl Fink Isaksen
To: Orion-Interest
Sent: Friday,
February 23, 2001 1:07 AM
Subject: RE: Win2k Pro. is messing up the
DB
I know this is a wild guess, but just to make sure, I would of
course do a disk scan on that machine to make sure it is not a hardware problem
- these things do happen, I am afraid.
Another good thing would be to run
the application on a _different_ Win2K Pro. machine to make sure it is not just
something which is specific to only her single machine.
BTW, I would
doubt PostgreSQL more on Win2K than I would doubt Orion. Orion is a java
application, which gives it a pretty good chance of running in the same way on
different platforms. To the best of my knowledge PostgreSQL on Win2K is a port
of the code from another platform, and from reading articles at PostgreSQL's
web-site it seems it is not totally stable on Win2K. I have seen at least two
posts on this list where people recommends *not* using PostgreSQL from Win NT
based systems - not yet, anyway.
I have used Orion on Win2K with no problems
- but then again I do *not* use PostgreSQL....
Hope you find a
solution
Yours
Randahl
-----Original Message-----
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
Sent: 23. februar 2001 02:19
To:
Orion-Interest
Subject: Win2k Pro. is messing up the
DB
Hello,
I do not really know if this is because she's using
Window 2000 Professional.
All our employees use Windows 2000 Servers or
Linuxes or Solarises except for one person.
The exception is Windows 2000
Professional. The problem occurs only at her computer.
Once she updates a DB
record, it messes up another record. This does not
happen all the time, but
once in a blue moon. This is why I can't catch the problem in my code.
And I
do not think it is my code. I am using CMPs and orion 1.3.8 with
PostgreSQL.
I doubted postgresql and orion in the beginning, and now I
narrowed it down to orion because
it may be machine specific as I mentioned
earlier. Why does a DB server have to do with
a specific machine? Then what?
An App. Server which holds a session to a machine?
I am lost. Does anyone
have any clue? I really really hope it's my code.
I appreciate your
attention.
Simon