How do I use Sybase as a pluggable store?
I tried to use a Sybase database for pluggable persistence, but could not create
the required tables.
I created a Sybase login/password for jmq, created a database within the dataserver,
changed that database to ownership by jmq's login, set the default for that login
to that database, and modified the appropriate fields in the file
$JMQ_VARHOME/stores/jmqbroker/props/config.properties.
After all of this, I got this:
$JMQ_HOME/bin/jmqdbmgr create tbl
[23/Jan/2002:10:31:30 EST] Using plugged in persistent store:
database connection url=jdbc:sybase:Tds:129.148.173.180:4100
brokerid=BRK01
[23/Jan/2002:10:31:31 EST] ERROR [B3073]: Failed to create database tables -
jdbc:sybase:Tds:129.148.173.180:4100:
com.sybase.jdbc.SybSQLException: The definition for column 'RECORDTIME' must include a datatype.
I tried this without specifying 'jmq.persist.jdbc.brokerid' in the config.properties file,
then got the same end result without the 'database connection' info:
$JMQ_HOME/bin/jmqdbmgr create tbl
[23/Jan/2002:10:25:51 EST] ERROR [B3073]: Failed to create database tables -
jdbc:sybase:Tds:129.148.173.180:4100:
com.sybase.jdbc.SybSQLException: The definition for column 'RECORDTIME' must include a datatype.
I tried Sybase jdbc drivers (jconnect) v3.0, v4.1, v5.0, and v5.2, all with the same result.
Looks like pluggable persistence using Sybase just can't be configured.
