Please Help Me, How to congfig Postgres DataSours on Orion?
Dear, I used Orion 1.3.8, Postgres 6.5,andits JDBC Driver jdbc6.5-1.2.jar. I'm config the Orion DataSours: data-source name="Postgres" class="postgresql.Driver" location="jdbc/javatest" pooled-location="jdbc/javatest" xa-location="jdbc/xa/javatest" ejb-location="jdbc/javatest" url="jdbc:postgresql://192.168.0.88/javatest" connection-driver="postgresql.Driver" username="postgres" password="" schema="./database-schemas/postgresql.xml"/ And copy the jdbc6.5-1.2.jar to Orion\Lib. But When I run Orion it's said: "Error initializing server: Unknown DataSource type: postgresql.Driver" I don't know how to config Postgres DataSours, and how to write the line Class="" and connection=""? and where can i get more info. of this? help me Please. Thank you! yoursUrey - Original Message - From: "Kays, Jeff" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Sent: Thursday, December 21, 2000 8:22 AM Subject: RE: Database behind entity beans? We're using Postgreslql with Linux. Seems to be working great, ask again in a couple of months when we're finished with our prototype. j -Original Message- From: Hegyi Tibor [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, December 20, 2000 4:20 AM To: Orion-Interest Subject: Database behind entity beans?Hi all, I just wonder what options we have for selecting the proper RDBMS/OODBMS to serve as persistent storage for our BMPs/CMPs or just for being accessed via JDBC. Oracle is the obvious choice, but might be rather expensive. I would like to hear some opinion on the databases you're using with Orion.Thanks, Tibor
Re: Please Help Me, How to congfig Postgres DataSours on Orion?
There is a problem with the jdbc postgresql documentation. Change your class name from postgresql.Driver to org.postgresql.Driver regards santosh s :) urey wrote: Dear, I used Orion 1.3.8, Postgres 6.5,and its JDBC Driver jdbc6.5-1.2.jar. I'm config the Orion DataSours: ß ålt;data-source ß ß name="Postgres" ß ß class="postgresql.Driver" ß ß location="jdbc/javatest" ß ß pooled-location="jdbc/javatest" ß ß xa-location="jdbc/xa/javatest" ß ß ejb-location="jdbc/javatest" ß ß url="jdbc:postgresql://192.168.0.88/javatest" ß ß connection-driver="postgresql.Driver" ß ß username="postgres" ß ß password="" ß ß schema="./database-schemas/postgresql.xml" /û/font And copy the jdbc6.5-1.2.jar to Orion\Lib. But When I run Orion it's said: ß"Error initializing server: Unknown DataSource type: postgresql.Driver" û/div I don't know how to config Postgres DataSours, and how to write the lineßClass="" and connection=""? and where can i get more info. of this?ß help me Please. Thank you! yoursUrey ß û/font û/div û/div - Original Message - From: "Kays, Jeff" mailto:[EMAIL PROTECTED][EMAIL PROTECTED] mailto:[EMAIL PROTECTED] To: "Orion-Interest" mailto:[EMAIL PROTECTED][EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Thursday, December 21, 2000 8:22 AM Subject: RE: Database behind entity beans? We're using Postgreslql with Linux. Seems to be working great, ask again in a couple of months when we're finished with our prototype. ßj -Original Message- From: Hegyi Tibor [ mailto:SMTP:[EMAIL PROTECTED]SMTP:[EMAIL PROTECTED] mailto:SMTP:[EMAIL PROTECTED]] Sent: Wednesday, December 20, 2000 4:20 AM To: Orion-Interest Subject: Database behind entity beans? Hi all, I just wonder what options we have for selecting the proper RDBMS/OODBMS to serve as persistent storage for our BMPs/CMPs or just for being accessed via JDBC. Oracle is the obvious choice, but might be rather expensive. I would like to hear some opinion on the databases you're using with Orion. Thanks, Tibor ß
RE: Please Help Me, How to congfig Postgres DataSours on Orion?
Easy, the driver class is org.postgresql.Driver - fix it and you're away. Mike -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ureySent: Wednesday, November 22, 2000 7:50 PMTo: Orion-InterestCc: Orion-InterestSubject: Please Help Me, How to congfig Postgres DataSours on Orion? Dear, I used Orion 1.3.8, Postgres 6.5,andits JDBC Driver jdbc6.5-1.2.jar. I'm config the Orion DataSours: data-source name="Postgres" class="postgresql.Driver" location="jdbc/javatest" pooled-location="jdbc/javatest" xa-location="jdbc/xa/javatest" ejb-location="jdbc/javatest" url="jdbc:postgresql://192.168.0.88/javatest" connection-driver="postgresql.Driver" username="postgres" password="" schema="./database-schemas/postgresql.xml"/ And copy the jdbc6.5-1.2.jar to Orion\Lib. But When I run Orion it's said: "Error initializing server: Unknown DataSource type: postgresql.Driver" I don't know how to config Postgres DataSours, and how to write the line Class="" and connection=""? and where can i get more info. of this? help me Please. Thank you! yoursUrey - Original Message - From: "Kays, Jeff" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Sent: Thursday, December 21, 2000 8:22 AM Subject: RE: Database behind entity beans? We're using Postgreslql with Linux. Seems to be working great, ask again in a couple of months when we're finished with our prototype. j -Original Message- From: Hegyi Tibor [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, December 20, 2000 4:20 AM To: Orion-Interest Subject: Database behind entity beans?Hi all, I just wonder what options we have for selecting the proper RDBMS/OODBMS to serve as persistent storage for our BMPs/CMPs or just for being accessed via JDBC. Oracle is the obvious choice, but might be rather expensive. I would like to hear some opinion on the databases you're using with Orion.Thanks, Tibor
Re: Please Help Me, How to congfig Postgres DataSours on Orion?
Not quite right, the class line is wrong - this should be the driver manager class, not the driver class i.e. class="com.evermind.sql.DriverManagerDataSource" Whether the driver is postgresql.Driver or org.postgresql.Driver depends on the driver version. Mike Cannon-Brookes wrote: Easy, the driver class is org.postgresql.Driver - fix it and you're away.Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of urey Sent: Wednesday, November 22, 2000 7:50 PM To: Orion-Interest Cc: Orion-Interest Subject: Please Help Me, How to congfig Postgres DataSours on Orion? Dear, I used Orion 1.3.8, Postgres 6.5,and its JDBC Driver jdbc6.5-1.2.jar.I'm config the Orion DataSours: data-source name="Postgres" class="postgresql.Driver" location="jdbc/javatest" pooled-location="jdbc/javatest" xa-location="jdbc/xa/javatest" ejb-location="jdbc/javatest" url="jdbc:postgresql://192.168.0.88/javatest" connection-driver="postgresql.Driver" username="postgres" password="" schema="./database-schemas/postgresql.xml" />And copy the jdbc6.5-1.2.jar to Orion\Lib.But When I run Orion it's said: "Error initializing server: Unknown DataSource type: postgresql.Driver" I don't know how to config Postgres DataSours, and how to write the line Class="" and connection=""? and where can i get more info. of this?help me Please.Thank you!yoursUrey - Original Message -From: "Kays, Jeff" [EMAIL PROTECTED]>To: "Orion-Interest" [EMAIL PROTECTED]>Sent: Thursday, December 21, 2000 8:22 AMSubject: RE: Database behind entity beans? > We're using Postgreslql with Linux. Seems to be working great, ask again in > a > couple of months when we're finished with our prototype. > > j > > > -Original Message- > > From: Hegyi Tibor [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, December 20, 2000 4:20 AM > > To: Orion-Interest > > Subject: Database behind entity beans? > > > > Hi all, > > > > I just wonder what options we have for selecting the proper RDBMS/OODBMS > > to serve as persistent storage for our BMPs/CMPs or just for being > > accessed via JDBC. Oracle is the obvious choice, but might be rather > > expensive. > > > > I would like to hear some opinion on the databases you're using with > > Orion. > > > > Thanks, > > > > Tibor > > > > > > > -- David Smith Software Development Manager e-Net Software Ltd [EMAIL PROTECTED]