logs -
[#|2009-01-06T15:30:43.485-0600|SEVERE|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=17;_ThreadName=httpSSLWorkerThread-80-0;_RequestID=8ad70b9c-9d94-4b53-b051-253010b7d994;|RAR5031:System Exception.
java.lang.NullPointerException
at com.mysql.jdbc.LoadBalancingConnectionProxy.invalidateCurrentConnection(LoadBalancingConnectionProxy.java:289)
at com.mysql.jdbc.LoadBalancingConnectionProxy.dealWithInvocationException(LoadBalancingConnectionProxy.java:257)
at com.mysql.jdbc.LoadBalancingConnectionProxy.invoke(LoadBalancingConnectionProxy.java:369)
at $Proxy40.setAutoCommit(Unknown Source)
at com.sun.gjc.spi.LocalTransaction.begin(LocalTransaction.java:75)
at com.sun.enterprise.resource.ConnectorXAResource.getResourceHandle(ConnectorXAResource.java:232)
at com.sun.enterprise.resource.ConnectorXAResource.rollback(ConnectorXAResource.java:195)
at com.sun.enterprise.distributedtx.J2EETransaction.rollback(J2EETransaction.java:515)
at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.rollback(J2EETransactionManagerOpt.java:420)
at com.sun.enterprise.distributedtx.UserTransactionImpl.rollback(UserTransactionImpl.java:225)
at org.jboss.seam.transaction.UTTransaction.rollback(UTTransaction.java:66)
at org.jboss.seam.jsf.SeamPhaseListener.commitOrRollback(SeamPhaseListener.java:622)
at org.jboss.seam.jsf.SeamPhaseListener.commitOrRollback(SeamPhaseListener.java:605)
at org.jboss.seam.jsf.SeamPhaseListener.handleTransactionsAfterPhase(SeamPhaseListener.java:343)
at org.jboss.seam.jsf.SeamPhaseListener.afterServletPhase(SeamPhaseListener.java:243)
at org.jboss.seam.jsf.SeamPhaseListener.afterPhase(SeamPhaseListener.java:194)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:280)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:38)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:522)
at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.sps.SPSWebFilter.doFilter(SPSWebFilter.java:109)
pool config -
<jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="auto-commit" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="false" lazy-connection-association="true" lazy-connection-enlistment="true" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="hssPool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
<property name="UseUnbufferedInput" value="true"/>
<property name="UseUltraDevWorkAround" value="false"/>
<property name="UseStreamLengthsInPrepStmts" value="true"/>
<property name="LogSlowQueries" value="false"/>
<property name="TcpRcvBuf" value="0"/>
<property name="UltraDevHack" value="false"/>
<property name="InitialTimeout" value="2"/>
<property name="UseNanosForElapsedTime" value="false"/>
<property name="MetadataCacheSize" value="50"/>
<property name="RequireSSL" value="false"/>
<property name="LogXaCommands" value="false"/>
<property name="CacheCallableStatements" value="false"/>
<property name="NoDatetimeStringSync" value="false"/>
<property name="EmulateUnsupportedPstmts" value="true"/>
<property name="TreatUtilDateAsTimestamp" value="true"/>
<property name="EmulateLocators" value="false"/>
<property name="IsInteractiveClient" value="false"/>
<property name="IncludeInnodbStatusInDeadlockExceptions" value="false"/>
<property name="ProcessEscapeCodesForPrepStmts" value="true"/>
<property name="GatherPerformanceMetrics" value="false"/>
<property name="UseOnlyServerErrorMessages" value="true"/>
<property name="LogSlowQueries" value="false"/>
<property name="TcpRcvBuf" value="0"/>
<property name="UltraDevHack" value="false"/>
<property name="InitialTimeout" value="2"/>
<property name="UseNanosForElapsedTime" value="false"/>
<property name="MetadataCacheSize" value="50"/>
<property name="RequireSSL" value="false"/>
<property name="LogXaCommands" value="false"/>
<property name="CacheCallableStatements" value="false"/>
<property name="NoDatetimeStringSync" value="false"/>
<property name="EmulateUnsupportedPstmts" value="true"/>
<property name="TreatUtilDateAsTimestamp" value="true"/>
<property name="EmulateLocators" value="false"/>
<property name="IsInteractiveClient" value="false"/>
<property name="IncludeInnodbStatusInDeadlockExceptions" value="false"/>
<property name="ProcessEscapeCodesForPrepStmts" value="true"/>
<property name="GatherPerformanceMetrics" value="false"/>
<property name="UseOnlyServerErrorMessages" value="true"/>
<property name="HoldResultsOpenOverStatementClose" value="false"/>
<property name="UseServerPreparedStmts" value="false"/>
<property name="CachePrepStmts" value="false"/>
<property name="UseTimezone" value="false"/>
<property name="BlobsAreStrings" value="false"/>
<property name="UseSSL" value="false"/>
<property name="AllowLoadLocalInfile" value="true"/>
<property name="IgnoreNonTxTables" value="false"/>
<property name="SocketFactoryClassName" value="com.mysql.jdbc.StandardSocketFactory"/>
<property name="AutoClosePStmtStreams" value="false"/>
<property name="NullCatalogMeansCurrent" value="true"/>
<property name="UseInformationSchema" value="false"/>
<property name="DynamicCalendars" value="false"/>
<property name="CreateDatabaseIfNotExist" value="false"/>
<property name="UseServerPrepStmts" value="false"/>
<property name="Pedantic" value="false"/>
<property name="UseSSPSCompatibleTimezoneShift" value="false"/>
<property name="ReconnectAtTxEnd" value="false"/>
<property name="UseJvmCharsetConverters" value="false"/>
<property name="FunctionsNeverReturnBlobs" value="false"/>
<property name="NoAccessToProcedureBodies" value="false"/>
<property name="AlwaysSendSetIsolation" value="true"/>
<property name="AllowNanAndInf" value="false"/>
<property name="ZeroDateTimeBehavior" value="exception"/><property name="CachePreparedStatements" value="false"/>
<property name="ExplainSlowQueries" value="false"/>
<property name="MaintainTimeStats" value="true"/>
<property name="CacheResultSetMetadata" value="false"/>
<property name="TcpKeepAlive" value="true"/>
<property name="PreparedStatementCacheSqlLimit" value="256"/>
<property name="SlowQueryThresholdNanos" value="0"/>
<property name="LoginTimeout" value="0"/>
<property name="UseCompression" value="false"/>
<property name="TcpSndBuf" value="0"/>
<property name="TcpTrafficClass" value="0"/>
<property name="CallableStatementCacheSize" value="100"/>
<property name="InteractiveClient" value="false"/>
<property name="NoTimezoneConversionForTimeType" value="false"/>
<property name="UseHostsInPrivileges" value="true"/>
<property name="UseSqlStateCodes" value="true"/>
<property name="GatherPerfMetrics" value="false"/>
<property name="UseReadAheadInput" value="true"/>
<property name="ReportMetricsIntervalMillis" value="30000"/>
<property name="UseFastDateParsing" value="true"/>
<property name="User" value="root"/>
<property name="UseLocalSessionState" value="false"/>
<property name="LoggerClassName" value="com.mysql.jdbc.log.StandardLogger"/>
<property name="DontTrackOpenResources" value="false"/>
<property name="UseOldUTF8Behavior" value="false"/>
<property name="OverrideSupportsIntegrityEnhancementFacility" value="false"/>
<property name="RollbackOnPooledClose" value="true"/>
<property name="GenerateSimpleParameterMetadata" value="false"/>
<property name="SlowQueryThresholdMillis" value="2000"/>
<property name="SecondsBeforeRetryMaster" value="30"/>
<property name="ResultSetSizeThreshold" value="100"/>
<property name="TransformedBitIsBoolean" value="false"/>
<property name="SocketTimeout" value="0"/>
<property name="Paranoid" value="false"/>
<property name="FailOverReadOnly" value="true"/>
<property name="CapitalizeTypeNames" value="true"/>
<property name="TinyInt1isBit" value="true"/>
<property name="UseDynamicCharsetInfo" value="true"/>
<property name="CacheServerConfiguration" value="false"/>
<property name="PrepStmtCacheSize" value="25"/>
<property name="EnableQueryTimeouts" value="true"/>
<property name="PopulateInsertRowWithDefaultValues" value="false"/>
<property name="RetainStatementAfterResultSetClose" value="false"/>
<property name="PadCharsWithSpace" value="false"/>
<property name="UseOldAliasMetadataBehavior" value="true"/>
<property name="PrepStmtCacheSqlLimit" value="256"/>
<property name="MaxReconnects" value="3"/>
<property name="AutoDeserialize" value="false"/>
<property name="ElideSetAutoCommits" value="false"/>
<property name="JdbcCompliantTruncationForReads" value="true"/>
<property name="ProfileSQL" value="false"/>
<property name="PinGlobalTxToPhysicalConnection" value="false"/>
<property name="RewriteBatchedStatements" value="false"/>
<property name="UseUnicode" value="true"/>
<property name="Logger" value="com.mysql.jdbc.log.StandardLogger"/>
<property name="DumpMetadataOnColumnNotFound" value="false"/>
<property name="MaxQuerySizeToLog" value="2048"/>
<property name="LocatorFetchBufferSize" value="1048576"/>
<property name="CallableStmtCacheSize" value="100"/>
<property name="ClobberStreamingResults" value="false"/>
<property name="TcpNoDelay" value="true"/>
<property name="StrictFloatingPoint" value="false"/>
<property name="AutoReconnectForPools" value="false"/>
<property name="CacheCallableStmts" value="false"/>
<property name="MaxRows" value="-1"/>
<property name="BlobSendChunkSize" value="1048576"/>
<property name="UseGmtMillisForDatetimes" value="false"/>
<property name="AllowMultiQueries" value="false"/>
<property name="JdbcCompliantTruncation" value="true"/>
<property name="AutoGenerateTestcaseScript" value="false"/>
<property name="EnablePacketDebug" value="false"/>
<property name="ContinueBatchOnError" value="true"/>
<property name="TraceProtocol" value="false"/>
<property name="UseCursorFetch" value="false"/>
<property name="EmptyStringsConvertToZero" value="true"/>
<property name="PreparedStatementCacheSize" value="25"/>
<property name="StrictUpdates" value="true"/>
<property name="Password" value="mavenir"/>
<property name="DumpQueriesOnException" value="false"/>
<property name="PacketDebugBufferSize" value="20"/>
<property name="AllowUrlInLocalInfile" value="false"/>
<property name="UseUsageAdvisor" value="false"/>
<property name="QueriesBeforeRetryMaster" value="50"/>
<property name="SocketFactory" value="com.mysql.jdbc.StandardSocketFactory"/>
<property name="DefaultFetchSize" value="0"/>
<property name="ConnectTimeout" value="0"/>
<property name="YearIsDateType" value="true"/>
<property name="RunningCTS13" value="false"/>
<property name="UseJDBCCompliantTimezoneShift" value="false"/>
<property name="UseFastIntParsing" value="true"/>
<property name="ProfileSql" value="false"/>
<property name="RelaxAutoCommit" value="false"/>
<property name="NullNamePatternMatchesAll" value="true"/>
<property name="PortNumber" value="3306"/>
<property name="Port" value="3306"/>
<property name="RoundRobinLoadBalance" value="false"/>
<property name="LoadBalanceStrategy" value="random"/>
<property name="URL" value="jdbc:mysql:loadbalance://10.3.2.17:3306,10.3.3.103:3306/hss?loadBalanceBlacklistTimeout=60000"/>
<property name="Url" value="jdbc:mysql:loadbalance://10.3.2.17:3306,10.3.3.103:3306/hss?loadBalanceBlacklistTimeout=60000"/>
</jdbc-connection-pool>
[Message sent by forum member 'kbsangha' (kbsangha)]
http://forums.java.net/jive/thread.jspa?messageID=324451