Re: BLOBs

 

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?

jdbc:pgsql://<host>:<port>/<database_name>?blob.type=oid

--

Andreas Joseph Krogh

CTO / Partner - Visena AS

Mobile: +47 909 56 963

andreas@visena.com

www.visena.com