From: Vladimir B. <vla...@xi...> - 2001-04-04 21:13:29
|
CC-ing jboss-user for archives. Kunle would you please verify doco for inet mssql driver with the context from the discussion below. vladimir Claudio Pi wrote: > Ok, now it worked, it seems to me that it was the URL as you said before > > Thanks a lot, > > Claudio. > > -----Mensaje original----- > De: Vladimir Blagojevic [mailto:vl...@xi...] > Enviado el: Wednesday, April 04, 2001 5:03 PM > Para: Claudio Pi > Asunto: RE: [JBoss-user] RV: Should I consider Jboss for a new project ? > > Claudio, > > Try specifying URL for inet driver too. I'll contact the doc writer of > this document. Maybe he just missed this detail of specifying URL for > inet driver. > > Cheers, > Vlada > > On Wed, 4 Apr 2001, Claudio Pi wrote: > > > Ok, I am downloading the merant driver and I'll try again. > > But shouldn't JBoss work with any JDBC 2.0 driver for SQLServer ? > > > > -----Mensaje original----- > > De: Vladimir Blagojevic [mailto:vl...@xi...] > > Enviado el: Wednesday, April 04, 2001 4:38 PM > > Para: Claudio Pi > > Asunto: RE: [JBoss-user] RV: Should I consider Jboss for a new project ? > > > > > > Yes true, > > > > That is for inet driver , but merant example shows URL attribute. I am > > convinced that this is the problem, I am looking into code with debugger. > > The code that I am looking into asks for URL attribute. Do try merant > > with attribute for example: > > > > <attribute name="URL">jdbc:sqlserver://servername:1433</attribute> > > > > of course with your database here > > > > Try it, > > Vlada > > > > On Wed, 4 Apr 2001, Claudio Pi wrote: > > > > > But that is almost the same documentation that I read at > > > http://www.jboss.org/documentation/mssql.htm, > > > > > > in fact I just enter to the URL that you sent me and there it says: > > > > > > Connection pool MBEAN declaration for i-net OPTA 2000 JDBC driver > > > > > > <mbean code="org.jboss.jdbc.XADataSourceLoader" > > > name="DefaultDomain:service=XADataSource,name=SQLServerPool"> > > > <attribute > name="DataSourceClass">com.inet.tds.XDataSource</attribute> > > > <attribute name="PoolName">SQLServerPool</attribute> > > > <attribute name="Properties">host=ServerName; > > > database=DatabaseName</attribute> > > > <attribute name="JDBCUser">dbusername</attribute> > > > <attribute name="Password">dbpassword</attribute> > > > <attribute name="MinSize">0</attribute> > > > <attribute name="MaxSize">10</attribute> > > > <attribute name="GCEnabled">false</attribute> > > > <attribute name="GCMinIdleTime">1200000</attribute> > > > <attribute name="GCInterval">120000</attribute> > > > <attribute name="InvalidateOnError">false</attribute> > > > <attribute name="TimestampUsed">false</attribute> > > > <attribute name="Blocking">true</attribute> > > > <attribute name="LoggingEnabled">false</attribute> > > > <attribute name="IdleTimeoutEnabled">false</attribute> > > > <attribute name="IdleTimeout">1800000</attribute> > > > <attribute name="MaxIdleTimeoutPercent">1.0</attribute> > > > </mbean> > > > > > > ...it doesn't specify a URL... > > > > > > -----Mensaje original----- > > > De: Vladimir Blagojevic [mailto:vl...@xi...] > > > Enviado el: Wednesday, April 04, 2001 4:24 PM > > > Para: Claudio Pi > > > Asunto: RE: [JBoss-user] RV: Should I consider Jboss for a new project ? > > > > > > > > > Hey Claudio, > > > > > > But I am looking at your configuration of XaDataSourceLoader and it > seems > > > that you have not specified URL for your database? Can you double check > > > this ? > > > > > > This is good > resource:http://www.jboss.org/documentation/HTML/ch10s17.html > > > > > > Cheers, > > > Vladimir > > > > > > > > > On Wed, 4 Apr 2001, Claudio Pi wrote: > > > > > > > I already tried the following: i-net Opti JDBC, JSQLConnect and > > JDBC:ODBC > > > > and none worked.... > > > > Which one else do you recommend me and what should I modify in > > jboss.jcml > > > in > > > > order to it to work ? > > > > > > > > May be it is the version of JBoss that I am working with (JBoss 2.1 > with > > > > Tomcat, the one that is posted at > > > http://www.jboss.org/business/binary.html) > > > > ? > > > > > > > > > > > > > > > > > > > > -----Mensaje original----- > > > > De: Vladimir Blagojevic [mailto:vl...@xi...] > > > > Enviado el: Wednesday, April 04, 2001 4:11 PM > > > > Para: Claudio Pi > > > > Asunto: RE: [JBoss-user] RV: Should I consider Jboss for a new project > ? > > > > > > > > > > > > Hey I wouldn't jump to the conslusions here. We need more > > > > investigation. Can you try another sql driver in the meantime? > > > > > > > > Cheers, > > > > Vladimir > > > > On Wed, 4 Apr 2001, Claudio Pi wrote: > > > > > > > > > But when I use minevra what happens as I posted early is: > > > > > > > > > > > > JBoss hangs while starting the connection pool at > > > > > > > [SQLServerPool] Starting > > > > > > > [SQLServerPool] XA Connection pool SQLServerPool bound to > > > > > > > java:/SQLServerPool > > > > > > > > > > > > > > > > > > > > > The same situation happened when I tried the JDBC:ODBC driver > and > > > > > > > JSQLConnect driver. > > > > > > > > > > So is this a JBoss bug ? > > > > > > > > > > > > > > > -----Mensaje original----- > > > > > De: Vladimir Blagojevic [mailto:vl...@xi...] > > > > > Enviado el: Wednesday, April 04, 2001 3:12 PM > > > > > Para: Claudio Pi > > > > > Asunto: RE: [JBoss-user] RV: Should I consider Jboss for a new > project > > ? > > > > > > > > > > > > > > > Ok yes, you are right. > > > > > > > > > > Well what happens bhind the scenes is this: XADataSource from your > > > driver > > > > > is reflected and setURL method is invoked. > > > > > > > > > > Yeah try minerva, and I'll look more into code, this seems to be > > > > > intriguing. > > > > > > > > > > Vladimir > > > > > On Wed, 4 Apr 2001, Claudio Pi wrote: > > > > > > > > > > > I tried with XADataSource as you suggested me, but I get the > > following > > > > > > exception: > > > > > > > > > > > > [SQLServerPool] java.lang.ClassNotFoundException: > > > > > com.inet.tds.XADataSource > > > > > > > > > > > > ...so that's not the problem. > > > > > > > > > > > > Moreover, it should work also with: > > > > > > org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp or not ? > > > > > > > > > > > > > > > > > > > > > > > > -----Mensaje original----- > > > > > > De: Vladimir Blagojevic [mailto:vl...@xi...] > > > > > > Enviado el: Wednesday, April 04, 2001 2:38 PM > > > > > > Para: Claudio Pi > > > > > > Asunto: Re: [JBoss-user] RV: Should I consider Jboss for a new > > project > > > ? > > > > > > > > > > > > > > > > > > Hey, > > > > > > I can not post to list at the momement, but the solution to your > > > problem > > > > > > is this: > > > > > > > > > > > > > > > > > > > > > > > > > > > <mbean code="org.jboss.jdbc.XADataSourceLoader" > > > > > > > name="DefaultDomain:service=XADataSource,name=SQLServerPool"> > > > > > > > <attribute > > > > > > > name="DataSourceClass">com.inet.tds.XDataSource</attribute> > > > > > > > > > > > > > > > > > > > > > > > > > you probably misspelled name of this class above, shoouldn't it be > > > > > > XADataSource? > > > > > > > > > > > > Vladimir > > > > > > > > > > > > > > > > > > <attribute name="PoolName">SQLServerPool</attribute> > > > > > > <attribute name="Properties">host=CV; > > database=Gestion</attribu> > > > > > > <attribute name="JDBCUser">sa</attribute> > > > > > > > <attribute name="Password"></attribute> > > > > > > > <attribute name="MinSize">0</attribute> > > > > > > > <attribute name="MaxSize">10</attribute> > > > > > > > <attribute name="GCEnabled">false</attribute> > > > > > > > <attribute name="GCMinIdleTime">1200000</attribute> > > > > > > > <attribute name="GCInterval">120000</attribute> > > > > > > > <attribute name="InvalidateOnError">false</attribute> > > > > > > > <attribute name="TimestampUsed">false</attribute> > > > > > > > <attribute name="Blocking">true</attribute> > > > > > > > <attribute name="LoggingEnabled">false</attribute> > > > > > > > <attribute name="IdleTimeoutEnabled">false</attribute> > > > > > > > <attribute name="IdleTimeout">1800000</attribute> > > > > > > > <attribute name="MaxIdleTimeoutPercent">1.0</attribute> > > > > > > > </mbean> > > > > > > > > > > > > > > The driver is loading correctly because I get the following at > the > > > > > command > > > > > > > prompt: > > > > > > > [JDBC provider] Loaded JDBC-driver:com.inet.tds.TdsDriver > > > > > > > > > > > > > > But then I get the following exception: > > > > > > > > > > > > > > [SQLServerPool] Starting > > > > > > > [SQLServerPool] Stopped > > > > > > > [SQLServerPool] java.lang.NoSuchMethodException > > > > > > > [SQLServerPool] at java.lang.Class.getMethod0(Native > > Method) > > > > > > > [SQLServerPool] at > > java.lang.Class.getMethod(Class.java:888) > > > > > > > [SQLServerPool] at > > > > > > > > > > > > > > > > > > > > > > > > > > > > org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:277) > > > > > > > [SQLServerPool] at > > > > > > > > > > org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93) > > > > > > > [SQLServerPool] at > java.lang.reflect.Method.invoke(Native > > > > > Method) > > > > > > > [SQLServerPool] at > > > > > > > > > > > > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628) > > > > > > > [SQLServerPool] at > > > > > > > > > > > > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) > > > > > > > [SQLServerPool] at > > > > > > > org.jboss.util.ServiceControl.start(ServiceControl.java:97) > > > > > > > [SQLServerPool] at > java.lang.reflect.Method.invoke(Native > > > > > Method) > > > > > > > [SQLServerPool] at > > > > > > > > > > > > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628) > > > > > > > [SQLServerPool] at > > > > > > > > > > > > com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) > > > > > > > [SQLServerPool] at org.jboss.Main.<init>(Main.java:203) > > > > > > > [SQLServerPool] at org.jboss.Main$1.run(Main.java:107) > > > > > > > [SQLServerPool] at > > > > > > > java.security.AccessController.doPrivileged(Native Method) > > > > > > > > > > > > > > > > > > > > > If I change the line <attribute > > > > > > > name="DataSourceClass">com.inet.tds.XDataSource</attribute> for > > > > > > > > > > > > > > <attribute > > > > > > > > > > > > > > > > > > > > > > > > > > > > name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp > > > > > > > l</attribute> > > > > > > > JBoss hangs while starting the connection pool at > > > > > > > [SQLServerPool] Starting > > > > > > > [SQLServerPool] XA Connection pool SQLServerPool bound to > > > > > > > java:/SQLServerPool > > > > > > > > > > > > > > > > > > > > > The same situation happened when I tried the JDBC:ODBC driver > and > > > > > > > JSQLConnect driver. > > > > > > > The MS SQL Server database is running and I can access without > > > problem > > > > > > > through JDBC with the parameters posted above. > > > > > > > > > > > > > > I am missing something ? I am doing something wrong ? Could > anyone > > > > > connect > > > > > > > to MS SQL Server 7.0 through Jboss ? > > > > > > > > > > > > > > Please note that if I can't connect to MS SQL Server 7.0 (our > > > > corporate > > > > > > > database)through JBoss I would have to choose other server. > > > > > > > > > > > > > > Thanks in advance, > > > > > > > > > > > > > > Claudio. > > > > > > > > > > > > > > _______________________________________________ > > > > > > > JBoss-user mailing list > > > > > > > JBo...@li... > > > > > > > http://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > > > > > > > > > > > > > > > > > > > |