|
tobi,
February 6, 2002 at 12:00:29 PM CET
antville & odbc inspired by the discussion at langreiter.com, i tried to connect antville with a microsoft access database via odbc on win2k. this is what i did so far:
tobi,
February 6, 2002 at 12:34:12 PM CET
direct db is working... ... comment
tobi,
February 6, 2002 at 12:39:19 PM CET
sql exception java.sql.SQLException: ResultSet is closed
at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6455
)
at sun.jdbc.odbc.JdbcOdbcResultSet.clearWarnings(JdbcOdbcResultSet.java:
1747)
at sun.jdbc.odbc.JdbcOdbcResultSet.close(JdbcOdbcResultSet.java:1452)
at com.workingdogs.village.DataSet.close(DataSet.java:337)
at helma.objectmodel.db.NodeManager.getNodes(NodeManager.java:752)
at helma.objectmodel.db.WrappedNodeManager.getNodes(WrappedNodeManager.j
ava:57)
at helma.objectmodel.db.Node.loadNodes(Node.java:1172)
at helma.objectmodel.db.Node.getSubnodeAt(Node.java:923)
at helma.scripting.fesi.ESNode.getProperty(ESNode.java:287)
at helma.scripting.fesi.HopExtension$NodeGet.
sitor.java:362)
at FESI.AST.ASTVariableDeclaration.jjtAccept(ASTVariableDeclaration.java
:26)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.visit(EcmaScriptEvaluateVi
sitor.java:339)
at FESI.AST.ASTStatement.jjtAccept(ASTStatement.java:26)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.visit(EcmaScriptEvaluateVi
sitor.java:320)
at FESI.AST.ASTStatementList.jjtAccept(ASTStatementList.java:26)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.
... comment
hns,
February 6, 2002 at 5:49:55 PM CET
Tobi Do you have data in the db? is there a weblog object? Can you try removing this line from root/type.properties: _subnodes.loadmode=aggressive Also, can you make a simple root/test.hac and tell me what you get on the following statements (issued separately): res.write (this.size()); (and, provided there is a weblog in the db) res.write (this.get(0));
tobi,
February 6, 2002 at 6:30:02 PM CET
here we go again sorry for the late reply... let's see: i have data in the db (it was successfully imported from the mysql db i used so far with the local antville installation). i can access the data via direct db, e.g. retrieve a record from the weblog table. this.get(0) returns the mentioned error (resultset is closed). this means, there is no weblog object. this.size() returns 2! after i commented out _subnodes.loadmode=aggressive: HEY! this.get(0) returns a hopobject! ok, after that i pointed the browser to antville's main page again and in fact got some more to see. moving forward! however, there are still errors, apparently the odbc driver does not like the sql syntax (i assume it's the single quotes, i had to use double ones in the direct db test.hac): [HopMacro error: java.lang.RuntimeException: Error retrieving NodeIDs: [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in FROM-Klausel.] (obviously i am using a german treiber, mein herr. should i try the us-english one?)
hns,
February 6, 2002 at 7:01:51 PM CET
Next 2 questions Haven't you used Helma with Access/ODBC already without any problems? Does the database look ok when you browse it with Access?
tobi,
February 6, 2002 at 7:12:03 PM CET
noyesno no, i haven't really used helma with access. i think we just connected a simple helma application with odbc for testing purposes one or two years ago. and i have not went any further than that. well, yes and no. it's ok to use the database in access. but in fact it does look a little bit weird. i just noticed that not all ID fields are set to NUMBER but instead to TEXT... and the PRIMARY KEYs are not set. i am currently modifying this and will see what happens. ... comment
tobi,
February 7, 2002 at 11:28:26 AM CET
odbc & simple app now i tested the whole thing with a totally simple application (the one described in the helma user's guide) and made the following observations:
hns,
February 7, 2002 at 11:38:14 AM CET
Thanks for the report The id stuff is rather obvious and I think I can fix it. Point 1 and 3 are pretty mysterious, though.
tobi,
February 7, 2002 at 3:25:43 PM CET
you're welcome obvious it might be. however, i did not think that such behaviour should give reason to change java code. well, you must know. so feel free to tell me if you need some further testing with this. ... comment
|
|
The Antville Server Fund has been a great success. Thanks to everybody who contributed!
online for 8550 Days
last updated: 1/4/11, 10:22 AM  Youre not logged in ... Login
 ... home
... topics ... galleries ... Home
... Tags
... Galleries
... about antville ... download ... macros.antville.org ... help.antville.org ... translate antville! ... antville home
i understand your concerns however,
i hardly can think of a solution. certainly, if the...
by tobi (7/29/03, 9:47 AM)
Found several more similar sites
listed This is getting to be quite a concern to...
by cobalt123 (7/27/03, 7:56 PM)
Second Post Alert on Referrer
bug livecatz I put this into "help" and now here:...
by cobalt123 (7/26/03, 7:14 PM)
well it's not easy to
find from here, anyway. think we should include a link,...
by tobi (7/24/03, 11:25 AM)
clock not that it's particularly
earthshattering but the antclock is running slow by about 15...
by kohlehydrat (7/23/03, 8:25 PM)
How to log skin names
I accessed to console?? Hi, I would like to know...
by winson (7/23/03, 4:12 PM)
  powered by  |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||