Connection to Oracle

[bijusugarland]

I have been using Dreamweaver 8 for developing PHP applications with MYSQL database and is very useful. Now I need to create some JSP pages with Oracle Database. I have Oracle Database Express Edition Installed on my PC . For PHP -MYSQL or ASP.NET - MS SQL I know how to make connction. But JSP - Oracle I don't know.
Some one please help making connection to Oracle Database from Dreamweaver
Thanks
George

[Creativ_Technologies]

This is a type of Oracle connection string that doesn't rely on you to have a DSN for the connection. You create a connection string based on the format used in the tnsnames.ora file without the need to actually have one of these files on the client pc.

SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));uid=myUsername;pwd=myPassword;

[Newsgroup_User]

JSP - Oracle requires a JDBC connection string to connect. It varies a bit
depending upon the database client you have installed on your machine and
the rdivers that are available, but this document might help a bit:

http://download-west.oracle.com/docs/cd/B10501_01/java.920/a96654/basic.htm#1004265

Dealing with Java and JSP is unlike anything else I've ever dealt with and
it's quite a bit more complicated than ASP, PHP, or any other procedural
language. You may end up digging for a while until you find exactly what
you're after (especially when dealing with Oracle). That's pretty much the
reason I stay away from it :-)

Hope you find what you're after!

Best regards,
Chris

"bijusugarland" <webforumsuser@macromedia.com> wrote in message
news:esp9pa$pvq$1@forums.macromedia.com...
>I have been using Dreamweaver 8 for developing PHP applications with MYSQL
> database and is very useful. Now I need to create some JSP pages with
> Oracle
> Database. I have Oracle Database Express Edition Installed on my PC .
> For PHP
> -MYSQL or ASP.NET - MS SQL I know how to make connction. But JSP -
> Oracle I
> don't know.
> Some one please help making connection to Oracle Database from Dreamweaver
> Thanks
> George
>

[bijusugarland]

I was able to make the Connection to Oracle using ODBC thin driver. Now I have a different question.
I am going to write java classes, and use it in the JSP pages.
Where do I keep the class files(which directory)?. I have IIS running on Windows XP prof.
Thanks
George
T

[Deaf_Web_Designer]

George,

I don't know if you have come across to this page, have a look at Oracle App Server Partners page.

Dreamweaver 8 works with JSP, and there is some pretty good self-explanatory stuff at Dreamweaver Developer Center (look for database-related topics for that matter) similar to your situation. Try to use search around Adobe System search with "Dreamweaver and Oracle" and see what it comes up for you. There are lot of options and possiblities. Of course, like you said, it is bit of information gathering and research. I guess that is what it is all about. :)

I happen to notice that Oracle Developer also supports PHP and Oracle, as well as Java, and XML and many others. Dreamweaver also support XML. I notice that Oracle supports J2EE. In case if you didn't know, Cold Fusion is capable of working with J2EE, JRUN and other venues. You might want to download Cold Fusioin - Developer Edition only, but I don't know if that is of an interest to you or that it fits right into your scope at this time. it is only a suggestion, though.

However, I don't think there are quite few Dreamweavers working with Oracle. I could be wrong about that, but hope that there are some other Dreamweavers who are familiar with Oracle database & application development. I recently just started to working with Cold Fusion, and Adobe Flex 2 to learn more about the capacity. There are lot of options, really.

quote:

---

Originally posted by: bijusugarland
I have been using Dreamweaver 8 for developing PHP applications with MYSQL database and is very useful. Now I need to create some JSP pages with Oracle Database. I have Oracle Database Express Edition Installed on my PC . For PHP -MYSQL or ASP.NET - MS SQL I know how to make connction. But JSP - Oracle I don't know.
Some one please help making connection to Oracle Database from Dreamweaver
Thanks
George

---

[Newsgroup_User]

Most of the time, that stuff would be kept in the /lib/ or /classes/
directory of your web application, if I remember correctly, where your
classes can be compressed into JAR files stored in the /lib/ directory and
regular classes are in the /classes/ directory. Although I believe you can
put them anywhere you like as long as the web app can find them. I haven't
done any Java development in a long time.

Best regards,
Chris

"bijusugarland" <webforumsuser@macromedia.com> wrote in message
news:esvt7q$4ui$1@forums.macromedia.com...
>I was able to make the Connection to Oracle using ODBC thin driver. Now I
>have
> a different question.
> I am going to write java classes, and use it in the JSP pages.
> Where do I keep the class files(which directory)?. I have IIS running on
> Windows XP prof.
> Thanks
> George
> T
>