Re: Re: Re: Re: replacing HSQL internal DB with other db (e.g., MySQL) - simple list of steps
Luke Rasmussen <[email protected]> Tue, 6 Oct 2009 12:23:40 -0500
| Newsgroups | gmane.comp.java.enhydra.shark |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format... ------------=_1254849824-18930-7419 Content-Type: multipart/alternative; boundary=0003255597fec8adad0475477d46 --0003255597fec8adad0475477d46 Content-Type: text/plain; charset=ISO-8859-1 Svjetlana - thank you for your reply, it was a good confirmation that the solution should be a simple one! I retried the steps you suggested, and the running instance I had still did not work. Now, this made me think that when I was trying to fix the error, I may have messed up something else. I reinstalled JBoss and installed the new version of TWS. I went through the steps again, and this time it worked. I should have tried with a fresh install instead of mucking around as much as I did. Thanks again for the help, we're back on track now! Luke R. On Tue, Oct 6, 2009 at 6:56 AM, svjetlana <[email protected]>wrote: > I've just try to run Shark as EJB (under jboss-4.0.2) and everything works > good. I did the following steps: > > EJB on JBoss > > look at EJB folder > -unpack jboss.zip in %JBOSS_HOME% dir > -copy .ear and .xml files into /server/default/deploy directory > - for MySQL db configuration copy mysql-connector-java-XX.jar to JBoss > server/default/lib folder > > - edit SharkClient.conf file: - ClientType=EJB > - > XaUserTransactionLookupName=UserTransaction > - The JBOSS jar file jbossall-client.jar (located in JBOSS server's client > directory) > must be copied to <shark_install_dir>/lib/contrib directory. > > > - run jboss from bin folder > - runSA from %TWS_INSTALL% dir > > > Luke Rasmussen wrote: > > After going through those steps we were able to get an instance of Shark > running as POJO to use MySQL instead of HSQL. It seems to have been working > well for us, and we have tried moving an instance of Shark running as EJB > (under JBoss) to also use MySQL instead of HSQL. > > Things look good initially after the configuration is done, however when I > try to load an XPDL using the Shark Admin client I get an exception: > > 09:52:13,835 INFO [Shark] PackageAdmin -> Trying to open Package from > provided byte[] content > 09:52:14,908 ERROR [STDERR] java.lang.NullPointerException > 09:52:14,910 ERROR [STDERR] at > org.enhydra.shark.PackageAdmin.openPackage(PackageAdmin.java:751) > 09:52:14,910 ERROR [STDERR] at > org.enhydra.shark.PackageAdmin.uploadPackage(PackageAdmin.java:238) > 09:52:14,910 ERROR [STDERR] at > org.enhydra.shark.ws.PackageAdministrationWrapper.uploadPackage(PackageAdministrationWrapper.java:251) > (...Additional stack trace removed...) > 09:52:14,915 ERROR [Shark] PackageAdmin -> Package byte[] representation > failed to open > > I realize this may not be enough information to troubleshoot the issue, so > please let me know what other logs or config files could be helpful. From > what I could tell, the config files the system was using all referenced the > MySQL instance, and the MySQL connectivity appears to be working since the > configure script worked correctly. > > I tried digging into the code, and this looks like what's throwing the > exception: > > Set currentPkgIds = *new *HashSet(getRepositoryPersistenceManager().getExistingXPDLIds(shandle)); > > > I'm not sure why the repository persistence manager (DODS by default, > right?) wouldn't be getting created, unless there's additional configuration > I need to do to point DODS at the MySQL instance. Could there possibly be > something with transferring byte[] to MySQL and the version of MySQL being > used? > > Thanks in advance for any direction you can point me in. I'll continue to > investigate in the meantime in case there's something simple I've > overlooked. > > Luke R. > > > On Mon, Jul 27, 2009 at 5:33 PM, Dmitry Shulga <[email protected]>wrote: > > > If I understood you right, you may find an answer in the very first > question in the Shark FAQ > db_loader_job=hsql > > DS > > > On Mon, Jul 27, 2009 at 3:28 PM, Vojtech Huser <[email protected]>wrote: > > > Dear members, > we would like to replace the HSQL database with a more robust one > (e.g., MySQL, MS SQL or Oracle). > We tried few things but can not get all the errors go away. > > If you were able to switch to a different db, can you please post a > ultra-short list of modifications/steps which are involved in such > switch? > > Vojtech Huser > > > > > -- You receive this message as a subscriber of the [email protected] mailing > list. > To unsubscribe: mailto:[email protected] > For general help: mailto:[email protected]?subject=help > OW2 mailing lists service home page: http://www.ow2.org/wws > > > > > > -- > You receive this message as a subscriber of the [email protected] mailing > list. > To unsubscribe: mailto:[email protected] > For general help: mailto:[email protected]?subject=help > OW2 mailing lists service home page: http://www.ow2.org/wws > > > > > ------------------------------ > > > -- > You receive this message as a subscriber of the [email protected] mailing list. > To unsubscribe: mailto:[email protected] <[email protected]> > For general help: mailto:[email protected]?subject=help <[email protected]?subject=help> > OW2 mailing lists service home page: http://www.ow2.org/wws > > > > > -- > You receive this message as a subscriber of the [email protected] mailing > list. > To unsubscribe: mailto:[email protected] > For general help: mailto:[email protected]?subject=help > OW2 mailing lists service home page: http://www.ow2.org/wws > > --0003255597fec8adad0475477d46 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <div>Svjetlana - thank you for your reply, it was a good confirmation that = the solution should be a simple one!=A0 I retried the steps you suggested, = and the running instance I had still did not work.=A0 Now, this made me thi= nk that when I was trying to fix the error, I may have messed up something = else.=A0 I reinstalled JBoss and installed the new version of TWS.=A0 I wen= t through the steps again, and this time it worked.=A0 I should have tried = with a fresh install instead of mucking around as much as I did.</div> <div>=A0</div> <div>Thanks again for the help, we're back on track now!</div> <div>=A0</div> <div>Luke R.</div> <div><br><br>=A0</div> <div class=3D"gmail_quote">On Tue, Oct 6, 2009 at 6:56 AM, svjetlana <span = dir=3D"ltr"><[email protected]></span> wrote:<br> <blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0= px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"> <div text=3D"#000000" bgcolor=3D"#ffffff">I've just try to run Shark as= EJB (under jboss-4.0.2) and everything works good. I did the following ste= ps: <br><br>EJB on JBoss=A0=A0 <br>=A0 <br>=A0 look at EJB folder<br>=A0=A0= -unpack jboss.zip in %JBOSS_HOME% dir<br> =A0=A0 -copy .ear and .xml files into /server/default/deploy directory<br>= =A0 - for MySQL db configuration copy mysql-connector-java-XX.jar to JBoss = server/default/lib folder<br><br>=A0- edit SharkClient.conf file:=A0 - Clie= ntType=3DEJB=A0 <br> =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 - XaUserTransactionLookupName=3DUserTransaction<br>=A0- = The JBOSS jar file jbossall-client.jar (located in JBOSS server's clien= t directory)<br>=A0=A0=A0 must be copied to <shark_install_dir>/lib/c= ontrib directory.<br> <br>=A0=A0=A0 <br>=A0- run jboss from bin folder<br>=A0- runSA from %TWS_IN= STALL% dir <br><br><br>Luke Rasmussen wrote:=20 <blockquote cite=3D"http://midee1b0ab0910051033u442c51e9h4b03b910a81c4894@m= ail.gmail.com" type=3D"cite"> <div> <div></div> <div class=3D"h5"> <div>After going through those steps we were able to get an instance of Sha= rk running as POJO to use MySQL instead of HSQL.=A0 It seems to have been w= orking well for us, and we have tried moving an instance of Shark running a= s EJB (under JBoss) to also use MySQL instead of HSQL.=A0 </div> <div>=A0</div> <div>Things look good initially after the configuration is done, however wh= en I try to load an XPDL using the Shark Admin client I get an exception:</= div> <blockquote> <div>09:52:13,835 INFO=A0 [Shark] PackageAdmin -> Trying to open Package= from provided byte[] content </div> <div>09:52:14,908 ERROR [STDERR] java.lang.NullPointerException</div> <div>09:52:14,910 ERROR [STDERR]=A0=A0=A0=A0 at org.enhydra.shark.PackageAd= min.openPackage(PackageAdmin.java:751)</div> <div>09:52:14,910 ERROR [STDERR]=A0=A0=A0=A0 at org.enhydra.shark.PackageAd= min.uploadPackage(PackageAdmin.java:238)</div> <div>09:52:14,910 ERROR [STDERR]=A0=A0=A0=A0 at org.enhydra.shark.ws.Packag= eAdministrationWrapper.uploadPackage(PackageAdministrationWrapper.java:251)= </div> <div>=A0(...Additional stack trace removed...) </div> <div>09:52:14,915 ERROR [Shark] PackageAdmin -> Package byte[] represent= ation failed to open </div></blockquote> <div>I realize this=A0may not be=A0enough information to=A0troubleshoot the= =A0issue,=A0so please let me know what other logs or config files could be = helpful.=A0 From what I could tell, the config files=A0the system was=A0usi= ng all referenced the MySQL instance, and the MySQL connectivity appears to= be working since the configure script worked correctly.=A0 </div> <div>=A0</div> <div>I tried digging into the code,=A0=A0and this looks like what's thr= owing the exception:</div> <blockquote> <div>Set currentPkgIds =3D <b>new </b>HashSet(getRepositoryPersistenceManag= er().getExistingXPDLIds(shandle)); </div></blockquote> <div>I'm not sure why the repository persistence manager (DODS by defau= lt, right?) wouldn't be getting created, unless there's additional = configuration I need to do to point DODS at the MySQL instance.=A0 Could th= ere possibly be something with transferring byte[] to MySQL and the version= of MySQL being used?</div> <div>=A0</div> <div>Thanks in advance for any direction you can point me in.=A0 I'll c= ontinue to investigate in the meantime in case there's something simple= I've overlooked.</div> <div>=A0</div> <div>Luke R.</div> <p>=A0 </p> <div>On Mon, Jul 27, 2009 at 5:33 PM, Dmitry Shulga <span><<a href=3D"ma= ilto:[email protected]" target=3D"_blank">[email protected]</a>= ></span> wrote:=20 <div>=A0</div> <blockquote>If I understood you right, you may find an answer in the very f= irst question in the Shark FAQ=20 <div>=A0</div> <div>db_loader_job=3Dhsql</div> <div>=A0</div> <div>DS</div> <div>=A0</div> <div>=A0</div> <div> <div> <div>On Mon, Jul 27, 2009 at 3:28 PM, Vojtech Huser <span><<a href=3D"ma= ilto:[email protected]" target=3D"_blank">[email protected]</a>= ></span> wrote:=20 <div>=A0</div></div></div> <blockquote> <div> <div>Dear members,=20 <div>=A0</div> <div>we would like to replace the HSQL database with a more robust one</div> <div>(e.g., MySQL, MS SQL or Oracle).</div> <div>We tried few things but can not get all the errors go away.</div> <div>=A0</div> <div>If you were able to switch to a different db, can you please post a</d= iv> <div>ultra-short list of modifications/steps which are involved in such</di= v> <div>switch?</div> <div>=A0 </div> <div>Vojtech Huser</div>=A0</div> <div>=A0</div> <div>=A0</div></div></blockquote></div>--=20 <div>You receive this message as a subscriber of the <a href=3D"mailto:shar= [email protected]" target=3D"_blank">[email protected]</a> mailing list.</div> <div>To unsubscribe: mailto:<a href=3D"mailto:[email protected]" ta= rget=3D"_blank">[email protected]</a></div> <div>For general help: mailto:<a href=3D"mailto:[email protected]" target=3D"_b= lank">[email protected]</a>?subject=3Dhelp</div> <div>OW2 mailing lists service home page: <a href=3D"http://www.ow2.org/wws= " target=3D"_blank">http://www.ow2.org/wws</a></div> <div>=A0</div> <div>=A0</div></blockquote></div> <div>=A0</div> <div>=A0</div> <div>--</div> <div>You receive this message as a subscriber of the <a href=3D"mailto:shar= [email protected]" target=3D"_blank">[email protected]</a> mailing list.</div> <div>To unsubscribe: mailto:<a href=3D"mailto:[email protected]" ta= rget=3D"_blank">[email protected]</a></div> <div>For general help: mailto:<a href=3D"mailto:[email protected]" target=3D"_b= lank">[email protected]</a>?subject=3Dhelp</div> <div>OW2 mailing lists service home page: <a href=3D"http://www.ow2.org/wws= " target=3D"_blank">http://www.ow2.org/wws</a></div> <div>=A0</div> <div>=A0</div> <div>=A0</div></div></div><pre><hr width=3D"90%" size=3D"4"><div class=3D"i= m"> -- You receive this message as a subscriber of the <a href=3D"mailto:shark@ow2= .org" target=3D"_blank">[email protected]</a> mailing list. To unsubscribe: <a href=3D"mailto:[email protected]" target=3D"_bla= nk">mailto:[email protected]</a> For general help: <a href=3D"mailto:[email protected]?subject=3Dhelp" target=3D= "_blank">mailto:[email protected]?subject=3Dhelp</a> OW2 mailing lists service home page: <a href=3D"http://www.ow2.org/wws" tar= get=3D"_blank">http://www.ow2.org/wws</a> </div></pre></blockquote><br></div><br><br>--<br>You receive this message= as a subscriber of the <a href=3D"mailto:[email protected]">[email protected]</a> = mailing list.<br>To unsubscribe: mailto:<a href=3D"mailto:shark-unsubscribe= @ow2.org">[email protected]</a><br> For general help: mailto:<a href=3D"mailto:[email protected]">[email protected]</a>= ?subject=3Dhelp<br>OW2 mailing lists service home page: <a href=3D"http://w= ww.ow2.org/wws" target=3D"_blank">http://www.ow2.org/wws</a><br><br></block= quote> </div><br> --0003255597fec8adad0475477d46-- ------------=_1254849824-18930-7419 Content-Type: text/plain; charset="UTF-8"; name="message-footer.txt" Content-Disposition: inline; filename="message-footer.txt" Content-Transfer-Encoding: quoted-printable -- You receive this message as a subscriber of the [email protected] mailing lis= t. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=3Dhelp OW2 mailing lists service home page: http://www.ow2.org/wws ------------=_1254849824-18930-7419--