Tim,
To begin with, I really appreciate your time.
I have one question for you, Tim.
Are you sure you are running CMP beans with THE config. files?
I still can't get it working.
I was able to get my BMP beans working with my original configs, but not with
CMP's.
Once again, thanks very much.
Seung,
Tim Drury wrote:
> Seung,
>
> Here is my data-sources.xml and postgres.xml. I'm using postgres 7.0
> and the 7.0.2 jdbc driver with great success.
>
> -tim
>
> <?xml version="1.0"?>
> <!DOCTYPE data-sources PUBLIC "Orion data-sources"
> "http://www.orionserver.com/dtds/data-sources.dtd">
>
> <data-sources>
> <!--
> An example DataSource that uses an ordinary JDBC-driver to
> create the connections,
> to install; set the proper URL to the db, specify the db-
> driver name and
> unrem the below section. This creates all the needed kinds
> of data-sources, transactional, pooled and EJB-aware
> sources.
> -->
> <data-source
> name="Default data-source"
> class="com.evermind.sql.ConnectionDataSource"
> location="jdbc/DefaultDS"
> pooled-location="jdbc/DefaultPooledDS"
> xa-location="jdbc/xa/DefaultXADS"
> ejb-location="jdbc/DefaultEJBDS"
> schema="database-schemas/postgresql.xml"
> url="jdbc:postgresql://localhost/ejb"
> connection-driver="org.postgresql.Driver"
> username="ejb"
> password="password"
> />
>
> </data-sources>
>
> <?xml version="1.0"?>
> <!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema"
> "http://www.orionserver.com/dtds/database-schemas.dtd">
>
> <database-scheme name="PostGreSQL" max-table-name-length="25" not-null="not
> null" null="" primary-key="primary key">
>
> <type-mapping type="java.lang.String" name="varchar" />
> <type-mapping type="java.lang.Integer" name="int8" />
> <type-mapping type="int" name="int4" />
> <type-mapping type="long" name="int8" />
> <type-mapping type="float" name="float4" />
> <type-mapping type="double" name="float8" />
> <type-mapping type="byte" name="int2" />
> <type-mapping type="char" name="char" />
> <type-mapping type="short" name="int2" />
> <type-mapping type="boolean" name="bool" />
> <type-mapping type="java.util.Date" name="timestamp" />
> <type-mapping type="java.io.Serializable" name="oid" />
> <type-mapping type="java.math.BigDecimal" name="decimal" />
>
> <disallowed-field name="parent" />
> <disallowed-field name="password" />
> <disallowed-field name="username" />
> <disallowed-field name="date" />
> <disallowed-field name="order" />
> <disallowed-field name="old" />
> <disallowed-field name="user" />
> </database-scheme>
>
> > -----Original Message-----
> > From: Seung Bang [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 01, 2000 1:10 PM
> > To: Orion-Interest
> > Subject: Re: Orion w/ postgresql
> >
> >
> > Mike & Guilherme:
> >
> > Thanks very much for your tips.
> > I tried as you guys instructed, and the same errors were produced.
> > My postgresql jdbc driver is now the brand new 7.0.2 driver, and
> > the '/usr/local/orion/config/database-schemas/postgresql.xml' file
> > has null="" section in place of null="null". And of course I tried
> > null="null" back in. All the trials yielded the same problem.
> > Please.... Anybody? Any clue???
> > Thanks very very much...
> >
> >
> > Seung,
> >
> >
> >
> >
