Tuesday, January 7, 2003, 10:33, you wrote:
> DBMS:PostgreSQL
> DRIVER: org.postgresql.Driver
> PROTOCOL: jdbc
> SUBPROTOCOL: postgresql
> DBALIAS: //134.z.y.x/xyz
> USERNAME: foo
> PASSWORD: bar
> EAGER RELEASE: false
> pool configuration was: {whenExhaustedAction=0, maxIdle=-1, maxActive=21,
>maxWait=5000, numTestsPerEvictionRun=10, testWhileIdle=false, testOnReturn=false,
>timeBetweenEvictionRunsMillis=-1,
> minEvictableIdleIimeMillis=600000, testOnBorrow=true}
> [org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table
>[OJB_DLIST_ENTRIES]
> java.sql.SQLException: ERROR: parser: parse error at or near "auto_increment"
The trying above was made with
PostgreSQL version 7.2.1 &
pg73jdbc3.jar
.
With
MySQL version 3.23.49 &
mysql-connector-java-2.0.14-bin.jar
it works as expected:
Initializing Broker
[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Create
PersistenceBroker instance pool, pool configuration was {whenExhaustedAction=0,
maxIdle=-1, maxActive=100, maxWait=2000, numTestsPerEvictionRun=10,
testWhileIdle=false, testOnReturn=false, timeBetweenEvictionRunsMillis=-1,
minEvictableIdleIimeMillis=600000, testOnBorrow=false}
[org.apache.ojb.broker.util.sequence.SequenceManagerFactory] INFO: Use sequence
manager class: class org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl
[org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: Create
connection pool for JdbcDescriptorKey -22398581
[org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: Create new
connection pool for org.apache.ojb.broker.metadata.JdbcConnectionDescriptor,
used descriptor: JdbcConnectionDescriptor
DBMS:PostgreSQL
DRIVER: com.mysql.jdbc.Driver
PROTOCOL: jdbc
SUBPROTOCOL: mysql
DBALIAS: //134.z.y.x/xyz
USERNAME: foo
PASSWORD: bar
EAGER RELEASE: false
pool configuration was: {whenExhaustedAction=0, maxIdle=-1, maxActive=21,
maxWait=5000, numTestsPerEvictionRun=10, testWhileIdle=false, testOnReturn=false,
timeBetweenEvictionRunsMillis=-1, minEvictableIdleIimeMillis=600000, testOnBorrow=true}
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table
[OJB_DLIST_ENTRIES]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table [OJB_DMAP]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table [OJB_DSET]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table [OJB_DLIST]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table [OJB_HL_SEQ]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table [USERGROUP]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table [USERS]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table [POOL]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table
[OJB_DMAP_ENTRIES]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table [OJB_NRM]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table
[OJB_LOCKENTRY]
[org.apache.ojb.broker.metadata.auto.AutoCreatorDb] INFO: Creating table
[OJB_DSET_ENTRIES]
Initializing Broker: DONE
Both RDBMS are running on the same machine w/ Debian GNU/Linux 3.0.
Regards,
Martin Burger
--
>> netbeyond
D. Barth & M. Burger GbR
Im Stadtwald, Geb�ude 34.2
66123 S a a r b r � c k e n
Tel. : +49 (0)700 netbeyond
+49 (0)700 63 82 39 66
Fax : +49 (0)681 3 02 63 84
Mail : [EMAIL PROTECTED]
Web : www.netbeyond.de
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
