User: vharcq
Date: 01/07/07 14:56:58
Modified: src/docs howtomssql.xml jbossdocs.xml jdbc-database.xml
Log:
Compliance 2.2 for MS SQL How To
Move MS SQL HowTo to JDBC Chapter
Add version required and Minerva Pool data source configuration for Inet Opta driver
Mention MS SQLSERVER2000 Mapping
Revision Changes Path
1.11 +65 -63 manual/src/docs/howtomssql.xml
Index: howtomssql.xml
===================================================================
RCS file: /cvsroot/jboss/manual/src/docs/howtomssql.xml,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- howtomssql.xml 2001/06/30 12:37:49 1.10
+++ howtomssql.xml 2001/07/07 21:56:57 1.11
@@ -116,6 +116,7 @@
<entry>Supplier</entry>
<entry>JDBC Type</entry>
<entry>Availability</entry>
+ <entry>Version</entry>
</row>
</thead>
<tbody>
@@ -126,6 +127,7 @@
</entry>
<entry>Type 4</entry>
<entry>Free/Open Source</entry>
+ <entry></entry>
</row>
<row>
<entry>Merant DataDirect Connect
JDBC</entry>
@@ -134,6 +136,7 @@
</entry>
<entry>Type 4</entry>
<entry>Commercial</entry>
+ <entry></entry>
</row>
<row>
<entry>i-net Opta JDBC</entry>
@@ -142,6 +145,7 @@
</entry>
<entry>Type 4</entry>
<entry>Commercial</entry>
+ <entry>4.10FIX</entry>
</row>
<row>
<entry>WebLogic jDriver for Microsoft
SQL Server</entry>
@@ -150,6 +154,7 @@
</entry>
<entry>Type 4</entry>
<entry>Commercial</entry>
+ <entry></entry>
</row>
<row>
<entry>Atinav aveConnect JDBC</entry>
@@ -158,6 +163,7 @@
</entry>
<entry>Type 4</entry>
<entry>Commercial</entry>
+ <entry></entry>
</row>
<row>
<entry>Sun JDBC-ODBC
Bridge<superscript>*</superscript>
@@ -167,6 +173,7 @@
</entry>
<entry>Type 4</entry>
<entry>Free</entry>
+ <entry></entry>
</row>
</tbody>
</tgroup>
@@ -201,6 +208,18 @@
</para>
</section>
<section>
+ <title>Installing the FreeTDS driver</title>
+ <para>
+ Download FreeTDS on http://www.freetds.org. You
should take the snapshot named <filename>freetds_jdbc.snapshot.jar</filename>.
+ Copy it to <filename>%JBOSS_HOME%/lib/ext</filename>.
+ </para>
+ <para>
+ To use the Sun JDBC-ODBC bridge with JBoss and MS SQL
Server you need to create an ODBC datasource that
+ references your MS SQL Server database. For this
tutorial it will be assumed that a datasource named
+ <replaceable>jboss_odbc</replaceable> has been created
that points to an MS SQL Server database.
+ </para>
+ </section>
+ <section>
<title>Installing the Merant DataDirect Connect JDBC
driver</title>
<para>
According to the blurb on Merant's site:
@@ -343,6 +362,20 @@
</listitem>
<listitem>
<para>
+ Adding the FreeTDS driver to the JBoss
JDBC driver list
+ </para>
+ <informalexample>
+ <programlisting>
+<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
+ <attribute name="<replaceable>Drivers</replaceable>">
+ org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,<replaceable>com.internetcds.jdbc.tds.Driver</replaceable>
+ </attribute>
+</mbean>
+ </programlisting>
+ </informalexample>
+ </listitem>
+ <listitem>
+ <para>
Adding the Merant DataDirect Connect
JDBC driver to the JBoss JDBC driver list
</para>
<informalexample>
@@ -415,6 +448,7 @@
<attribute
name="URL">jdbc:odbc:<replaceable>jboss_odbc</replaceable></attribute>
<attribute
name="JDBCUser"><replaceable>dbusername</replaceable></attribute>
<attribute
name="Password"><replaceable>dbpassword</replaceable></attribute>
+etc...
</mbean>
</programlisting>
</informalexample>
@@ -432,25 +466,14 @@
<attribute
name="Properties">DatabaseName=<replaceable>DatabaseName</replaceable></attribute>
<attribute
name="JDBCUser"><replaceable>dbusername</replaceable></attribute>
<attribute
name="Password"><replaceable>dbpassword</replaceable></attribute>
- <attribute name="MinSize">0</attribute>
- <attribute name="MaxSize">10</attribute>
- <attribute name="GCEnabled">false</attribute>
- <attribute name="GCMinIdleTime">1200000</attribute>
- <attribute name="GCInterval">120000</attribute>
- <attribute name="InvalidateOnError">false</attribute>
- <attribute name="TimestampUsed">false</attribute>
- <attribute name="Blocking">true</attribute>
- <attribute name="LoggingEnabled">false</attribute>
- <attribute name="IdleTimeoutEnabled">false</attribute>
- <attribute name="IdleTimeout">1800000</attribute>
- <attribute
name="MaxIdleTimeoutPercent">1.0</attribute>
+etc...
</mbean>
</programlisting>
</informalexample>
</listitem>
<listitem>
<para>
- Connection pool MBEAN declaration for
i-net OPTA 2000 JDBC driver
+ Connection pool MBEAN declaration for
i-net OPTA 2000 JDBC driver using INET DataSource
</para>
<informalexample>
<programlisting>
@@ -459,19 +482,25 @@
<attribute
name="PoolName"><replaceable>SQLServerPool</replaceable></attribute>
<attribute
name="Properties">host=<replaceable>ServerName</replaceable>;
database=<replaceable>DatabaseName</replaceable></attribute>
<attribute
name="JDBCUser"><replaceable>dbusername</replaceable></attribute>
+ <attribute
name="Password"><replaceable>dbpassword</replaceable></attribute>
+etc...
+</mbean>
+ </programlisting>
+ </informalexample>
+ </listitem>
+ <listitem>
+ <para>
+ Connection pool MBEAN declaration for
i-net OPTA 2000 JDBC driver using JBoss DataSource
+ </para>
+ <informalexample>
+ <programlisting>
+<mbean code="<replaceable>org.jboss.jdbc.XADataSourceLoader</replaceable>"
name="DefaultDomain:service=XADataSource,name=<replaceable>SQLServerPool</replaceable>">
+ <attribute
name="DataSourceClass"><replaceable>org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</replaceable></attribute>
+ <attribute
name="PoolName"><replaceable>SQLServerPool</replaceable></attribute>
+ <attribute
name="URL">jdbc:inetdae7:<replaceable>HostName</replaceable></attribute>
+ <attribute
name="JDBCUser"><replaceable>dbusername</replaceable></attribute>
<attribute
name="Password"><replaceable>dbpassword</replaceable></attribute>
- <attribute name="MinSize">0</attribute>
- <attribute name="MaxSize">10</attribute>
- <attribute name="GCEnabled">false</attribute>
- <attribute name="GCMinIdleTime">1200000</attribute>
- <attribute name="GCInterval">120000</attribute>
- <attribute name="InvalidateOnError">false</attribute>
- <attribute name="TimestampUsed">false</attribute>
- <attribute name="Blocking">true</attribute>
- <attribute name="LoggingEnabled">false</attribute>
- <attribute name="IdleTimeoutEnabled">false</attribute>
- <attribute name="IdleTimeout">1800000</attribute>
- <attribute
name="MaxIdleTimeoutPercent">1.0</attribute>
+etc...
</mbean>
</programlisting>
</informalexample>
@@ -487,18 +516,7 @@
<attribute
name="PoolName"><replaceable>SQLServerPool</replaceable></attribute>
<attribute
name="URL">jdbc:weblogic:mssqlserver4:<replaceable>DatabaseName</replaceable>@<replaceable>ServerName</replaceable>:<replaceable>1433</replaceable></attribute>
<attribute
name="Properties">user=<replaceable>dbusername</replaceable>;
password=<replaceable>dbpassword</replaceable></attribute>
- <attribute name="MinSize">4</attribute>
- <attribute name="MaxSize">10</attribute>
- <attribute name="GCEnabled">false</attribute>
- <attribute name="GCMinIdleTime">1200000</attribute>
- <attribute name="GCInterval">120000</attribute>
- <attribute name="InvalidateOnError">false</attribute>
- <attribute name="TimestampUsed">false</attribute>
- <attribute name="Blocking">true</attribute>
- <attribute name="LoggingEnabled">false</attribute>
- <attribute name="IdleTimeoutEnabled">false</attribute>
- <attribute name="IdleTimeout">1800000</attribute>
- <attribute
name="MaxIdleTimeoutPercent">1.0</attribute>
+etc...
</mbean>
</programlisting>
</informalexample>
@@ -651,7 +669,7 @@
</para>
<informalexample>
<programlisting>
-<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,Opta200.jar"
CODEBASE="../lib/ext/">
+<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,Opta2000.jar"
CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String"
VALUE="<replaceable>SQLServerPool</replaceable>">
<ARG TYPE="java.lang.String"
VALUE="com.inet.tds.XDataSource">
</MLET>
@@ -682,6 +700,7 @@
<attribute
name="URL">jdbc:odbc:<replaceable>jboss_odbc</replaceable></attribute>
<attribute
name="JDBCUser"><replaceable>dbusername</replaceable></attribute>
<attribute
name="Password"><replaceable>dbpassword</replaceable></attribute>
+etc...
</mbean>
</programlisting>
</informalexample>
@@ -697,18 +716,7 @@
<attribute
name="Properties">DatabaseName=<replaceable>DatabaseName</replaceable></attribute>
<attribute
name="JDBCUser"><replaceable>dbusername</replaceable></attribute>
<attribute
name="Password"><replaceable>dbpassword</replaceable></attribute>
- <attribute name="MinSize">0</attribute>
- <attribute name="MaxSize">10</attribute>
- <attribute name="GCEnabled">false</attribute>
- <attribute name="GCMinIdleTime">1200000</attribute>
- <attribute name="GCInterval">120000</attribute>
- <attribute name="InvalidateOnError">false</attribute>
- <attribute name="TimestampUsed">false</attribute>
- <attribute name="Blocking">true</attribute>
- <attribute name="LoggingEnabled">false</attribute>
- <attribute name="IdleTimeoutEnabled">false</attribute>
- <attribute name="IdleTimeout">1800000</attribute>
- <attribute
name="MaxIdleTimeoutPercent">1.0</attribute>
+etc...
</mbean>
</programlisting>
</informalexample>
@@ -723,18 +731,7 @@
<attribute
name="Properties">host=<replaceable>ServerName</replaceable>;
database=<replaceable>DatabaseName</replaceable></attribute>
<attribute
name="JDBCUser"><replaceable>dbusername</replaceable></attribute>
<attribute
name="Password"><replaceable>dbpassword</replaceable></attribute>
- <attribute name="MinSize">0</attribute>
- <attribute name="MaxSize">10</attribute>
- <attribute name="GCEnabled">false</attribute>
- <attribute name="GCMinIdleTime">1200000</attribute>
- <attribute name="GCInterval">120000</attribute>
- <attribute name="InvalidateOnError">false</attribute>
- <attribute name="TimestampUsed">false</attribute>
- <attribute name="Blocking">true</attribute>
- <attribute name="LoggingEnabled">false</attribute>
- <attribute name="IdleTimeoutEnabled">false</attribute>
- <attribute name="IdleTimeout">1800000</attribute>
- <attribute
name="MaxIdleTimeoutPercent">1.0</attribute>
+etc...
</mbean>
</programlisting>
</informalexample>
@@ -809,9 +806,14 @@
<jaws>
]]>
<datasource><replaceable>java:/SQLServerPool</replaceable></datasource>
- <type-mapping><replaceable>MS
SQLSERVER</replaceable></type-mapping>
+ <type-mapping>MS SQLSERVER</type-mapping>
</programlisting>
</informalexample>
+ </listitem>
+ <listitem>
+ <para>
+ Note that MS SQLSERVER is for all version except
Microsoft SQL Server 2000 for which MS SQLSERVER2000 has to be used.
+ </para>
</listitem>
</orderedlist>
<para>
1.20 +12 -2 manual/src/docs/jbossdocs.xml
Index: jbossdocs.xml
===================================================================
RCS file: /cvsroot/jboss/manual/src/docs/jbossdocs.xml,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- jbossdocs.xml 2001/07/07 19:25:16 1.19
+++ jbossdocs.xml 2001/07/07 21:56:57 1.20
@@ -6,6 +6,7 @@
<!ENTITY customizingjaws.xml SYSTEM "customizingjaws.xml">
<!ENTITY advconfig.xml SYSTEM "advconfig.xml">
<!ENTITY jdbc-database.xml SYSTEM "jdbc-database.xml">
+ <!ENTITY howtomssql.xml SYSTEM "howtomssql.xml">
<!ENTITY designnotes.xml SYSTEM "designnotes.xml">
<!ENTITY production.xml SYSTEM "production.xml">
<!ENTITY howtotomcat.xml SYSTEM "howtotomcat.xml">
@@ -25,7 +26,6 @@
<!ENTITY howto_socketfactories.xml SYSTEM "howto_socketfactories.xml">
<!ENTITY howtojaxp.xml SYSTEM "howtojaxp.xml">
<!ENTITY howtojpda.xml SYSTEM "howtojpda.xml">
- <!ENTITY howtomssql.xml SYSTEM "howtomssql.xml">
<!ENTITY howtojetty.xml SYSTEM "howtojetty.xml">
<!ENTITY howtoverifier.xml SYSTEM "howtoverifier.xml">
<!ENTITY howtombeans.xml SYSTEM "howtombeans.xml">
@@ -47,7 +47,18 @@
&preface.xml;
&jbossintro.xml;
&basicconfiguration.xml;
+<chapter id="jdbc">
+ <title>JDBC</title>
+ <para>
+ <author>
+ <firstname>Aaron</firstname>
+ <surname>Mulder</surname>
+ </author>
+ <email>[EMAIL PROTECTED]</email>
+ </para>
&jdbc-database.xml;
+&howtomssql.xml;
+</chapter>
&cmp.xml;
&customizingjaws.xml;
&advconfig.xml;
@@ -59,7 +70,6 @@
<title>Howto</title>
&howtotomcat.xml;
&howtojetty.xml;
-&howtomssql.xml;
&howtormhexamples.xml;
&howtombeans.xml;
&howtojmx.xml;
1.8 +1 -14 manual/src/docs/jdbc-database.xml
Index: jdbc-database.xml
===================================================================
RCS file: /cvsroot/jboss/manual/src/docs/jdbc-database.xml,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- jdbc-database.xml 2001/06/09 01:15:32 1.7
+++ jdbc-database.xml 2001/07/07 21:56:57 1.8
@@ -1,16 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-<chapter id="jdbc">
- <title>JDBC</title>
- <para>
- <author>
- <firstname>Aaron</firstname>
- <surname>Mulder</surname>
- </author>
- <email>[EMAIL PROTECTED]</email>
- </para>
-
-
-
<section>
<title>Introduction</title>
<section>
@@ -802,5 +790,4 @@
</listitem>
</itemizedlist>
<para>Note that driver installation instructions are in <xref
linkend ="installing-jdbc-driver"/></para>
- </section>
-</chapter>
+ </section>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
