Hello, I tried many examples including the one you mention but keeps dumping the NoSuchMethod error. Of all the classes that I inspected, oracle.jdbc.pool.OracleDataSource is the only one that implements this method. While tracing the error I can see in the source for the XmlConfigurator class that it fails to find the set method of the object. It tries various ways of finding it but fails in each of them. I will have to trace them and maybe I'll be able to find the specific point of failure.
While in that roadblock I decided to let it cool off and try to modify the configuration files in the release version of Webical to se if I can get it to just run as is and connect to Oracle. Interestingly, when Tomcats starts the application context, webical audits the schema. We ran in to an Oracle limitation of 30 characters per table name and because of it we modified the database scripts (perhaps I could post them somewhere) to cope with oracle's expectations. Tables such as "application_settings_plugin_paths" had to be changed to "appl_settings_plugin_paths" and several other tables that used oracle reserved table names had to be renamed. We also created triggers for the autoincrement functions and such. Then while the context starts the audit, it fails to start due to not finding the application_settings_plugin_paths table. I conclude that to make further progress I need to get the dev environment up and running. I may not be able to run the test environment but maybe with the ability to make changes to the hibernate various xmls and compiling the application I will be able to continue. I may need some assistance in how to go about compiling a version that I can deploy in a local Tomcat with the changes I make. I have all the tools set up (Maven, Eclipse, Databases etc) but I'm not too familiarized with Maven yet. I'm thankful if anyone can spare a few minutes of their time to shine a light on this. On Aug 25, 2:34 am, Ivo van Dongen <[email protected]> wrote: > Hi, > > The Wierd thing is that the class seems to hace a setURL method, but no > setUrl as seen in the stackstrace. Somehow jetty is calling the setter > in the wrong case. > > Also are you sure you are using the correct datasource class? I found > this example: > > <New id="DSTest" class="org.mortbay.jetty.plus.naming.Resource"> > <Arg></Arg> > <Arg>jdbc/DSTest</Arg> > <Arg> > <New class="oracle.jdbc.pool.OracleConnectionPoolDataSource"> > <Set name="URL">jdbc:oracle:thin:@localhost:1521:orcl</Set> > <Set name="User">user</Set> > <Set name="Password">pass</Set> > > </New> > </Arg> > </New> > > Regards, > Ivo > > On 8/24/09 7:00 PM, Marks Andre wrote: > > > First interesting roadblock. I'm trying to configure the jetty > > instance in the development environment to use the Oracle jdbc driver > > to connect to the Oracle database and use it as datasource. The > > information I gathered points out that the ojdbc14.jar has the > > necesary classes for this to work. So I configure the jetty.xml as > > follows: > > <New id="calendarDataBase" > > class="org.mortbay.jetty.plus.naming.Resource"> > > <Arg>jdbc/SAICWQC</Arg> > > <New class="oracle.jdbc.pool.OracleDataSource"> > > <Set name="user">dbUsr</Set> > > <Set name="password">dbPass</Set> > > <Set name="URL">jdbc:oracle:thin:@myhostname.com: > > 1521:INSTANCE</Set> > > </New> > > </Arg> > > </New> > > > While starting the jetty server I get the following exception: > > > 2009-08-24 12:25:30,394 ERROR StartWebApplication - > > java.lang.NoSuchMethodException: class > > oracle.jdbc.pool.OracleDataSource.setUrl(class java.lang.String) > > java.lang.NoSuchMethodException: class > > oracle.jdbc.pool.OracleDataSource.setUrl(class java.lang.String) > > at org.mortbay.xml.XmlConfiguration.set(XmlConfiguration.java:411) > > > Interestingly, the setUrl you can clearly see that is implemented in > > the class in question. So far I'm unable to figure out why is not able > > to see the method. > > > I'll have more as it continues. > > On Aug 24, 10:49 am, Marks Andre<[email protected]> wrote: > > >> Good day, > > >> Thanks for your response. As you pointed out I checked the database > >> connection and the SCHEMA name which the database was created with was > >> incorrect. This error would also show up if the MySQL service was down > >> for some reason. I was able to get the environment up and running. The > >> main objective as of right now is implementing interoperability with > >> Oracle with the project functioning as is right now. At the very least > >> I will come up for a guide of the process depending of how complicated > >> the roadblocks I find are. I hope to continue posting more information > >> as it unfolds. > > >> Regards, > > >> On Aug 24, 6:11 am, Ivo van Dongen<[email protected]> wrote: > > >>> Hi, > > >>> Good to hear that the project can be of use to you. If you have > >>> something that can be of use to more users it would certainly be > >>> appreciated. > > >>> Concerning your troubles in setting up a developing environment. I'm > >>> sorry to say that I don't have any spare time atm to help you out and > >>> won't for the coming month. I'm still planning to renew the development > >>> efforts on webical (hopefully supported by some more interested > >>> developers), but right now I have other priorities. > >>> What I can tell you is that the the application context file concerned > >>> defines a bootstrap bean that tries to insert some data in the database > >>> on startup so that the application works in a basic form without further > >>> configuration. The error you get is not really helpful, but it can > >>> indicate any number of issues. I would advise you to check the database > >>> connection, are you sure it is writable and hibernate creates the > >>> correct tables for you? > > >>> If you have any progress or other issues, just post to this list and > >>> I'll try to help you along the best I can. > > >>> Regards, > >>> Ivo > > >>> On 8/21/09 8:24 PM, Marks Andre wrote: > > >>>> Good day all, > > >>>> I'm in the process of integrating Webical in a project and among > >>>> making it fully compatible with oracle10g there will be certanly > >>>> specific changes and modifications. I hope to publish these ventures > >>>> as it further unfolds but I seem to be having a problem initializing > >>>> the development environment. > > >>>> The following exception occurs when starting the development > >>>> environment according to the developers guide: > > >>>> ERROR ContextLoader - Context initialization failed > >>>> org.springframework.beans.factory.BeanCreationException: Error > >>>> creating bean with name 'databaseBootStrapDao' defined in > >>>> ServletContext resource [/WEB-INF/applicationContext-bootstrap.xml]: > >>>> Invocation of init method failed; nested exception is > >>>> org.hibernate.AssertionFailure: null id in > >>>> org.webical.ApplicationSettings entry (don't flush the Session after > >>>> an exception occurs) > >>>> Caused by: > >>>> org.hibernate.AssertionFailure: null id in > >>>> org.webical.ApplicationSettings entry (don't flush the Session after > >>>> an exception occurs) > >>>> at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId > >>>> (DefaultFlushEntityEventListener.java:48) > > >>>> I'm using the Eclipse setup as detailed in the > >>>> DevelopmentEnvironmentSetup Guide. > > >>>> Thanks, --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "webical-developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/webical-developers?hl=en -~----------~----~----~----~------~----~------~--~---
