IDs with mssql

[Nik Frank <ni...@subnet.at>]

hi
i use turbine-tdk with MS SQL server (with the JDBC driver provided by
microsoft). retrieving and updating data from the database works fine,
however there seems to be a problem with IDs when inserting.
my project schemes looks like this:
<database>
  <table name="RDF" idMethod="idbroker">
    <column name="RDF_ID" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
    <column name="TITLE" size="255" type="VARCHAR"/>
    <column name="BODY" size="255" type="VARCHAR"/>
    <column name="URL" size="255" type="VARCHAR"/>
    <column name="AUTHOR" size="255" type="VARCHAR"/>
    <column name="DEPT" size="255" type="VARCHAR"/>
  </table>
</database>

but i get the error message included at the end of this e-mail.

did anyone experience a similar problem or even find a solution?

best regards
nik

[Mon Feb 11 12:25:05 CET 2002] -- INFO -- Forced id retrieval - no available
vec
tor
[Mon Feb 11 12:25:15 CET 2002] -- ERROR -- Turbine.handleException: null
[Mon Feb 11 12:25:15 CET 2002] -- ERROR --
        Exception:  java.lang.reflect.InvocationTargetException
        Stack Trace follows:
        java.lang.reflect.InvocationTargetException:
java.lang.NullPointerExcept
ion
        at
org.apache.turbine.om.peer.BasePeer.rollBackTransaction(BasePeer.java
:366)
        at org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:574)
        at org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:371)
        at
org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker.java:2
85)
        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.createAccount(D
BUserManager.java:399)
rethrown as org.apache.turbine.util.security.DataBackendException: Failed to
cre
ate account 'dom'
        at
org.apache.turbine.services.security.db.DBUserManager.createAccount(D
BUserManager.java:404)
        at
org.apache.turbine.services.security.BaseSecurityService.addUser(Base
SecurityService.java:392)
        at
org.apache.turbine.services.security.TurbineSecurity.addUser(TurbineS
ecurity.java:430)
        at
org.apache.turbine.flux.modules.actions.user.FluxUserAction.doInsert(
FluxUserAction.java:133)
        at java.lang.reflect.Method.invoke(Native Method)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(Ve
locityActionEvent.java:166)
        at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(Velocity
ActionEvent.java:114)
        at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAct
ion.java: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(Appl
icationFilterChain.java:247)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:255)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:225)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a: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.j
ava:164)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
446)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:163)
        at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcesso
r.java:875)
        at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.ja
va:952)
        at java.lang.Thread.run(Thread.java:484)
_____________
Nik Frank
nik@subnet.at


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>