users@glassfish.java.net

RE: IBM DB2 Type 4 Driver is supported in GlassFish V2.1 server

From: Martin Gainty <mgainty_at_hotmail.com>
Date: Thu, 12 Mar 2009 14:12:49 -0400

http://www.ibm.com/developerworks/data/library/techarticle/dm-0512kokkat/#features

type4 JDBC driver is packaged as
db2jcc.jar which is referenced from

the Glassfish DataSource configuration file db2_jcc_datasource.xml
which identifies DB2 DataSource as db2_jcc_pool
and references via jndi as jdbc/db2_jcc_resource

assuming we can supply the required DB2 parameters:
        <arg line=" --user ${admin.user}"/>
        <arg line=" --passwordfile '${admin.password.file}'"/>
        <arg line=" --host ${admin.host}"/>
        <arg line=" --port ${admin.port}"/>
        <arg line=" --virtualservers ${appserver.instance}"/>
        <arg line=" --force=true"/>
        <arg line=" --name ${binary.name}"/>
        <arg line=" --upload=true"/>
        <arg line=" --dbvendorname=${dbvendorname}"/>

and we run deploy_common target in /samples/common-ant.xml:

<target name="deploy_common" depends="setup_env, setup_db, configPlatform">
    <echo message="Deploying ${deploy.file}."/>
    <exec executable="${exec.asadmin}" >
        <arg line=" deploy"/>
        <arg line=" --user ${admin.user}"/>
        <arg line=" --passwordfile '${admin.password.file}'"/>
        <arg line=" --host ${admin.host}"/>
        <arg line=" --port ${admin.port}"/>
        <arg line=" --virtualservers ${appserver.instance}"/>
        <arg line=" --force=true"/>
        <arg line=" --name ${binary.name}"/>
        <arg line=" --upload=true"/>
        <arg line=" --dbvendorname=${dbvendorname}"/>
        <arg line="${extraargs.1}"/>
        <arg line="${extraargs.2}"/>
        <arg line="${createTablesArgs}"/>
        <arg line="${deploy.file}"/>
     </exec>
  </target>

is there a DB2 server to test against
?
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.




> Date: Thu, 12 Mar 2009 09:31:45 -0700
> From: John.Clingan_at_Sun.COM
> To: users_at_glassfish.dev.java.net
> Subject: Re: IBM DB2 Type 4 Driver is supported in GlassFish V2.1 server
>
> On 03/12/09 05:23, glassfish_at_javadesktop.org wrote:
> > Recently I came across Sun GlassFish Enterprise Server 2.1 Release Notes of "JDBC Drivers and Databases" supported in Glassfish v2.1(http://docs.sun.com/app/docs/doc/820-4329/gawms?l=en&a=view).
> >
> > I didn't find IBM DB2 Type4 Driver in the table list.
> >
> > Just i want to confirm that IBM DB2 Type 4 Driver is supported in GlassFish V2.1 server?
> > [Message sent by forum member 'rajeshkannacse' (rajeshkannacse)]
> >
> > http://forums.java.net/jive/thread.jspa?messageID=336618
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> > For additional commands, e-mail: users-help_at_glassfish.dev.java.net
> >
> >
> The ones in the matrix are ones that we have actually tested. Note the
> comment below the table:
> "In general, the Enterprise Server 2.1 supports all JDBC drivers that
> meet the Java EE specification."
>
> Hope this helps.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>

_________________________________________________________________
HotmailŪ is up to 70% faster. Now good news travels really fast.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_70faster_032009