Re: Orion - Postgresql

[Alex 'Kazuma' Garbagnati]

I've searched for it, but I cannot find one.
How do I filled in the data-source.xml to connect to postgresql? fyi, I 
use postgresql7.0-1.2.jar.

This is the one I'm using, even if I'm not crasy and I don't allow orion to 
create the table for me...

database-scheme name=PostGreSQL
 not-null=not null
 null=null
 primary-key=primary key
 type-mapping type=java.lang.String name=varchar(255) /
 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

 best regards,
 Kazuma


Cos'e' il genio. E' fantasia intuizione, colpo d'occhio e velocita' 
d'esecuzione.
(Amici Miei)

---
Alessandro A. 'Kazuma' Garbagnati
http://www.kazuma.net/   ICQ UIN: 1600386
Mountain View, CA, 94043 - USA

Re: Orion - Postgresql

[Joseph B. Ottinger]

Well, class shouldn't be ???, that's for sure... you should leave the
class attribute to be the com.evermind.whatever.it.is as the default
value.

On Fri, 18 May 2001, Budi Prawira wrote:

 I've searched for it, but I cannot find one.
 
 How do I filled in the data-source.xml to connect to postgresql? fyi, I use
 postgresql7.0-1.2.jar.
 
 Are these correct?
   data-source
   class=???
   name=Postgresql
   location=jdbc/PostgresqlDS
   xa-location=jdbc/xa/PostgresqlXADS
   ejb-location=jdbc/PostgresqlDS
   connection-driver=org.postgresql.Driver
   username=username
   password=password
   url=jdbc:postgresql:mydb
   inactivity-timeout=30
   /
 
 thanks!
 Budi
 

---
Joseph B. Ottinger   [EMAIL PROTECTED]
http://adjacency.org/ IT Consultant

RE: Orion - Postgresql

[elephantwalker]

Title: Orion - Postgresql



There's a howto on www.orionsupport.com for 
postgre...

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Budi 
  PrawiraSent: Thursday, May 17, 2001 6:21 PMTo: 
  Orion-InterestSubject: Orion - Postgresql
  I've searched for it, but I cannot find one. 
  How do I filled in the data-source.xml to connect to 
  postgresql? fyi, I use postgresql7.0-1.2.jar. 
  Are these correct? 
   data-source  
   class="???" 
   
   name="Postgresql"  
   location="jdbc/PostgresqlDS" 
   
   xa-location="jdbc/xa/PostgresqlXADS" 
   
   ejb-location="jdbc/PostgresqlDS" 
   
   connection-driver="org.postgresql.Driver" 
   
   username="username" 
   
   password="password" 
   
   url="jdbc:postgresql:mydb" 
   
   inactivity-timeout="30" 
   / 
  thanks! Budi