I try to configure MS SQL Server with I-Net jdbc driver, and i have tried
what Steve Kwee suggested. But when i run the bank test
i don't see any new tables in MS SQL Server. I think it uses the Hypersonic.
Please if anyone has tried something similar, or if anyone can explain the
structure
of the misc. config settings ?
1. I don't use odbc so step 1 is not necessary
2. I modified the jboss.properties file to
jdbc.drivers=org.hsql.jdbcDriver,jdbc.idbDriver,com.inet.tds.TdsDriver
3. i added the supposed MLET (but since i don't have a descr for what
exactly the ARG fields represent, i am not sure if they are ok)
<MLET CODE = "org.jboss.jdbc.DataSourceImpl"
ARCHIVE="jboss.jar,jdbc2_0-stdext.jar" CODEBASE="c:/Opta2000_trial">
<ARG TYPE="java.lang.String"
VALUE="jdbc:inetdae:e-commerce:1433?database=stratos">
<ARG TYPE="java.lang.String" VALUE="MS SQLSERVER">
/********** What's This ? ******************/
<ARG TYPE="java.lang.String" VALUE="com.inet.tds.TdsDriver">
/********** Driver class *********************/
<ARG TYPE="java.lang.String" VALUE="stratos">
/********** This seems the login **********/
<ARG TYPE="java.lang.String" VALUE="stratos">
/********** -//- passwd ******/
</MLET>
4. Is done (an i have rebuild the cvs version), but what datasource do i use
?
Here is the jaws.xml
<?xml version="1.0" encoding="UTF-8"?>
<jaws>
<type-mappings>
<type-mapping>
<name>MS SQLSERVER</name>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>SMALLINT</jdbc-type>
<sql-type>SMALLINT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>DECIMAL</jdbc-type>
<sql-type>DECIMAL(20)</sql-type>
</mapping>
<mapping>
<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(256)</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>IMAGE</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
<sql-type>TINYINT</sql-type>
</mapping>
<mapping>
<java-type>java.sql.TimeStamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
<jdbc-type>DATETIME</jdbc-type>
<sql-type>DATETIME</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
<sql-type>BIT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>FLOAT</jdbc-type>
<sql-type>FLOAT</sql-type>
</mapping>
</type-mapping>
</type-mappings>
<enterprise-beans>
<entity>
<ejb-name>Customer</ejb-name>
<table-name>Customer</table-name>
<create-table>true</create-table>
<remove-table>false</remove-table>
<tuned-updates>false</tuned-updates>
<cmp-field>
<field-name>id</field-name>
<column-name>id</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>name</field-name>
<column-name>name</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
</entity>
<entity>
<ejb-name>Account</ejb-name>
<table-name>Account</table-name>
<create-table>true</create-table>
<remove-table>false</remove-table>
<tuned-updates>false</tuned-updates>
<cmp-field>
<field-name>owner</field-name>
<column-name>owner</column-name>
<sql-type>ejb/Customer</sql-type>
<jdbc-type>REF</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>balance</field-name>
<column-name>balance</column-name>
<sql-type>REAL</sql-type>
<jdbc-type>REAL</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>id</field-name>
<column-name>id</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<finder>
<name>findLargeAccounts</name>
<query>balance > {0}</query>
<order>balance</order>
</finder>
</entity>
<datasource>MS SQLSERVER</datasource>
/***** What datasource should i place ? *********/
<type-mapping>MS SQLSERVER</type-mapping>
</enterprise-beans>
</jaws>
5. I have modified the jaws.xml in EJB to use
a) the MS SQLSERVER Type-Mapping with
<type-mapping>MS SQLSERVER</type-mapping>
b) your Datasource
<datasource>MS SQLSERVER</datasource>
Thanks
Stratis
> -----Original Message-----
> From: Steve Kwee [SMTP:[EMAIL PROTECTED]]
> Sent: On?oc, 27 Eioi?io 2000 11:20
> To: 'jBoss'
> Subject: AW: [jBoss-User] SQL Server
>
> At least, there is someone else, using MSSQL...
> Last night I put toghether this kind of readme on the topic.
> Works with a compiled version I took from the cvs a week ago.
>
> Using MS SQLServer with the JDBC-ODBC Bridge (included in JDK since 1.2.x)
> --------------------------------------------------------------------------
> Should also work for other ODBC Datasources
>
> 1. Install ODBC Datasource <my_dsn>
>
> 2. Add sun.jdbc.odbc.JdbcOdbcDriver to jboss.properties:
>
> jdbc.drivers=org.hsql.jdbcDriver,jdbc.idbDriver,sun.jdbc.odbc.JdbcOdbcDriv
> er
>
> 3. Add MLet for Datasource in jboss.conf
> <MLET CODE = "org.jboss.jdbc.DataSourceImpl" ARCHIVE="rt.jar"
> CODEBASE="../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="jdbc:odbc:my_dsn">
> <ARG TYPE="java.lang.String" VALUE="my_dsn">
> <ARG TYPE="java.lang.String" VALUE="sun.jdbc.odbc.JdbcOdbcDriver">
> <ARG TYPE="java.lang.String" VALUE="sa">
> <ARG TYPE="java.lang.String" VALUE="">
> </MLET>
>
> 4. Add Type-Mapping for MS SQLSERVER to the beans jaws.xml
> (was provided by Pedro Mota, maybe someone could add it to the
> cvs/defaultjaws.xml)
> <type-mapping>
> <name>MS SQLSERVER</name>
> <mapping>
> <java-type>java.lang.Integer</java-type>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>INTEGER</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Character</java-type>
> <jdbc-type>CHAR</jdbc-type>
> <sql-type>CHAR</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Short</java-type>
> <jdbc-type>SMALLINT</jdbc-type>
> <sql-type>SMALLINT</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Double</java-type>
> <jdbc-type>DOUBLE</jdbc-type>
> <sql-type>DOUBLE</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Long</java-type>
> <jdbc-type>DECIMAL</jdbc-type>
> <sql-type>DECIMAL(20)</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.String</java-type>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>VARCHAR(256)</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Object</java-type>
> <jdbc-type>IMAGE</jdbc-type>
> <sql-type>IMAGE</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Byte</java-type>
> <jdbc-type>TINYINT</jdbc-type>
> <sql-type>TINYINT</sql-type>
> </mapping>
> <mapping>
> <java-type>java.sql.TimeStamp</java-type>
> <jdbc-type>TIMESTAMP</jdbc-type>
> <sql-type>TIMESTAMP</sql-type>
> </mapping>
> <mapping>
> <java-type>java.util.Date</java-type>
> <jdbc-type>DATETIME</jdbc-type>
> <sql-type>DATETIME</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Boolean</java-type>
> <jdbc-type>BIT</jdbc-type>
> <sql-type>BIT</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Float</java-type>
> <jdbc-type>FLOAT</jdbc-type>
> <sql-type>FLOAT</sql-type>
> </mapping>
> </type-mapping>
>
> 5. Edit your beans jaws.xml and tell your enterprise-beans to use
> a) the MS SQLSERVER Type-Mapping with
> <type-mapping>MS SQLSERVER</type-mapping>
> b) your Datasource
> <datasource>my_dsn</datasource>
>
> This has been testet with the banktest and worked only "half".
> Jaws was able to init create the tables and to populate the table
> customers
> but failed to insert data into accounts.
>
>
>
> -----Ursprungliche Nachricht-----
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Gesendet: Dienstag, 27. Juni 2000 12:12
> An: [EMAIL PROTECTED]
> Betreff: [jBoss-User] SQL Server
>
>
> hello
>
> How I can configure jboss2.0 for using MS SQL Server?
>
> The container documentation says that I can use management console to
> manualy deploy/undeploy without stop the server. How can I do that in
> reality?
>
> Thank's you
>
> William
>
> ----------------------------------------------------------------
> Get your free email from AltaVista at http://altavista.iname.com
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
