John,
You didn't give out your JdbcProvider section, so i'm not sure what JDBC
driver you're using. I've had good luck with the Sybase JConnect JDBC
drivers. If you're using that, this is what the relevant sections of
jboss.jcml looks like for my configuration:
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute
name="Drivers">org.hsql.jdbcDriver,com.sybase.jdbc2.jdbc.SybDriver</attribut
e>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=SybasePool">
<attribute name="PoolName">SybasePool</attribute>
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
ibute>
<attribute
name="URL">jdbc:sybase:Tds:servername:7100?ELIMINAT_010SM=true</attribute>
<attribute name="JDBCUser">username</attribute>
<attribute name="Password">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>
I'm currently running JBoss 2.3 beta, but i used this with JBoss PRE-2.1 and
it worked then too (albeit with some minor tweaks IIRC). Hope this helps.
Jason
----- Original Message -----
From: "John DeStefano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 10:25 AM
Subject: [JBoss-user] Sybase Datasource problem
> Hi,
>
> I'm having a problem with creating a Sybase connection pool. I'm using
JBoss 2.2.2 and JDK1.3.1. The startup output looks like this:
>
> [JNDIView] Starting
> [JNDIView] Started
> [Transaction manager] Starting
> [Transaction manager] Started
> [JAAS Security Manager] Starting
> [JAAS Security Manager] JAAS.startService, cachePolicy=null
> [JAAS Security Manager] JAAS.startService,
SecurityProxyFactory=org.jboss.security.SubjectSecurityProxyFactory@4b6009
> [JAAS Security Manager] Started
> [JDBC provider] Starting
> [JDBC provider] Started
> [Hypersonic] Starting
> [Hypersonic] Database started
> [Hypersonic] Started
> [DefaultDS] Starting
> [Hypersonic] Server 1.4 is running
> [Hypersonic] Press [Ctrl]+[C] to abort
> [DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
> [DefaultDS] Started
> [CensusDS] Starting
> [CensusDS] XA Connection pool CensusDS bound to java:/CensusDS
>
> It hangs at the attempt to bind the Sybase datasource.
>
> The jboss.jcml section for the sysbase database looks like this:
>
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=CensusDS">
> <attribute name="PoolName">CensusDS</attribute>
> <attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
> <attribute
name="URL">jdbc:sybase:Tds:localhost:2638/census_file_db</attribute>
> <attribute name="JDBCUser">dba</attribute>
> <attribute name="MaxSize">2</attribute>
> <attribute name="MinSize">1</attribute>
> <attribute name="Password">sql</attribute>
> <attribute name="Properties"></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>
> </mbean>
>
> The sybase driver does load according to the server startup output.
>
> Any help would be appreciated.
>
> Thanks
>
>
> _______________________________________________
> 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
