[jBoss-Dev] CVS update: jbossweb getting_startedJB2.htmpostgres.htm

Thu, 05 Oct 2000 12:06:51 -0700 

  User: mulder  
  Date: 00/10/05 12:10:07

  Modified:    .        getting_startedJB2.htm postgres.htm
  Log:
  Update the Postgres example to refer to the manual for MBean
  configuration.
  
  Revision  Changes    Path
  1.7       +1 -1      jbossweb/getting_startedJB2.htm
  
  Index: getting_startedJB2.htm
  ===================================================================
  RCS file: /products/cvs/ejboss/jbossweb/getting_startedJB2.htm,v
  retrieving revision 1.6
  retrieving revision 1.7
  diff -u -r1.6 -r1.7
  --- getting_startedJB2.htm    2000/10/02 14:22:52     1.6
  +++ getting_startedJB2.htm    2000/10/05 19:10:07     1.7
  @@ -67,7 +67,7 @@
                                                                                       
                         <p><a href="oraclecmp.htm"><font face="Myriad Web,Arial">CMP 
with ORACLE Howto</font></a></p>
                                                                                       
                         <p><a href="mssql.htm"><font face="Myriad Web,Arial">MS SQL 
Server (includes JDBC-ODBC) Howto</font></a></p>
                                                                                       
                         <p><a href="jbuilder.htm"><font face="Myriad Web,Arial">Run 
jBoss and debug EJBs in JBuilder's Debugger Howto</font></a></p>
  -                                                                                    
                         <p><a href="postgres.htm"><font face="Myriad Web,Arial">CMP 
with PostgreSQL MLET&nbsp;Howto</font></a></p>
  +                                                                                    
                         <p><a href="postgres.htm"><font face="Myriad Web,Arial">CMP 
with PostgreSQL Howto</font></a></p>
                                                                                       
                         <p><font face="Myriad Web,Arial"><a 
href="rmh_howto.html">RMH&nbsp;(run the examples) Howto</a></font></p>
                                                                                       
                         <p><a href="JMX.Connector.Howto.html"><font face="Myriad 
Web,Arial">JMX Connector&nbsp;Howto</font></a></p>
                                                                                       
                         <p></p>
  
  
  
  1.2       +79 -94    jbossweb/postgres.htm
  
  Index: postgres.htm
  ===================================================================
  RCS file: /products/cvs/ejboss/jbossweb/postgres.htm,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- postgres.htm      2000/09/01 23:53:44     1.1
  +++ postgres.htm      2000/10/05 19:10:07     1.2
  @@ -1,95 +1,80 @@
  -I use the following for PostgreSQL:<br>
  -<br>
  -In JBOSS_HOME/conf/jboss.conf:<br>
  -<br>
  -&lt;MLET CODE = &quot;org.jboss.jdbc.DataSourceImpl&quot;<br>
  -        ARCHIVE=&quot;jboss.jar,jdbc2_0-stdext.jar&quot; 
CODEBASE=&quot;../lib/ext/&quot;&gt;<br>
  -        &lt;ARG TYPE=&quot;java.lang.String&quot;<br>
  -                        
VALUE=&quot;jdbc:postgresql://&lt;host&gt;/&lt;database&gt;&quot;&gt;<br>
  -        &lt;ARG TYPE=&quot;java.lang.String&quot; 
VALUE=&quot;PostgreSQLPool&quot;&gt;<br>
  -        &lt;ARG TYPE=&quot;java.lang.String&quot; 
VALUE=&quot;postgresql.Driver&quot;&gt;<br>
  -        &lt;ARG TYPE=&quot;java.lang.String&quot; VALUE=&quot;&lt;user 
name&gt;&quot;&gt;<br>
  -        &lt;ARG TYPE=&quot;java.lang.String&quot; 
VALUE=&quot;&lt;password&gt;&quot;&gt;<br>
  -&lt;/MLET&gt;<br>
  -<br>
  -<br>
  -In jboss.properties:<br>
  -<br>
  -jdbc.drivers=postgresql.Driver<br>
  -<br>
  -In the jaws.xml of the deployed bean, the above-mentioned DataSource<br>
  -must be specified. The default PostgreSQL mappings, by the way, don't<br>
  -seem to work in my setup, so I've added them to the jaws.xml file, too:<br>
  -<br>
  -&lt;jaws&gt;<br>
  -        &lt;datasource&gt;PostgreSQLPool&lt;/datasource&gt;<br>
  -        &lt;type-mapping&gt;PostgreSQL&lt;/type-mapping&gt;<br>
  -<br>
  -        &lt;type-mappings&gt;<br>
  -                &lt;type-mapping&gt;<br>
  -                        &lt;name&gt;PostgreSQL&lt;/name&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.lang.Boolean&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;BIT&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.lang.Short&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;INTEGER&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;INTEGER&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.util.Date&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;DATE&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;DATE&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.lang.Double&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;DOUBLE&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;FLOAT8&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.lang.Character&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;CHAR&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;CHAR&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.lang.Object&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;BLOB&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;BLOB&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.sql.TimeStamp&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;TIMESTAMP&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;TIMESTAMP&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.lang.Integer&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;INTEGER&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;INTEGER&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.lang.Byte&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;TINYINT&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;TINYINT&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.lang.Float&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;FLOAT&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;FLOAT4&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.lang.String&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;VARCHAR&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;TEXT&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                        &lt;mapping&gt;<br>
  -                                
&lt;java-type&gt;java.lang.Long&lt;/java-type&gt;<br>
  -                                &lt;jdbc-type&gt;BIGINT&lt;/jdbc-type&gt;<br>
  -                                &lt;sql-type&gt;BIGINT&lt;/sql-type&gt;<br>
  -                        &lt;/mapping&gt;<br>
  -                &lt;/type-mapping&gt;<br>
  -        &lt;/type-mappings&gt;<br>
  +<p>Here's a sample <code>jaws.xml</code> file for Postgres.  In order
  +  to set up your data source, please refer to the Manual sections on
  +  <a HREF="manual/adv_config.html#datasources">Data Sources</a> or
  +  <a HREF="manual/adv_config.html#poolex">Data Source Examples</a>.
  +  The name of your database pool should match the
  +  <code>datasource</code> tag in <code>jboss.xml</code> (which is
  +  "PostgreSQLPool" in the example below).</p>
  +
  +<pre>
  +&lt;jaws&gt;
  +        &lt;datasource&gt;PostgreSQLPool&lt;/datasource&gt;
  +        &lt;type-mapping&gt;PostgreSQL&lt;/type-mapping&gt;
  +
  +        &lt;type-mappings&gt;
  +                &lt;type-mapping&gt;
  +                        &lt;name&gt;PostgreSQL&lt;/name&gt;
  +                        &lt;mapping&gt;
  +                                &lt;java-type&gt;java.lang.Boolean&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;BIT&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                &lt;java-type&gt;java.lang.Short&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;INTEGER&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;INTEGER&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                &lt;java-type&gt;java.util.Date&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;DATE&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;DATE&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                &lt;java-type&gt;java.lang.Double&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;DOUBLE&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;FLOAT8&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                
&lt;java-type&gt;java.lang.Character&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;CHAR&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;CHAR&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                &lt;java-type&gt;java.lang.Object&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;BLOB&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;BLOB&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                
&lt;java-type&gt;java.sql.TimeStamp&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;TIMESTAMP&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;TIMESTAMP&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                &lt;java-type&gt;java.lang.Integer&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;INTEGER&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;INTEGER&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                &lt;java-type&gt;java.lang.Byte&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;TINYINT&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;TINYINT&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                &lt;java-type&gt;java.lang.Float&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;FLOAT&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;FLOAT4&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                &lt;java-type&gt;java.lang.String&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;VARCHAR&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;TEXT&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                        &lt;mapping&gt;
  +                                &lt;java-type&gt;java.lang.Long&lt;/java-type&gt;
  +                                &lt;jdbc-type&gt;BIGINT&lt;/jdbc-type&gt;
  +                                &lt;sql-type&gt;BIGINT&lt;/sql-type&gt;
  +                        &lt;/mapping&gt;
  +                &lt;/type-mapping&gt;
  +        &lt;/type-mappings&gt;
   &lt;/jaws&gt;
  -<p></p>
  -<p>
  \ No newline at end of file
  +</pre>

Reply via email to