🚀 go-pugleaf

Tom Butler wrote:

> Need help getting JNDI MySQL database source setup correctly within JBuilder
> 2006 to support a JSF application.   I am able to access the database using
> a non-JNDI based approach, and, I was also able to get JNDI to work outside
> of JBuilder 2006 using the configuration described below.
> 
> I am using the following tomcat documentation as a guide:
> http://tomcat.apache.org/tomcat-5.5-doc/jndi-resources-howto.html
> 
> I have looked through a number of posts and examples, but at this point
> (after many non-frutile hours) need someone with experience to help me to
> get the configuration correct.
> 
> 1.  Install JDBC Driver
>     *  have 'mysql-connector-java-3.1.11-bin.jar' installed to
> /myapp/webmodule/WEB-INF/lib

No, you don't manage this; JBuilder does.  As noted five
gazillion times in these newsgroups, you create a JBuilder
library (see JBuilder Help if you don't know how to do this)
and add it to your project.  You configure your Web Module to
copy all resources.  Read the JBuilder Help on developing
Web apps and all about Web Module configuration. Note the
Content > Dependencies page in the Web Module properties
dialog.  (By default, your "required libraries" are set to
"Include all" which is what you want.)  Use the samples/jsf/
Tomcat/bookstore.jpx Web module as a learning tool.

>     * also have JDBC driver installed to
> /JBuilder2006/thirdparty/jakarta-tomcat-5.5.9/common/lib (this was done as a
> troubleshooting step though; prefer to only install this within the project
> directory)

No, don't put the driver lib in the thirdparty dirs.

> 
> 2.  Declare your Resource Requirements
>   *  following code included in web.xml within project:
> /myapp/webmodule/WEB-INF/web.xml
>   <resource-ref>
>     <description>MySQL DB Connection</description>
>     <res-ref-name>jdbc/mysql</res-ref-name>
>     <res-type>javax.sql.DataSource</res-type>
>     <res-auth>Container</res-auth>
>   </resource-ref>

This is correct.

> [...]
> 4. Configure Tomcat's Resource Factory
>    * context.xml contents located at:
> /JBuilder2006/thirdparty/jakarta-tomcat-5.5.9/conf/context.xml
 > [...]

JBuilder manages Tomcat runs, so I doubt that monkeying
with the thirdparty directory XML files will get you where
you want to go.  In general, don't touch those.

> [...] 
> ANY SUGGESTIONS?
> * Do I need anything specified in the server.xml file?

Yes, isn't that the place where you generally place the
resource definition?  I just opened up the JBuilder/samples/
jsf/Tomcat/bookstore.jpx and tested using Tomcat 5.5.  Do
this yourself, and run the "Server" runtime config.  Then
while the Web app is running, do a "File open" in JBuilder,
navigate to the "Project" dir via the "Favorites" panel
on the left.  Click on the "Tomcat/conf" dir, and open
the server8080.xml file.  From here on in, I'll ask you
to do some research: following the generously available
instructions in the newsgroup archives on editing "server8080.xml" 
(search keywords "edit server8080 tomcat"), edit the file, adding
your <Resource ...> definition.


-- 


Paul Furbacher (TeamB)

   Save time, search the archives:
        http://info.borland.com/newsgroups/ngsearch.html

   Is it in Joi Ellis's Faq-O-Matic?
        http://www.visi.com/~gyles19/fom-serve/cache/1.html

   Finally, please send responses to the newsgroup only.
   That means, do not send email directly to me.
   Thank you.