|
From: Colin B. <col...@bi...> - 2003-11-05 10:55:35
|
Hi Stephen, I've moved this message to the user list as somebody else may have ecperience with the simple text driver. On Fri, 2003-10-31 at 09:01, SM...@em... wrote: > In the SQuirreL SQL Client I am trying to use a JDBC Driver that reads and > writes Flat Files: > http://www.thoughtinc.com/simpletext.html > > ( I have already submitted a bug fix to thoughtinc. ) > > This JDBC driver looks for a property called "Directory". > > How can I pass a directory property through SQuirreL SQL Client to this JDBC > Driver when creating an alias ? In 1.2beta4 you can specify driver properties in the alias definition. This only works for JDBC drivers that can be interrogated for their properties, I don't know if this will work with the Simple Text driver. If it doesn't you can probably pass the property in the URL string, you'll need to check the driver documentation to see the syntax. In MySQL for example you can pass properties using ? and & jdbc:mysql://<hostname>[,<failoverhost>][<:3306>]/<dbname>[?<param1>=<value1>][&<param2>=<value2>] Something similar may work for the Simple text driver. > Is there a test to see if this Driver meets the JDBC 2.0 specification ? I'm pretty sure that Sun make a test suite for JDBC drivers. Try a search on the javaSoft site. -- Colin Bell http://squirrel-sql.sf.net |
