RE: [jBoss-User] Jboss with MSSQL

Scott Warren Wed, 28 Feb 2001 22:11:06 -0800

Title: RE: [jBoss-User] Jboss with MSSQL

Yeah I think the problem is with the Data Source, try using the Minerva driver, I had the same problem and this is what I use.

This is the contents of a jboss.conf I have that works.

I had the same problem, I just could not remember what the solution was, I need your details to see the solution.

Hope this helps.

Regards

Scott Warren
Lead Internet Technologies Developer
-----------------------------------------------------------------------------
Phone: +61 3 5222 6240
mailto: [EMAIL PROTECTED]
web: www.advancedresource.com.au
-----------------------------------------------------------------------------

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 1 March 2001 4:53 PM
To: [EMAIL PROTECTED]
Subject: RE: [jBoss-User] Jboss with MSSQL

On Thu, 01 March 2001, Scott Warren wrote:

Was there another exception thrown before the listed Exception
No there was no other exception before the listed exception.

and what does your jboss.conf, jboss.jcml files have on them

Here is the jboss.conf configuration
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,JSQLConnect.jar" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="SQLPool">
<ARG TYPE="java.lang.String" VALUE="com.jnetdirect.jsql.JSQLXADataSource">
</MLET>

for jboss.jcml

here is the configuration

<mbean name="DefaultDomain:service=XADataSource,name=SQLPool">
 <attribute name="Properties"></attribute>
 <attribute name="URL">jdbc:JSQLConnect://192.168.1.145:1433/database=ecrm</attribute>
 <attribute name="GCMinIdleTime">1200000</attribute>
 <attribute name="JDBCUser">sa</attribute>
 <attribute name="MaxSize">0</attribute>
 <attribute name="Password"> </attribute>
 <attribute name="GCEnabled">false</attribute>
 <attribute name="InvalidateOnError">false</attribute>
 <attribute name="TimestampUsed">false</attribute>
 <attribute name="Blocking">true</attribute>
 <attribute name="GCInterval">120000</attribute>
 <attribute name="IdleTimeout">1800000</attribute>
 <attribute name="IdleTimeoutEnabled">false</attribute>
 <attribute name="LoggingEnabled">false</attribute>
 <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
 <attribute name="MinSize">0</attribute>
 </mbean>

thanks for your help

regards,
sundarprasath J

I have used this combination on win2K, so I may be able to help, just need more info
Regards
Scott Warren
Lead Internet Technologies Developer
-----Original Message-----
From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Sent: Thursday, 1 March 2001 4:11 PM
 To: [EMAIL PROTECTED]
> Subject: [jBoss-User] Jboss with MSSQL
> 
> 
>
> hi,
> 
>
> The environment i am using for jboss is
> JBOSSFInal2.0  on Win NT with MSSQL Server.
> 
>
> I am trying to connect to the database using JSQLConnect driver 
> and also from 
> Opta2000
> but my attempts till now has been a failure
> Here is the error that i am getting for
> JSQLConnect.
> 
>
> [Default] javax.management.RuntimeMBeanException: RuntimeException thrown in
>  MBean's setter
> [Default]       at com.sun.management.jmx.MBeanServerImpl.setAttribute(MBean

> erImpl.java:1417)
> [Default]       at com.sun.management.jmx.MBeanServerImpl.setAttribute(MBean

> erImpl.java:1331)
> [Default]       at org.jboss.configuration.ConfigurationService.load(Configu

> onService.java:139)
> [Default]       at java.lang.reflect.Method.invoke(Native Method)

> [Default]       at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServer

> .java:1628)
> [Default]       at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServer

> .java:1523)
> [Default]       at org.jboss.Main.<init>(Main.java:143)
> [Default]       at org.jboss.Main$1.run(Main.java:87)
> [Default]       at java.security.AccessController.doPrivileged(Native Method

> [Default]       at org.jboss.Main.main(Main.java:83)
> [Default] javax.management.RuntimeMBeanException: RuntimeException thrown in
>  MBean's setter
> [Default]       at com.sun.management.jmx.MBeanServerImpl.setAttribute(MBean

> erImpl.java:1417)
> [Default]       at com.sun.management.jmx.MBeanServerImpl.setAttribute(MBean

> erImpl.java:1331)
> [Default]       at org.jboss.configuration.ConfigurationService.load(Configu

> onService.java:139)
> [Default]       at java.lang.reflect.Method.invoke(Native Method)

> [Default]       at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServer

> .java:1628)
> [Default]       at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServer

> [Default]       at org.jboss.Main.main(Main.java:83)
> 
> 
> 
>
> Chequemail.com - a free web based e-mail service that also pays!!!
> <A HREF="http://www.chequemail.com" TARGET="_blank">http://www.chequemail.com</A>
> 
> 
>
> --
> --------------------------------------------------------------
> To subscribe:        [EMAIL PROTECTED]
> To unsubscribe:      [EMAIL PROTECTED]
> List Help?:          [EMAIL PROTECTED]
> 
>
> </BODY>
> </HTML>

Chequemail.com - a free web based e-mail service that also pays!!!
http://www.chequemail.com

RE: [jBoss-User] Jboss with MSSQL

Reply via email to