Hi
I'm just a beginer in development with Sun App Server 9. With JBoss I could just put DB driver in lib directory of server instance but in manuals on Sun server I didn't find information about it, though it's written much about configuring connection pools and resources. So how can I install a JDBC driver on Sun App Server 9 or where can I read about it?
thanks
Straiver
MMMySQLType 4 Driver (XAOnly)
The JAR file for the MySQLdriver is mysql-connector-java-version-bin-g.jar, for example,
mysql-connector-java-3.1.12-bin-g.jar. Configure the connection pool using the following
settings:
Name: Use this name when you configure the JDBC resource later.
Resource Type: Specify the appropriate value.
DatabaseVendor: mysql
DataSource Classname: Specify one of the following:
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
Properties:
serverName - Specify the host name or IP address of the database server.
port - Specify the port number of the database server.
user - Set as appropriate.
password - Set as appropriate.
databaseName - Set as appropriate.
URL - If you are using global transactions, you can set this property instead of serverName,
port, and databaseName.
TheMMMySQLType 4 driver doesn抰 provide a method to set the required
relaxAutoCommit property, so you must set it indirectly by setting the URL property:
jdbc:mysql://host:port/database?relaxAutoCommit="true"
You can place the jar for the driver in $AS_HOME/lib or $AS_HOME/domains/domain1/lib/ext
Or you can add it explictly to the classpath via the CLI or admin gui.
Following page in developer guide has information about creating jdbc-resource, connection-pool, making the jdbc driver available for app.server
http://docs.sun.com/app/docs/doc/819-3659/6n5s6m5bn?a=view#beamn
Typical configurations for various jdbc-drivers can be found at
http://docs.sun.com/app/docs/doc/819-3658/6n5s5nklf?a=view
Thanks,
-Jagadish
