Using Oracle as juddi db not working in 4.2.1?
berkar Nov 7, 2007 8:46 AMHi!
I have a working installation of 4.2GA that uses oracle 10g as message store and juddi db and tries to update to 4.2.1 now.
I can't find any db scripts as admin guide says (page 11). Only import.sql is available for any of the databases?
When I try to use the 4.2GA version I get an exception on startup. Only a small part is included becauce after this the log fill's up :-)
14:32:04,333 ERROR [FindTModelFunction] java.sql.SQLException: ORA-00904: "LANG_CODE": ogiltig identifierare
14:32:04,333 ERROR [RequestHandler] java.sql.SQLException: ORA-00904: "LANG_CODE": ogiltig identifierare
14:32:04,333 ERROR [STDERR] java.lang.reflect.InvocationTargetException
14:32:04,333 ERROR [STDERR] at org.apache.ws.scout.transport.LocalTransport.send(LocalTransport.java:67)
14:32:04,333 ERROR [STDERR] at org.apache.ws.scout.registry.RegistryImpl.execute(RegistryImpl.java:271)
14:32:04,333 ERROR [STDERR] at org.apache.ws.scout.registry.RegistryImpl.findTModel(RegistryImpl.java:793)
14:32:04,333 ERROR [STDERR] at org.apache.ws.scout.registry.BusinessQueryManagerImpl.findClassificationSchemeByName(BusinessQueryManagerImpl.java:440)
14:32:04,333 ERROR [STDERR] at org.jboss.internal.soa.esb.services.registry.JAXRRegistryImpl.findService(JAXRRegistryImpl.java:488)
14:32:04,333 ERROR [STDERR] at org.jboss.internal.soa.esb.services.registry.JAXRRegistryImpl.registerEPR(JAXRRegistryImpl.java:204)
14:32:04,333 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:32:04,333 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:32:04,333 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:32:04,333 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
14:32:04,333 ERROR [STDERR] at org.jboss.internal.soa.esb.services.registry.RegistryService$1.invoke(RegistryService.java:61)
14:32:04,333 ERROR [STDERR] at $Proxy24.registerEPR(Unknown Source)
Should there be new db scripts or should 4.2 and 4.2.1 be compatible?
BRGDS
/B
PS. the message store has scripts! It's the juddi db scripts that's missing DS.