Hi Martin,
seems to be a postgreSQL specific bug in AutoCreatorDb or in one of the
crossDB classes. I think the used crossDB.jar does not support
postgreSQL
database.
Davide Mora currently working on the auto-create feature and try to make
it run with most common databases.
regards,
Armin
----- Original Message -----
From: "Martin Burger" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 11:00 AM
Subject: Re: parse error at or near "auto_increment"
>
> Tuesday, January 7, 2003, 10:33, you wrote:
>
> > DBMS:PostgreSQL
> > DRIVER: org.postgresql.Driver
> > PROTOCOL: jdbc
> > SUBPROTOCOL: postgresql
> > DBALIAS: file://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: file://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]>
>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
