Re: BLOBs

På mandag 11. januar 2016 kl. 16:37:50, skrev Eugene Yin <eugeneymail(at)ymail(dot)com
<mailto:eugeneymail(at)ymail(dot)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(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>