db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anas Mughal" <anasmug...@gmail.com>
Subject Re: Torque connection error
Date Thu, 11 Oct 2007 20:59:18 GMT
Thomas, Hi,

Thank you very much for your help.

You are right. When I generated the code I had specified "webmodel" as the
database name. I didn't realize that it kept on complaining about not
finding the connect info for "webmodel".

Sometime it helps to have an second set of eyes looking at a problem.

I appreciate your help...
--
Anas Mughal




On 10/11/07, Thomas Fischer <tfischer@apache.org> wrote:
>
> The error message says that the database "webmodel" cannot be accessed.
> However, your database key is "mydb". You did not define any connection
> properties for the database "webmodel". Try syncing the two database
> names.
>
> If this sill does not work, can you post the stack trace of the exception
> you are getting ?
>
>     Thomas
>
> On Thu, 11 Oct 2007, Anas Mughal wrote:
>
> > I keep on getting the error:
> > SEVERE: Could not open a connection to the database webmodel
> >
> > I am able to connect from java using the same settings that I am trying
> in
> > my torque.properties file. Please advise what is wrong.
> >
> > Here is my torque.properties file:
> >
> > torque.database.default=mydb
> > torque.database.mydb.adapter=oracle
> >
> > torque.database.mydb.driver=oracle.jdbc.driver.OracleDriver
> > torque.database.mydb.url=jdbc:oracle:thin:@127.0.0.1:1521:xe
> > torque.database.mydb.username=webmodel
> > torque.database.mydb.password=webmodel
> >
> > #Using commons-dbcp
> > torque.dsfactory.mydb.factory =
> > org.apache.torque.dsfactory.SharedPoolDataSourceFactory
> > torque.dsfactory.mydb.connection.driver =
> oracle.jdbc.driver.OracleDriver
> > torque.dsfactory.mydb.connection.url = jdbc:oracle:thin:@127.0.0.1
> :1521:xe
> > torque.dsfactory.mydb.connection.user = webmodel
> > torque.dsfactory.mydb.connection.password = webmodel
> >
> >
> >
> > I am running this as a stand-alone application. (Not in any app server.)
> >
> > Here is my Java code that connects successfully to the database:
> >
> >            Class.forName("oracle.jdbc.driver.OracleDriver
> ").newInstance();
> >            con = DriverManager.getConnection("
> jdbc:oracle:thin:@127.0.0.1
> > :1521:XE",
> >                "webmodel", "webmodel");
> >
> > if(!con.isClosed())
> >                System.out.println("Successfully connected to Oracle");
> >
> >
> > Please advise as I am stuck at this point.
> > Best Regards.
> > --
> > Anas Mughal
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>


-- 
Anas Mughal

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message