On Thu, 01 March 2001, Scott Warren wrote:
Thanks a lot.
Its working fine.
regards,
sundarprasath J
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
> <TITLE>RE: [jBoss-User] Jboss with MSSQL</TITLE>
> </HEAD>
> <BODY>
>
> <P><FONT SIZE=2>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.</FONT></P>
>
> <P><FONT SIZE=2>This is the contents of a jboss.conf I have that works.</FONT>
> </P>
>
> <P><FONT SIZE=2><MLET CODE="org.jboss.jdbc.XADataSourceLoader"
>ARCHIVE="jboss.jar,JSQLConnect.jar,JSQLOptionalAPI.jar"
>CODEBASE="../lib/ext/"></FONT></P>
>
> <P><FONT SIZE=2> <ARG TYPE="java.lang.String"
>VALUE="ArtData"></FONT>
> <BR><FONT SIZE=2> <ARG TYPE="java.lang.String"
>VALUE="org.jboss.minerva.xa.XADataSourceImpl"></FONT>
> <BR><FONT SIZE=2></MLET></FONT>
> </P>
>
> <P><FONT SIZE=2>I had the same problem, I just could not remember what the solution
>was, I need your details to see the solution.</FONT>
> </P>
>
> <P><FONT SIZE=2>Hope this helps.</FONT>
> </P>
>
> <P><FONT SIZE=2>Regards</FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=2>Scott Warren</FONT>
> <BR><FONT SIZE=2>Lead Internet Technologies Developer</FONT>
> <BR><FONT
>SIZE=2>-----------------------------------------------------------------------------</FONT>
> <BR><FONT SIZE=2>Phone: +61 3 5222 6240</FONT>
> <BR><FONT SIZE=2>mailto: [EMAIL PROTECTED]</FONT>
> <BR><FONT SIZE=2>web: www.advancedresource.com.au</FONT>
> <BR><FONT
>SIZE=2>-----------------------------------------------------------------------------</FONT>
> </P>
> <BR>
> <BR>
>
> <P><FONT SIZE=2>-----Original Message-----</FONT>
> <BR><FONT SIZE=2>From: [EMAIL PROTECTED] [<A
>HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
> <BR><FONT SIZE=2>Sent: Thursday, 1 March 2001 4:53 PM</FONT>
> <BR><FONT SIZE=2>To: [EMAIL PROTECTED]</FONT>
> <BR><FONT SIZE=2>Subject: RE: [jBoss-User] Jboss with MSSQL</FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=2>On Thu, 01 March 2001, Scott Warren wrote:</FONT>
> </P>
>
> <P><FONT SIZE=2>Was there another exception thrown before the listed Exception</FONT>
> <BR><FONT SIZE=2>No there was no other exception before the listed exception.</FONT>
> </P>
>
> <P><FONT SIZE=2> and what does your jboss.conf, jboss.jcml files have on them
></FONT>
> </P>
>
> <P><FONT SIZE=2>Here is the jboss.conf configuration</FONT>
> <BR><FONT SIZE=2><MLET CODE="org.jboss.jdbc.XADataSourceLoader"
>ARCHIVE="jboss.jar,JSQLConnect.jar"
>CODEBASE="../lib/ext/"></FONT>
> <BR><FONT SIZE=2><ARG TYPE="java.lang.String"
>VALUE="SQLPool"></FONT>
> <BR><FONT SIZE=2><ARG TYPE="java.lang.String"
>VALUE="com.jnetdirect.jsql.JSQLXADataSource"></FONT>
> <BR><FONT SIZE=2></MLET></FONT>
> </P>
>
> <P><FONT SIZE=2>for jboss.jcml</FONT>
> </P>
>
> <P><FONT SIZE=2>here is the configuration</FONT>
> </P>
>
> <P><FONT SIZE=2> <mbean
>name="DefaultDomain:service=XADataSource,name=SQLPool"></FONT>
> <BR><FONT SIZE=2> <attribute
>name="Properties"></attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="URL">jdbc:JSQLConnect://192.168.1.145:1433/database=ecrm</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="GCMinIdleTime">1200000</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="JDBCUser">sa</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="MaxSize">0</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="Password"> </attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="GCEnabled">false</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="InvalidateOnError">false</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="TimestampUsed">false</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="Blocking">true</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="GCInterval">120000</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="IdleTimeout">1800000</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="IdleTimeoutEnabled">false</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="LoggingEnabled">false</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="MaxIdleTimeoutPercent">1.0</attribute></FONT>
> <BR><FONT SIZE=2> <attribute
>name="MinSize">0</attribute></FONT>
> <BR><FONT SIZE=2> </mbean></FONT>
> </P>
>
> <P><FONT SIZE=2>thanks for your help</FONT>
> </P>
>
> <P><FONT SIZE=2>regards,</FONT>
> <BR><FONT SIZE=2>sundarprasath J</FONT>
> </P>
> <BR>
> <BR>
> <BR>
> <BR>
> <BR>
> <BR>
> <BR>
>
> <P><FONT SIZE=2>I have used this combination on win2K, so I may be able to help,
>just need more info</FONT>
> <BR><FONT SIZE=2>Regards</FONT>
> <BR><FONT SIZE=2>Scott Warren</FONT>
> <BR><FONT SIZE=2>Lead Internet Technologies Developer</FONT>
> <BR><FONT SIZE=2>-----Original Message-----</FONT>
> <BR><FONT SIZE=2>From: [EMAIL PROTECTED] <A
>HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A></FONT>
> <BR><FONT SIZE=2>Sent: Thursday, 1 March 2001 4:11 PM</FONT>
> <BR><FONT SIZE=2> <BR><FONT SIZE=2>To:
>[EMAIL PROTECTED]</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>Subject: [jBoss-User] Jboss with
>MSSQL</FONT></FONT>
> <BR><FONT SIZE=2>> </P></FONT>
> <BR><FONT SIZE=2>> <BR></FONT>
> <BR><FONT SIZE=2>> </FONT>
> <BR><FONT SIZE=2>> <P><FONT SIZE=2>hi,</FONT></FONT>
> <BR><FONT SIZE=2>> </P></FONT>
> <BR><FONT SIZE=2>> </FONT>
> <BR><FONT SIZE=2>> <P><FONT SIZE=2>The environment i am using for
>jboss is</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>JBOSSFInal2.0&nbsp; on Win NT
>with MSSQL Server.</FONT></FONT>
> <BR><FONT SIZE=2>> </P></FONT>
> <BR><FONT SIZE=2>> </FONT>
> <BR><FONT SIZE=2>> <P><FONT SIZE=2>I am trying to connect to the
>database using JSQLConnect driver </FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>and also from </FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>Opta2000</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>but my attempts till now has been
>a failure</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>Here is the error that i am
>getting for</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>JSQLConnect.</FONT></FONT>
> <BR><FONT SIZE=2>> </P></FONT>
> <BR><FONT SIZE=2>> </FONT>
> <BR><FONT SIZE=2>> <P><FONT SIZE=2>[Default]
>javax.management.RuntimeMBeanException: RuntimeException thrown in</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>&nbsp;MBean's
>setter</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>com.sun.management.jmx.MBeanServerImpl.setAttribute(MBean</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT
>SIZE=2>erImpl.java:1417)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>com.sun.management.jmx.MBeanServerImpl.setAttribute(MBean</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT
>SIZE=2>erImpl.java:1331)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>org.jboss.configuration.ConfigurationService.load(Configu</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT
>SIZE=2>onService.java:139)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>java.lang.reflect.Method.invoke(Native Method)</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServer</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT SIZE=2>.java:1628)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServer</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT SIZE=2>.java:1523)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>org.jboss.Main.&lt;init&gt;(Main.java:143)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>org.jboss.Main$1.run(Main.java:87)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>java.security.AccessController.doPrivileged(Native Method</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>org.jboss.Main.main(Main.java:83)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>[Default]
>javax.management.RuntimeMBeanException: RuntimeException thrown in</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>&nbsp;MBean's
>setter</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>com.sun.management.jmx.MBeanServerImpl.setAttribute(MBean</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT
>SIZE=2>erImpl.java:1417)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>com.sun.management.jmx.MBeanServerImpl.setAttribute(MBean</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT
>SIZE=2>erImpl.java:1331)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>org.jboss.configuration.ConfigurationService.load(Configu</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT
>SIZE=2>onService.java:139)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>java.lang.reflect.Method.invoke(Native Method)</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServer</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT SIZE=2>.java:1628)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServer</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT SIZE=2>.java:1523)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>org.jboss.Main.&lt;init&gt;(Main.java:143)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>org.jboss.Main$1.run(Main.java:87)</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>java.security.AccessController.doPrivileged(Native Method</FONT></FONT></P>
>
> <P><FONT SIZE=2>> <BR><FONT
>SIZE=2>[Default]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
>org.jboss.Main.main(Main.java:83)</FONT></FONT>
> <BR><FONT SIZE=2>> </P></FONT>
> <BR><FONT SIZE=2>> <BR></FONT>
> <BR><FONT SIZE=2>> <BR></FONT>
> <BR><FONT SIZE=2>> </FONT>
> <BR><FONT SIZE=2>> <P><FONT SIZE=2>Chequemail.com - a free web based
>e-mail service that also pays!!!</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2><A HREF="<A
>HREF="http://www.chequemail.com" TARGET="_blank">http://www.chequemail.com</A>"
>TARGET="_blank"><A HREF="http://www.chequemail.com"
>TARGET="_blank">http://www.chequemail.com</A></A></FONT></FONT>
> <BR><FONT SIZE=2>> </P></FONT>
> <BR><FONT SIZE=2>> <BR></FONT>
> <BR><FONT SIZE=2>> </FONT>
> <BR><FONT SIZE=2>> <P><FONT SIZE=2>--</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT
>SIZE=2>--------------------------------------------------------------</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>To
>subscribe:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>[EMAIL PROTECTED]</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>To
>unsubscribe:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>[EMAIL PROTECTED]</FONT></FONT>
> <BR><FONT SIZE=2>> <BR><FONT SIZE=2>List
>Help?:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> [EMAIL PROTECTED]</FONT></FONT>
> <BR><FONT SIZE=2>> </P></FONT>
> <BR><FONT SIZE=2>> </FONT>
> <BR><FONT SIZE=2>> </BODY></FONT>
> <BR><FONT SIZE=2>> </HTML></FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=2>Chequemail.com - a free web based e-mail service that also
>pays!!!</FONT>
> <BR><FONT SIZE=2><A HREF="http://www.chequemail.com"
>TARGET="_blank">http://www.chequemail.com</A></FONT>
> </P>
>
> </BODY>
> </HTML>
Chequemail.com - a free web based e-mail service that also pays!!!
http://www.chequemail.com
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]