Hello, Thanks for the assistance. I managed to package the war and do continuous testing. I believe its progressing quite nicely. At first I was a little confused by the command typos so for future reference to anyone reading, the command I used was:
mvn -D maven.test.skip=true package Now, I've been getting a grasp of hibernate and learning a lot about the configurations and I came across an interesting hurdle that I would like to share. Since I wasn't able to get the development mode running with the Oracle jdbc driver I've been chaging the application little by little and deploying on a local tomcat and pointing to an Oracle development database. Since the Webical project has various configuration files depending for if you're testing or development or production I would like to have a better understanding of how should I configure Webical for the different scenarios (eg. which files to remove or change and maybe the different maven tasks available). The thing is that since I'm sort of treating development testing as production I came across a hibernate configuration that drops certain tables every time the context starts (<prop key="hibernate.hbm2ddl.auto">create</prop>). I found the solution to this which was change the property to "update" but because my development methodology is different perhaps I would need a production- like configuration. I know that my development methodology is not what Webical intends but changing the database type doesn't seem to be as seamless. Perhaps someone could point me in the right direction as to what I would need to change depending on the scenarios (test, QA, Dev, Prod) and maybe what maven tasks to run etc. Thanks for any help and invested time. On Aug 27, 4:22 pm, Ivo van Dongen <[email protected]> wrote: > Hi, > > Skipping the tests is quite easy actually. Just run maven with an extra > option like so: #> mvn -Dmaven/.test.skip///=true package. > > Ivo > > On 8/27/09 8:25 PM, Marks Andre wrote: > > > Hello, > > > Thanks for the tip. It seems what you mention is the right track but I > > face a problem when the tests are run. Since I'm making changes to the > > DAO when the post compilation automatic tests are run they will fail > > (due to the fact that I'm merely just starting to test this > > integration) hence the war file does not get created. I think that I > > merely need to acomplish right now is a repackage of the webical-core > > jar with the changes I make to hibernate and the java classes. I guess > > I could manually edit the files in the jar archive and recompile the > > classes individually but as this may grow I may need to streamline > > development early to avoid any scaling issues. Is there a way to > > disable the tests and just do the repack of the recompiled changes? > > > On Aug 26, 1:27 pm, Ivo van Dongen<[email protected]> wrote: > > >> Hi, > > >> Thanks for the detailed description. I only ogt a minute as I was just > >> about > >> to go out. But compiling a version to run on a local tomcat should be as > >> easy as invoking maven with #> mvn package on the parent level. It will > >> create a war file for you in the webical-war module under the target > >> directory. > > >> Concerning the changes you make. You can send them over so we can evaluate > >> if it are changes that others can benefit from as well. If that's the case > >> I'll add them to the code base. Perhaps you can create a patch with all the > >> needed changes? > > >> Good luck, > >> Ivo > > >> On Wed, Aug 26, 2009 at 5:17 PM, Marks Andre<[email protected]> wrote: > > >>> 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<jdbc%3aoracle%[email protected]> > > >>> : > > >>>>> 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 > > ... > > read more » --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
