RE: Datasource confusion
Dear All, I've nailed the problem. I removed the datasource definition from the ejb-jar.xml and placed one in ~orion/config/data-sources.xml. After rebuilding the application I stopped Orion, wiped out the ~orion/application-deployments directory, and restarted Orion. I now get remote access denied errors from the database server, which is good. :-) This line jdbc:mysql://luggage/log is not complete and consider mysql local. Umm. Well, this is the precise URL that I use now. Just for the record, the database server is named "luggage" and the database is called "log". MySQL server is running on the default port, so I don't have to specify that. Thanks for the quick responses. I'm going away now to get some harder problems for you to help me with. :-) off-topic Ah, while I'm on the line: I tried finding information about JMS, but all I can find are tutorials for local examples. I want to set up a message queue between two machines. I'd like to know a little about the implementation of JMS, so that I can get an idea about performance pitfalls and such. /off-topic Kees Jan You are only young once, but you can stay immature all your life.
RE: Datasource confusion
The reason you are probably getting remote access denied from the Mysql server, is that the grant tables must be set up with the com address (www.something.com) and localhost. If you are using mysql, I strongly recommend picking up Mysql by Paul DuBois (see page 429, A Privileged puzzle), and perhaps the O'Rielly book. -Original Message- From: Koster, K.J. [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 6:00 AM To: Orion-Interest Subject: RE: Datasource confusion Dear All, I've nailed the problem. I removed the datasource definition from the ejb-jar.xml and placed one in ~orion/config/data-sources.xml. After rebuilding the application I stopped Orion, wiped out the ~orion/application-deployments directory, and restarted Orion. I now get remote access denied errors from the database server, which is good. :-) This line jdbc:mysql://luggage/log is not complete and consider mysql local. Umm. Well, this is the precise URL that I use now. Just for the record, the database server is named "luggage" and the database is called "log". MySQL server is running on the default port, so I don't have to specify that. Thanks for the quick responses. I'm going away now to get some harder problems for you to help me with. :-) off-topic Ah, while I'm on the line: I tried finding information about JMS, but all I can find are tutorials for local examples. I want to set up a message queue between two machines. I'd like to know a little about the implementation of JMS, so that I can get an idea about performance pitfalls and such. /off-topic Kees Jan You are only young once, but you can stay immature all your life.
RE: Datasource confusion
Hi, I am trying to use MySQL and Orion where the MySQL database is located on a different host than Orion is. The beans look up the datasource in JNDI. I've specified the datasource in in ejb-jar.xml. (The resource-ref thingy) This is found, becasue I no longer get naming exceptions. In data-sources.xml, I have specified the proper database URI (jdbc:mysql://luggage/log). Let me tell if I have understood the question... You are unable to connect to your database, isn't it? I had similar problem for a EJB (BMP)... I don't know if the approach used for it was correct one, but it worked. Orion create folders for beans etc in application-deployments. There I in 'orion-ejb-jar.xml' under my ejb folder, I added location="jdbc/MyDS" (in my case), in the tag which specified the resource dependancy. If you haven't tried that then try the above... it might work! Seeya. - UnicMan
Re: Datasource confusion
This line jdbc:mysql://luggage/log is not complete and consider mysql local. The syntax for url = drivertype:@location:PORT:instancedb ex: jdbc:oracle:[EMAIL PROTECTED]:777:FDEV for hsql this points to local jdbc:HypersonicSQL:./databases/mydb = :. means local for u I think it should be but I do not know your network topo try jdbc:mysql:@luggage.log:yourdbpath --- "Koster, K.J." [EMAIL PROTECTED] wrote: Dear All, I am trying to use MySQL and Orion where the MySQL database is located on a different host than Orion is. The beans look up the datasource in JNDI. I've specified the datasource in in ejb-jar.xml. (The resource-ref thingy) This is found, becasue I no longer get naming exceptions. In data-sources.xml, I have specified the proper database URI (jdbc:mysql://luggage/log). However, I get an exception saying that on localhost there is no mysql database (which is true, 'cuz it's on luggage). Obviously Orion is feeding the bean a database URI that points to localhost. How can I tell Orion to use the database on the other machine? I've tried shouting in the floppy drive, but that does not help either. :-/ Kees Jan You are only young once, but you can stay immature all your life. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/