Hi-
I am moving our application from Weblogic 8.1 SP3 to Sun Appserver 8.1 2005Q1 and I am having problems with setting up my connection pool for my CMP beans. I have been banging my head on this for a few days now and could use some help.
After reading the Developers Guide, and following the directions for "JConnect/Type4 Driver for Sybase ASE 12.5 Databases" I setup the pool as follows:
<jdbc-connection-pool connection-validation-method="auto-commit" datasource-classname="com.sybase.jdbc2.jdbc.SybDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="false" max-pool-size="32" max-wait-time-in-millis="60000" name="edssPool" pool-resize-quantity="2" steady-pool-size="8">
<property name="FAKE_METADATA" value="true"/>
<property name="user" value="validuser"/>
<property name="password" value="validpass"/>
<property name="BE_AS_JDBC_COMPLIANT_AS_POSSIBLE" value="true"/>
<property name="portNumber" value="5000"/>
<property name="databaseName" value="validdatabasename"/>
<property name="serverName" value="validhost"/>
</jdbc-connection-pool>
Then I created a resource that uses it...
<jdbc-resource enabled="true" jndi-name="EdssDB" object-type="user" pool-name="edssPool"/>
My sun-ejb-jar has...
<ejb>
<ejb-name>PlannedEventBean</ejb-name>
<jndi-name>ejb/edss/PlannedEventEJB</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/edss/OperationalEventEJB</ejb-ref-name>
<jndi-name>ejb/edss/OperationalEventEJB</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/edss/SerialEJB</ejb-ref-name>
<jndi-name>ejb/edss/SerialEJB</jndi-name>
</ejb-ref>
<cmp>
<mapping-properties>META-INF/sun-cmp-mappings.xml</mapping-properties>
<is-one-one-cmp>false</is-one-one-cmp>
</cmp>
<bean-cache>
<max-cache-size>60</max-cache-size>
</bean-cache>
</ejb>
... and my sun-cmp-mappings.xml contains...
<schema/>
<entity-mapping>
<ejb-name>PlannedEventBean</ejb-name>
<table-name>PLANNEDEVENT</table-name>
<cmp-field-mapping>
<field-name>event_id</field-name>
<column-name>EVENT_ID</column-name>
</cmp-field-mapping>
<cmp-field-mapping>
<field-name>plan_id</field-name>
<column-name>PLAN_ID</column-name>
</cmp-field-mapping>
</entity-mapping>
When I deploy our ear, I see...
[#|2005-03-01T15:46:35.890-0500|WARNING|sun-appserver-pe8.1|javax.enterprise.res
ource.resourceadapter|_ThreadID=11;|RAR6017 : Failed to get connection pool obje
ct via JNDI lookup : edssPool|#]
[#|2005-03-01T15:46:36.765-0500|WARNING|sun-appserver-pe8.1|javax.enterprise.sys
tem.tools.deployment|_ThreadID=11;|JDO74046: JDOCodeGenerator: Caught a MappingC
onversionException loading or creating mapping model for application 'EDSS' modu
le 'EDSSServer': JDO71002: The schema file EDSS_EDSSServer does not contain a ta
ble named PLANNEDEVENT|#]
[#|2005-03-01T15:46:38.406-0500|INFO|sun-appserver-pe8.1|javax.enterprise.system
.util|_ThreadID=11;|UTIL6040: Error attempting to delete D:\Sun\AppServer\domain
s\domain1\applications\j2ee-apps\EDSS\EDSSWeb_war\WEB-INF\lib\commons-beanutils.
jar|#]
[#|2005-03-01T15:46:38.406-0500|INFO|sun-appserver-pe8.1|javax.enterprise.system
.util|_ThreadID=11;|UTIL6041: Performing gc to try to force file closures|#]
Sorry this is so long but I wanted to include as much info as possible. In the Edit Connection Pool page of the admin console I can ping just fine. Its only when I deploy that I see that the JNDI lookup for edssPool fail.
Can anyone help?
Thanks!
Dave
PS -One other thing.. In weblogic we used the com.sybase.jdbc2.jdbc.SybDriver Driver but when I use that I can't even ping the database at all.