The code is responsible for creating the tables.
Other things I need to bring to your notice is regarding the following
issues
Issue 1
18:20:31,046 WARN [GeronimoConnectionEventListener] connectionErrorOccurred
called with null
java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT
specified
I have never faced such an issue when I deployed with apache tomcat
Issue 2
Mar 12, 2009 6:20:33 PM
com.telelogic.focalpoint.bus.report.ReportManagerImpl setDefaultReportImage
SEVERE: Error when uploading default report image
org.springframework.dao.InvalidDataAccessApiUsageException: OracleLobCreator
needs to work on [oracl
e.jdbc.OracleConnection], not on
[org.tranql.connector.jdbc.ConnectionHandle]: specify a correspondi
ng NativeJdbcExtractor; nested exception is java.lang.ClassCastException:
org.tranql.connector.jdbc.
ConnectionHandle
Caused by: java.lang.ClassCastException:
org.tranql.connector.jdbc.ConnectionHandle
at oracle.sql.BLOB.createTemporary(BLOB.java:531)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.prepareLob(OracleL
obHandler.java:393)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.createLob(OracleLo
bHandler.java:340)
at
org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.setBlobAsBytes(Ora
cleLobHandler.java:220)
at
org.springframework.jdbc.core.support.SqlLobValue.setTypeValue(SqlLobValue.java:175)
at
org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUti
ls.java:128)
at
org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUti
ls.java:76)
at
org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImp
l.setValues(PreparedStatementCreatorFactory.java:271)
at
org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImp
l.createPreparedStatement(PreparedStatementCreatorFactory.java:247)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:524)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:736)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:759)
at
org.springframework.jdbc.object.SqlUpdate.update(SqlUpdate.java:163)
at
com.telelogic.focalpoint.dao.jdbc.ReportDaoJdbc.uplodadReportImage(ReportDaoJdbc.java:109
)
at
com.telelogic.focalpoint.bus.report.ReportManagerImpl.uploadReportImage(ReportManagerImpl
.java:274)
at
com.telelogic.focalpoint.bus.report.ReportManagerImpl.setDefaultReportImage(ReportManager
Impl.java:301)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281
)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMe
thodInvocation.java:187)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:154)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInte
rceptor.java:107)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:176)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy60.setDefaultReportImage(Unknown Source)
at
com.telelogic.focalpoint.dom.server.ServerImpl.init(ServerImpl.java:165)
at
com.telelogic.focalpoint.dom.server.ServerImpl.afterPropertiesSet(ServerImpl.java:112)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMe
thods(AbstractAutowireCapableBeanFactory.java:1118)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBe
an(AbstractAutowireCapableBeanFactory.java:1085)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(A
bstractAutowireCapableBeanFactory.java:429)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFac
tory.java:250)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(Defau
ltSingletonBeanRegistry.java:141)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory
.java:247)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory
.java:161)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingle
tons(DefaultListableBeanFactory.java:273)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicatio
nContext.java:346)
at
org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(
AbstractRefreshableWebApplicationContext.java:156)
at
org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.j
ava:246)
at
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.jav
a:184)
at
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderLis
tener.java:49)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3839)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4332)
at
org.apache.geronimo.tomcat.GeronimoStandardContext.access$201(GeronimoStandardContext.jav
a:63)
at
org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStand
ardContext.java:398)
at
org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve
.java:47)
at
org.apache.geronimo.tomcat.GeronimoStandardContext.start(GeronimoStandardContext.java:251
)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at
org.apache.geronimo.tomcat.TomcatContainer.addContext(TomcatContainer.java:364)
at
org.apache.geronimo.tomcat.TomcatWebAppContext.doStart(TomcatWebAppContext.java:512)
at
org.apache.geronimo.gbean.runtime.GBeanInstance.createInstance(GBeanInstance.java:998)
at
org.apache.geronimo.gbean.runtime.GBeanInstanceState.attemptFullStart(GBeanInstanceState.
java:268)
at
org.apache.geronimo.gbean.runtime.GBeanInstanceState.start(GBeanInstanceState.java:102)
at
org.apache.geronimo.gbean.runtime.GBeanInstance.start(GBeanInstance.java:541)
at
org.apache.geronimo.gbean.runtime.GBeanDependency.attemptFullStart(GBeanDependency.java:1
11)
at
org.apache.geronimo.gbean.runtime.GBeanDependency.addTarget(GBeanDependency.java:146)
at
org.apache.geronimo.gbean.runtime.GBeanDependency$1.running(GBeanDependency.java:120)
at
org.apache.geronimo.kernel.basic.BasicLifecycleMonitor.fireRunningEvent(BasicLifecycleMon
itor.java:176)
at
org.apache.geronimo.kernel.basic.BasicLifecycleMonitor.access$300(BasicLifecycleMonitor.j
ava:44)
at
org.apache.geronimo.kernel.basic.BasicLifecycleMonitor$RawLifecycleBroadcaster.fireRunnin
gEvent(BasicLifecycleMonitor.java:254)
at
org.apache.geronimo.gbean.runtime.GBeanInstanceState.attemptFullStart(GBeanInstanceState.
java:294)
at
org.apache.geronimo.gbean.runtime.GBeanInstanceState.start(GBeanInstanceState.java:102)
at
org.apache.geronimo.gbean.runtime.GBeanInstanceState.startRecursive(GBeanInstanceState.ja
va:124)
at
org.apache.geronimo.gbean.runtime.GBeanInstance.startRecursive(GBeanInstance.java:555)
at
org.apache.geronimo.kernel.basic.BasicKernel.startRecursiveGBean(BasicKernel.java:379)
at
org.apache.geronimo.kernel.config.ConfigurationUtil.startConfigurationGBeans(Configuratio
nUtil.java:456)
at
org.apache.geronimo.kernel.config.KernelConfigurationManager.start(KernelConfigurationMan
ager.java:188)
at
org.apache.geronimo.kernel.config.SimpleConfigurationManager.startConfiguration(SimpleCon
figurationManager.java:562)
at
org.apache.geronimo.kernel.config.SimpleConfigurationManager.startConfiguration(SimpleCon
figurationManager.java:543)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.geronimo.gbean.runtime.ReflectionMethodInvoker.invoke(ReflectionMethodInvoker.
java:34)
at
org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:124)
at
org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:832)
at
org.apache.geronimo.gbean.runtime.RawInvoker.invoke(RawInvoker.java:57)
at
org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke(RawOperationInvoker.java:35)
at
org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept(ProxyMethodInterceptor.
java:96)
at
org.apache.geronimo.kernel.config.EditableConfigurationManager$$EnhancerByCGLIB$$b90e4867
.startConfiguration(<generated>)
at
org.apache.geronimo.deployment.plugin.local.RedeployCommand.redeploySameConfiguration(Red
eployCommand.java:229)
at
org.apache.geronimo.deployment.plugin.local.RedeployCommand.run(RedeployCommand.java:101)
at java.lang.Thread.run(Unknown Source)
djencks wrote:
>
> This looks ok to me. I think maybe we didn't ship the tranql oracle
> wrappers with geronimo until a later geronimo release: I think they
> are in 2.1.3.
>
> The values in your geronimo plan override the defaults in ra.xml, but
> don't change the contents of ra.xml.
>
> If you are still having problems with this you might try changing to
> <no-transaction/> and see what happens. Obviously you won't want to
> use this in production but if it works it may help figure out what is
> wrong.
>
> Does your code start by creating tables and the problem you are seeing
> is that when you try to use them they have not been created? Or are
> the tables created by some other process like running a script on the
> db by hand?
>
> thanks
> david jencks
>
> On Mar 13, 2009, at 12:09 AM, Hearty wrote:
>
>>
>> I am not using any oracle specific wrapper for the db pool.
>> I have used admin console for configuring the db pool. Since admin
>> console
>> does not provide a way
>> to set the property for autocommit, I have modified ra.xml manually.
>>
>> I have tried one more option by deploying the dbpool using deploy
>> command
>> deploy
>> %GERONIMO_HOME%\repository\org\tranql\tranql-connector-ra\1.4\tranql-
>> connector-ra-1.4.rar
>> ..\fpconfig\oracle10g-deployment-plan.xml
>>
>> oracle10g-deployment-plan is as follows
>>
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <connector
>> xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2";>
>> <dep:environment
>> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2";>
>> <dep:moduleId>
>> <dep:groupId>console.dbpool</dep:groupId>
>> <dep:artifactId>fpdbpool</dep:artifactId>
>> <dep:version>1.0</dep:version>
>> <dep:type>rar</dep:type>
>> </dep:moduleId>
>> <dep:dependencies>
>> <dep:dependency>
>>
>> <dep:groupId>com.telelogic.focalpoint.lib</dep:groupId>
>> <dep:artifactId>ojdbc14</dep:artifactId>
>> <dep:version>10.2.0.1.0</dep:version>
>> <dep:type>jar</dep:type>
>> </dep:dependency>
>> </dep:dependencies>
>> </dep:environment>
>> <resourceadapter>
>> <outbound-resourceadapter>
>> <connection-definition>
>> <connectionfactory-interface>
>> javax.sql.DataSource
>> </connectionfactory-interface>
>> <connectiondefinition-instance>
>> <name>fpdbpool</name>
>> <config-property-setting
>> name="Password">
>> focalpoint
>> </config-property-setting>
>> <config-property-setting name="Driver">
>> oracle.jdbc.driver.OracleDriver
>> </config-property-setting>
>> <config-property-setting
>> name="UserName">
>> mobile
>> </config-property-setting>
>> <config-property-setting
>> name="ConnectionURL">
>>
>> jdbc:oracle:thin:@192.168.133.96:1521:orcl
>> </config-property-setting>
>> <config-property-setting
>> name="CommitBeforeAutocommit">true</config-property-setting>
>>
>> <connectionmanager>
>> <local-transaction />
>> <single-pool>
>> <max-size>10</max-size>
>> <min-size>10</min-size>
>>
>> <blocking-timeout-milliseconds>
>> 60000
>>
>> </blocking-timeout-milliseconds>
>> <idle-timeout-minutes>
>> 10
>> </idle-timeout-minutes>
>> <match-one />
>> </single-pool>
>> </connectionmanager>
>> </connectiondefinition-instance>
>> </connection-definition>
>> </outbound-resourceadapter>
>> </resourceadapter>
>> </connector>
>>
>>
>> But I've observed even I've specified "CommitBeforeAutocommit" as
>> true,
>> ra.xml contains the value of "CommitBeforeAutocommit" as false. I am
>> using
>> "Oracle Thin" as the Database Type.
>>
>> I am not using any specific tranql wrapper for oracle. I am using
>> tranql-connector-ra-1.4.rar which I found with
>> repository\org\tranql\tranql-connector-ra\1.4
>>
>> Please let me know if I am doing some thing wrong. Is there
>> documentation
>> (with sample code) for creating tranql oracle specific wrapper for
>> the db
>> pool.
>>
>> Can I rely on the admin console alone for deploying the database
>> pool for
>> oracle 10g?
>>
>>
>> djencks wrote:
>>>
>>> Its difficult to do more than guess without more information on what
>>> you have deployed.
>>>
>>> You should be using one of the tranql oracle specific wrappers for
>>> your db pool. This should take care of the commit-before-autocommit
>>> problem caused by oracle jdbc spec non-compliance. If you aren't
>>> using an oracle specific wrapper you do need to set the commit before
>>> autocommit property to true, but you should do it in your pool
>>> deployment plan, not by modifying the ra.xml.
>>>
>>> At a minimum I think we'd need to know which tranql wrapper you are
>>> using and to see the deployment plan for it.
>>>
>>> thanks
>>> david jencks
>>>
>>> On Mar 12, 2009, at 6:19 AM, Hearty wrote:
>>>
>>>>
>>>> When I have configured database pool with oracle10g and running
>>>> against the
>>>> apache geronimo v2.1, I am getting some unusual errors where as when
>>>> I've
>>>> tried with tomcat5.5 it is working smoothly.
>>>> Oracle driver I've used is ojdbc14-10.2.0.1.0.jar.
>>>>
>>>> The following is the error message I am getting. Also I am uploading
>>>> the
>>>> error log since the error log is a big file
>>>> http://www.nabble.com/file/p22476155/errorLog.txt errorLog.txt
>>>> I have modified ra.xml with the following entry
>>>> <config-property>
>>>> <description>
>>>> Flag indicating whether the Driver requires a
>>>> commit
>>>> to be performed
>>>> before enabling auto-commit on a Connection.
>>>> This
>>>> should be set to false for
>>>> compliant drivers to avoid an extraneous
>>>> commit to
>>>> the database.
>>>> </description>
>>>>
>>>> <config-property-name>CommitBeforeAutocommit</config-property-name>
>>>>
>>>> <config-property-type>java.lang.Boolean</config-property-type>
>>>> <config-property-value>true</config-property-
>>>> value>
>>>> </config-property>
>>>> The default value was false
>>>>
>>>> I am struggling with this issue for more than one week.
>>>>
>>>> Any help is highly appreciated. I am very new to apache geronimo.
>>>> Please let
>>>> me know if I've missed out any entries.
>>>>
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/Issues-facing-when-connecting-with-Oracle10g-tp22476155s134p22476155.html
>>>> Sent from the Apache Geronimo - Users mailing list archive at
>>>> Nabble.com.
>>>>
>>>
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Issues-facing-when-connecting-with-Oracle10g-tp22476155s134p22491260.html
>> Sent from the Apache Geronimo - Users mailing list archive at
>> Nabble.com.
>>
>
>
>
--
View this message in context:
http://www.nabble.com/Issues-facing-when-connecting-with-Oracle10g-tp22476155s134p22493784.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.
