I work of the same way when my connect a SAPDB, but you put the driver inside lib/ext, but you make mistake in the jboss.jcml, i send you my example
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=TeceduDB"> <attribute name="PoolName">TeceduDB</attribute> <attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr ibute> <attribute name="URL">jdbc:sapdb://192.168.68.177/TECEDU</attribute> <attribute name="JDBCUser">TEST</attribute> <attribute name="Password">TEST</attribute> <attribute name="Properties"></attribute> <attribute name="GCMinIdleTime">1200000</attribute> <attribute name="MaxSize">10</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> Regards Jaime Lima-Peru ----- Original Message ----- From: "B V M Mohan" <[EMAIL PROTECTED]> To: "jaime1" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, August 24, 2002 7:28 AM Subject: Re: Jboss and SAPDB > Hai > Thank you for your response, I am new to Jboss as well > I have added the sapdbc.jar in the appropriate lib file and edited > jboss.jcml in the following way but I am not sure whether that is right or > not please correct it > > I doubt the correction in jboss.jcml file that I have edited ,My > program gives an exception that table is not found wheras I am able to > get a good result through a simple program > > In my program I am Connecting to a Database which is of IP > :172.16.4.25 and connecting to data base "TST" and with user name and > password DBA > > Awaiting for your reply with great eagerness > > bye > mohan > > > <!- > ==================================================================== --> > <!-- JDBC > --> > <!-- > ==================================================================== --> > > <mbean code="org.jboss.jdbc.JdbcProvider" > name="DefaultDomain:service=JdbcProvider"> > <attribute > name="Drivers">org.hsqldb.jdbcDriver,com.sap.dbtech.jdbc.DriverSapDB</attrib ute> > </mbean> > > <mbean code="org.jboss.jdbc.HypersonicDatabase" > name="DefaultDomain:service=Hypersonic"> > <attribute name="Port">1476</attribute> > <attribute name="Silent">true</attribute> > <attribute name="Database">default</attribute> > <attribute name="Trace">false</attribute> > </mbean> > > <mbean code="org.jboss.jdbc.XADataSourceLoader" > name="DefaultDomain:service=XADataSource,name=DefaultDS"> > <attribute name="PoolName">SAPDB</attribute> > <attribute > name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr ibute> > <attribute name="Properties"></attribute> > <attribute name="URL">jdbc:sapdb://172.16.4.25/TST</attribute> > <attribute name="GCMinIdleTime">1200000</attribute> > <attribute name="JDBCUser">DBA</attribute> > <attribute name="MaxSize">10</attribute> > <attribute name="Password">DBA</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> > > ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
