third-party products

Resin's support for third-party libraries and packages is primarily documented at http://wiki.caucho.com. This section includes links to the most popular packages.

Common

Eclipse

IntelliJ

Databases

hsqldb

Informix

Interbase

MySQL Connector/J

Oracle

PostgreSQL

SQL Server

Sybase

Groovy

Hibernate

IDE

Common

Because Resin will detect and reload web-apps automatically, you can configure a Resin web-app to point directly to your IDE's build space. When you build the project in the IDE, Resin will automatically pick up the changes without any need for a deploy step.

resin.conf for IDE

<resin xmlns="http://caucho.com/ns/resin">
  <cluster id="">
    <server id="">
      <http port="8080"/>
    </server>

    <host id="">

      <web-app id="/test" root-directory="/home/ferg/ws/test/build"/>

    </host>
  </cluster>
</resin>

Eclipse

See http://wiki.caucho.com/Eclipse

IntelliJ

See http://wiki.caucho.com/IntelliJ

Databases

DB2

See http://wiki.caucho.com/Db2

hsqldb

"hsqldb is a relational database engine written in Java. It offers a small (less than 160k), fast database engine which offers both in memory and disk based tables."

Informix

META-INF/resin-web.xml - non-XA

<web-app xmlns="http://caucho.com/ns/resin">

  <database>
    <name>jdbc/informix</name>
    <driver>
      <type>com.informix.jdbcx.IfxConnectionPoolDataSource</type>
      <url>jdbc:informix-sqli://123.45.67.89:1533/dbname</url>
      <init-param param-name="INFORMIXSERVER" param-value="myserver"/>
      <user>username</user>
      <password>password</password>
    </driver>
  </database>

</web-app>

META-INF/resin-web.xml - XA

<web-app xmlns="http://caucho.com/ns/resin">

  <database>
    <name>jdbc/informix-xa</name>
    <xa>true</xa>
    <driver type="com.informix.jdbcx.IfxXADataSource">
      <url>jdbc:informix-sqli://123.45.67.89:1533/dbname</url>
      <init-param param-name="INFORMIXSERVER" param-value="myserver"/>
      <user>username</user>
      <password>password</password>
    </driver>
    ...
  </database>

</web-app>

Interbase

See http://wiki.caucho.com/Interbase

MySQL Connector/J

See http://wiki.caucho.com/Mysql for more information

META-INF/resin-web.xml

<web-app xmlns="http://caucho.com/ns/resin">

  <database>
    <name>jdbc/mysql</name>
      <driver>
      <type>com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource</type>
      <url>jdbc:mysql://localhost:3306/dbname</url>
      <user>username</user>
      <password>password</password>
   </driver>
  </database>

</web-app>

Oracle

META-INF/resin-web.xml Oracle JDBC configuration - non-XA

<web-app xmlns="http://caucho.com/ns/resin">

  <database>
    <name>jdbc/oracle</name>
    <driver>
      <type>oracle.jdbc.pool.OracleConnectionPoolDataSource</type>
      <url>jdbc:oracle:thin:@localhost:1521:dbname</url>
      <user>username</user>
     <password>password</password>
    </driver>
  </database>

</web-app>

Note, the XADataSource is only needed for distributed transactions. If your transactions only include the single data source, the OracleConnectionPoolDataSource will be more efficient.

META-INF/resin-web.xml Oracle XADataSource JDBC configuration

<web-app xmlns="http://caucho.com/ns/resin">

  <database>
    <jndi-name>jdbc/oracle-xa</jndi-name>
    <xa>true</xa>
    <driver>
      <type>oracle.jdbc.xa.client.OracleXADataSource</type>
      <url>jdbc:oracle:thin:@localhost:1521:dbname</url>
      <user>username</user>
      <password>password</password>
    </driver>
    ...
  </database>

</web-app>

PostgreSQL

META-INF/resin-web.xml

<web-app xmlns="http://caucho.com/ns/resin">

  <database>
    <name>jdbc/name</name>
    <driver>
      <type>org.postgresql.Driver</type>
      <url>jdbc:postgresql://127.0.0.1:5432/dbname</url>
      <user>username</user>
      <password>password</password>
    </driver>
  </database>

</web-app>

SQL Server

See http://wiki.caucho.com/SQLServer

WEB-INF/resin-web.xml

<web-app xmlns="http://caucho.com/ns/resin">

   <database>
     <name>jdbc/sqlserver</name>
     <driver type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource">
       <serverName>csdevsqla01.office.foo</serverName>
       <portNumber>1433</portNumber>
       <databaseName>Reports</databaseName>
       <user>XXX</user>
       <password>YYY</password>
       <selectMethod>cursor</selectMethod>
     </driver>
     <xa>true</xa>
  </database>

</web-app>

Sybase

See http://wiki.caucho.com/Sybase

WEB-INF/resin-web.xml

<web-app xmlns="http://caucho.com/ns/resin">

  <database>
    <name>jdbc/sybase</name>
    <driver type="com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource">
      <network-protocol>Tds</network-protocol>
      <port-number>5000</port-number>
      <server-name>myhost</server-name>
      <database-name>mydb</database-name>
      <user>XXX</user>
      <password>YYY</password>
    </driver>
  </database>

</web-app>

Groovy

Groovy information is available at http://wiki.caucho.com/Groovy

Hibernate

Hibernate information is available at http://wiki.caucho.com/Hibernate