Re: [Idrs-help] RE:ERrors while compiling

[Marc B. <mbo...@ya...>]

Raj,

I've been thinking about this problem, and I think I know why it doesn't
work.  InsertToIDRS is creating a list of object wrappers (Integer,
String ...).  At the end it calls setObject() to set it in the
PreparedStatement.  For MySQL setObject sets up the binary stream
automaticly, oracle's driver might not be.  The solution must be check
the type of object and do a specific setX() for it.  

Marc
On Fri, 2001-10-12 at 22:55, Rajagopal. V wrote:


    Marc,
    Im trying to get an entry into InsertintoIDRS. I tried
    to change the type of DocSRC to BLOB and Long Raw. But
    when i try to insert a rml file into Docsrc, i do this
    
    E:\sf\Idrs\dev\src>java InsertToIDRS -insgpc 1 TestDoc
    d:/tomcat/webapps/IDRS/sample.rml 1, boss_BossID:
    jdbc:oracle:thin:scott/tiger@127.0.0.1:1521:raja
    
    It gives me an exception saying 
    Exception in thread "main" java.sql.SQLException:
    Invalid column type at
    oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
        at
    oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
        at
    oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:219)
    
    What shud be the datatype for DOCSRC?? And How shud i
    geive it in InsertToIDRS?
    
    Thanks
    Raj
    
    --- Marc Boorshtein <mbo...@ya...> wrote:
    > Raj,
    > 
    > Do not include IDRSParams in the build, i will be
    > removing it from the
    > source tree.  It is deprecated and now i am
    > completly removing it.  It
    > never worked the way I wanted it too, and I never
    > found any use for it
    > in my projects.  
    > 
    > thanks
    > marc
    > On Fri, 2001-10-05 at 16:16, Rajagopal. V wrote:
    > 
    > 
    >     Im trying to compile the source and i got
    > following
    >     errors. I hvea no clue about this
    >     
    >    
    >
    C:\sf\Idrs\dev\src\net\sourceforge\idrs\core\IDRSParams.java:120:
    >     incompatible types
    >         [javac] found   :
    >     net.sourceforge.idrs.utils.pool.PooledObject
    >         [javac] required: java.sql.Connection
    >         [javac]     con = idrsDBs.getConnection();
    >         [javac]                                ^
    >         [javac] 
    >     
    >    
    >
    C:\sf\Idrs\dev\src\net\sourceforge\idrs\core\IDRSParams.java:144:
    >    
    > ProcSQL(java.lang.String,boolean,java.lang.String[])
    >     in net.sourceforge.idrs.utils
    >     .DB cannot be applied to
    > (java.lang.String,boolean)
    >         [javac]     db.ProcSQL(SQL, false);
    >         [javac]       ^
    >         [javac] 
    >    
    >
    C:\sf\Idrs\dev\src\net\sourceforge\idrs\script\embedable\IDRSShell.java:112:
    >     cannot resolve symbol
    >         [javac] symbol  : method getResponse  ()
    >         [javac] location: interface
    >     net.sourceforge.idrs.script.IDRSScript
    >         [javac]       return idrs.getResponse();
    >         [javac]                  ^
    >         [javac] 
    >    
    >
    C:\sf\Idrs\dev\src\net\sourceforge\idrs\core\IDRSReport.java:38:
    >     net.sourceforge.idrs.core.IDRSReport should be
    >     declared abstract; it does not defin
    >     e setSendToClient(boolean) in
    >     net.sourceforge.idrs.core.IDRSReport
    >         [javac] public class IDRSReport implements
    >     IDRSScript {
    >         [javac]        ^
    >         [javac] 
    >    
    >
    C:\sf\Idrs\dev\src\net\sourceforge\idrs\core\IDRSReport.java:591:
    >     cannot resolve symbol
    >         [javac] symbol  : method setIDRS 
    >     (net.sourceforge.idrs.core.IDRSReport)
    >         [javac] location: class
    >     net.sourceforge.idrs.utils.DB
    >         [javac]     db.setIDRS(this);
    >         [javac]       ^
    >         [javac] 
    >    
    >
    C:\sf\Idrs\dev\src\net\sourceforge\idrs\core\IDRSReport.java:592:
    >    
    >
    procMethod(net.sourceforge.idrs.utils.ObjectStore,java.lang.String,java.lang.Strin
    >     g[],net.sourceforge.idrs.script.IDRSScript) in
    >     net.sourceforge.idrs.utils.DB cannot be applied
    > to
    >    
    >
    (net.sourceforge.idrs.utils.ObjectStore,java.lang.String,java.
    >     util.Vector)
    >         [javac]    
    >     db.procMethod(tmpObj,methodName,tmpVec);
    >         [javac]       ^
    >         [javac] 
    >     
    >    
    >
    C:\sf\Idrs\dev\src\net\sourceforge\idrs\core\IDRSReport.java:926:
    >    
    > ProcSQL(java.lang.String,boolean,java.lang.String[])
    >     in net.sourceforge.idrs.utils
    >     .DB cannot be applied to
    > (java.lang.String,boolean)
    >         [javac]     db.ProcSQL(rSQL,isProc);
    >         [javac]       ^
    >     
    >     
    >     
    >     Also, I downloaded the python file from jython
    >     website. So that reduced some errors.
    >     I found these things in the code
    >     a) in IDRSReport.java, there is a function call
    > like
    >     db.addVar whereas it shud be just addVar(There
    > is no
    >     addVar function in DB.java, Its in
    > IDRSReport.java).
    >     
    >     Please let me know about these errors.
    >     
    >     Thanks so much. Can i post the ant script that i
    > did
    >     for development. It is a compile and jar making
    >     script.
    >     
    >     Thanks
    >     Raj
    >     
    >    
    > __________________________________________________
    >     Do You Yahoo!?
    >     NEW from Yahoo! GeoCities - quick and easy web
    > site hosting, just $8.95/month.
    >     http://geocities.yahoo.com/ps/info1
    >     
    >     _______________________________________________
    >     Idrs-help mailing list
    >     Idr...@li...
    > 
    > 
    >
    https://lists.sourceforge.net/lists/listinfo/idrs-help
    > 
    > 
    >     
    > 
    
    
    __________________________________________________
    Do You Yahoo!?
    Make a great connection at Yahoo! Personals.
    http://personals.yahoo.com
    
    _______________________________________________
    Idrs-help mailing list
    Idr...@li...


https://lists.sourceforge.net/lists/listinfo/idrs-help