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:[EMAIL PROTECTED]]
> 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:[EMAIL PROTECTED]]
> > 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:[EMAIL PROTECTED]]
> > > 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:[EMAIL PROTECTED]]
> > > > 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:[EMAIL PROTECTED]]
> > > > > 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:[EMAIL PROTECTED]]
> > > > > > 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
> > > > > > > [EMAIL PROTECTED]
> > > > > > > http://lists.sourceforge.net/lists/listinfo/jboss-user
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
