It's a bit confusing what you did with the usernames.... did you create the turbine tables under the user 'system' or under another user ? Oracle creates tables under users, not globally like mysql. That being said, the specific text of the error message and the fact that it is not an SQLException points more in the direction of a general system config problem than an Oracle problem... also because you don't usually need a network adapter to connect to localhost.
Sorry I can't be of more help, Age > -----Original Message----- > From: venkat [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 03, 2002 13:10 > To: Turbine Users List > Subject: RE: Turbine error while connecting with oracle > > > Thanks. Following are the steps i have done so far, > > 1. Created a new database and SID in the name of "trbn". > 2. Placed the classes12.zip which comes along with Oracle 8i Personal > Edition in \lib directory > 3. Created tables and inserted datas from the turbine src\sql directory. > 4. modified the TRP. > > Following is the stacktrace of the error > ------------------------------------------ > > [Wed Jul 03 16:20:58 PDT 2002] -- ERROR -- > Turbine.handleException: Error in > BasePeer.initTableSchema(TURBINE_USER): Io exception: The Network Adapter > could not establish the connection > [Wed Jul 03 16:20:58 PDT 2002] -- ERROR -- > Exception: java.lang.Error: Error in > BasePeer.initTableSchema(TURBINE_USER): Io exception: The Network Adapter > could not establish the connection > Stack Trace follows: > java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Io > exception: The Network Adapter could not establish the connection > at > org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:232) > at > org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:194) > at > org.apache.turbine.om.security.peer.TurbineUserPeer.<clinit>(Turbi > neUserPeer > .java) > at > org.apache.turbine.services.security.db.DBUserManager.retrieve(DBU > serManager > .java:158) > at > org.apache.turbine.services.security.db.DBUserManager.retrieve(DBU > serManager > .java:246) > at > org.apache.turbine.services.security.BaseSecurityService.getAuthen > ticatedUse > r > ............... > > Following are the configuration TRP > ------------------------------------ > > database.default.driver=oracle.jdbc.driver.OracleDriver > database.default.url=jdbc:oracle:thin:@localhost:1521:trbn > database.default.username=system > database.default.password=manager > > > database.adaptor=DBOracle > database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver > > Points to be noted: > -------------------- > > 1. trbn - SID name > 2. username and password i have given the default name. But while i was > creating the "trbn" database i have given the password as > "password", hence > whenever i start the trbn database, i have been giving the "password" and > also it is allowing me to go inside. > > -----Original Message----- > From: Age Mooy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 03, 2002 3:59 PM > To: Turbine Users List > Subject: RE: Turbine error while connecting with oracle > > > If you post the complete stacktrace of that error (is it an SQLException > thrown by the Oracle driver ?) plus the oracle db setup lines > from your TRP, > I might be able to spot something wrong. > > Is the database on your own machine or on another machine ? > > Age > > > -----Original Message----- > > From: venkat [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 03, 2002 11:14 > > To: Turbine Users List > > Subject: RE: Turbine error while connecting with oracle > > > > > > i have created new instance in oracle and mentioned the same in > > TurbineResources.properties but still i am getting the same error "The > > Network Adapter could not establish the connection". can any one > > help me to > > resolve the above mentioned problem. > > > > Apart from the instance creation do we need to do any Net8 > configuration.I > > have also mentioned the instance name in the listener.ora and > tnsnames.ora > > file, but the same error continues. > > > > Any idea mucg appreciated. > > > > Thanks in advance. > > > > Venkat > > > > -----Original Message----- > > From: Gray, Cameron C. [UltraSpeed] [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, July 02, 2002 11:19 AM > > To: 'Turbine Users List' > > Subject: RE: Turbine error while connecting with oracle > > > > > > I assume you are still running the starter database that comes with > > Oracle? > > > > In this case you need to create a new "instance". You can do this with > > the graphical tools, The DBCA (Database Creation Assistant) will do just > > fine. > > > > Just set the instance name to turbine and away you go. > > > > Cameron > > > > -----Original Message----- > > From: venkat [mailto:[EMAIL PROTECTED]] > > Sent: 02 July 2002 04:46 > > To: Turbine User > > Subject: Turbine error while connecting with oracle > > > > > > Hi, > > > > I have installed Oracle 8i personnal edition in my Win 98 system and now > > i am trying to connect a sample application with oracle database, i have > > done the following procedures so far, > > > > 1. Copied the classes12.jar (not downloaded one, comes along with oracle > > 8i) file in web-inf/lib. 2. Created sql statements manually. 3. Modified > > the TurbineResources.properties (database settings) > > > > After the above steps i am getting error like "The Network Adapter could > > not establish the connection". > > > > I have following clarifications, > > 1. Whether i am using the correct driver? becuase i found gtom how to > > tutorial, it is classes12_10.zip so can any one please confirm this? 2. > > The document says "Ensure that the OracleoracleTNSListener service and > > the OracleServiceTURBINE service is running before using the driver" , > > but i could not found such service in oracle menu options so if any > > thing please pass on the information to me. 3. For the above mentioned > > error what would be the other possibilities? Thanking you in advance. > > Venkat > > > > > > > > > > > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.371 / Virus Database: 206 - Release Date: 6/13/02 > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > --- > > Incoming mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.371 / Virus Database: 206 - Release Date: 6/13/02 > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.373 / Virus Database: 208 - Release Date: 7/1/02 > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.373 / Virus Database: 208 - Release Date: 7/1/02 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.373 / Virus Database: 208 - Release Date: 7/1/02 > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED] g> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
