Re: [SignServer-develop] Problem with signserver-ce-3.7.0 and oracle database

[Markus K. <ma...@pr...>]

On 05/23/2016 11:50 AM, Tung, Tran wrote:
> 
> Please find the attachment for standalone.xml.

I couldn't find any obvious issue with your datasources section. My is
just slightly different. I post it here also for reference:

--- from standalone.xml ---

<datasource jndi-name="java:/SignServerOracleDS"
pool-name="signserveroracleds" enabled="true">

<connection-url>jdbc:oracle:thin:@192.168.123.123:1555:XE</connection-url>
    <driver>com.oracle</driver>
    <pool>
        <min-pool-size>3</min-pool-size>
        <max-pool-size>5</max-pool-size>
    </pool>
    <security>
        <user-name>signserver_trunk_eap6</user-name>
        <password>signserver</password>
    </security>
    <validation>
        <exception-sorter
class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/>
    </validation>
    <timeout>
        <blocking-timeout-millis>5000</blocking-timeout-millis>
        <idle-timeout-minutes>5</idle-timeout-minutes>
    </timeout>
</datasource>
<drivers>
    <driver name="h2" module="com.h2database.h2">

<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
    </driver>
    <driver name="com.mysql.jdbc.Driver" module="com.mysql">

<xa-datasource-class>com.mysql.jdbc.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
    </driver>
    <driver name="org.mariadb.jdbc.Driver" module="org.mariadb">

<xa-datasource-class>org.mariadb.jdbc.MySQLDataSource</xa-datasource-class>
    </driver>
    <driver name="com.oracle" module="com.oracle">
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    </driver>
</drivers>

---


Regards,
Markus
PrimeKey Solutions AB