Raible's Wiki: AppFuseWSAD

-       Raible's Wiki




    Raible Designs

Wiki Home

News

Recent Changes

AppFuse
Homepage

  -  Korean

  -  Chinese

  -  Italian

  -  Japanese

QuickStart Guide

  - Chinese
 
  - French

  - German

  - Italian

  - Korean

  - Portuguese

  - Spanish

  - Japanese


User Guide

  - Korean

  - Chinese
 

Tutorials

  -  Chinese

  -  German

  -  Italian

  -  Korean

  -  Portuguese

  -  Spanish


FAQ

  -  Korean


Latest Downloads

Other Applications
Struts Resume

Security Example

Struts Menu



    




    

    
         
        Set your name in

        UserPreferences
            
    





       
       
       
       




    

Referenced by

...nobody


    




   



   
   JSPWiki v2.2.33 
   



       
           

           

           
           
           


           Hide Menu
+            AppFuseWSAD
            



  
    Search Wiki:
    
    
  



         
         
            Your trail: 
         
      

      


      

      
         



      
          Difference between 
          version 6 
          and 
          version 5:
          

          
At line 42 added 56 lines.
!MySQL Datasource in WSAD/WAS
Borrowed from:

http://www.webspherepower.com/issues/issue200403/00001236001.html



JDBC Provider
{{{

# Name: MySQL

# Description: MySQL JDBC 2.0-compliant Provider configuration

# Classpath: ${User-defined_JDBC_DRIVER_PATH}/mysql-connector-java-3.1.7-bin.jar (or the appropriate name for the version of MySQL Connector/J that you are using)

# Native Library Path: <leave blank>

# Implementation Classname: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource



Data source (defined in the JDBC provider selected above)

# Name: <data source name>

# JNDI (Java Naming and Directory Interface) Name: jdbc/<data source name>

# Description: <data source description>

# Statement Cache Size: 10 (the default)

# Category: <leave blank>

# Datasource Helper Classname: com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper

# Component-managed Authentication Alias: <leave blank>

# Container-managed Authentication Alias: <leave blank>



Resource Properties (defined in the data source selected above)

databaseName 	java.lang.String 	<database-name>?autoReconnect=true&useUnicode=true&characterEncoding=utf-8

factory 	java.lang.String 	com.mysql.jdbc.jdbc2.optional.MysqlDataSourceFactory

password 	java.lang.String 	<password>

port 		java.lang.String 	3306 (or your MySQL port, if you have changed it)

serverName 	java.lang.String 	<server-name>

user 		java.lang.String 	<user-name>
}}}


          

      

      

      
      Back to AppFuseWSAD,
       or to the Page History.
       

      

      

      

      

      

      

      

      Show Menu
-AppFuseWSAD
+    Search Wiki:
 At line 42 added 56 lines.
+!MySQL Datasource in WSAD/WAS
+Borrowed from:
+http://www.webspherepower.com/issues/issue200403/00001236001.html
+JDBC Provider
+{{{
+# Name: MySQL
+# Description: MySQL JDBC 2.0-compliant Provider configuration
+# Classpath: ${User-defined_JDBC_DRIVER_PATH}/mysql-connector-java-3.1.7-bin.jar (or the appropriate name for the version of MySQL Connector/J that you are using)
+# Native Library Path: <leave blank>
+# Implementation Classname: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
+Data source (defined in the JDBC provider selected above)
+# Name: <data source name>
+# JNDI (Java Naming and Directory Interface) Name: jdbc/<data source name>
+# Description: <data source description>
+# Statement Cache Size: 10 (the default)
+# Category: <leave blank>
+# Datasource Helper Classname: com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper
+# Component-managed Authentication Alias: <leave blank>
+# Container-managed Authentication Alias: <leave blank>
+Resource Properties (defined in the data source selected above)
+databaseName 	java.lang.String 	<database-name>?autoReconnect=true&useUnicode=true&characterEncoding=utf-8
+factory 	java.lang.String 	com.mysql.jdbc.jdbc2.optional.MysqlDataSourceFactory
+password 	java.lang.String 	<password>
+port 		java.lang.String 	3306 (or your MySQL port, if you have changed it)
+serverName 	java.lang.String 	<server-name>
+user 		java.lang.String 	<user-name>
+}}}