|

»

replacing HSQL internal DB with other db (e.g., MySQL) - simple list of steps

View: New views

5 Messages — Rating Filter: Alert me

	replacing HSQL internal DB with other db (e.g., MySQL) - simple list of steps by Vojtech Huser-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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 shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws
	Re: replacing HSQL internal DB with other db (e.g., MySQL) - simple list of steps by DS-22 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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 <huser.vojtech@...> 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 shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws -- You receive this message as a subscriber of the shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws
	Re: Re: replacing HSQL internal DB with other db (e.g., MySQL) - simple list of steps by Luke Rasmussen :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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 <dmitry.shulga@...> 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 <huser.vojtech@...> 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 shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws -- You receive this message as a subscriber of the shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws -- You receive this message as a subscriber of the shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws
	Re: Re: Re: replacing HSQL internal DB with other db (e.g., MySQL) - simple list of steps by svjetlana :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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 <dmitry.shulga@...> 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 <huser.vojtech@...> 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 shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws -- You receive this message as a subscriber of the shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws -- You receive this message as a subscriber of the shark@... mailing list. To unsubscribe: shark-unsubscribe@... For general help: sympa@... OW2 mailing lists service home page: http://www.ow2.org/wws -- You receive this message as a subscriber of the shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws
	Re: Re: Re: Re: replacing HSQL internal DB with other db (e.g., MySQL) - simple list of steps by Luke Rasmussen :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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 <svjetlana.milidrag@...> 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 <dmitry.shulga@...> 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 <huser.vojtech@...> 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 shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws -- You receive this message as a subscriber of the shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws -- You receive this message as a subscriber of the shark@... mailing list. To unsubscribe: shark-unsubscribe@... For general help: sympa@... OW2 mailing lists service home page: http://www.ow2.org/wws -- You receive this message as a subscriber of the shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws -- You receive this message as a subscriber of the shark@... mailing list. To unsubscribe: mailto:shark-unsubscribe@... For general help: mailto:sympa@...?subject=help OW2 mailing lists service home page: http://www.ow2.org/wws