Thank you very much for your advice.
I found the error in the method updateRow() of IDBroker.java :
private void updateRow(Connection con,
String tableName,
String id)
throws Exception
{
StringBuffer stmt =
new StringBuffer(id.length() + tableName.length() + 50);
stmt.append( "UPDATE ID_TABLE" )
.append( " SET next_id = " )
.append( id )
.append( " WHERE TABLE_NAME = '" )
.append( tableName )
.append( '\'' );
Statement statement = null;
try
{
statement = con.createStatement();
statement.executeUpdate( stmt.toString() );
}
finally
{
if (statement != null) statement.close();
}
}
In this Select Statement, next_id schould be NEXT_ID.
So now I would like to recompile the source-code for turbine2.1, but I don't
know how is the fastest way.
Another solution would be to change the case sensitive behavior of the
Sybase ASE, but this DB is already
running and used by other applications.
-----Urspr�ngliche Nachricht-----
Von: Holger Dehnhardt [mailto:[EMAIL PROTECTED]]
Gesendet: Friday, August 31, 2001 10:04 AM
An: [EMAIL PROTECTED]
Betreff: AW: Big troubles with Sybase DB
Hi Pattrick,
You are talking about Sybase Adaptive Server Enterprise - right?
ASE is case sensitive by default. (You can change this behavior
only when creating the database)
The error-message prints 'next_id', you say the table name is
'NEXT_ID'. Maybe somewhere the case is converted??
Holger
> -----Urspr�ngliche Nachricht-----
> Von: Patrick Tonidandel [mailto:[EMAIL PROTECTED]]
> Gesendet: Freitag, 31. August 2001 08:50
> An: Turbine-User
> Betreff: Big troubles with Sybase DB
>
>
> Hi there,
>
> who can give me an advice, how to get the example web application
> running on
> Sybase.
>
> I got the tables TURBINE_PERMISSION, TURBINE_USER, RDF, ID_TABLE .....
> created on the SybaseDB, but after that
> the example application cannot access the records in the tables.
>
> In turbine.log i found the following messages:
> [Fri Aug 31 08:03:46 GMT+02:00 2001] -- INFO -- Forced id retrieval - no
> available vector
> [Fri Aug 31 08:03:47 GMT+02:00 2001] -- ERROR -- Turbine.handleException:
> null
> [Fri Aug 31 08:03:47 GMT+02:00 2001] -- ERROR --
> Exception: java.lang.reflect.InvocationTargetException
> Stack Trace follows:
> java.lang.reflect.InvocationTargetException:
> com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'next_id'.
> at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2408)
> at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1844)
> at
> com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
> at
> com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:201)
> at
> com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182)
> at
> com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1479)
> at
> com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1462)
> at
> com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:411)
> at org.apache.turbine.util.db.IDBroker.updateRow(IDBroker.java:742)
> at org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:563)
> at org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:371)
> at
> org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker.java:285)
> at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:746)
> at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:657)
> at
> org.apache.turbine.services.security.db.DBUserManager.createAccoun
> t(DBUserMa
> nager.java:399)
> rethrown as
> org.apache.turbine.util.security.DataBackendException: Failed to
> create account 'pat': Invalid column name 'next_id'.
> at
> org.apache.turbine.services.security.db.DBUserManager.createAccoun
> t(DBUserMa
> nager.java:404)
> at
> org.apache.turbine.services.security.BaseSecurityService.addUser(B
> aseSecurit
> yService.java:392)
> at
> org.apache.turbine.services.security.TurbineSecurity.addUser(Turbi
> neSecurity
> .java:430)
> at
> org.apache.turbine.flux.modules.actions.user.FluxUserAction.doInse
> rt(FluxUse
> rAction.java:133)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents
> (VelocityA
> ctionEvent.java:166)
> at
> org.apache.turbine.util.velocity.VelocityActionEvent.perform(Veloc
> ityActionE
> vent.java:114)
> at
> org.apache.turbine.modules.actions.VelocityAction.perform(Velocity
> Action.jav
> a:114)
> at
> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
> at
> org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143)
> at org.apache.turbine.modules.Page.build(Page.java:90)
> at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
> at org.apache.turbine.Turbine.doGet(Turbine.java:447)
> 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(A
> pplication
> FilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati
> onFilterCh
> ain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp
> erValve.ja
> va:255)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> ine.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(StandardConte
> xtValve.ja
> va:225)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> ine.java:5
> 66)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authent
> icatorBase
> .java:472)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> ine.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(StandardHostValv
> e.java:164
> )
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> ine.java:5
> 66)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> ine.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(StandardEngine
> Valve.java
> :163)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> ine.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(HttpProce
> ssor.java:
> 875)
> at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor
> .java:952)
> at java.lang.Thread.run(Thread.java:484)
>
> I can't understand why i got this error. The column name of the table
> ID_TABLE is NEXT_ID.
> In the file
> '..tdk/webapps/site/turbine-docs/resources/IdTableMapBuilder.java'
> i found
> the following code:
>
> /** ID_TABLE.NEXT_ID */
> public static String getIdTable_NextId()
> {
> return getTable() + ".NEXT_ID";
> }
>
> If this is the right code, the method should match with column name.
>
> Any help is very appreciated.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
