Camera is seen as a scsi device:

scsi 7:0:0:0: Direct-Access Sony Camcorder 1.00 PQ: 0 ANSI: 0 CCS
sd 7:0:0:0: [sdc] 78126048 512-byte hardware sectors (40001 MB)
sd 7:0:0:0: [sdc] Write Protect is on
sd 7:0:0:0: [sdc] Mode Sense: 00 32 00 80
sd 7:0:0:0: [sdc] Assuming drive cache: write through
sd 7:0:0:0: [sdc] 78126048 512-byte hardware sectors (40001 MB)
sd 7:0:0:0: [sdc] Write Protect is on
sd 7:0:0:0: [sdc] Mode Sense: 00 32 00 80
d 7:0:0:0: [sdc] Assuming drive cache: write through
sdc: sdc1
sd 7:0:0:0: [sdc] Attached SCSI removable disk
sd 7:0:0:0: Attached scsi generic sg4 type 0

No problems with USB detection after plugging in:

$ lsusb -s 1:10
Bus 1 Device 10: ID 054c:02cb Sony Corp.

Too bad there are no UUID and/or LABEL entries, which would make mounting a bit easier:

$ udevinfo -q env -n /dev/sdc1
ID_VENDOR=Sony
ID_MODEL=Sony_Camcorder
ID_REVISION=0400
ID_SERIAL=Sony_Sony_Camcorder_0898E0091877
ID_TYPE=floppy
ID_BUS=usb
ID_PATH=pci-0000:00:1d.7-usb-0:5:1.0-scsi-0:0:0:0
ID_FS_USAGE=filesystem
ID_FS_TYPE=vfat
ID_FS_VERSION=FAT32
ID_FS_UUID=
ID_FS_LABEL=
ID_FS_LABEL_SAFE=