cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <DHo...@csir.co.za>
Subject Re: MS Access Driver!!!
Date Tue, 16 Apr 2002 14:28:31 GMT
And to add - combine mySQL with the wonderful dbTools package
 import your m$access files in one swift swoop - then....
delete them!!) and you have all you need !

See: http://www.dbtools.com.br/

>>> bloritsch@apache.org 16/04/2002 02:54:17 >>>
Faulkner, Perry wrote:
> Muhammad,
> 
> Your original post was that you had jdbc:odbc: - not jdbc.odbc., so
your
> missing more than just "sun." in the web.xml! It is a java package
and class
> reference.
> 
> In coccon.xconf you should have something similar to:
> 
>     <jdbc name="mydb">
>       <auto-commit>false</auto-commit>
>       <dburl>jdbc:odbc:mydatabase</dburl>
>       <user>uuuu</user>
>       <password>ppppp</password>
>     </jdbc>
> 
> Note: that this needs the ":" and is NOT a class reference!
> 


Rewrite that to:

<jdbc name="mydb">
   <auto-commit>false</auto-commit> <!-- may fail with some drivers
-->
   <driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
   <dburl>jdbc:odbc:mydatabase</dburl>
   <!-- username/password is not necessary with MS Access -->
</jdbc>

Ladies in gentlemen, I provided this so you can see the proper markup
for the <jdbc> entry.  I do not advocate the use of the Jdbc/Odbc
bridge driver at all--esp. in regards to MS Access.

You can install MySQL on windows for a real database that does not
cost any money for development.


-- 

"They that give up essential liberty to obtain a little temporary
safety
  deserve neither liberty nor safety."
                 - Benjamin Franklin


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message