Re: EO_PK_TABLE not being created
David Avendasora <[email protected]> Mon, 5 Sep 2011 10:40:54 +0800
| Newsgroups | gmane.comp.web.webobjects.woproject.devel |
|---|---|
| Message-ID | <[email protected]> |
--Apple-Mail-2--271673195 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii It would be cool if Migrations would add the table automatically, like it do= es the _dbupdate table. Also, it would be handy if it would make the length= of the Entity name longer than 31? Characters. Not all RDBS are as irritati= ng as Oracle. I like long, very clear entity names and have had to modify th= e length of the field before. Dave On Sep 5, 2011, at 10:17 AM, Kieran Kelleher <[email protected]> wrote: > Just create the EO_PK_TABLE yourself ...... your error is probably caused b= y the user/password not having privileges to create the missing table on the= first attempt to create PKs. >=20 > On Sep 3, 2011, at 3:38 PM, Cord Sengbusch wrote: >=20 >> Hi All - >>=20 >> I am using Eclipse, WOLips, WebObjects 5.3.3 and MySQL for a small projec= t. >>=20 >> I am able to query tables in my database, but as soon as I try to insert a= row using my WebObjects application, I get the following exception: >>=20 >> Error: java.lang.IllegalStateException: Adaptor com.webobjects.jdb= cadaptor.JDBCAdaptor@a8cf03 failed to provide new primary keys for entity 'R= egistration' >> Reason: Adaptor com.webobjects.jdbcadaptor.JDBCAdaptor@a8cf03 faile= d to provide new primary keys for entity 'Registration' >>=20 >> In Entity Modeler I have com.webobjects.jdbcadaptor.MySQLPlugIn as the th= e Plugin in the config file. >>=20 >> When viewing my database I do not see an EO_PK_TABLE. >>=20 >> Not sure how to get my application to create/use the eo_pk_table. >>=20 >> Thanks for the help. >>=20 >> Cord >=20 --Apple-Mail-2--271673195 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 <html><body bgcolor=3D"#FFFFFF"><div>It would be cool if Migrations would ad= d the table automatically, like it does the _dbupdate table. Also, it w= ould be handy if it would make the length of the Entity name longer than 31?= Characters. Not all RDBS are as irritating as Oracle. I like long, very cle= ar entity names and have had to modify the length of the field before.<br><b= r><div>Dave</div><div><br></div></div><div><br>On Sep 5, 2011, at 10:17 AM, K= ieran Kelleher <<a href=3D"mailto:[email protected]">[email protected]= m</a>> wrote:<br><br></div><div></div><blockquote type=3D"cite"><div>Just= create the EO_PK_TABLE yourself ...... your error is probably caused by the= user/password not having privileges to create the missing table on the firs= t attempt to create PKs.<div><br><div><div>On Sep 3, 2011, at 3:38 PM, Cord S= engbusch wrote:</div><br class=3D"Apple-interchange-newline"><blockquote typ= e=3D"cite">Hi All -<div><br></div><div>I am using Eclipse, WOLips, WebObject= s 5.3.3 and MySQL for a small project.</div><div><br></div><div>I am able to= query tables in my database, but as soon as I try to insert a row using my W= ebObjects application, I get the following exception:</div> <div><br></div><div><span class=3D"Apple-style-span" style=3D"-webkit-border= -horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; font-family:= Times; font-size: medium; "><table border=3D"0" width=3D"100%"><tbody><tr><= td align=3D"right" valign=3D"top" height=3D"13"> <b>Error:</b></td><td align=3D"left" valign=3D"top" height=3D"13">java.lang.= IllegalStateException: Adaptor com.webobjects.jdbcadaptor.JDBCAdaptor@a8cf03= failed to provide new primary keys for entity 'Registration'</td></tr> <tr><td align=3D"right" valign=3D"top"><b>Reason:</b></td><td align=3D"left"= valign=3D"top">Adaptor com.webobjects.jdbcadaptor.JDBCAdaptor@a8cf03 failed= to provide new primary keys for entity 'Registration'<br></td></tr></tbody>= </table> <br></span></div><div><span class=3D"Apple-style-span" style=3D"-webkit-bord= er-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; font-famil= y: Times; font-size: medium; ">In Entity Modeler I have com.webobjects.= jdbcadaptor.MySQLPlugIn as the the Plugin in the config file.</span></div> <div><span class=3D"Apple-style-span" style=3D"-webkit-border-horizontal-spa= cing: 2px; -webkit-border-vertical-spacing: 2px; font-family: Times; font-si= ze: medium; "><br></span></div><div><font class=3D"Apple-style-span" face=3D= "Times" size=3D"3"><span class=3D"Apple-style-span" style=3D"-webkit-border-= horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;">When viewing= my database I do not see an EO_PK_TABLE.</span></font></div> <div><font class=3D"Apple-style-span" face=3D"Times" size=3D"3"><span class=3D= "Apple-style-span" style=3D"-webkit-border-horizontal-spacing: 2px; -webkit-= border-vertical-spacing: 2px;"><br></span></font></div><div><span class=3D"A= pple-style-span" style=3D"-webkit-border-horizontal-spacing: 2px; -webkit-bo= rder-vertical-spacing: 2px; font-family: Times; font-size: medium; ">Not sur= e how to get my application to create/use the eo_pk_table.</span></div> <div><span class=3D"Apple-style-span" style=3D"-webkit-border-horizontal-spa= cing: 2px; -webkit-border-vertical-spacing: 2px; font-family: Times; font-si= ze: medium; "><br></span></div><div><span class=3D"Apple-style-span" style=3D= "-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2p= x; font-family: Times; font-size: medium; ">Thanks for the help.</span></div= > <div><span class=3D"Apple-style-span" style=3D"-webkit-border-horizontal-spa= cing: 2px; -webkit-border-vertical-spacing: 2px; font-family: Times; font-si= ze: medium; "><br></span></div><div><span class=3D"Apple-style-span" style=3D= "-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2p= x; font-family: Times; font-size: medium; ">Cord</span></div> </blockquote></div><br></div></div></blockquote></body></html>= --Apple-Mail-2--271673195--