agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-sql@postgresql.org
Subject: Re: BLOBs
Date: Mon, 11 Jan 2016 18:48:17 +0100 (CET)
Message-ID: <VisenaEmail.16.33738fffabc53422.15231ca9847@tc7-visena> (raw)
In-Reply-To: <2023667230.3407381.1452526670272.JavaMail.yahoo@mail.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

På mandag 11. januar 2016 kl. 16:37:50, skrev Eugene Yin <eugeneymail@ymail.com 
<mailto:eugeneymail@ymail.com>>:
 
QUOTE:
 
Maven-config:
<properties> <version.pgjdbc-ng>0.6</version.pgjdbc-ng> </properties> 
<dependency> <groupId>com.impossibl.pgjdbc-ng</groupId> <artifactId>pgjdbc-ng</
artifactId> <version>${version.pgjdbc-ng}</version> <classifier>complete</
classifier> </dependency>  
 
I do not use Maven.  
 
I use web.xml and standalone-ha.xml of JBoss AS 7.1.1 to configure the JDBC, 
such as
 
 
[web.xml]
 
<resource-ref>
     <description>Resource reference to my database</description>
    <res-ref-name>jdbc/web</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Application</res-auth> 
    <res-sharing-scope>Shareable</res-sharing-scope>
 </resource-ref>
 
    
[standalone-ha.xml]
 
 <datasource jta="false" jndi-name="java:/jdbc/web" pool-name="OracleDS" 
enabled="true" use-ccm="false">
                    
<connection-url>jdbc:oracle:thin:@192.168.1.20:1521:deepy</connection-url>
                    <driver-class>oracle.jdbc.OracleDriver</driver-class>
                    <driver>OracleJDBCDriver</driver>
                    <security>
                        <security-domain>mysecuritydomain</security-domain>
                    </security>
                    <validation>
                        <validate-on-match>false</validate-on-match>
                        <background-validation>false</background-validation>
                    </validation>
                    <statement>
                        
<share-prepared-statements>false</share-prepared-statements>
                    </statement>
                </datasource>

 
 
 
What corresponding changes I need to make to use the Postgres?


 
Using Maven is only for getting the right deps in place for your app, it has 
nothing to do with configuration.
 
The URL should be on the form: 
jdbc:pgsql://<host>:<port>/<database_name>?blob.type=oid 
Other parameters are available here: http://impossibl.github.io/pgjdbc-ng/
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com;
 <https://www.visena.com;


 

view thread (20+ messages)  latest in thread

Message-ID: <VisenaEmail.16.33738fffabc53422.15231ca9847@tc7-visena>
Permalink:  ../VisenaEmail.16.33738fffabc53422.15231ca9847@tc7-visena/
Also on:    postgresql.org/message-id/VisenaEmail.16.33738fffabc53422.15231ca9847@tc7-visena

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: andreas@visena.com
  Subject: Re: BLOBs
  In-Reply-To: <VisenaEmail.16.33738fffabc53422.15231ca9847@tc7-visena>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox