I wasn't very clear in my first post ;-(
I think this section is ok based on my other configurations for sybase.
<jdbc id="keel-dbpool" activation="request">
<pool-controller max="10" maxStrict="true" blocking="true" timeout="-1"
trim-interval="60000" auto-commit="true" connection-class="org.apache.avalon.excalibur.datasource.JdbcConnection">
<keep-alive disable="false">select 1</keep-alive>
</pool-controller>
<driver>com.sybase.jdbc2.jdbc.SybDriver</driver>
<dburl>jdbc:sybase:Tds:@SERVERNAME@:@DBPORT@/@DBNAME@</dburl>
<user>@USERNAME@</user>
<password>@PASSWORD@</password>
</jdbc>
My problem is that I don't understand what is expected in the following section for Sybase or any other db. This is of course taken from mysql-jdbc-system.xconf
<mysql id="keel-dbtype" activation="startup">
<type from="longvarchar" to="text" prefix="'" suffix="'"/>
</mysql>Perplexed, Steve
Shash Chatterjee wrote:
Steve,
I don't know what is expected from the last tag <[dbname]> ?That would be the name of the DB instance where the Keel tables would be created. The @DBNAME@ is meant to be replaced by the Ant script with Database.dbname property from the *-deploy.properties file. If you are sure, don't bother with that just yet, just hardcode the entire URL you would use to access the DB outside of Keel inside the <dburl>...</dburl> element.
Where do I ensure that my jdbc driver jar will be included in the war file ?
All that need sto happen is that it is in the Keel servers classpath. Sticking it in any modules lib directory will make Ant copy it over. Typically, we put it in keel-server/lib.
HTH, Shash
PS: If you get it working, it'd be great if you wouldn't mind sharing the sybase-jdbc-system.xconf for our repository of samples!
http://keelframework.org/documentation Keelgroup mailing list [EMAIL PROTECTED] http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
http://keelframework.org/documentation Keelgroup mailing list [EMAIL PROTECTED] http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
