How to insert null in database

[sjcarroll6]

I'm trying to insert a null into a database. I tried to insert a scala null into the insert statement and got a java null error. When I tried to insert NULL then scala didn't recognize the value. Thanks for any help on this.

queryEvaluator.execute("INSERT INTO CSEUser VALUES (?, ?, ?, ?, ?, ?, ?)", 220, "Happy1",3121266.39,"BigBoote", "Fred",null,6385068.77)

[eaceaser]

will fix this

[jboyens]

Any idea on how to work past this?

It's kind of a sad roadblock for me.

[eaceaser]

http://github.com/nkallen/querulous/commit/d2d117a2afc0714a83e6b88a1770a5836a51bfe3

Sorry about the long turnaround, I've been pretty busy with the FlockDB opensourcing stuff.

This should give you something to work with :) unfortunately I can't put a new version of querulous on the maven repo right now, so you'll have to build a jar yourself.

Please let me know if this is an acceptable solution. This was the best way of doing nulls that I could come up with in a relatively short notice.

[eaceaser]

p.s. some of us hang out in #twinfra on freenode irc if you have any problems and want to see if you can get a more immediate response

[jboyens]

Haha! This was the exact solution I had come up with, I just went to sleep instead of implementing it.

Thanks so much.