Nazri
|
| Posted: 08/27/2002, 6:57 AM |
|
Hi,
I am going thru the provided tutorial using JSP/servlet, but I am encountering some challenhes in the database access part.
Since the provided database (intranetDB) is MS Access, how can I connect from Java? What JDBC driver I should use? Some sample codes & the connection string will be helpful.
Better yet, does anybody has the db structure & data of intranetDB (and internetDB) for mySQL?
Thanks
|
|
|
 |
Rick
|
| Posted: 08/28/2002, 5:10 AM |
|
Hello,
here is sample for server side connection for ODBC:
Dabase URL: jdbc:odbc:DSN_name
Database Driver: sun.jdbc.odbc.JdbcOdbcDriver
Note, that you should create dsn for Access db on server.
You'll find sql script for creating mysql tables for intranet and internet databases in ..\CodeChargeStudio\Examples\Intranet (or Internet) folders.
Connection settings for mysql db are:
Database URL: jdbc:mysql://<host>/<database>
Database Driver: org.gjt.mm.mysql.Driver
|
|
|
|
xbill
|
| Posted: 08/28/2002, 7:30 AM |
|
You can also use the "MyODBC" native ODBC to
mysql driver to configure the design database.
Just use the windows ODBC setup tool along with
the MyODBC drivers to configure a connection.
There is also a new beta JDBC connector on
the mysql site.
The JDBC connect string changes with this driver
to : com.mysql.jdbc.Driver
Both the MYODBC and the Java Connector are available
on the mysql site: http://www.mysql.com
When deploying- make sure to put the JDBC driver
jar file in the CLASSPATH of the servlet container.
There is a good setup document on the CCS studio
site that steps through JSP/Servlet setup.
-bill
|
|
|
|
|
