Re: Help needed getting BC4J in Jdeveloper to recognize Rowid and Primary Key info in a MySql database

I am aware that JDeveloper does not officially support MySql, but it can be rigged via a jdbc-odbc bridge. I am also aware that there will be some speed issues, but I am not going to worry about those for right now.

I am constrained to use MySql by my ISP as the database and Jdeveloper 9.0.3 because that is waht is available on oracles site. If I could get hold of a previous copy of Jdeveloper (8? or is it 3?) that would be better, but alas, I can't find a free copy for developement purposes.

"AV" <avek_nospam_at_videotron.ca> wrote in message news:<4fKt9.10893$OF3.582421_at_weber.videotron.net>...
> Hi,
>
> mySql by it-self has no PK. Only with InnoDB (or BDB)
> it is possible to define PK. Look at MySql-max-4.x.
> May be it will work.
>
> JDeveloper supports officially only several db, not
> including mysql.
>
> For educational purposes smallest current download from Oracle
> would be personal 8.1.7 - less than 300MB and relatively
> acceptable for low-memory machines. I remember playing
> with 816 personal on P-120MHz and 48M ram. 9i goes on
> several CD (>2G).
>
> AlexV.
>
> "yosarian_espo" <yosarian_espo_at_yahoo.com> wrote in message
> news:d00bb417.0210231825.588952c8_at_posting.google.com...
> > I am walking myself thru the online tutorial in the current release of
> > JDeveloper (9.0.3 Release 2) for creating a BC4J application using the
> > "Business Component Package Wizard". The database I was going to use
> > is a MySql (v 3.23.49) with a few simple tables with data. Each table
> > has a column that is "User Defined Data Type" of ROWID with attributes
> > of primary key, not null and auto Increment.
> >
> > I am able to go thru the entire wizard, but when I run it at the end
> > to get the created business components, I get this error message
> > instead:
> >
> > oracle.jbo.dt.objects.JboException: Entity creation failed for the
> > following Database Object. No primary key attributes and does not
> > support ROWID. Use the Entity Wizard to create the Entity Object.
> >
> > movies
> >
> > void oracle.jbo.dt.objects.JboException.throwException(java.lang.String,
> > oracle.jbo.dt.objects.JboNamedObject, java.lang.Throwable)
> >
> > JboException.java:81
> >
> > void
> oracle.jbo.dt.objects.JboEntity.setUniquelyIdentified(oracle.jbo.dt.objects.
> JboConnection,
> > boolean)
> >
> > JboEntity.java:807
> >
> > oracle.jbo.dt.objects.JboEntity
> >
> oracle.jbo.dt.ui.main.DtuUtil.createEntityFromThread(oracle.jbo.dt.objects.J
> boPackage,
> > java.lang.String, java.lang.String,
> > oracle.jbo.dt.objects.JboConnection, boolean,
> > oracle.jbo.dt.ui.main.dlg.DtuLongOpThread, boolean)
> >
> > DtuUtil.java:604
> >
> > oracle.jbo.dt.objects.JboEntity
> > oracle.jbo.dt.ui.pkg.PKEntityThread.createEntity(java.lang.String,
> > java.lang.String)
> >
> > PKEntityThread.java:342
> >
> > oracle.jbo.dt.objects.JboEntity
> >
> oracle.jbo.dt.ui.pkg.PKEntityThread.createEntity(oracle.jbo.dt.ui.pkg.PKEnti
> tySelection)
> >
> > PKEntityThread.java:277
> >
> > void oracle.jbo.dt.ui.pkg.PKEntityThread.doEntityViewCreation()
> >
> > PKEntityThread.java:221
> >
> > void oracle.jbo.dt.ui.pkg.PKEntityThread.createObjects()
> >
> > PKEntityThread.java:190
> >
> > void oracle.jbo.dt.ui.pkg.PKEntityThread.run()
> >
> > PKEntityThread.java:173
> >
> >
> > Any thoughts anout how to fix this or work around it would be very
> > helpful. Thanks!
Received on Thu Oct 24 2002 - 17:10:12 CEST