The semicolon ; in the url looks unusual.
The datasource will be bound under java:/PersonEntity
david jencks
On 2002.10.08 07:43:00 -0400 Dhiraj Ramakrishnan wrote:
> Hi Guys ,
> For the past 2 days i have been trying to configure JBoss3.0.3
> to
> work with MSSQLServer2000. I have followed the following steps for
> configuring JBOSS with SQLServer2000,
>
> The following are the steps that i have done in
> JBoss3.0.3
> to get it working with SQLServer2000,
>
> a) Copied mssqlservice.xml to
> {$JBOSS-HOME}/server/all/deploy/
>
> b) Copied the 3 jar files given with the driver
> to
> {$JBOSS-HOME}/server/all/lib
>
> c) Changed the standardjbosscmp-jdbc.xml to the
> following (i am pasting only the part which i have changed.)
> <defaults>
>
> <datasource>java:/MSSQLDS</datasource>
> <datasource-mapping>MS
> SQLSERVER2000</datasource-mapping>
>
> d) Changed the standardjaws.xml (i am pasting
> only
> the part which i have changed.)
> <jaws>
>
> <datasource>java:/MSSQLDS</datasource>
> <type-mapping>MS
> SQLSERVER2000</type-mapping>
> e) Changed the mssql-service.xml to the following
> ,
> <mbean
> code="org.jboss.resource.connectionmanager.RARDeployment"
> name="jboss.jca:service=LocalTxDS,name=MSSQLDS">
>
> <attribute
> name="JndiName">PersonEntity</attribute>
>
> <attribute
> name="ManagedConnectionFactoryProperties">
> <properties>
> <config-property
> name="ConnectionURL" type="java.lang.String">
> jdbc:microsoft:sqlserver://localhost;DatabaseName=ContactInfo</config-proper
> ty>
> <config-property name="DriverClass"
> type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config
> - property>
> <!--set these only if you
> want
> only default logins, not through JAAS-->
> <config-property name="UserName"
> type="java.lang.String">sa</config-property>
> <config-property name="Password"
> type="java.lang.String">sa</config-property>
> </properties>
> </attribute>
> <depends
> optional-attribute-name="ManagedConnectionPool">
> <!--embedded mbean-->
> <mbean
> code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
> name="jboss.jca:service=LocalTxPool,name=MSSQLDS">
> <attribute
> name="MinSize">0</attribute>
> <attribute
> name="MaxSize">50</attribute>
> <attribute
> name="BlockingTimeoutMillis">5000</attribute>
> <attribute
> name="IdleTimeoutMinutes">15</attribute>-->
> <!--criteria indicates if Subject
> (from security domain) or app supplied
> parameters (such as from
> getConnection(user, pw)) are used to distinguish
> connections in the pool.
> Choices
> are
> ByContainerAndApplication
> (use
> both),
> ByContainer (use Subject),
> ByApplication (use app supplied
> params only),
> ByNothing (all connections are
> equivalent, usually if adapter supports
> reauthentication)
> <attribute
> name="Criteria">ByContainerAndApplication</attribute>
> </mbean>
>
> </depends>
>
>
> For the above line if i give use the following options it
> gives me the following error
>
> a) ByContainerAndApplication -
> org.jboss.util.NestedSQLException: Need non-null subject for subject/cri
> based pooling; - nested throwable: (javax.resource.ResourceException:
> b) ByApplication Or ByContainer - Could not
> create
> connection; - nested throwable: (java.sql.SQLException:
> [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.); -
> nested throwable:
>
>
>
> Could anybody please tell me how to fix this problem?
> Thank You very much
>
> Dhiraj Ramakrishnan
>
>
>
>
>
>
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
