Hey Matt, Well, to put it more succinctly, what are the steps to configure appfuse for *any* DB? I can abstract that for DB2 myself but I don't know what the general approach is for appfuse 2.
Thanks dude... --j mraible wrote: > > On Tue, Oct 21, 2008 at 8:53 AM, jackalista <[EMAIL PROTECTED]> wrote: >> >> Hey Matt, >> >> There's only 1 zip file, so there's no need to combine anything, so no. >> Are you saying that the zip format might be the problem? >> >> Can you tell me the list of steps that need to be performed to allow >> appfuse >> to use DB2? As I'm kind of new to both appfuse 2.x and maven I'm not >> sure >> what all needs to be done. > > I've never used AppFuse 2 with DB2, so I don't have an answer for you. > > Matt > >> >> Thanks man, >> >> --jack >> >> >> mraible wrote: >>> >>> Have you tried combining the zips into a single JAR and installing that? >>> >>> On Mon, Oct 20, 2008 at 4:18 PM, jackalista <[EMAIL PROTECTED]> wrote: >>>> >>>> One more clue: I just checked my repository in ~/.m2/repository and >>>> since I >>>> tried running the mvn install:install-file cmd using both "db2java" and >>>> "db2jcc" as the jdbc.artifactId I have the zip file for the driver in >>>> the >>>> repository under both db2java and db2jcc (in com/ibm). For some reason >>>> it's >>>> not becoming available to the app though; if anyone can see what I'm >>>> doing >>>> wrong I'd love to hear from you. >>>> >>>> --jack >>>> >>>> PS: I tried to do the mvn install:install-file using -Dpackaging=zip, >>>> since >>>> the driver is actually in a zip file rather than a jar but I got a >>>> different >>>> error, it seems pretty clear that the problem is that I'm not correctly >>>> getting the dependency set up with maven (tho I could be wrong...). >>>> Here's >>>> the trace from that: >>>> >>>> [EMAIL PROTECTED]:~/java/ccas/proto/af2.02/src/ccas/web$ mvn >>>> install:install-file >>>> -Dfile=/home/jack/dnlds/java/db2/jdbc.driver/db2java.zip >>>> -DgroupId=com.ibm >>>> -DartifactId=db2jcc -Dversion=3.50.152 -Dpackaging=zip >>>> -DgeneratePom=true >>>> [INFO] Scanning for projects... >>>> [INFO] Searching repository for plugin with prefix: 'install'. >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> [INFO] Building AppFuse Modular Application - Web (Struts 2) >>>> [INFO] task-segment: [install:install-file] (aggregator-style) >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> [INFO] [install:install-file] >>>> [INFO] Installing /home/jack/dnlds/java/db2/jdbc.driver/db2java.zip to >>>> /home/jack/.m2/repository/com/ibm/db2jcc/3.50.152/db2jcc-3.50.152.zip >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> [INFO] BUILD SUCCESSFUL >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> [INFO] Total time: 3 seconds >>>> [INFO] Finished at: Mon Oct 20 17:08:11 GMT-05:00 2008 >>>> [INFO] Final Memory: 10M/94M >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> >>>> >>>> >>>> >>>> [EMAIL PROTECTED]:~/java/ccas/proto/af2.02/src/ccas/web$ mvn jetty:run-war >>>> [INFO] Scanning for projects... >>>> [INFO] Searching repository for plugin with prefix: 'jetty'. >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> [INFO] Building AppFuse Modular Application - Web (Struts 2) >>>> [INFO] task-segment: [jetty:run-war] >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> [INFO] Preparing jetty:run-war >>>> Downloading: >>>> http://repo1.maven.org/maven2/com/ibm/db2java/3.50.152/db2java-3.50.152.jar >>>> Downloading: >>>> http://static.appfuse.org/repository/com/ibm/db2java/3.50.152/db2java-3.50.152.jar >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> [ERROR] BUILD ERROR >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> [INFO] Failed to resolve artifact. >>>> >>>> Missing: >>>> ---------- >>>> 1) com.ibm:db2java:jar:3.50.152 >>>> >>>> Try downloading the file manually from the project website. >>>> >>>> Then, install it using the command: >>>> mvn install:install-file -DgroupId=com.ibm -DartifactId=db2java >>>> -Dversion=3.50.152 -Dpackaging=jar -Dfile=/path/to/file >>>> >>>> Alternatively, if you host your own repository you can deploy the file >>>> there: >>>> mvn deploy:deploy-file -DgroupId=com.ibm -DartifactId=db2java >>>> -Dversion=3.50.152 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url] >>>> -DrepositoryId=[id] >>>> >>>> Path to dependency: >>>> 1) com.hbc.ccas:ccas-webapp:war:1.0-SNAPSHOT >>>> 2) com.ibm:db2java:jar:3.50.152 >>>> >>>> ---------- >>>> 1 required artifact is missing. >>>> >>>> for artifact: >>>> com.hbc.ccas:ccas-webapp:war:1.0-SNAPSHOT >>>> >>>> from the specified remote repositories: >>>> central (http://repo1.maven.org/maven2), >>>> appfuse (http://static.appfuse.org/repository) >>>> >>>> >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> [INFO] For more information, run Maven with the -e switch >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> [INFO] Total time: 5 seconds >>>> [INFO] Finished at: Mon Oct 20 17:08:52 GMT-05:00 2008 >>>> [INFO] Final Memory: 16M/118M >>>> [INFO] >>>> ------------------------------------------------------------------------ >>>> >>>> >>>> >>>> >>>> >>>> jackalista wrote: >>>>> >>>>> I tried running mvn jetty:run-war after adding the profile below to my >>>>> top >>>>> level pom.xml and also changing the settings at the bottom of the >>>>> pom.xml >>>>> in the section titled "<!-- Database settings -->". I got an >>>>> UnsatisfiedLinkError that makes it look like even though the mvn >>>>> install:install-file command succeeded the zip file for the driver >>>>> doesn't >>>>> appear to be available to the app. If anyone knows what's wrong with >>>>> this >>>>> picture I'd appreciate hearing from you. Here's the error I got >>>>> running >>>>> mvn jetty:run-war: >>>>> >>>>> [EMAIL PROTECTED]:~/java/fooapp/web$ mvn jetty:run-war >>>>> [INFO] Scanning for projects... >>>>> [INFO] Searching repository for plugin with prefix: 'jetty'. >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] Building AppFuse Modular Application - Web (Struts 2) >>>>> [INFO] task-segment: [jetty:run-war] >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] Preparing jetty:run-war >>>>> [INFO] [warpath:add-classes {execution: default}] >>>>> [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}] >>>>> [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}] >>>>> [INFO] [resources:resources] >>>>> [INFO] Using default encoding to copy filtered resources. >>>>> [INFO] [compiler:compile] >>>>> [INFO] Compiling 1 source file to >>>>> /home/jack/java/fooapp/web/target/classes >>>>> [INFO] [resources:testResources] >>>>> [INFO] Using default encoding to copy filtered resources. >>>>> [INFO] [compiler:testCompile] >>>>> [INFO] Compiling 1 source file to >>>>> /home/jack/java/fooapp/web/target/test-classes >>>>> [INFO] [dbunit:operation {execution: test-compile}] >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [ERROR] BUILD ERROR >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] Error executing database operation: CLEAN_INSERT >>>>> >>>>> Embedded error: java.lang.UnsatisfiedLinkError: no db2jdbc in >>>>> java.library.path >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] For more information, run Maven with the -e switch >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> [INFO] Total time: 10 seconds >>>>> [INFO] Finished at: Mon Oct 20 16:47:09 GMT-05:00 2008 >>>>> [INFO] Final Memory: 19M/121M >>>>> [INFO] >>>>> ------------------------------------------------------------------------ >>>>> >>>>> >>>>> I have a feeling this is merely maven cluelessness, does anyone see >>>>> what >>>>> I'm doing wrong? >>>>> >>>>> Thanks... >>>>> >>>>> --jack >>>>> >>>>> >>>>> >>>>> jackalista wrote: >>>>>> >>>>>> I'm piecing together the profile for DB2, if someone would comment >>>>>> and >>>>>> help me tweak this I'd appreciate it. I'm trying to put together >>>>>> some >>>>>> code in a hurry to do some performance testing and need to do it >>>>>> against >>>>>> DB2. I'm hoping to use appfuse on this project so I need to figure >>>>>> out >>>>>> how to set appfuse up to use DB2. We're using DB2 version 9.5, the >>>>>> driver is in a zip file called db2java.zip. >>>>>> >>>>>> Here's the profile I've got so far, can anyone take a look at this >>>>>> and >>>>>> tell me if it's correct?: >>>>>> >>>>>> <profile> >>>>>> <id>db2</id> >>>>>> <properties> >>>>>> >>>>>> <hibernate.dialect>org.hibernate.dialect.DB2Dialect</hibernate.dialect> >>>>>> <jdbc.groupId>com.ibm</jdbc.groupId> >>>>>> <jdbc.artifactId>db2jcc</jdbc.artifactId> >>>>>> <jdbc.version>3.50.152</jdbc.version> >>>>>> >>>>>> <jdbc.driverClassName>COM.ibm.db2.jdbc.app.DB2Driver</jdbc.driverClassName> >>>>>> >>>>>> <jdbc.url><![CDATA[jdbc:db2://myhost:50000/mydb]]></jdbc.url> >>>>>> <jdbc.username>foo</jdbc.username> >>>>>> <jdbc.password>bar</jdbc.password> >>>>>> </properties> >>>>>> </profile> >>>>>> >>>>>> The part I'm not sure about are the artifactId. I seems like it >>>>>> should >>>>>> either be db2jcc or db2java, I'm not sure which is right. I tried >>>>>> running the following command and it succeeded, so thta may confirm >>>>>> that >>>>>> db2jcc is correct, but as I'm pretty new to maven I'm not too sure. >>>>>> Here's the command: >>>>>> >>>>>> mvn install:install-file >>>>>> -Dfile=/home/jack/dnlds/java/db2/jdbc.driver/db2java.zip >>>>>> -DgroupId=com.ibm -DartifactId=db2jcc -Dversion=3.50.152 >>>>>> -Dpackaging=jar >>>>>> -DgeneratePom=true >>>>>> >>>>>> If anyone would help me figure out if this is the right approach, I'd >>>>>> be >>>>>> very grateful, tia... >>>>>> >>>>>> --jack >>>>>> >>>>>> >>>>>> >>>>>> jackalista wrote: >>>>>>> >>>>>>> I'm trying to run down how to configure appfuse to use DB2 so am >>>>>>> finding >>>>>>> a;ll these threads. DB2 *does* have a single zip file for version >>>>>>> 9.5 >>>>>>> of the DB. >>>>>>> >>>>>>> What I'm not so clear on is how to set this up. Do I need to create >>>>>>> a >>>>>>> profile in the top pom.xml? What other steps are involved? I'm >>>>>>> seeing >>>>>>> info but some of it appears irrelevant (like the comments about >>>>>>> multiple >>>>>>> jars for the jdbc driver, for ex.). Is there a list that explains >>>>>>> how >>>>>>> to integrate a DB? >>>>>>> >>>>>>> Here's what appears to be the necessary steps: >>>>>>> >>>>>>> 1. create a profile for DB2 >>>>>>> 2. somehow import the jar (actally a zip file in this case) into my >>>>>>> project >>>>>>> 3. set up hibernate to use the DB2 dialect (and where is this now? >>>>>>> I'm >>>>>>> also semi new to appfuse 2.x) >>>>>>> >>>>>>> Is that the correct set of steps? Is the complete process spelled >>>>>>> out >>>>>>> anywhere? >>>>>>> >>>>>>> thanks... >>>>>>> >>>>>>> --j >>>>>>> >>>>>>> >>>>>>> >>>>>>> mraible wrote: >>>>>>>> >>>>>>>> You should be able to. I've tried to use the Derby Driver with DB2, >>>>>>>> but it didn't work. The main issue we've had in adding DB2 support >>>>>>>> is >>>>>>>> the fact that it requires multiple JARs for its JDBC Driver. If you >>>>>>>> can find a single JAR/artifact we can use, we'd be happy to add >>>>>>>> support. In the meantime, there's two things you can do: >>>>>>>> >>>>>>>> 1. Replace all references to jdbc.* dependencies with the two >>>>>>>> depdendencies that DB2 requires in pom.xml. >>>>>>>> >>>>>>>> 2. Create a pom that has a dependency on the two DB2 artifacts and >>>>>>>> install it in your local repository. >>>>>>>> >>>>>>>> See the following entry (and comments) on my blog for more >>>>>>>> solutions: >>>>>>>> >>>>>>>> http://raibledesigns.com/rd/entry/database_profiles_in_appfuse_2 >>>>>>>> >>>>>>>> Matt >>>>>>>> >>>>>>>> On 9/26/07, meisam4910 <[EMAIL PROTECTED]> wrote: >>>>>>>>> >>>>>>>>> does Appfuse work with IBM DB2 ? in its database list i could not >>>>>>>>> found the >>>>>>>>> DB2 name :(( is there any way to use DB2 with appfuse ? >>>>>>>>> -- >>>>>>>>> View this message in context: >>>>>>>>> http://www.nabble.com/IBM-DB2-tf4521471s2369.html#a12898330 >>>>>>>>> Sent from the AppFuse - User mailing list archive at Nabble.com. >>>>>>>>> >>>>>>>>> --------------------------------------------------------------------- >>>>>>>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>>>>>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> http://raibledesigns.com >>>>>>>> >>>>>>>> --------------------------------------------------------------------- >>>>>>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>>>>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> -- >>>> View this message in context: >>>> http://www.nabble.com/IBM-DB2-tp12898330s2369p20079950.html >>>> Sent from the AppFuse - User mailing list archive at Nabble.com. >>>> >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>> >>>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>> For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >>> >> >> -- >> View this message in context: >> http://www.nabble.com/IBM-DB2-tp12898330s2369p20092017.html >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/IBM-DB2-tp12898330s2369p20099668.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
