1.2 preview test failing on MS SQL 2012:

[tapirus]

Hope it helps and the little bit of german is not to confusing. ;-)

Railo 3.3.3.001 Error (database)
Message Der Wert NULL kann in die galleryid-Spalte, wheelstestdb.dbo.photos-Tabelle nicht eingefügt werden. Die Spalte lässt NULL-Werte nicht zu. Fehler bei INSERT.
SQL INSERT INTO photos (
description
,
galleryid
,
filename
)
VALUES (
'test photo 1 for gallery '
,
[CF_SQL_INTEGER]
,
'Gallery Photo Test 1'
)

DatabaseName Microsoft SQL Server
DatabaseVersion 11.00.2100
DriverName Microsoft JDBC Driver 4.0 for SQL Server
DriverVersion 4.0.2206.100
Datasource wheelstestdb
Stacktrace The Error Occurred in
D:\websites\mysite.com\wheels\model\adapters\Base.cfc: line 244

242:
243:
244: <cfif IsStruct(loc.i)><cfif StructKeyExists(loc.queryParamAttributes, "useNull")>NULL<cfelseif StructKeyExists(loc.queryParamAttributes, "list")>()(#PreserveSingleQuotes(loc.i.value)#)#$quoteValue(str=loc.i.value, sqlType=loc.i.type)#<cfset loc.i = Replace(PreserveSingleQuotes(loc.i), "[[comma]]", ",", "all")>#PreserveSingleQuotes(loc.i)##chr(13)##chr(10)#LIMIT #arguments.limit##chr(13)##chr(10)#OFFSET #arguments.offset#
245:
246:

[rip747]

try reloading the test data. I think something is not clearing the tables.

[tapirus]

How do I reload the test data?
I tried it on wheels 1.2.preview2 and also on 1.1.8.
I get the same error on both.
I have a database named: wheelstestdb and have created a datasource in railo 3.3.001 with the same name

[rip747]

on the top of the test page there should be a link label "reload test data".

what driver are you using? there are 3 different ones you can use in railo:

MSSQL - Microsoft SQL Server (Vendor Microsoft)
MSSQL - Microsoft SQL Server (Vendor jTDS)
Other - JDBC Driver

[tapirus]

Other - JDBC Driver
But I downloaded and use the sqljdbc4.jar driver from microsoft.
I will try it again.

[rip747]

english translation of error:

Railo 3.3.3.001 Error (database)
Message The value NULL in the column galleryId, wheelstestdb.dbo.photos table can not be inserted. Column is not nullable. Error in INSERT.
SQL INSERT INTO photos (
description
,
galleryId
,
filename
)
VALUES (
'test 1 for photo gallery'
,
[CF_SQL_INTEGER]
,
'Photo Gallery Test 1'
)

Microsoft SQL Server Database Name
Database Version 11.00.2100
Driver Name Microsoft JDBC Driver 4.0 for SQL Server
Driver Version 4.0.2206.100
DataSource wheelstestdb
Stacktrace The Error Occurred in
D: \ websites \ mysite.com \ wheels \ model \ adapters \ Base.cfc: line 244

242:
243:
244: ZERO () (# PreserveSingleQuotes (loc.i.value) #) # $ value ratio (str = loc.i.value, sqlType loc.i.type =) # # PreserveSingleQuotes (loc.i) # # chr (13 ) # # chr (10) # # LIMIT arguments.limit # # chr (13) # # chr (10) # # # OFFSET arguments.offset
245:
246:

[rip747]

you shouldn't need to use the other driver for MSSQL 2012. I use the MSSQL - Microsoft SQL Server (Vendor Microsoft) when running the framework tests against MSSQL 2012

btw, that other driver option has ALWAYS had problems

[tapirus]

Hi,
I did it again, same error.
There is no "reload test data" link.
I have the site in "design" mode, if this maybe makes a difference.

Other say I should use the sqljdbc4.jar for MSSQL2012.
But I can only use it when I choose the "Other driver" option in railo admin.

It's a pity that Railo 4.0 ships with the old microsoft driver. If they had shipped it with the new one the use of "other driver" would be obsolete.

[rip747]

i might be wrong, but I think all i did was drop the sqljdbc4.jar in the railo/lib folder and it used the new driver when I select the MSSQL - Microsoft SQL Server (Vendor Microsoft). i have to check though.

[rip747]

Here is the fix:

http://www.cognitiveoxygen.com/2012/11/error-installing-mura-cms-the-conversion-from-char-to-smallint-is-unsupported.cfm

• Download the Microsoft JDBC Driver 4.0 for SQL Server from http://www.microsoft.com/en-us/download/details.aspx?id=11774
• Once you have extracted the archive, browser for the file sqljdbc4.jar (for me, it was under \sqljdbc_4.0\enu).
• Drop sqljdbc4.jar into your {railo}\lib folder
• Stop the railo service (or "Apache Tomcat Railo" service)
• In your {railo}\lib folder, rename microsoft-sqljdbc.jar to microsoft-sqljdbc.jar.bak (or something else that changes the extension...or move it to another directory altogether). NOTE: for Railo 3.3.X the microsoft-sqljdbc.jar is located in the {railo}\lib\ext
• Restart the railo service