2003-06-23 17:57:14 UTC
I'm getting several errors I cannot solve:
ERROR yapoolman.PoolManager - create pool ITCMD error:Object type net.sf.yapoolman.jdbc.JdbcConnectionWrapper not valid
And when trying to get a DataSource via JNDI:
java.lang.ClassCastException: net.sf.yapoolman.pool.ObjectPool
Here is my poolman.xml . Is there a way to create a DS via JNDI without an ObjectPool? Please help.
<?xml version="1.0" encoding="UTF-8"?>
<poolman>
<global>false</global>
<jmx>
<serverName>YAPoolMan</serverName>
<defaultDomain>poolman</defaultDomain>
<enabled>false</enabled>
<agentPort>8082</agentPort>
</jmx>
<objectPool>
<name>mypool</name>
<jndiName>jdbc/sybase1</jndiName>
<initialObjects>10</initialObjects>
<objectTimeout>600</objectTimeout>
<userTimeout>30</userTimeout>
<requestTimeout>10</requestTimeout>
<maximumUseCount>100</maximumUseCount>
<checkInterval>300</checkInterval>
<shrinkBy>2</shrinkBy>
<sticky>true</sticky>
<logger>net.sf.yapoolman.pool.mypool</logger>
<factory>
<type>net.sf.yapoolman.factory.SimpleFactory</type>
<objectType>java.lang.StringBuffer</objectType>
<checkInterval>30</checkInterval>
<maximumSoft>true</maximumSoft>
<logger>net.sf.yapoolman.pool.mypool.factory</logger>
<server>
<name>172.16.68.12</name>
<maxConnection>20</maxConnection>
<priority>0</priority>
<weight>10</weight>
<busyStandby>false</busyStandby>
<failStandby>false</failStandby>
<param>
<name>serverName</name>
<value>172.16.68.12</value>
</param>
<param>
<name>portNumber</name>
<value>4100</value>
</param>
</server>
</factory>
</objectPool>
<datasource>
<dbName>ITCMD</dbName>
<jndiName>jdbc/sybase1</jndiName>
<driver>com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource</driver>
<!--
<driver>com.sybase.jdbc2.jdbc.SybDriver</driver>
<driver>org.postgresql.Driver</driver>
-->
<url>jdbc:sybase:Tds:172.16.68.12:4100/cts?FAKE_METADATA=true</url>
<userName>usr_itcmd</userName>
<password>usr_itcmd</password>
<txIsolationLevel>READ_COMMITTED</txIsolationLevel>
<transactionTimeout>100</transactionTimeout>
<connectionTimeout>600</connectionTimeout>
<removeOnExceptions>false</removeOnExceptions>
<initialConnections>1</initialConnections>
<maximumSize>10</maximumSize>
<userTimeout>12</userTimeout>
<requestTimeout>12</requestTimeout>
<shrinkBy>10</shrinkBy>
</datasource>