Hi Martin ,
are you using the sources from the CVS or the
distribution?
I had the same error using mssql, i fixed the problem
and now should work ok with the cvs version.
Let me know,
Davide
--- Armin Waibel <[EMAIL PROTECTED]> wrote:
> 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]>
>
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
