Hi,
I'm not sure about JBoss's config, but for MS SQL Server JDBC, the config
should look like the following:
driver=com.inet.tds.TdsDriver
url=jdbc:inetdae:localhost:1433?database=pubs
hope this help!
>From: ARAVIAS EFSTRATIOS <[EMAIL PROTECTED]>
>Reply-To: "jBoss" <[EMAIL PROTECTED]>
>To: jBoss <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: RE: [jBoss-User] SQL Server with jdbc, help !
>Date: Mon, 3 Jul 2000 19:09:36 +0300
>
>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]
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
