hello again,
look again at the relevant lines in data-sources.xml.
first, in 'connection-driver' i have
com.ashna.jturbo.driver.Driver which means that i must
have a classfile named 'Driver' in a directory at
orion\lib\com\ashna\jturbo\driver\..
secondly, you must use the correct syntax in the url,
which is different for each driver, so check your
driver documentation..
i did not change any lib refs, nor did i do anything
with the 'schemas' line. i just left it at its
default value..
i'm just getting started with orion myself, so i am by
no means an expert..
bradley mclain
--- Tamer <[EMAIL PROTECTED]> wrote:
> hello,
> I'm still have problems with my oracle connection.
>
> I'm searching for an answer on orion web page , but
> not yet.
>
> whats the steps to complete the connection?
> I wish to use db connection on my Jsp pages, with
> oracle7.
> note:I can access data base with standalone
> programs.
> note2: using db access on jsp, i ever had success.
>
>
> my way:
> first: I configured server.xml like this:
> <library path="C:\jdk1.2.2\lib\classes7.zip;../lib"
> />
> but isnt only this.
>
> second: reading answers on list I saw your response
> <Re: Oracle Driver is
> not working>
> i tried and nothing happened.
>
> third: reading Sudhir doubt I note the following
> line on data-sources.xml
> >>> schema="database-schemas/oracle.xml" >>
> what 's this?
>
> please, sorry for my doubts, stack of questions and
> poor english.
>
> but, if u can, help me.
>
>
>
>
>
>
> At 02:29 14/04/2000 -0700, you wrote:
> >i think your problem lies in two places in your
> >data-source tag.
> >class should be:
> >"com.evermind.sql.ConnectionDataSource"
> >and connection-driver should be something like:
> >"com.oracle.thin.driver" or whatever the proper
> >reference is.
> >
> >here is my data-source tag, which seems to work
> just
> >fine. i am using the jturbo type 4 driver:
> >
> ><data-source
> > name="Default data-source"
> > class="com.evermind.sql.ConnectionDataSource"
> > location="jdbc/DefaultDS"
> > pooled-location="jdbc/DefaultPooledDS"
> > xa-location="jdbc/xa/DefaultXADS"
> > ejb-location="jdbc/DefaultEJBDS"
> > url="jdbc:JTurbo://localhost:1433/nexus"
> >
> connection-driver="com.ashna.jturbo.driver.Driver"
> > username="xxx"
> > password="yyy"
> > />
> >
> >hth,
> >bradley mclain
> >
> >--- "Sudhir A." <[EMAIL PROTECTED]> wrote:
> >> Hi,
> >> I have been trying to set up the Oracle driver
> for
> >> a long time. Finally could not make it. Check if
> >> someelse had the same problem and founf out a
> way. I
> >> have tried placing Classes12.zip at all places,
> >> orion/
> >> orion/lib/
> >>
> >> Even extracted the entire zip file and tried it.
> It
> >> didn't work. Here is how my data-source
> definition
> >> looks like
> >>
> >> ***************
> >>
> >> <data-source
> >> name="Default data-source"
> >> class="oracle.jdbc.driver.OracleDriver"
> >> location="jdbc/DefaultDS"
> >> pooled-location="jdbc/DefaultPooledDS"
> >> xa-location="jdbc/xa/DefaultXADS"
> >> ejb-location="jdbc/DefaultEJBDS"
> >> url="jdbc:ORACLE:defaultdb"
> >>
> >>
>
>connection-driver="jdbc:oracle:thin:@surya:1521:TESTDB"
> >> username="XXXXXXXX"
> >> password="CXXXXXX"
> >> schema="database-schemas/oracle.xml"
> >> />
> >>
> >> ***************
> >>
> >> The only file i made changes are to
> >> "data-sources.xml"
> >> I am getting error invalid Driver name
> >> "oracle.jdbc.driver.OracleDriver"
> >>
> >> Can some one please help me with this one.
> >>
> >> Thanks
> >> Sudhir
> >>
>
_____________________________________________________________________________
> Tamer Americo - Conselho Federal de Medicina - CFM
> [EMAIL PROTECTED] - ICQ#3221276
>
> "When we are young / Wandering the face of the earth
> Wondering what our dreams might be worth / Learning
> that we're only immortal
> For a limited time"
> Dreamline - Rush
>
____________________________________________________________________________
> _
>
__________________________________________________
Do You Yahoo!?
Send online invitations with Yahoo! Invites.
http://invites.yahoo.com
