9 Replies Latest reply on Nov 21, 2007 9:24 AM by Noel Rocher

    Using Oracle as juddi db not working in 4.2.1?

    Bertil Karlsson Newbie

      Hi!

      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.

        • 1. Re: Using Oracle as juddi db not working in 4.2.1?
          Daniel Bevenius Master

          Hi,

          just wanted to make sure the you have modified the esb.juddi.xml to match your datebase:

          <!-- jUDDI database creation -->
           <entry key="juddi.isCreateDatabase">true</entry>
           <entry key="juddi.databaseExistsSql">select * from BUSINESS_ENTITY</entry>
           <entry key="juddi.sqlFiles">juddi-sql/hsqldb/create_database.sql,juddi-sql/hsqldb/import.sql</entry>
          


          You are right about there only being import scripts in the jbossesb.sar/udd-sql folder. The create_database scripts are located in jbossesb.sar/lib/juddi-20071022.191630-27.jar

          Regards,

          /Daniel

          • 2. Re: Using Oracle as juddi db not working in 4.2.1?
            Bertil Karlsson Newbie

            Jepp! That's the way it looks!

            BTW, if i start with an empty oracle database i get another exception:


            15:15:08,036 INFO [DatabaseInitializer] Initializing java:/VicNatur-esb from listed sql files
            15:15:08,052 WARN [ServiceController] Problem starting service jboss.esb:service=MessageStoreDatabaseInitializer
            java.sql.SQLException: ORA-00906: võnster parentes saknas

            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
            at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
            at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
            at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
            at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
            at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
            at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:186)
            at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:129)
            at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:111)
            at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:143)
            at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
            at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
            at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)


            I thought I could live with that if I got the manual version to work ;-)

            BRGDS

            /B

            PS.
            I see that your swedish so i don't need to translate i guess, but for all you others, it says 'missing left parenthesis' ...
            DS.

            • 3. Re: Using Oracle as juddi db not working in 4.2.1?
              Bertil Karlsson Newbie

              Stop the presses!

              It seems that my last post was related to the message store!

              Now it starts without errors reported. What did I do?

              1. Manual create with the juddi scripts in the jar

              2. Manual create of message store table

              Now I only have to verify that it works to ...

              ;-)

              • 4. Re: Using Oracle as juddi db not working in 4.2.1?
                Daniel Bevenius Master

                Hi Bertil,

                good news that if might be working:) But you should not have to create the tables manually :(

                Could you paste your esb.uddi.xml just in case someone here can spot anything odd?

                Thanks,

                Daniel

                • 5. Re: Using Oracle as juddi db not working in 4.2.1?
                  Bertil Karlsson Newbie

                  Sure! Actually the only thing I have touched is the datasource name. Which in my case points to a no-tx-datasource (oracle 10g).

                  But it seems as if i'm to stupid to figure out how to paste xml in a readable way in to this forum?? Neither as-is, &gt;/&lt; or quote works.

                  At least not in preview mode ...

                  How do I do it?

                  /B

                  PS. I do not have 'Disable HTML ...' selected DS.

                  • 6. Re: Using Oracle as juddi db not working in 4.2.1?
                    Kurt Stam Master

                    You use the 'Post Reply' button. Then you get more options like "Quote" or "Code". I think either one of them will work.

                    BTW when you switched jUDDI over to oracle, did you change the esb.uddi.xml to point to the oracle scripts? This setting I mean

                    <entry key="juddi.sqlFiles">juddi-sql/hsqldb/create_database.sql,juddi-sql/hsqldb/import.sql</entry>
                    


                    Change 'hsqldb' to 'oracle'.

                    Hope that helps,

                    --Kurt

                    • 7. Re: Using Oracle as juddi db not working in 4.2.1?
                      toby saville Novice

                      Hi,

                      For anyone that gets the "missing left parenthesis" error when auto generating the message store tables, the answer is to change the SqlFiles path to be your be your database, in the file deploy\jbossesb.esb\jbossesb-service.xml

                      cheers,
                      Toby

                      • 8. Re: Using Oracle as juddi db not working in 4.2.1?
                        Bertil Karlsson Newbie

                        Thank you guys!

                        Now both the juddi & the message store works fine.

                        I saw that part in the conf files but you guys are doing such a great job so I assumed you were doing some 'magic' there, like replacing it with the database found or something, sorry :-)

                        Now I have only to get the JBossMessaging 1.4.0.SP1 to behave also, but that's another forum ... perhaps I'm assuming to much again ;-)

                        Regards

                        /B

                        • 9. Re: Using Oracle as juddi db not working in 4.2.1?
                          Noel Rocher Apprentice

                          Just to let you know that I was able to set up ESB 4.2.1 on JBoss AS 4.2.2 (conf "all") with JBoss Messaging 1.4.0SP1 (waiting for SP2 as all jira are closed) with an Oracle Database for juddi/message-store/jBPM/JBM. I've prefixed all tables with "ESB_" except for jBPM. Moreover, I've used the binding manager to run several instance on one physical server.

                          I haven't tested it very much yet. Even, I don't know if this will is a good idea as the supported platform should be the target.

                          But I can say that it works ;)