You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by KL Tse <kl...@yahoo.com> on 2001/12/07 09:52:09 UTC
Connect to Sybase on Linux
Dear All,
I have problem in connecting to sybase on Linux. I have already created the
database and tables. I believes that Database Url and Driver settings are
correct. After I have input the user name and password of the newapp, the
center is displayed an error at the middle with menu on the left side.
Can anyone tell me the way to debug sybase connection in Turbine ?
Jconn2.jar of version 5.2 is also copied to WEB-INF/lib, is this the only
file required for sybase connection ?
Thanks in advance for any help.
P.S. The flux.jar which solve the login problem is already copied to
WEB-INF/lib and all flux java and class file erased.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Connect to Sybase on Linux
Posted by KL Tse <kl...@yahoo.com>.
The corresponding sybase settings are :
database.default.driver=com.sybase.jdbc2.jdbc.SybDriver
database.default.url=jdbc:sybase:Tds:www.server.com:7100/jm
database.default.username=sa
database.default.password=2528sallmanns5079
database.adaptor=DBSybase
database.adaptor.DBSybase=com.sybase.jdbc2.jdbc.SybDriver
The following is the relevant log section, any ideas about it ?
[Fri Dec 07 21:15:52 HKT 2001] -- WARN -- IDBroker is being used with db:
default
which does not support transactions. It is possible to
generate duplicate keys, if multiple JVM's are used or other
means are used to write to the database.
[Fri Dec 07 21:15:52 HKT 2001] -- ERROR --
Exception: java.sql.SQLException: JZ006: Caught IOException:
java.net.ConnectException: Connection refused
Stack Trace follows:
java.sql.SQLException: JZ006: Caught IOException:
java.net.ConnectException: Connection refused
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:467)
at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:2919)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:393)
at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:219)
at
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174)
at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:173)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at org.apache.turbine.util.db.adapter.DB.getConnection(DB.java:153)
at
org.apache.turbine.util.db.pool.ConnectionPool.getNewConnection(ConnectionPo
ol.java:498)
at
org.apache.turbine.util.db.pool.ConnectionPool.getConnection(ConnectionPool.
java:339)
at
org.apache.turbine.services.db.TurbinePoolBrokerService.getConnection(Turbin
ePoolBrokerService.java:171)
at
org.apache.turbine.services.db.TurbinePoolBrokerService.getConnection(Turbin
ePoolBrokerService.java:145)
at
org.apache.turbine.services.db.TurbineDB.getConnection(TurbineDB.java:169)
at org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:217)
at org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:194)
at
org.apache.turbine.om.security.peer.TurbineUserPeer.<clinit>(TurbineUserPeer
.java)
at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager
.java:158)
at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager
.java:246)
at
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUse
r(BaseSecurityService.java:313)
at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(Tu
rbineSecurity.java:199)
at
org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:103)
at org.apache.turbine.modules.Action.perform(Action.java:87)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at org.apache.turbine.Turbine.doGet(Turbine.java:393)
at org.apache.turbine.Turbine.doPost(Turbine.java:537)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:255)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:225)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:472)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2252)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:163)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
875)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:952)
at java.lang.Thread.run(Thread.java:484)
[Fri Dec 07 21:15:52 HKT 2001] -- ERROR -- Turbine.handleException: Error in
BasePeer.initTableSchema(TURBINE_USER): JZ006: Caught IOException:
java.net.ConnectException: Connection refused
[Fri Dec 07 21:15:52 HKT 2001] -- ERROR --
Exception: java.lang.Error: Error in
BasePeer.initTableSchema(TURBINE_USER): JZ006: Caught IOException:
java.net.ConnectException: Connection refused
Stack Trace follows:
java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): JZ006:
Caught IOException: java.net.ConnectException: Connection refused
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>(TurbineUserPeer
.java)
at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager
.java:158)
at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager
.java:246)
at
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUse
r(BaseSecurityService.java:313)
at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(Tu
rbineSecurity.java:199)
at
org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:103)
at org.apache.turbine.modules.Action.perform(Action.java:87)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at org.apache.turbine.Turbine.doGet(Turbine.java:393)
at org.apache.turbine.Turbine.doPost(Turbine.java:537)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:255)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:225)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:472)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2252)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:163)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
875)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:952)
at java.lang.Thread.run(Thread.java:484)
----- Original Message -----
From: "Colm McCartan" <co...@owl.co.uk>
To: "Turbine Users List" <tu...@jakarta.apache.org>
Sent: Friday, December 07, 2001 8:11 PM
Subject: Re: Connect to Sybase on Linux
>
>
> KL Tse wrote:
>
> > Dear All,
> > I have problem in connecting to sybase on Linux. I have already created
the
> > database and tables. I believes that Database Url and Driver settings
are
> > correct. After I have input the user name and password of the newapp,
the
> > center is displayed an error at the middle with menu on the left side.
>
>
> Whats in the error logs?
>
> Have you added not only your database connection variables in
> TurbineResources.properties but also the correct adapter lines? e.g.
>
> database.default.driver=org.postgresql.Driver
> database.default.url=jdbc:postgresql://127.0.0.1/dbname
> database.default.username=turbine
> database.default.password=******
>
> database.adaptor=DBPostgres
> database.adaptor.DBPostgres=org.postgresql.Driver
>
> c
>
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Connect to Sybase on Linux
Posted by Colm McCartan <co...@owl.co.uk>.
KL Tse wrote:
> Dear All,
> I have problem in connecting to sybase on Linux. I have already created the
> database and tables. I believes that Database Url and Driver settings are
> correct. After I have input the user name and password of the newapp, the
> center is displayed an error at the middle with menu on the left side.
Whats in the error logs?
Have you added not only your database connection variables in
TurbineResources.properties but also the correct adapter lines? e.g.
database.default.driver=org.postgresql.Driver
database.default.url=jdbc:postgresql://127.0.0.1/dbname
database.default.username=turbine
database.default.password=******
database.adaptor=DBPostgres
database.adaptor.DBPostgres=org.postgresql.Driver
c
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>