ORA-01461 error for persistent Weblogic 6.0 config
Evgenii Bazarov
Hi!
I am trying to set-up persistent configuration for the JMS running within Weblogic
6.0 Service Pack 1.
I checked that server has created two tables in Oracle DB, this seems to be right:
SQL> desc jmsstore
Name Null? Type
----------------------------------------- -------- ----------------------------
RECORDHANDLE NUMBER(38)
RECORDSTATE NUMBER(38)
RECORD LONG RAW
SQL> desc jmsstate
Name Null? Type
----------------------------------------- -------- ----------------------------
RECORDHANDLE NUMBER(38)
RECORDSTATE NUMBER(38)
RECORDGENERATION NUMBER(38)
However I am getting Oracle exception on server start-up:
<Jun 29, 2001 1:08:20 PM PDT> <Alert> <JMS> <JMSServer "examplesJMSServer", store
failed to open, java.io.IOException: JMS JDBC store, connection pool = <testJ
MSPool>, prefix = <null>: change state
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a
LONG column
at weblogic.db.oci.OciCursor.getCDAException(OciCursor.java:238)
at weblogic.jdbcbase.oci.Statement.executeUpdate(Statement.java:869)
at weblogic.jdbc.pool.PreparedStatement.executeUpdate(PreparedStatement.java:75)
at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:399)
at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:1516)
at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:282)
at weblogic.jms.store.JMSStore.open(JMSStore.java:90)
at weblogic.jms.backend.BEStore.open(BEStore.java:175)
at weblogic.jms.backend.BackEnd.initialize(BackEnd.java:323)
at weblogic.jms.JMSService.createBackEnd(JMSService.java:778)
at weblogic.jms.JMSService.addJMSServer(JMSService.java:1137)
at weblogic.jms.JMSService.addDeployment(JMSService.java:1035)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:283)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:233)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:194)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:158)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:562)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:548)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:285)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:437)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:178)
at $Proxy32.updateDeployments(Unknown Source)
at weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_CachingStub.java:2299)
at weblogic.management.mbeans.custom.ApplicationManager.startConfigManager(ApplicationManager.java:240)
at weblogic.management.mbeans.custom.ApplicationManager.start(ApplicationManager.java:122)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:562)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:548)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:285)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:437)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:178)
at $Proxy25.start(Unknown Source)
at weblogic.management.configuration.ApplicationManagerMBean_CachingStub.start(ApplicationManagerMBean_CachingStub.java:435)
at weblogic.management.Admin.startApplicationManager(Admin.java:1030)
at weblogic.management.Admin.finish(Admin.java:491)
at weblogic.t3.srvr.T3Srvr.start(T3Srvr.java:429)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:170)
at weblogic.Server.main(Server.java:35)
Here is my configuration config.xml extract:
<JMSServer Name="examplesJMSServer" TemporaryTemplate="TestTemplate" Store="testJMSStore"
Targets="myserver">
<JMSTopic JNDIName="test.content.image" Name="imageTopic"/>
<JMSTopic JNDIName="test.content.text" Name="textTopic"/>
</JMSServer>
<JMSJDBCStore ConnectionPool="testJMSPool"
Name="testJMSStore"
Notes="purely for auto-persisting JMS messages by the server"/>
<JDBCConnectionPool CapacityIncrement="1"
DriverName="weblogic.jdbc.oci.Driver"
InitialCapacity="1"
MaxCapacity="4" Name="testJMSPool"
Properties="user=evg;password=evg;server=blah"
ShrinkPeriodMinutes="2" Targets="myserver"
TestConnectionsOnReserve="true" TestTableName="dual"
URL="jdbc:weblogic:oracle:blah"/>
Any advice would be highly appreciated!
Cheers,
Evg
Stephen Felts
I haven't seen this error.
What client version of Oracle are you using on what platform?
"Evgenii Bazarov" <evgenii...@usa.net> wrote in message
news:3b3c116c$1...@newsgroups.bea.com...
Evgenii Bazarov
Sorry for not feeding this information.
Server:
Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production
With the Partitioning option
Client:
I've just used weblogic oci driver coming with the distribution
Thanks,
Evg
>..java:562)
>..java:562)
Evgenii Bazarov
I should also mention that I used weblogic oci816_8 driver on Windows 2000.
I switched to Oracle thin driver just to make sure that driver isn't the issue,
and surprise-surprise the problem was fixed. Since I don't mind using either driver,
I am fine, but you will probably want to investigate the problem further.
Thanks,
Evg