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-tp12898330s2369p20079604.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]
