Re: Setting Up JDBC driver for Oracle database
peace - scot Mong Kon Mo wrote: > > Hello, > > I am trying setup Orion to communicate with an Oracle 8.0.5.1 database. > I've obtained the JDBC drivers from Oracle, but I'm confused about what > I should be doing next. The Orion documentation says I need to copy the > driver to the Orion\lib directory and add a data source in > data-sources.xml; but what fields do I change and what values should I > use? > > Can anyone, perhaps someone who uses Orion and Oracle, help clear up > this process for me? > > Thanks in advance, > > Mong Kon Mo -- scot weber - [EMAIL PROTECTED] - Given a choice between a folly and a sacrament, one should always choose the folly -- because we know a sacrament will not bring us closer to God and there's always a chance that a folly will. - Erasmus The only man who never makes a mistake is the man who never does anything. - Theodore Roosevelt.
RE: Setting Up JDBC driver for Oracle database
Mong, Here's a data-sources.xml I use with 8i, I don't know if it will work with 8, though: http://www.orionserver.com/dtds/data-sources.dtd";> Regards, the elepantwalker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mong Kon Mo Sent: Friday, June 29, 2001 4:58 PM To: Orion-Interest Subject: Setting Up JDBC driver for Oracle database Hello, I am trying setup Orion to communicate with an Oracle 8.0.5.1 database. I've obtained the JDBC drivers from Oracle, but I'm confused about what I should be doing next. The Orion documentation says I need to copy the driver to the Orion\lib directory and add a data source in data-sources.xml; but what fields do I change and what values should I use? Can anyone, perhaps someone who uses Orion and Oracle, help clear up this process for me? Thanks in advance, Mong Kon Mo
RE: Documents and dynamic web pages
Hi. Here is ths Oracle DS sample. We use thin driver. (orion 1.5.2) -- data-sources.xml http://www.orionserver.com/dtds/data-sources.dtd";>
Setting Up JDBC driver for Oracle database
Hello, I am trying setup Orion to communicate with an Oracle 8.0.5.1 database. I've obtained the JDBC drivers from Oracle, but I'm confused about what I should be doing next. The Orion documentation says I need to copy the driver to the Orion\lib directory and add a data source in data-sources.xml; but what fields do I change and what values should I use? Can anyone, perhaps someone who uses Orion and Oracle, help clear up this process for me? Thanks in advance, Mong Kon Mo
Re: returning an interface
the answer is in your question
MyInterfaceImpl is not Serializable.
you have 2 options: make your interface extend
java.io.Serializable, or make your Impl class also implement
java.io.Serializable.
Noah
- Original Message -
From:
Paul
Knepper
To: Orion-Interest
Sent: Friday, June 29, 2001 2:33 PM
Subject: returning an interface
Has anyone ever
returned an interface from an EJB?
I get the
following error:
com.evermind.server.rmi.OrionRemoteException: Error (de-)serializing
object: MyInterfaceImpl
Here is my Remote
Interface:
public interface
Test extends EJBObject{ public IMyInterface
getInterface() throws
RemoteException;}
Here is the
implmentation of the method:
public IMyInterface
getInterface() throws
RemoteException
{ return new
MyInterfaceImpl(); }
Thanks,
Paul
Documents and dynamic web pages
I am aiding a department that is using a two tier application design, with a JSP engine and Oracle, to build a dynamic web site. It's easy to deal with images, by either using a URL link, or a BLOB field in Oracle. Now I wonder how to deal with documents. Is it best to store them as BLOBS, or perhaps PDF files, and use software such as www.pdflib.com to transform them. Any suggestions on the best approach. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
Re: Classpath and library path ERROR ??? --> PLEASE again ???
Title: SV: Classpath and library path ERROR ??? --> PLEASE again ??? Hellu again, Finally I have been able to jar the project to a ear file and deploy it. I included the log4j-core.jar file in my ear file, by including it in a ejb.jar file. I did this like Magnus suggested below: including the jar file in one of the ejb.jar files and put it in the MANIFEST.MF file. However, Orion still complains that it can't find the log4j-core.jar file!! Please some help with the configuration ??: The ear files contains (locates in $ORION_HOME/applications): - META-INF sgs-web.war um-ejb.jar They um-ejb.jar contains : -- log4j-core.jarMETA-INF/MANIFEST.MFMETA-INF/ejb-jar.xml -- And the MANIFEST.MF file contains: --- Manifest-Version: 1.0Created-By: Ant 1.3Class-Path: log4j-core.jar--- So, please can someone tell me what the ... am I doing wrong, as it drives my grazy !!! BTW: I also included the log4j-core.jar file in a lib dir, which I did put in the orion-application.xml file with the 'library path' tag, like the elephantwalker suggested, but still had the same problem!! (ofcourse I included everything in the ear file). Musn't I include the log4j-core.jar in the MANIFEST.MF file of the ear file, instead of the ejb.jar file, as Magnus suggested ?? Gr, Eddie - Original Message - From: Magnus Rydin To: Orion-Interest Sent: Monday, June 25, 2001 8:22 AM Subject: SV: Classpath and library path ERROR ??? --> PLEASE again ??? I guess thats orion-application.xml right? Another way would be to include the jar in the .ear file, and make one of the ejb .jar:s manifest files point it out. This is according to my interpretation of the specification, so Im pretty sure this will work with most J2EE servers out there. WR > -Ursprungligt meddelande- > Från: Ye He [mailto:[EMAIL PROTECTED]] > Skickat: den 22 juni 2001 09:09 > Till: Orion-Interest > Ämne: Re: Classpath and library path ERROR ??? --> PLEASE again ??? > > > i speicify my CLASSPATH thru applications.xml's > tag, using absolute path. i'm on > SuSE 7.1 (kernel 2.4.0) with IBM jdk 1.3.0 > > --- Eddie <[EMAIL PROTECTED]> wrote: > > Helllu ?? > > > > What do you need to do to get an answer from this newsgroup > > when you are > > really in trouble ?? :( > > > > I still haven't be able to include a jar file in the > > orion-application.xml, > > that can be used by my application. It is able to use my jar > > when I put it > > in the $ORION_HOME/lib dir, but that's not what I want, as > > every application > > needs his own copy. > > > > I like to hear from Linux users how they did this, as I > > noticed that all the > > people that talked about it in the newsgroup, where all > > Windoze hackers. (I > > use: redhat 7.0 with sun jdk and orion 1.5.1) > > > > PLEASE some help, see below for more info ?? > > > > Eddie :( > > > > > > > > - Original Message - > > From: Eddie > > To: Orion-Interest > > Sent: Tuesday, June 19, 2001 11:20 AM > > Subject: Re: Classpath and library path ERROR ??? --> PLEASE > > again ??? > > > > > > Thanks, > > > > Indeed the library tag wasn't on the correct place in the > > orion-application.xml. > > However, after placing it in the correct place it still > > doesn't work: > > > > . > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- > > > > I also tried the orion-web.xml: > > > > > > > > deployment-version="1.5.1" > > development="true" > > jsp-cache-directory="./persistence" > > temporary-directory="./temp" > > servlet-webdir="/servlets/" > > > > > > > > > ... > > > > > > But didn't had much luck, which didn't suprise me, as I am > > using the lib > > files in my ejb's. > > I am sure that the jar files can be find by Orion, as it > > complaints when it > > can't find the files. > > > > But are you using Linux ?? I have a friend that has exatly the > > same problems > > on his linux machine!! .--> :( > > Shoudn't I put it all in a ear file ?? and if so, where ?? > > > > Hope you have some ideas as I don't have them anymore. Neither > > do I know how > > to debug this, as Orion doesn't show that it loads the jar > > file...or where > > it looks.. > > Hmmm... frustrating.. > > Eddie > > - Original Message - > > From: elephantwalker > > To: Orion-Interest > > Sent: Monday, June 18, 2001 6:20 PM > > Subject: RE: Classpath and library path ERROR ??? --> PLEASE > > again ??? > > > > > > The dtd for orion-application.xml says about library: > > > > > > > > > > > > > > > The main orion-application element is: > > > > > > > (ejb-module*,web-module*,client-module*,securi
500 Internal Server Error after deploying
Title: 500 Internal Server Error after deploying Here's the deal, I set up and deploy an ear file and i try to run the associated servlet and i get 500 internal server error. Now the kicker is i have succesfuly deployed some of the other beans. I really have absolutely no clue what i am doing wrong this time. I will spend more monday and disect it. However does anyone know what i could be missing? Nothing is being written to log file or in the system.out.println's I am at a loss ... and trying to figure it out so i never do it again. (btw i am used BMP bean and a servlet) to start it out
returning an interface
Has anyone ever
returned an interface from an EJB?
I get the following
error:
com.evermind.server.rmi.OrionRemoteException: Error (de-)serializing
object: MyInterfaceImpl
Here is my Remote
Interface:
public interface
Test extends EJBObject{ public IMyInterface
getInterface() throws
RemoteException;}
Here is the
implmentation of the method:
public IMyInterface getInterface()
throws RemoteException
{ return new
MyInterfaceImpl(); }
Thanks,
Paul
Question about port listener
Question 1) Is it possible to build an bean, which is some sort of tcp port listener? Idea is to listen for traffic on port and then fire an even/send a msg to queue if something is received Question 2) What if we have an 3rd party java api to connect some server using rmi (for an example an api which builds up an connection to short message center) Would it be possible to create an bean which builds up this connection(and does this only once), keeps it up and listens for method calls from clients and then sends them away
Re:"UNSUSCRIBE"
> >-- > >/* > * Kenneth N. M. Eisner > * Developer > * > * Brics|net US, LLC > * 53 Green St. > * Portsmouth, NH > * 03801 > * > * (tel.) 603-436-6868 > * (fax.) 603-436-5760 > */ > > hello: my name is ¿×ÏéÓÑ,I am form beijin tel.:01067501840 ===sms.163.com--ÍøÒ׶ÌÐÅ ÎÞÂÛÄãÉíÔں䦣¬Ò²²»¹ÜÒƶ¯»òÊÇÁªÍ¨£¬ÍøÒ׶ÌÐŶ¼ÄÜÒ»Íø´ò¾¡£¡ Ñ¡ÔñÍøÒ׶ÌÐÅ£¬ÐÄÓëÐÄÖ®¼ä½«²»ÔÙÓоàÀ룡
Re:
package com.cyonara.gw.sql;
import com.cyonara.gw.util.*;
import java.sql.Connection;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class DataSourceSqlConnector implements SqlConnector
{
//===/
//=== Static Data Members ===/
//===/
private static final Log fLog =
LogFactory.getInstance(DataSourceSqlConnector.class);
///
//=== Data Members ===/
///
private String fDataSourceName = null;
///
//=== Constructors ===/
///
public DataSourceSqlConnector(
final String dataSourceName)
{
fDataSourceName = dataSourceName;
}
//==/
//=== Public Methods ===/
//==/
public Connection getConnection()
throws
Exception
{
fLog.beginDebug("getConnection()");
Context context = new InitialContext();
DataSource ds = (DataSource)context.lookup(fDataSourceName);
Connection result = ds.getConnection();
fLog.endDebug("getConnection()");
return result;
}
}
- Original Message -
From: "struts orion" <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 8:57 PM
> Hi
>
> I am using oracle thin driver
> the data-source.xml configuration is
>
> class="com.evermind.sql.DriverManagerDataSource"
> name="oraclethin"
> location="jdbc/Oracle"
> connection-driver="oracle.jdbc.driver.OracleDriver"
> username="varro"
> password="varro"
> url="jdbc:oracle:thin:@192.0.0.8:1521:hcp"
> inactivity-timeout="30"
> />
>
> How to use/locate this data source in a simple client
> application which uses this datasource and connects to
> database
> If possible give example code for client application
>
> thanks & regards
> praveen
>
>
>
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
>
>
Re:JMS .xml files question
Queues and topics that are in the config/jms.xml dont have to be in the application-client.xml. I have not been able to create a factory in the config/jms.xml.
"UNSUSCRIBE"
-- /* * Kenneth N. M. Eisner * Developer * * Brics|net US, LLC * 53 Green St. * Portsmouth, NH * 03801 * * (tel.) 603-436-6868 * (fax.) 603-436-5760 */
mdb and external jms
Still wondering about the subject. When using swiftmq jms server, client only has to set INITIAL_CONTEXT_FACTORY and PROVIDER_URL to connect to swiftmq router/jms server. So in orion-ejb-jar.xml we define message-driven-deployment tag.. Under it its possible to set lookup-context location and context-attribute. Question goes: is it possible set up bean to listen external jms using these tags? Example is this valid: ..? (trying to set java.naming.provider.url .. And what should the value for lookup-context location be then?
Re:
Go look on www.orionsupport.com or search through the mailing list. You should find examples! RHH --- struts orion <[EMAIL PROTECTED]> wrote: > Hi > > I am using oracle thin driver > the data-source.xml configuration is > > class="com.evermind.sql.DriverManagerDataSource" > name="oraclethin" > location="jdbc/Oracle" > connection-driver="oracle.jdbc.driver.OracleDriver" > username="varro" > password="varro" > url="jdbc:oracle:thin:@192.0.0.8:1521:hcp" > inactivity-timeout="30" > /> > > How to use/locate this data source in a simple client > application which uses this datasource and connects to > database > If possible give example code for client application > > thanks & regards > praveen > > > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/ > __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
CMP vs BMP and finder methods
Hi forum,
I would like to know what strategies people
use in real life to design their entity beans, when use CMPs and when BMPs. Each
approarch has its own benefits and drawbacks.
This is what I found out during my experience with
EJB:
1.CMPs
Benefits:
- easy to
develop;
- better
perfomance.
Drawbacks:
- less flexible then
BMPs;
- some of the queries
cannot be performed with pure CMP, so sometimes it is necessary to add a
data access object ( java class ) that uses JDBC to directly communicate with
database ( to retreive the number of records etc. ). The problem here is that it
is necessary
- not all queries can be coded
with CMP finder methods ( consider example: I need to extract 20 records,
starting with 500 out of 3000 records in a table. Using Collection would be
extremely expensive ).
2.BMPs
Benefits:
- full control over data
flow. you can do anything JDBC is capable of.
Drawbacks:
- huge perfomance
degradation when retrieving a collection of BMPs - the problem of n+1
call.
My conclusion is: everyting is fine with the
creation, updating and deleting the entities. The problem arises with finder
methods: You are either to slow with BMPs or fast with CMPs but with limited
functionality. Another idea is to use CMPs to create/update/delete entities, but
use JDBC and retreive collections values value objects for finders,
something like:
public class EntityValue {
public int
id;
public String
data;
}
The problem here is that we lose encapsulation...
How do you handle this situation?
Any suggestions are very much
appreciated.
Sergei.
UNSUSCRIBE
Re: Debug JSP - how to?
Try uncommenting the thing in web.xml, this would let you see
what is actually going on.
Johan
- Original Message -
From: "Henrik Skafsgaard Larsen" <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 8:07 AM
Subject: Re: Debug JSP - how to?
> I AM using IE and that thingy for *user friendly* messages has been
disabled.
> Both Netscape and IE attempts to save the file instead of displaying it.
> What I do not understand is, how can I actually make an instance of the
class
> but not use a method in it? Seems odd to me.
>
> mvh / best regards
> Henrik Skafsgaard Larsen
>
> - Original Message -
> From: "Scot Weber" <[EMAIL PROTECTED]>
> To: "Orion-Interest" <[EMAIL PROTECTED]>
> Sent: Thursday, June 28, 2001 5:21 PM
> Subject: Re: Debug JSP - how to?
>
>
> > Henrik,
> >
> > Are you by chance using IE? If you are, go to the advanced properties
> > and disable the beautified error page display, this will give you the
> > actual jsp error information from things like 500 Server Errors. If
you're
> > using nutscrape and not getting meaningful error messages, then
something
> > is radically wrong.
> >
> > - peace - scot weber / [EMAIL PROTECTED]
> > [ this space reserved for something really clever ]
> >
> > Henrik Skafsgaard Larsen wrote:
> >
> > > Hello
> > >
> > > I have this servlet, which actually doesn't do much except write html,
> > > so for testing purpose I decided to change it to JSP.
> > > I want to use some methods defined in our homegrown packages
> > > and imported the package with: <%@ page import="com.mypacke.util.*" %>
> > > I then wrote the following:
> > > .
> > > .
> > > <%
> > > Cleo c = new Cleo();
> > > out.println("Howdy from Cleo: " + c.getDate());
> > > %>
> > > .
> > > .
> > > the result was, that my page could not be displayed.
> > > Removing the reference: c.getDate() helped
> > > but I cannot find any hints ind the logfiles as to WHY it doesn't
work.
> > >
> > > med venlig hilsen / best regards
> > > Henrik Skafsgaard Larsen
> >
> >
> >
> >
>
>
RE: Memory leaks
There are issues with memory leaks and some jdbc drivers. Search the list on postgresql, for example. This is not necessarily orion, but if you are using a database with orion, the driver will be in the orion vm. If the driver chews up memory, so will orion. the elephantwalker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jens Stutte Sent: Friday, June 29, 2001 12:31 AM To: Orion-Interest Subject: AW: Memory leaks We do not have any production site, yet, but from my experience with orion and EJB, the most important thing is to provide an orion-ejb-jar.xml with your application, where you specify maximum instance limits for each entity bean. Otherwise there will be only a timeout to destroy cached instances, which under heavy load may not be sufficient. This looks like: http://www.orionserver.com/dtds/orion-ejb-jar.dtd";> Best performance (together with exclusive-write-access) you get with high timeouts and a sufficient number of instances to fill your RAM without swapping - only that you must set it for each bean and play around a bit to find the best values (especially when you have a lot of entity beans). Lowest memory usage you get with both low timeouts and max-instances, of course. This is no memory leak issue, but may seem as such if you don't limit the number of beans and put your system under heavy load. Other problems with memory (except for our own code ;-) did not show up yet. Good luck, Jens Stutte -Ursprüngliche Nachricht- Von: Nusairat, Joseph F. [mailto:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 28. Juni 2001 21:17 An: Orion-Interest Betreff: Memory leaks I was curious ... i am about to put orion into a production enviroment within the next week. I have been writing some EJB's with it ... and some testing and configuring I was wondering how bad or good it is at memory leaks? Do u all have to restart your servers often??? Or??? any suggestions It will be on win2k boxes
AW: Memory leaks
We do not have any production site, yet, but from my experience with orion and EJB, the most important thing is to provide an orion-ejb-jar.xml with your application, where you specify maximum instance limits for each entity bean. Otherwise there will be only a timeout to destroy cached instances, which under heavy load may not be sufficient. This looks like: http://www.orionserver.com/dtds/orion-ejb-jar.dtd";> Best performance (together with exclusive-write-access) you get with high timeouts and a sufficient number of instances to fill your RAM without swapping - only that you must set it for each bean and play around a bit to find the best values (especially when you have a lot of entity beans). Lowest memory usage you get with both low timeouts and max-instances, of course. This is no memory leak issue, but may seem as such if you don't limit the number of beans and put your system under heavy load. Other problems with memory (except for our own code ;-) did not show up yet. Good luck, Jens Stutte -Ursprüngliche Nachricht- Von: Nusairat, Joseph F. [mailto:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 28. Juni 2001 21:17 An: Orion-Interest Betreff: Memory leaks I was curious ... i am about to put orion into a production enviroment within the next week. I have been writing some EJB's with it ... and some testing and configuring I was wondering how bad or good it is at memory leaks? Do u all have to restart your servers often??? Or??? any suggestions It will be on win2k boxes
